DataFrames Exercises#

Section Title: DataFrames Exercises

Question-1#

Load the grades CSV file from https://raw.githubusercontent.com/datasmp/datasets/main/grades.csv into a DataFrame.

  • Use the Pandas read_csv() method.

  • Display the first 10 rows of the DataFrame.

  • Display the last 10 rows of the DataFrame.

Question-2#

Display the Test 3 grade of the student rlpsr (5th student):

  • Using loc

  • Using iloc

Question-3#

Display the column labels.

Question-4#

Remove the gender column from the DataFrame.

Question-5#

Add a new column named Weighted Average, calculated as follows:

\(0.10 \times HW + 0.15 \times Test1 + 0.15 \times Test2 + 0.15 \times Test3 + 0.15 \times Test4 + 0.3 \times Final\)

Question-6#

Display only the name of the student with highest Weighted Average.

Question-7#

Find the number of students in the 11th grade.