📊 Data Analysis & CSV Cleaner (Python)

An automated Python script that cleans messy CSV files and provides data insights through visualizations. Perfect for datasets with inconsistent formatting, missing values, or unclear column names.

---

✅ Features

• 📥 Robust CSV loading (handles UTF-8 and Latin-1 encodings)
• 🧹 Cleans column names (removes spaces, trims whitespace)
• 🗑 Removes duplicate rows
• 🧠 Intelligent missing value handling (separates numeric and text fields)
• 📈 Auto-generates useful visualizations:
  • Score distribution
  • City-wise count
  • Join-year trends
• 💾 Exports a cleaned version of the input file
• 🖼 Saves all charts as PNG images

---

📂 Files Included

• main.py – the main script
• sample.csv – sample messy CSV for testing
• cleaned_sample.csv – cleaned CSV (output)
• score_distribution.png – visualization of numeric data
• city_counts.png – count plot by city
• join_years.png – join date timeline
• screenshots/ – (optional) place to store project screenshots for GitHub/Fiverr

---

▶️ How to Run

# 1. Install dependencies (if not already)
pip install pandas seaborn matplotlib

# 2. Run the script
python main.py

---

📷 Example Output

Add screenshots of:

• Cleaned CSV preview
• Visualizations like Score distribution, City count, etc.

---

🧠 Ideal Use Cases

• Freelancers offering data cleaning services
• Analysts who want to automate EDA (exploratory data analysis)
• Anyone who works with messy spreadsheets or unstructured data

---

💼 Want This as a Service?

This is part of my Fiverr portfolio. If you're looking to:

• Clean a CSV
• Generate quick insights
• Automate your reporting workflow...

➡️ Hire me on Fiverr (replace with your Fiverr profile link)