Python dataframe to JSON add additional fields

Question

I am looking to transform my dataframe to json

Age   Eye     Gender
30    blue    male

My current code, I convert the dataframe to json and get the below result:

json_file = df.to_json(orient='records')

json_file

[{'age':'30'},{'eye':'blue'},{'gender':'male'}]

However, I want to add an additional layer that would state the id and name to the json data and then label it as 'info'.

{'id':'5231'
 'name':'Bob'
 'info': [
          {'age':'30'},{'eye':'blue'},{'gender':'male'}
         ]
 }

How would I add the additional fields? I tried reading the docs however I do not see a clear answer on how to add the additional fields in during dataframe to json conversion.

Where is that additional information coming from? What format is it in? — aensm
– aensm, Commented Mar 23, 2017 at 14:30

zipa · Accepted Answer · 2017-03-23 14:35:11Z

1

Based on the data you provided this is your answer:

import pandas as pd

a = {'id':'5231',
    'name':'Bob',
}

df = pd.DataFrame({'Age':[30], 'Eye':['blue'], 'Gender': ['male']})
json = df.to_json(orient='records')

a['info'] = json

answered Mar 23, 2017 at 14:35

zipa

28k6 gold badges45 silver badges62 bronze badges

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

2 Comments

Hachi Over a year ago

hi, how do you output the result as a json file?

zipa Over a year ago

@Hachi you can use this code stackoverflow.com/questions/12309269/…

Collectives™ on Stack Overflow

Python dataframe to JSON add additional fields

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related