Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Manga Guide To Databases

Authors: Mana Takahashi, Shoko Azuma, Co Ltd Trend

1st Edition

1593271905, 978-1593271909

More Books

Students also viewed these Databases questions

Question

What is Aufbau's rule explain with example?

Answered: 1 week ago