The Student Performance Analytics System is a data analysis project developed using Python, Pandas, and Matplotlib. The objective of this project is to analyze student academic performance, generate meaningful insights, and visualize key metrics related to grades, attendance, and subject-wise performance.
This project simulates a real-world data analytics workflow, starting from raw CSV data and ending with actionable insights and visual reports.
- Calculate Total Marks for each student
- Calculate Percentage Scores
- Assign Grades based on performance
- Categorize students based on attendance percentage
- Identify students requiring attendance improvement
- Identify Top 3 Performing Students
- Determine Class Topper
- Calculate Average Marks for each subject
- Identify Subject Toppers
- Analyze the distribution of grades across the class
- Generate summary statistics
- Generate a processed student performance dataset
- Create a final class performance report
- Grade Distribution Chart
- Subject Average Marks Chart
| Technology | Purpose |
|---|---|
| Python | Core Programming Language |
| Pandas | Data Cleaning & Analysis |
| Matplotlib | Data Visualization |
| Jupyter Notebook | Development Environment |
| CSV | Data Storage |
Student_Performance_Analytics/
│
├── Student_Performance_Analytics.ipynb
├── Student.csv
├── student_performance_report.csv
├── Grade_Distribution.png
├── Subject_Average_Marks.png
└── README.md
Raw Student Dataset (CSV)
│
▼
Data Loading using Pandas
│
▼
Data Processing
(Total Marks, Percentage, Grades)
│
▼
Attendance Analysis
│
▼
Student Ranking & Subject Analysis
│
▼
Data Visualization
│
▼
Final Report Generation
- Total Marks
- Percentage
- Grade
- Attendance Status
- Class Average
- Top Performing Students
- Grade Distribution
- Attendance Summary
- Average Marks by Subject
- Subject Toppers
- Visual representation of student grade categories.
- Comparison of average marks across subjects.
- Exported CSV containing calculated performance metrics.
This project demonstrates practical knowledge of:
- Data Cleaning
- Data Transformation
- Exploratory Data Analysis (EDA)
- Data Aggregation
- Data Visualization
- Reporting & Insight Generation
- Python for Data Analytics
- Pandas DataFrame Operations
- Interactive Dashboard using Power BI
- Excel Report Automation
- Streamlit Web Application
- Student Performance Prediction using Machine Learning
Saurav18K.
Aspiring Data Analyst | Python | Pandas | SQL | Excel | Power BI
✅ Completed
This project was developed as part of a Data Analyst learning roadmap to gain hands-on experience with Python-based data analysis and reporting.