Question

Write a class named SatData that reads a JSON file containing data on 2010 SAT results for New York City and writes the data to a text file in CSV (comma-separated values) format. It just needs to read a local JSON file - it doesn't need to access the internet. Specifically, your class should have an init method that reads the file, and it should have a method named save_as_csv that takes as a parameter a list of DBNs (district bureau numbers) and saves a CSV file that looks like this, but with only the rows corresponding to the DBNs in the list (and also the row of column headers). You may assume that the DBNs in the list are all present in the JSON file. The rows in the CSV file must be sorted in ascending order by DBN. The name of the file must be output.csv. There is a csv module for Python, but you will not use it for this project. CSV is a very simple format - just commas separating columns and newlines separating rows. The JSON file will be named sat.json and will be provided - you do not need to submit it.

For example, your class could be used like this:

sd = SatData()
dbns = ["02M303", "02M294", "01M450", "02M418"]
sd.save_as_csv(dbns)

Some of the school names contain one or more commas. How should you preserve such a name as a single field in CSV format, since commas normally separate fields? The correct way to handle that is to enclose such names in double quotes in your CSV file. If you open up the example CSV file in a text editor, you can see that's what it does.

The file must be named: SatData.py

MUST BE WRITTEN IN PYTHON!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Answer 1

Hi Friend,

I tooked a dummy json file to create the code for your problem, whoes format is given below:

******** JSON FORMAT **********

{}JSON +{}meta []data [] 0:"row-4fb2.h7ir.w2nm" 1:"00000000-0000-0000-47D2-278BF31BBA1F" 2:0 3: 1425759032 4: null 5: 1425759032 6: null 7:"{}" 8:01M292" 9: "Henry Street School for International Studies 10: "31" 11: "391" 12: "425" 13: "385" []1 0:"row-txg5_999b-z2yr" 1:"00000000-0000-0000-B7F9-6857A2443692" 2:0 3: 1425759032 4: null 5: 1425759032 6: null 7:"{}" 8:"01M448" 9: "University Neighborhood High School" 10: "60" 11: "394" 12: "419" 13: "387" UUUL

I have inline comments in the code for the ease of your understanding

********** CODE *******************

import json
class SatData:
def __init__(self):
#Read the json file
with open('test_json.json','r') as f:
self.data = json.load(f)['data']
def save_as_csv(self,dbns):
resData=[]#to store the required dbns data
#Fetch the data of the required dbns
for data in self.data:
if data[8] in dbns: #8assuming dbns is located at position 8
resData.append(data)
#Sorting the dbns data based upon the dbns
resData = sorted(resData,key=lambda x:x[8])

#Create output.csv to store the reult
with open('output.csv','a+') as f:
#Add the row of column header
header = [ str(i) for i in range(len(resData[0]))]
f.write(','.join(header))
#Create new row
f.write('\n')
#Add the remaining data
for row in resData:
rowData=[]
for item in row:
#To handle the entry which has , in between
if ',' in str(item):
rowData.append("\""+item+"\"")
else:
rowData.append(str(item))
f.write(','.join(rowData))
#Create new row
f.write('\n')
  
sd = SatData()
dbns = ["02M303", "02M294", "01M450", "02M418"]
sd.save_as_csv(dbns)

******* SNAPSHOT *****************

import json class SatData: definit__(self): #Read the json file with open('test_json.json', 'r') as f: self.data = json.load(f) ('data'] def save_as_csv (self, dbns): resData=[]#to store the required dbns data #Fetch the data of the required dins for data in self.data: if data[8] in dbns: #Sassuming dbns is located at position 8 resData.append(data) #Sorting the dbns data based upon the dbns resData = sorted (resData, key=lambda x:x[8]) #Create output.csv to store the reult with open('output.csv', 'at') as f: #Add the row of column header header = [ str(i) for i in range (len (resData[0]))] f.write(','.join (header)) #Create new row f.write("\n') #Add the remaining data for row in resData: rowData=[] for item in row: #To handle the entry which has, in between if ',' in str(item): rowData.append("""+item+"|"") else: rowData.append(str(item)) f.write(','.join (rowData)) #Create new row f.write('\n') sd = SatData() dbns = ["02M303", "O2M294", "O1M450", "O2M418"] sd.save as csv (dons)

Output

H M 4 6 B 10 row-37g8. 00000000- row-qywq 00000000- row-yvp3_00000000- row-b79e. 00000000- D E 2 3 B 0 1.43E+09 None 0 1.43E+09 None 0 1.43E+09 None 01.43E+09 None F G 5 1.43E+09 None 1.43E+09 None 1.43E+09 None 1.43E+09 None 8 9 01M450 East Side 02M294 HIGH SCHO 02M303 The Facing 02M418 Millenniun L 10 11 69418 51 382 59 381 12 431 364 373 554 N 13 402 366 377 140 512 523

I hope it helps

Please get back to me in comment section in case of any query

Have a great day