Find a data set in csv format. An interesting website is Link (Links to an exter

Question

Find a data set in csv format. An interesting website is Link (Links to an external site.)Links to an external site..( https://www.data.gov/)
Use home_sales.py program from class to guide you in making the data available to you for analysis. (There is a copy of that program in Files/Assignment 6.)
Use lists in conjunction with dictionaries to describe your data in at least 3 ways.
For instance, the number of houses sold in age categories: 1 to < 11, 11 to < 21, 21 to < 31, 31 and greater; the number of houses and their average selling price for houses with 5, 6, 7, 8, 9, 10, 11 rooms.
Present your descriptive statistics clearly and neatly. Tables are good for that. Include a reference (url) to the data you are using. Turn in your csv file with your python program(s).
Rooms
# houses
Avg Sell Price
5
1
89.0
6
3
135.3
7
11
139.6
8
21
162.5
9
8
180.9
10
4
212.0
11
1
567.0
12
1
212.0

home_sales.py
import csv
def main():
filename = "HomeSales.csv"
with open(filename) as file:
reader = csv.reader(file)
#header_row = next(reader)
Sell = []
List = []
Living = []
Rooms = []
Beds = []
Baths = []
Age = []
Acres = []
Taxes = []
for row in reader:
Sell.append(int(row[0]))
List.append(int(row[1]))
Living.append(int(row[2]))
Rooms.append(int(row[3]))
Beds.append(int(row[4]))
Baths.append(int(row[5]))
Age.append(int(row[6]))
Acres.append(float(row[7]))
Taxes.append(int(row[8]))
#print('Sell',len(Sell),max(Sell),min(Sell))
#print('Taxes',len(Taxes),max(Taxes),min(Taxes))
print(max(Sell),min(Sell))
print(max(Taxes),min(Taxes))
main()

Explanation / Answer

Let me know if you have any doubt.

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.