Using Python / Pandas, in a new Jupyter Notebook please do the following: 1.) Cr

ID: 3919467 • Letter: U

Question

Using Python / Pandas, in a new Jupyter Notebook please do the following:

1.) Create a print statement to output the number of data rows in the csv file. Format output as "File has %d rows".

2.) In a new cell, display a dataframe containing all series that is sorted by "Average Household Size" (high-to-low or low-to-high is fine)

3.) In a new cell, display a dataframe containing only the 'Zipcode' and 'Median Age' series, sorted by 'Median Age' low-to-high. (Hint: ascending = True parameter...)

4.) In a new cell, display the above data frame but filter out all 'Median Age' values that are less than 1. (We don't want the '0' cases)

5.) Finally, in a new cell, show the Zip Code, Total Population, and Total Households for the top ten zip codes ranked by Total Population.

CSV FILE https://files.fm/u/v6y96f9g

Explanation / Answer

#import csv

import csv

# create filename

nameoffile = "ela.csv"

# initializing firlds and rows

data = []

rows = []

# reading filename

with open(nameoffile, 'r') as csvfile:

#reader object creation

reader = csv.reader(csvfile)

# extracting field names through first row

data = reader.next()

# extract row one by one

for row in csvreader:

rows.append(row)

# get total number of rows

print("Total no. of rows: %d"%(reader.numberrows))

# printing the data

print('datas are:' + ', '.join(data for data in datas))

# printing first 5 rows

print(' First 5 rows are: ')

for row in rows[:5]:

# going through the column

for col in row:

print("%10s"%col),

print(' ')

// to add the columns in pandas