An automated utility designed to transform "messy" CSV files into structured, clean datasets. Ideal for data analysts and businesses that need to prep data for databases or BI tools.
- Empty Row Removal: Automatically detects and drops rows that contain no data.
- String Normalization: Trims hidden whitespaces from text (leading and trailing).
- Smart Type Conversion: Converts columns to numeric types where possible for better analysis.
- Safe Export: Generates a new cleaned file without modifying the original source.
This tool uses the Pandas library. You can install it via terminal:
pip install pandas🚀 How to Use Clone the repository.
Place your "dirty" CSV in the project folder.
Open csv_cleaner.py and update the input_file name in the main block.
Run: python csv_cleaner.py
This project is licensed under the MIT License. See the LICENSE file for details.
Developed by Emanuele Tarchi | Automation Specialist Portfolio