Python : JSon Output to a file

Question

I have as an output from my Python script a JSon format and I want to write the JSon into a file.

I use

df_json.to_json(orient='records') 

with open('JSONData.json', 'w') as f:
     json.dump(df_json, f)

I have the following error:

raise TypeError(repr(o) + " is not JSON serializable")

[1746 rows x 2 columns] is not JSON serializable

I don't know what I am doing wrong.

My JSon output is as follows :

[
  {
    "id": 1,
    "results": [
      1,
      2,
      3

    ]
  },
  {
    "id": 558599,
    "results": [
      4,
      5,
      6
    ]
  }
]

Thank you in advance.

Jean-François Fabre · Accepted Answer · 2017-02-24 14:04:40Z

2

you're calling df_json.to_json(orient='records') but you don't use the results. Object is not going to mutate itself into a jsonisable object.

Serializing the original object obviously doesn't work (or there wouldn't be a to_json method on it)

Since the string is already json, you don't even need the json module (or json would try to serialize the string again, which is not what you want): just do:

f.write(df_json.to_json(orient='records'))

edited Feb 24, 2017 at 14:04

answered Feb 24, 2017 at 13:28

Jean-François Fabre♦

141k24 gold badges179 silver badges246 bronze badges

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

4 Comments

Amy21 Over a year ago

Thank you for your answer, I have used this but I get some strange output with a slash ( \ ) before every double quotes ( " )

Amy21 Over a year ago

The output in my file is "[ { \"id\": 1, \"results\": [ 1, 2, 3 ] } ] "

Jean-François Fabre Over a year ago

sorry, I was mistaken earlier. It's simpler than that. Edited my answer...

Amy21 Over a year ago

Thank you, that's what I was searching for ;)

Collectives™ on Stack Overflow

Python : JSon Output to a file

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related