This project analyses e-commerce sales data to identify key business insights such as:
- Most sold products
- Best performing cities
- Monthly and hourly sales trends
- Relationship between quantity and revenue
To demonstrate data cleaning, analysis, and visualisation skills using Python, Pandas, NumPy, and Matplotlib.
- Python 3
- Pandas
- NumPy
- Matplotlib
- Jupyter Notebook
The dataset contains sales information, including:
Order IDProductQuantity OrderedPrice EachOrder DatePurchase AddressMonthSalesCityHour
- Top-selling product: Determined using grouped sales quantities.
- Most profitable city: Calculated using total sales.
- Monthly trends: Identified peak sales months.
- Hour analysis: Found the best time of day for orders.
- Bar chart of Top 10 Most Sold Products
- Sales comparison by City
- Monthly sales trend
This project helped explore real-world business questions using Python.
It showcases strong skills in:
- Data Cleaning
- Exploratory Data Analysis (EDA)
- Visualization
- Insight Reporting
| File | Description |
|---|---|
sales Data.ipynb |
Jupyter Notebook with complete code |
sales data.csv |
Dataset used for analysis |
README.md |
Project documentation |
NITHIN.Y
Aspiring Data Analyst | Python & SQL Enthusiast
www.linkedin.com/in/46nithin