Seat No.: ________ Enrolment No.
___________
LJ. UNIVERSITY
L.J. Institute of Management Studies
MBA II SEM III
REGULAR WINTER 2024 EXAMINATION
Subject Name: Data Processing and Analysis using Python
Subject Code: 340039311 Date: 21/12/2024
Time: Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
Set-1
Ques Data Analysis - Zomato dataset Marks
Q1: Read the dataset and Perform the data cleaning of the dataset. 20
Check the shape of the dataset
Check if there is any missing value or not
Remove the duplicate rows
Remove the un-necessary columns (if any)
Check the outliers if any
Q2: Find is there any correlation between the attributes 10
Q3: Create a countplot for listed_in(type) and write the 20
conclusion for the chart.
Q4: Plot a bar chart to show that the restaurants prefer online orders or not 20
and write the conclusion for the chart.
Seat No.: ________ Enrolment No.___________
LJ. UNIVERSITY
L.J. Institute of Management Studies
MBA II SEM III
REGULAR WINTER 2024 EXAMINATION
Subject Name: Data Processing and Analysis using Python
Subject Code: 340039311 Date: 21/12/2024
Time: Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
Set-2
Ques Data Analysis – Covid Dataset Marks
Q1: Read the dataset and Perform the data cleaning of the dataset. 20
Check the shape of the dataset
Check if there is any missing value or not
Remove the duplicate rows
Remove the un-necessary columns (if any)
Check the outliers if any
Q2: Find is there any correlation between the attributes 10
Q3: Plot a barchart for visualizing total cases country/region 20
wise and write the conclusion for the chart.
Q4: Plot a horizontal barchart for visualizing total tests 20
country/region wise and write the conclusion for the chart
Seat No.: ________ Enrolment No.___________
LJ. UNIVERSITY
L.J. Institute of Management Studies
MBA II SEM III
REGULAR WINTER 2024 EXAMINATION
Subject Name: Data Processing and Analysis using Python
Subject Code: 340039311 Date: 21/12/2024
Time: Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
Set-3
Ques Data Analysis – Loan Dataset Marks
Q1: Read the dataset and Perform the data cleaning of the dataset. 20
Check the shape of the dataset
Check if there is any missing value or not
Remove the duplicate rows
Remove the un-necessary columns (if any)
Check the outliers if any
Q2: Find is there any correlation between the attributes 10
Q3: Plot a chart to show the highest number of loans issued 20
grade wise and write the conclusion of the chart
Q4: Plot a chart to show who are loan defaulters and 20
write the conclusion of the chart