Class 12 IP Practical - 22

 

22. Consider the DataFrame (dfmks) given below.

	A	B	C	D
Acct	99	94.0	92	97.0
Eco	90	94.0	92	97.0
Eng	95	89.0	91	89.0
IP	94	NaN	99	95.0
Math	97	100.0	99	NaN

WAP to print the maximum marks scored in each subject across all sections.

import pandas as pd

import numpy as np

d={'A':{'Acct':99,'Eco':90,'Eng':95,'IP':94,'Math':97}, \

   'B':{'Acct':94.0,'Eco':94.0,'Eng':89.0,'IP':np.NaN,'Math':100.0}, \

   'C':{'Acct':92,'Eco':92,'Eng':91,'IP':99,'Math':99}, \

   'D':{'Acct':97.0,'Eco':97.0,'Eng':89.0,'IP':95.0,'Math':np.NaN}}

 

dfmks=pd.DataFrame(d)

print("DataFrame is: ")

print(dfmks)

print("Maximum Marks in each subject across all sections. ")

print(dfmks.max(axis=1))

 

 

 

>>>

======================= RESTART: C:/Program Files (x86)/Python38-32/IP-22.py ======================

DataFrame is:

       A      B   C     D

Acct  99   94.0  92  97.0

Eco   90   94.0  92  97.0

Eng   95   89.0  91  89.0

IP    94    NaN  99  95.0

Math  97  100.0  99   NaN

Maximum Marks in each subject across all sections.

Acct     99.0

Eco      97.0

Eng      95.0

IP       99.0

Math    100.0

dtype: float64

>>>