Question: File Edit View Insert Runtime Tools Help All changes saved + Code + Text RAM: Disk Editing A [72] import pandas as pd import numpy

File Edit View Insert Runtime Tools Help All changes saved + Code + Text RAM: Disk Editing A [72] import pandas as pd import numpy as np from pandas import Series, DataFrame [73] df_test -

File Edit View Insert Runtime Tools Help All changes saved + Code + Text RAM: Disk Editing A [72] import pandas as pd import numpy as np from pandas import Series, DataFrame [73] df_test - pd. read csv df_test D 0 Lisa AAA 1/1/2000 CS 5000.0 yes 1 Tom BBB 1/1/1999 Math 12000.0 no 2 John CCC 10/20/1989 Physics 15000.0 no 3 Matt DDD 4/21/1989 CS 20687.0 yes 4 Kate EEE 10/22/1989 Math 25667.0 no 5 5 Bill AAA 10/23/1989 Physics 30667.0 no 6 BBB 10/24/1969 CS 35687.0 yes 7 B 1/25/1989 Math 40667.0 8 DDD 3/26/1989 Physics 45687.0 9 d EEE 10/27/1989 CS 50667.0 yes 10 FFF 10/28/1989 Math 55667.0 no 11 HHH 10/29/1989 Physics 60687.0 12 GGG 10/30/1989 CS 65667.0 yes 13 y JJK 10/31/1989 Math 70687.0 14 y DFDF no 11/1/1989 Physics 75667.0 11/2/1989 cs 80667.0 15 y DRE yes 16 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 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.) https://colab.research.google.com/drive/1A0n6HinpZ-O6tBpysa3_TBRROpaatOO#scrollTo=zotW_Prsp6-1&printMode=true 17/18 3/2/2021 2_DataTypes_PdSeriesDF_HomeworkTwo.ipynb - Colaboratory 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. File Edit View Insert Runtime Tools Help All changes saved + Code + Text RAM: Disk Editing A [72] import pandas as pd import numpy as np from pandas import Series, DataFrame [73] df_test - pd. read csv df_test D 0 Lisa AAA 1/1/2000 CS 5000.0 yes 1 Tom BBB 1/1/1999 Math 12000.0 no 2 John CCC 10/20/1989 Physics 15000.0 no 3 Matt DDD 4/21/1989 CS 20687.0 yes 4 Kate EEE 10/22/1989 Math 25667.0 no 5 5 Bill AAA 10/23/1989 Physics 30667.0 no 6 BBB 10/24/1969 CS 35687.0 yes 7 B 1/25/1989 Math 40667.0 8 DDD 3/26/1989 Physics 45687.0 9 d EEE 10/27/1989 CS 50667.0 yes 10 FFF 10/28/1989 Math 55667.0 no 11 HHH 10/29/1989 Physics 60687.0 12 GGG 10/30/1989 CS 65667.0 yes 13 y JJK 10/31/1989 Math 70687.0 14 y DFDF no 11/1/1989 Physics 75667.0 11/2/1989 cs 80667.0 15 y DRE yes 16 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 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.) https://colab.research.google.com/drive/1A0n6HinpZ-O6tBpysa3_TBRROpaatOO#scrollTo=zotW_Prsp6-1&printMode=true 17/18 3/2/2021 2_DataTypes_PdSeriesDF_HomeworkTwo.ipynb - Colaboratory 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

To solve these questions lets use Python with the pandas library Well assume the DataFrame dftest is ... View full answer

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!

Need to fill in all parts that say "Implement me" and answer in one or two lines here. The following cell contains code that will be referred to as the Preprocessing Block from now on. It contains a...

Need help getting started on these questions. I am supposed to add code where it says "implement me" and write the answer where it says answer in one or two line. Need to fill in the "Implement me"...

This question uses the code on top to simulate a data set. Question mumber 2 asks what code would you use to test the hyporthesis colab.research google.com Testing Hypotheses Testing Hypotheses.pnb....

This is a coding problem and i dont know the code to run a hypothesis for this specific example colab.research google.com Testing Hypotheses Testing Hypotheses.pnb. Colaboratory Updates Not Installed...

I do not have access to Python or excel/office Covid sick cant access school computer last time getting error please help No matter how much I access and cleanData1 I always get an error on every...

This code block works with data.all-data but I don't understand why does not accept data.csv file. I don't know how to use phyton well. I would be glad if you could help. Code Block: # -*- coding:...

Run Markdown NFL Play-by-play Modeling and Classification In [10] : import os import pandas as pd import numpy as np import seaborn as sb import statsmodels . api as sm import sklearn. tree as tr...

Define the null and alternative hypothesis in mathematical terms and in words. Report the level of significance. Include the test statistic and the P-value. See Step 2 in the Python script. Provide...

Use the link in the Jupyter Notebook activity to access your Python script. Once you have made your calculations, complete the discussion. The script will output answers to the questions given below....

INSTRUCTIONS This assignment testsyour ability to create a simple regression solution to a prediction problem. You will use a dataset of bike rentals fromCapital Bikeshare system, Washington D.C.,...

Canadian Pacific Railway is planning to computerize the inventory management operations of its' train engine repair center. Following details were captured by the system analysts who performed the...

Timmy and co begin operations on 1/1/X1 by issuing a 3.00 year term (Bullet) bond with a par value of $4,700,000. The bond pays interest semi- annually. On the date of issuance, the annual coupon...

Which of the following is the primary cash flow management tool for most consumers, providing a way to pay for expenses and store cash until it is needed? a . money market account b . individual...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

How many Tables Will Base HCMSs typically have? Why?

What is the process of normalization?

What is Notation in Data Modeling, and what is the most common Notation Type used?