Data Sweeper - CSV Data Cleaning App
A lightweight CSV data cleaning utility built with Streamlit and Pandas — supports duplicate removal, missing value imputation via drop, mean, or median strategies, and one-click export of the cleaned dataset.
The Challenge
Cleaning raw CSV data manually is repetitive and error-prone, requiring custom scripts for deduplication, missing value handling, and exporting results.
The Solution
Built an interactive Streamlit app powered by Pandas that automates duplicate removal, offers multiple missing-value imputation strategies, and enables instant one-click export of cleaned data.
System Architecture
Duplicate Removal
Detects and removes duplicate rows from uploaded CSV files.
Missing Value Imputation
Handles missing data through drop, mean, or median strategies.
One-Click Export
Exports the cleaned dataset instantly for immediate use.
Key Outcomes
Automated duplicate row removal for cleaner datasets.
Implemented drop, mean, and median strategies for missing value imputation.
Enabled one-click export of the cleaned dataset.