This is a Streamlit app that helps users preprocess and clean CSV files quickly and stress-free. Users can upload one or multiple CSV files, and the app provides several options to merge, filter, and display the cleaned data.
Click Here To View This App Online!
- Upload one or multiple CSV files.
- Merge uploaded CSV files.
- Keep only the header of the first file.
- Remove duplicate rows.
- Remove empty rows.
- Choose end-line characters.
- Preview DataFrames before downloading.
- Download cleaned data as separate CSV files.
After running the app, you will see a title and description explaining the app's purpose. You can then upload one or multiple CSV files using the file uploader. The app provides options for merging and cleaning the uploaded data.
- Merge uploaded CSV files: If you upload multiple files, you can merge them into a single DataFrame.
- Keep only the header (first row) of the first file: When merging files, you can choose to keep only the header of the first file and match columns from the other files.
- Remove duplicate rows: Remove any duplicate rows in the merged DataFrame.
- Remove empty rows: Remove any empty rows in the merged DataFrame.
- End line: Choose the end-line characters for your CSV files.
- Show DataFrames: Preview the cleaned DataFrames before downloading.
- Download cleaned data: Download the cleaned data as separate CSV files or one big file.
- Python 3.6 or higher
- Streamlit
- Pandas
- Clone the repository:
git clone https://github.com/Kaludii/CSV-Data-Cleaning-Tool.git
- Install the required packages: To run this app, you will need to install the following dependencies or type
pip install -r requirements.txtto automatically download:
streamlitpandas
You can install them using pip:
pip install streamlit pandas
- Run the app:
streamlit run app.py