Changing json file format

Question

The script scrapes prices, addresses, suburbs and postcodes of houses and then writes them to a csv file.

The csv file is imported into panda (only postcode and price) and groupby the mean price of the postcode. This groupby list is written to a json.

The csv file looks like this in excel

    ________________________
    |Postcode|Price        |
    ________________________
    |5061    | 205000      |
    ________________________
    |5063    | 930000      |
    ________________________

The code looks like this

import pandas as pd
from pandas import DataFrame
df = pd.read_csv('House_Prices.csv', usecols=[ 'Postcode' , ' Price' ], index_col=False)

grouped = df.groupby(['Postcode']).mean()

grouped.to_json('average_house_price.json')

The code above outputs the json file as

{" Price":{"5061":2025000.0,"5063":930000.0}}

I want the json file to be outputted like this

{"5061":2025000.0,"5063":930000.0}

Is there a way with the panda library (or other) to remove the starting Price index?

jezrael · Accepted Answer · 2019-12-22 06:05:39Z

1

Add column name for aggregate "Price" or " Price" for Series:

grouped = df.groupby(['Postcode'])["Price"].mean()
#grouped = df.groupby(['Postcode'])[" Price"].mean()

grouped.to_json('average_house_price.json')

answered Dec 22, 2019 at 6:05

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

vitkarpov · Accepted Answer · 2019-12-22 06:08:50Z

0

Why don't take the field before saving as JSON, like this:

grouped[" Price"].to_json('average_house_price.json')

answered Dec 22, 2019 at 6:08

vitkarpov

3993 silver badges9 bronze badges

Comments

user7548672 · Accepted Answer · 2019-12-22 06:16:09Z

0

Try passing header=None

Look here:

df = pd.read_csv('t.csv', usecols=[ 'Postcode' , ' Price' ], index_col=False, header=None)

answered Dec 22, 2019 at 6:16

user7548672

Collectives™ on Stack Overflow

Changing json file format

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related