In [1]:

    

import pandas as pd
from textblob import TextBlob


    

In [16]:

    

listings = pd.read_csv('listings.csv')
listings = listings[["neighbourhood", "price"]]


    

In [19]:

    

listings = listings.groupby('neighbourhood').mean().reset_index()


    

In [33]:

    

_min = listings.price.min()
_max = listings.price.max()

listings.price = listings.price.apply(lambda x: ((x-_min)/(_max - _min)))
listings.max()


    

    
Out[33]:





neighbourhood    Yorkdale-Glen Park
price                             1
dtype: object

In [30]:

    

import json
demo = {
    'result': listings.to_dict(orient='record')
}


with open('pricy.json', 'w') as outfile:
    json.dump(demo, outfile)