Question: forgot to include this in the beginning part: from pandas import Series, DataFrame [2] import pandas as pd import numpy as np [4] df_test =

 forgot to include this in the beginning part: from pandas import

Series, DataFrame [2] import pandas as pd import numpy as np [4]df_test = pd. read_cs te: df_test firstName LastName DOB Major tuition Paid

forgot to include this in the beginning part:

from pandas import Series, DataFrame

[2] import pandas as pd import numpy as np [4] df_test = pd. read_cs te: df_test firstName LastName DOB Major tuition Paid 0 Lisa AAA 1/1/2000 CS 5000.0 yes 1 Tom BBB 1/1/1999 Math 12000.0 na 2 John CCC 10/20/1989 Physics 15000.0 no 3 Matt DDD 4/21/1989 CS 20667.0 yes 4 4 Kate EEE 10/22/1989 Math 25667.0 no 5 Bill AAA 10/23/1989 Physics 30867.0 no 6 A BBB 10/24/1989 CS 35867.0 yes 7 7 B CCC 1/25/1989 Math 40867.0 no 8 DDD 3/26/1989 Physics 45867.0 na 9 d EEE 10/27/1989 CS 50867,0 yes 10 y FFF 10/28/1989 Math 55667.0 no 11 y HHH 10/29/1989 Physics 60667.0 no 12 C GGG 10/30/1989 CS 65667.0 yes 13 JJK 10/31/1989 Math 70667.0 no 14 DFDF 11/1/1989 Physics 75667.0 no 15 y DRE 11/2/1989 CS 80667.0 yes 16 z CF 11/3/1989 Math 85667.0 yes 17 Z CFEA 12/4/1989 CS 90667.0 no 18 Zz YRY 1/5/1989 Math 95667.0 no 19 Z JGKJHK 11/6/1989 Physics 100667.0 yes 20 z RTDH 10/7/1989 CS 105667.0 no 21 ZZ FHSF 11/8/1990 Math 110667.0 no 22 za GHGJD 11/9/1989 Physics 115667.0 yes 23 W RTR 11/10/1989 CS 120667.0 no 24 e VBV 1/11/1989 Math 125667.0 no 25 r FGSFH 11/21/1989 Physics 130667.0 yes 26 Tom VBV 11/13/1989 CS 135667.0 NaN 27 y FGSER 11/2/1989 Math 140667.0 NaN 28 u OPK 11/15/1989 Physics 145667.0 NaN 29 i FFF 11/16/1989 CS 150667.0 NaN 30 d WWA 1/17/1989 Math 155667.0 no 31 iy DGK 11/18/1989 Physics 160667.0 yes dla ISIT Steps. 1. Show the first five rows of the dataframe table. 2. Show number of rows and columns of this table. 3. Show all column names. 4. Set the name of the index of the table as 'FIDN', which starting from 1. 5. Find all students majored in CS. How many of them? 6. Find all students who have not paid tuition, how many of them? (The result should include those unknown.) httpsacolah reseregle.com S_TORROW paato0ASER -1&l=true rilnozo 17/18 3/2/2021 OK 7. Find all students who are CS students and have not paid the tuition. (The intersection of two index objects could be found by & operation) 8. Find students with FIDN from 10 to 20. 9. Find the major of the student whose FIDN is 30. 10. Sort all students by their last name, then by their tuition amount. [2] import pandas as pd import numpy as np [4] df_test = pd. read_cs te: df_test firstName LastName DOB Major tuition Paid 0 Lisa AAA 1/1/2000 CS 5000.0 yes 1 Tom BBB 1/1/1999 Math 12000.0 na 2 John CCC 10/20/1989 Physics 15000.0 no 3 Matt DDD 4/21/1989 CS 20667.0 yes 4 4 Kate EEE 10/22/1989 Math 25667.0 no 5 Bill AAA 10/23/1989 Physics 30867.0 no 6 A BBB 10/24/1989 CS 35867.0 yes 7 7 B CCC 1/25/1989 Math 40867.0 no 8 DDD 3/26/1989 Physics 45867.0 na 9 d EEE 10/27/1989 CS 50867,0 yes 10 y FFF 10/28/1989 Math 55667.0 no 11 y HHH 10/29/1989 Physics 60667.0 no 12 C GGG 10/30/1989 CS 65667.0 yes 13 JJK 10/31/1989 Math 70667.0 no 14 DFDF 11/1/1989 Physics 75667.0 no 15 y DRE 11/2/1989 CS 80667.0 yes 16 z CF 11/3/1989 Math 85667.0 yes 17 Z CFEA 12/4/1989 CS 90667.0 no 18 Zz YRY 1/5/1989 Math 95667.0 no 19 Z JGKJHK 11/6/1989 Physics 100667.0 yes 20 z RTDH 10/7/1989 CS 105667.0 no 21 ZZ FHSF 11/8/1990 Math 110667.0 no 22 za GHGJD 11/9/1989 Physics 115667.0 yes 23 W RTR 11/10/1989 CS 120667.0 no 24 e VBV 1/11/1989 Math 125667.0 no 25 r FGSFH 11/21/1989 Physics 130667.0 yes 26 Tom VBV 11/13/1989 CS 135667.0 NaN 27 y FGSER 11/2/1989 Math 140667.0 NaN 28 u OPK 11/15/1989 Physics 145667.0 NaN 29 i FFF 11/16/1989 CS 150667.0 NaN 30 d WWA 1/17/1989 Math 155667.0 no 31 iy DGK 11/18/1989 Physics 160667.0 yes dla ISIT Steps. 1. Show the first five rows of the dataframe table. 2. Show number of rows and columns of this table. 3. Show all column names. 4. Set the name of the index of the table as 'FIDN', which starting from 1. 5. Find all students majored in CS. How many of them? 6. Find all students who have not paid tuition, how many of them? (The result should include those unknown.) httpsacolah reseregle.com S_TORROW paato0ASER -1&l=true rilnozo 17/18 3/2/2021 OK 7. Find all students who are CS students and have not paid the tuition. (The intersection of two index objects could be found by & operation) 8. Find students with FIDN from 10 to 20. 9. Find the major of the student whose FIDN is 30. 10. Sort all students by their last name, then by their tuition amount

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Lets work through each of the tasks step by step using the provided DataFrame python import pandas a... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!