Grade 12 Holiday Homework Projects – Python Pandas
Case Study 1: TechMart Sales Insights
Background:
TechMart is a retail store selling electronic gadgets in Delhi, Mumbai, and Bangalore. The
management wants to analyze its quarterly sales to understand customer behavior, top-
performing products, and financial trends using data analysis.
Objective:
Use Python Pandas to create, manipulate, and analyze a DataFrame to generate useful
business insights.
Project Task:
❖ Part A: Create the DataFrame
➢ Create a DataFrame with at least 15 rows and the following
columns:
- Product_ID
- Product_Name
- Category (Laptop, Mobile, Accessories)
- City (Delhi, Mumbai, Bangalore)
- Units_Sold
- Unit_Price
- Quarter (Q1, Q2, Q3, Q4)
❖ Part B: Data Processing and Computation
➢ Create a new column Total_Sales = Units_Sold * Unit_Price
• Display:
- First 5 and last 5 rows
- Summary statistics using .describe()
- Info about data types using .info()
❖ Part C: Data Filtering & Grouping
➢ Display products sold in Mumbai
➢ Filter and display data where Units_Sold > 50
➢ Group by Category and show total Units_Sold and Total_Sales
➢ Group by City and Quarter to find total sales per quarter in each
city
❖ Part D: Advanced Analysis
➢ Sort the DataFrame by Total_Sales in descending order
• Find and display:
- The product with maximum sales
- The city with minimum total sales
- The average unit price for each category
Submission Instructions
• Mail a well-commented .py or .ipynb file on bparashar@[Link]
• Name your file as: FullName_Class12_Pandas_Project1
• Ensure all tasks are completed and verified.
• Deadline:12-06-25
Case Study 2: Euro International School Progress
Tracker
Background:
Euro International School has collected academic performance data for its senior students. The
principal wants to analyze this data to identify high performers, weak subjects, and performance
trends. You have been appointed as a data analyst to help with this analysis.
Objective:
Use Python Pandas to perform data analysis on student marks data and derive useful academic
insights.
Project Tasks
❖ Part A: Create the DataFrame
➢ Create a DataFrame with at least 12 rows and the following
columns:
- Student_ID
- Name
- Class_Section (e.g., 12A, 12B)
- Subject (IP, CS, English, Maths, Physics, etc.)
- Marks_Obtained
- Total_Marks (out of 100)
- Term (Term1, Term2, Preboard, Final)
❖ Part B: Data Processing and Computation
➢ Create a new column Percentage = (Marks_Obtained /
Total_Marks) * 100
• Display:
- First 5 and last 5 records
- Data types using .dtypes or .info()
- Summary statistics using .describe()
❖ Part C: Data Filtering & Grouping
➢ Filter and display all records where Subject is Informatics
Practices (IP)
• Show records where Percentage is greater than 90
• Group by Subject and show:
- Average marks
- Highest marks
• Group by Class_Section to show average performance in
each section
❖ Part D: Advanced Analysis
➢ Sort data based on Percentage (highest to lowest)
• Find and display:
- The student with the highest percentage
- The subject with the lowest average score
- The number of students scoring above 80% in Term 1
Submission Instructions
• Mail a well-commented .py or .ipynb file on bparashar@[Link]
• Use meaningful column names and values.
• File name: FullName_Class12_Performance_Analysis2
• Deadline: 12-06-25
