change json format generated from pandas dataframe

Question

I have a pandas dataframe and want to convert it to json format.

import pandas as pd
df = pd.DataFrame({'A': [1,2,3,4], 'B': [5,6,7,8]})
df.to_json()

'{"A":{"0":1,"1":2,"2":3,"3":4},"B":{"0":5,"1":6,"2":7,"3":8}}'

The json string I need is like below:

'{"A":[1,2,3,4], "B":[5,6,7,8]}'

How can I get this json string from pandas dataframe? Thanks a lot.

abc · Accepted Answer · 2020-02-05 20:30:08Z

1

You can use to_dict() with orient='list' and consider the string representation of the output.

>>> str(df.to_dict(orient='list'))
"{'A': [1, 2, 3, 4], 'B': [5, 6, 7, 8]}"

answered Feb 5, 2020 at 20:30

abc

12k2 gold badges30 silver badges55 bronze badges

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

Comments

Renaud · Accepted Answer · 2020-02-05 20:32:07Z

0

Did you tried to put the argument index=False:

https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.to_json.html

index:bool, default True Whether to include the index values in the JSON string. Not including the index (index=False) is only supported when orient is ‘split’ or ‘table’.

New in version 0.23.0.

answered Feb 5, 2020 at 20:32

Renaud

2,8172 gold badges12 silver badges25 bronze badges

Collectives™ on Stack Overflow

change json format generated from pandas dataframe

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related