python pandas dataframe 转json_将Pandas DataFrame转换为JSON格式

I have a Pandas DataFrame with two columns – one with the filename and one with the hour in which it was generated:

File Hour

F1 1

F1 2

F2 1

F3 1

I am trying to convert it to a JSON file with the following format:

{"File":"F1","Hour":"1"}

{"File":"F1","Hour":"2"}

{"File":"F2","Hour":"1"}

{"File":"F3","Hour":"1"}

When I use the command DataFrame.to_json(orient = "records"), I get the records in the below format:

[{"File":"F1","Hour":"1"},

{"File":"F1","Hour":"2"},

{"File":"F2","Hour":"1"},

{"File":"F3","Hour":"1"}]

I'm just wondering whether there is an option to get the JSON file in the desired format. Any help would be appreciated.

解决方案

The output that you get after DF.to_json is a string. So, you can simply slice it according to your requirement and remove the commas from it too.

out = df.to_json(orient='records')[1:-1].replace('},{', '} {')

To write the output to a text file, you could do:

with open('file_name.txt', 'w') as f:

f.write(out)