PANDAS to JSON: Changing name of columns

Question

df = pd.concat([a,b,c,d,e], axis=1, sort=False)

I want to give column names which I usually do to output to Excel as

df.to_excel ("ids.xlsx", index = None, header=['IDs', 'Phases','Versions','Internal Version List','Tests'])

But when I do output to JSON, where should I give the header inputs?

df.to_json ('Export_DataFrame.json', orient='table')

set the names beforehand df.columns = ['IDs', 'Phases','Versions','Internal Version List','Tests'], then df.to_json(....) — gbruenjes
– gbruenjes, Commented May 13, 2020 at 9:42
Can you write this as answer so that I mark it as completed and then it would helpful for others too. Thanks — Darshan Malu
– Darshan Malu, Commented May 13, 2020 at 10:40

gbruenjes · Accepted Answer · 2020-05-13 11:26:37Z

1

You can set the column names beforehand using:

df.columns = ['IDs', 'Phases','Versions','Internal Version List','Tests']

After you can write the DataFrame to json using:

df.to_json ('Export_DataFrame.json', orient='table')

answered May 13, 2020 at 11:26

gbruenjes

4,2251 gold badge18 silver badges32 bronze badges

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

1 Answer 1