This project focuses on cleaning, transforming, and analyzing student grade and tuition datasets using Python libraries such as Pandas.
The project includes:
- Handling missing values
- Removing duplicate records
- Creating new columns using conditions
- Merging datasets
- Grouping and analyzing data
- Exporting cleaned datasets to CSV and Excel
- Python
- Pandas
- Jupyter Notebook
- Excel
- student_data_wrangling.ipynb
- grades.csv
- tuition.xlsx
- output1.csv
- output1.xlsx
- Data cleaning
- Duplicate detection and removal
- Missing value handling
- Conditional column creation
- Dataset merging
- Grouping and aggregation
- Sorting and filtering
- Data export