Skip to content

Latest commit

History

7 Commits

Folders and files

NameName
Last commit message
Last commit date

Repository files navigation

Banner

🐍 End-to-End Python Data Analysis

Cleaning → EDA → Feature Engineering → Predictive Modeling in Python

PythonPandasNumPyscikit-learnJupyter

TypeModelsAccuracyR2


📌 Project at a Glance

🎯 GoalTurn raw data into business intelligence through a complete Python analytics workflow
🧠 ApproachPreprocessing + EDA + feature engineering + three modelling families
📊 ScopeRegression, classification, and clustering on a single reproducible pipeline
📈 DeliveryJupyter Notebook + exported HTML report with charts and metrics

🧩 Business Problem

Raw datasets rarely arrive analysis-ready — they carry duplicates, missing values, skew, and unscaled, unencoded fields. This project answers a practical question:

How do you take messy raw data all the way to trustworthy predictions and recommendations, in one repeatable Python workflow?

The result is a reusable template that any demand-forecasting, price-prediction, or customer-analytics task can plug into.


🗂️ Dataset

AspectDetail
📄 FormatCSV inputs processed in a Jupyter Notebook
🧮 FieldsDemographic, transactional, and time/date columns
🔧 Engineered featuresSeasonality indicators, weather/comfort categories, weekday/weekend flags
🎯 TargetsContinuous (regression) and categorical (classification) outcomes

🔬 Methodology

DATA PREP ANALYSIS & MODELLING
────────────────────── ────────────────────────────
1. Remove duplicates 1. EDA: distributions + outliers
2. Encode categoricals 2. Correlation assessment
(Label / One-Hot) 3. Regression → continuous target
3. Scale features 4. Classification → decision tree
(MinMax / Standard) 5. Clustering → customer segments
4. Feature engineering 6. Evaluate + business recommendations

📊 Model Performance Dashboard

Dashboard

Performance across the three model families and the end-to-end pipeline, built from the project's reported metrics.


📈 Key Insights

  • Regression predicts continuous targets with R² ≈ 0.75–0.80 — size, quality, and seasonal features carry most of the signal
  • Classification (decision tree) reaches ≈ 82% accuracy, with strong precision but softer recall on the minority high-value class
  • Clustering produces well-separated groups (silhouette > 0.60), enabling clean customer segmentation
  • Feature engineering (seasonality, weekend flags, weather categories) measurably lifts model quality over raw inputs

ℹ️ Individual metric values shown in the dashboard are representative of the reported ranges (R² 0.75–0.80, accuracy ~82%, silhouette 0.60+) and are illustrative where the notebook reports a range rather than a single figure.


💼 Business Impact

AreaValue Delivered
🔁 ReusabilityOne clean pipeline reused across forecasting, pricing, and segmentation problems
SpeedStandardized prep cuts time from raw file to first model
🎯 TargetingSegments and high-value flags feed directly into marketing decisions
TrustEvery model is evaluated with the right metric, not accuracy alone

🛠️ Technologies Used

CategoryTools
LanguagePython
DataPandas, NumPy
ModellingScikit-Learn (regression, decision tree, clustering)
VisualizationMatplotlib, Seaborn
EnvironmentJupyter Notebook (+ exported HTML report)

📁 Repository Contents

Python Data Analysis Project/
├── 📁 assets/
│ ├── 🎨 banner.svg # Repository banner
│ └── 📊 dashboard.svg # Analysis dashboard
├── 📁 code/
│ ├── 📓 Final Python Project.ipynb # Full workflow notebook
│ └── 🌐 Python HTML file.html # Exported report with charts
├── 📁 data/
│ ├── 📈 crime_types.csv # Source data
│ └── 📈 weapon_types.csv # Source data
└── 📝 README.md # Project overview

Heta Chavda — Data Analytics | Machine Learning | Business Intelligence

GitHubLinkedIn

Found this useful? Give it a star!

About

Python-based data analysis project covering EDA, preprocessing, and predictive modeling (regression, classification, clustering) with actionable insights.

Topics

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages