Spaces:
Runtime error
Runtime error
File size: 2,552 Bytes
45e5a75 eba54ac ea4879e 45e5a75 3652aa7 45e5a75 3652aa7 eba54ac 3652aa7 45e5a75 ea4879e 45e5a75 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 |
import streamlit as st
import pandas as pd
from st_aggrid import AgGrid
from st_aggrid.grid_options_builder import GridOptionsBuilder
from st_aggrid.shared import JsCode
from download import download_button
from st_aggrid import GridUpdateMode, DataReturnMode
def _max_width_():
max_width_str = f"max-width: 1800px;"
st.markdown(
f"""
<style>
.reportview-container .main .block-container{{
{max_width_str}
}}
</style>
""",
unsafe_allow_html=True,
)
st.set_page_config(page_icon="🧠", page_title="CSV Dataset Analyzer")
col1, col2, col3 = st.columns([1,6,1])
with col1:
st.image("https://cdna.artstation.com/p/assets/images/images/054/900/924/large/aaron-wacker-event-horizon.jpg?1665626929",width=100,)
with col2:
st.title("CSV Dataset Analyzer")
with col3:
st.write("")
c29, c30, c31 = st.columns([1, 6, 1])
with c30:
uploaded_file = st.file_uploader(
"",
key="1",
help="To activate 'wide mode', go to the hamburger menu > Settings > turn on 'wide mode'",
)
if uploaded_file is not None:
file_container = st.expander("Check your uploaded .csv")
shows = pd.read_csv(uploaded_file)
uploaded_file.seek(0)
file_container.write(shows)
else:
st.info(
f"""
👆 Upload a .csv file first. Sample to try: [biostats.csv](https://people.sc.fsu.edu/~jburkardt/data/csv/biostats.csv)
"""
)
st.stop()
gb = GridOptionsBuilder.from_dataframe(shows)
gb.configure_default_column(enablePivot=True, enableValue=True, enableRowGroup=True)
gb.configure_selection(selection_mode="multiple", use_checkbox=True)
gb.configure_side_bar() # side_bar is clearly a typo :) should by sidebar
gridOptions = gb.build()
st.success(
f"""
💡 Tip! Hold the shift key when selecting rows to select multiple rows at once!
"""
)
response = AgGrid(
shows,
gridOptions=gridOptions,
enable_enterprise_modules=True,
update_mode=GridUpdateMode.MODEL_CHANGED,
data_return_mode=DataReturnMode.FILTERED_AND_SORTED,
fit_columns_on_grid_load=False,
)
df = pd.DataFrame(response["selected_rows"])
st.subheader("Filtered data will appear below 👇 ")
st.text("")
st.table(df)
st.text("")
c29, c30, c31 = st.columns([1, 1, 2])
with c29:
CSVButton = download_button(
df,
"File.csv",
"Download to CSV",
)
with c30:
CSVButton = download_button(
df,
"File.csv",
"Download to TXT",
) |