Question

1. Consider the given dataframe and answer the following questions:
i. Write program to create the dataframe “student” with the above data. ii. Display all the data of the above created dataframe. iii. Write the commands to: a. Display the details of class 11 students. b. Display the project remarks of all students. c. Display the details at location 101, 103, 104 d. Display details of students where project remarks are ‘Good’ of class 11 students. e. Details of students of section “A” f. Display the details of students with marks in ACCT more than 90 and less than 80 in IP iv. Write the command to add a new column ENG in the above dataframe v. Write the command to add a new row of the child “Mahi’ at index number 105 of class 11 , section C, with marks as 90,98,87,92 in ACCT,ECO, IP, ENG respectively with Project remarks as Good vi. Write the command to change ACCT marks of index number 103 to 77 vii. Write the command to rename the column Name as SName.

Answer 1

Answer:

.........................