Question
Implement in Numpy Python Load a .csv file into a DataFrame object by using the following statement: df_test= pd.read_csv('http://storm.cis.fordham.edu/~yli/data/testDataOne.csv') Answer only one question: 1. Find
Implement in Numpy Python
Load a .csv file into a DataFrame object by using the following statement:
df_test= pd.read_csv('http://storm.cis.fordham.edu/~yli/data/testDataOne.csv')
Answer only one question:
1. Find all students who have not paid tuition, how many of them? (the result should include those unknown)
Expected Output: 21 students not paid tuition, including those unknown.
What I have so far:
import numpy as np
import pandas as pd
#from pandas import DataFrame
df = pd.read_csv('http://storm.cis.fordham.edu/~yli/data/testDataOne.csv')
df
#set the name of the index of the table as 'FIDN', which starting from 1
df['FIDN']=np.arange(1,33,1)
df.set_index("FIDN",inplace=True)
df
#Find all students who have not paid tuition, how many of them? (the result should include those unknown)
print(len(df[df.Paid == "no"]|df[df.Paid.isnull()]))
There's an error here. HELP!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started