This repository contains a Python script that allows you to filter data in an Excel file using Streamlit, a web application framework for Python. The script utilizes the pandas library for data manipulation.
- Python 3
- Clone the repository:
git clone https://github.com/lojer19/streamlit-multi-columns-data-filter-demo.git- Install the required dependencies:
pip install -r requirements.txt- Run the script:
streamline run filter.py- The Streamlit web application will open in your browser.
- Click on the "Upload Excel file" button and select an Excel file (.xlsx or .xls) containing the data you want to filter.
- Enter the row number that contains the column titles in the Excel file. This row will be skipped when reading the data.
- The script will display a multi-select dropdown for each column in the dataset. Select the values you want to filter by for each column.
- The filtered data will be displayed below the filters.
Pull requests are welcome.