Skip to content

About

WEIntern Week 1 Data Science Internship Project -E-Commerce Sales Analysis,Data Cleaning & Dashboard Mockup

Topics

Resources

Stars

0 stars

Watchers

0 watching

Forks

Latest commit

 

History

90 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

WeIntern Data Science Internship - Week 1 Project

📌Week Number and Objective

Week: Week 1

Objective: The goal is to clean data, analyze key performance indicators (KPIs), and visualize sales trends.

Dataset Description

Dataset Name:'ecommerce_data.csv'

Description:Contains e-commerce transaction details including order IDs,product categories,quantities sold,prices,payment methods,and timestamps.

🛠️ Tools & Technologies Used

Platform:Google Colab

Language:Python

Libraries:Pandas & Matplotlib (for Data Analysis & Visualization)

📊 Key Tasks Completed

  1. Data Cleaning:* Handled missing values and duplicates in ecommerce_data.csv.
  2. Sales & KPI Analysis:* Calculated Total Revenue, Total Orders, Average Order Value, Total Units Sold, Top Category, and Best Product.
  3. Data Visualization:* Generated Bar Charts, Line Charts, and Pie Charts to represent sales trends and payment distributions.

Folder structure

data-science-week1-assignment/ │ ├── weintern_week1_project (1).py

Google Colab Project File

└── README.md

Project Documentation

Author Details

Name: Himani Surendra More

Internship:WEIntern Pvt Ltd Data Science Internship.

Markdown Screenshots & Visual Outputs https://github.com/theeventhost21/data-science-week1-assignment/blob/main/Data%20Cleaning%20Output.png https://github.com/theeventhost21/data-science-week1-assignment/blob/main/KPI%20Analysis%20Result.png https://github.com/theeventhost21/data-science-week1-assignment/blob/main/dataset-overview.png https://github.com/theeventhost21/data-science-week1-assignment/blob/main/dashboard-mockup.png https://github.com/theeventhost21/data-science-week1-assignment/blob/main/Screenshot_Bar_Chart.png https://github.com/theeventhost21/data-science-week1-assignment/blob/main/Screenshot_Line_Chart.png https://github.com/theeventhost21/data-science-week1-assignment/blob/main/Screenshot_Pie_Chart.png

About

WEIntern Week 1 Data Science Internship Project -E-Commerce Sales Analysis,Data Cleaning & Dashboard Mockup

Topics

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages