Student Name:
João Victor Sena Seri
Course:
Data Analysis for Business Insights
Week Number:
Week 1
Project Title:
Sales Data Analysis for ShopEase
---
1. Summary of Dataset:
The dataset contains 21 rows and 23 columns. However, many columns from `Unnamed: 11` to
`Unnamed: 22` are empty or irrelevant. The core columns include: `Transaction_ID`, `Date`,
`Customer_ID`, `Product`, `Category`, `Quantity`, `Price`, `Total_Amount`, `Payment_Method`,
`Region`, and `Advertising_Spend`. These provide detailed information about each transaction,
including product type, payment method, and geographical region.
2. Missing or Duplicate Data:
- Several important columns contain missing values, such as `Transaction_ID`, `Date`,
`Customer_ID`, `Price`, and `Total_Amount`.
- The `Total_Amount` column is missing two values, which impacts revenue analysis.
- There are no duplicate rows in the dataset.
