This project uses Python and Pandas to clean, prepare, and analyze supermarket sales data.
The dataset used in this project is:
SuperMarket.csv
The goal is to clean the data and answer business questions using the available sales and transaction information.
🛠️ Tools Used
Python
Pandas
Matplotlib / Seaborn (Optional)
Streamlit (Optional)
🧹 Data Cleaning
The following data-cleaning steps were performed:
Checked data types
Checked missing values
Checked duplicate records
Renamed columns
Removed unnecessary columns
Corrected data types
Sorted the data
Create 3 columns (Day, Month, Year )
Created the satisfied column based on the rating