Page 68 - IPP-12-2024

print("Data Analytics Menu")

print("1. Subject with maximum average
marks")
print("2. Subject with minimum average
marks")

print("3. Subject with maximum highest
marks")

print("4. Subject with minimum highest
marks")
print("5. Subject with maximum percentage of
A1 and A2")

print("6. Subject with minimum percentage of
A1 and A2")

print("7. Exit")

chana=int(input("Enter choice:"))

if chana==1:
m=result['Average'].max()

s=result.loc[result.Average==m]

print("Subject with maximum average marks
of ",m," is\n ",s.index)

elif chana==2:

m=result['Average'].min()
s=result.loc[result.Average==m]

print("Subject with minimum average marks
of ",m," is\n ",s.index)

elif chana==3:

m=result['Highest'].max()

s=result.loc[result.Highest==m]
print("Subject with maximum highest marks
of ",m," is\n ",s.index)

elif chana==4:

m=result['Highest'].min()

s=result.loc[result.Highest==m]