Question

Mr. Som, a data analyst has designed the DataFrame df that contains data about Computer Olympiad with ‘CO1’, ‘CO2’, ‘CO3’, ‘CO4’, ‘CO5’ as indexes shown below. Answer the following questions:

A. Predict the output of the following python statement:

i. df.shape

ii. df[2:4]

B. Write Python statement to display the data of Topper column of indexes CO2 to CO4.

OR

Write Python statement to compute and display the difference of data of Tot_students column and First_Runnerup column of the above given DataFrame.

Answer 1

A. Output:

B. Python statement:

print(df.loc['CO2': 'CO4', 'Topper'])

OR

print(df.Tot_students-df.First_Runnerup)