This project is an exploratory data analysis (EDA) on an E-commerce dataset to derive insights into customer behavior, sales trends, and potential business opportunities. The analysis is performed using Python, with a focus on data cleaning, visualization, and statistical exploration.
π E-commerce-Sales-Analysis/ β βββ e commerce sales.ipynb # Jupyter Notebook with complete analysis βββ Ecommerce Data.csv # Dataset containing e-commerce transaction details βββ README.md # Project documentation (this file)
- Clean and preprocess the dataset.
- Analyze customer purchasing patterns.
- Identify peak sales times and top-performing products.
- Understand user demographics and behavior.
- Visualize trends using seaborn, matplotlib, and pandas.
The dataset Ecommerce Data.csv
contains the following key columns:
Email
: Customer's email addressAddress
: Shipping addressAvatar
: Customer avatar (profile image)Avg. Session Length
: Time spent on the site during average sessionsTime on App
: Time spent on the mobile appTime on Website
: Time spent on the websiteLength of Membership
: Years of membershipYearly Amount Spent
: Annual spending amount by the customer
- Python 3.8+
- Pandas β for data manipulation
- Matplotlib & Seaborn β for data visualization
- Jupyter Notebook β for interactive analysis
- Customers who spend more time on the app are likely to spend more money.
- Time on website has a weaker correlation with yearly spending compared to the app.
- Membership length is positively correlated with customer spending.
- Recommendations: Focus development on the mobile app to improve customer retention and spending.
- Clone the repository:
git clone https://github.com/yourusername/e-commerce-sales-analysis.git cd e-commerce-sales-analysis
Create a virtual environment and install dependencies:
python -m venv venv
source venv/bin/activate # On Windows use venv\Scripts\activate
pip install -r requirements.txt
Launch Jupyter Notebook:
jupyter notebook "e commerce sales.ipynb"
pandas
matplotlib
seaborn
notebook
Feel free to fork this repo, make changes, and submit pull requests. Contributions are welcome!
Linkedin: Syed Darain Hyder Kazmi
Instagram: sawab_e_darain
Whatsapp: +923433055357
discord: sawab_e_darain