Question

Ope
311
Grade Calculation Using DataFrame
Assignment - 1
application to demonstrate the pandas DataFrame for the following
A DataFrame called Student contains the following data columns:
Enter the roll number (RollNo), Name of the student and the five subject marks.
Calculate the TotalMarks, Per (Percentage), and Grades for each student for the
The TotalMarks, Per (Percentage), and Grade will be calculate as given below:
Name
E Mark
Create an
operation:
RollNo
P_Mark
CMark M_Mark IP Mark
DataFrame.
.
= E Mark +P_Mark +C_Mark + M_Mark + IP Mark
TotalMarks
Per
TotalMarks / 5
The Grades will be calculated as:
Percentage
Grade
91 - 100
A1
81 - 90
A2
71 - 80
B1
61 - 70
B2
51 - 60
С1
41 - 50
C2
33 - 40
D
21 - 32
00 - 20
E2
All the newly calculated columns (TotalMarks
, Per, and Grades) will be inserted
into the DataFrame.
Print the final DataFrame.
Any number of students can be entered according to users choice. While printing the
data, the Name of each student will only print 15 characters.
E1
Solution​

Answer 1

Answer:

Explanation: DataFrame called Student contains the following data columns:

Enter the roll number (RollNo), Name of the student and the five subject marks.

Calculate the TotalMarks, Per (Percentage), and Grades for each student for the

The TotalMarks, Per (Percentage), and