In [1]:
import pandas as pd
In [19]:
assaults = pd.read_csv('assault.csv')
assaults = assaults[["Name","Number of occurrences per 10,000 residents in 2011"]]
assaults = assaults.rename(index=str, columns={"Name": "neighborhood", "Number of occurrences per 10,000 residents in 2011": "crime"})
min_ = float(assaults.crime.min())
max_ = float(assaults.crime.max())
assaults["crime"] = assaults["crime"].apply(lambda x: (float(x) - min_)/(max_-min_))
In [24]:
assaults
Out[24]:
In [25]:
import json
demo = {
'result': assaults.to_dict(orient='record')
}
with open('assaults.json', 'w') as outfile:
json.dump(demo, outfile)