A Python project for automating Excel/CSV data cleaning tasks.
-
Remove duplicate rows
-
Fill missing values
-
Standardize column names
-
Export cleaned Excel files
-
Simple automation workflow
-
Python
-
pandas
-
openpyxl
python-data-automation/
│
├── data/
├── output/
├── src/
├── requirements.txt
└── README.md
Install dependencies:
pip install -r requirements.txt
Run the script:
cd src
python main.py
-
Data preprocessing
-
Excel automation
-
CSV cleaning
-
Business reporting workflows