Question

Write a program in Python Pandas to create the following DataFrame batsman from a Dictionary:

B_NO	Name	Score1	Score2
1	Sunil Pillai	90	80
2	Gaurav Sharma	65	45
3	Piyush Goel	70	90
4	Kartik Thakur	80	76

Perform the following operations on the DataFrame :

(1) Add both the scores of a batsman and assign to column “Total”

(2) Display the highest score in both Score1 and Score2 of the DataFrame.

(3) Display the DataFrame.

Answer 1

Alternative Answer