Writing multiple json objects to a json file

Question

I have a list of json objects that I would like to write to a json file. Example of my data is as follows:

    {
    "_id": "abc",
    "resolved": false,
    "timestamp": "2017-04-18T04:57:41 366000",
    "timestamp_utc": {
        "$date": 1492509461366
    },
    "sessionID": "abc",
    "resHeight": 768,

    "time_bucket": ["2017-year", "2017-04-month", "2017-16-week", "2017-04-18-day", "2017-04-18 16-hour"],
    "referrer": "Standalone",
    "g_event_id": "abc",

    "user_agent": "abc"
    "_id": "abc",
} {
    "_id": "abc",
    "resolved": false,
    "timestamp": "2017-04-18T04:57:41 366000",
    "timestamp_utc": {
        "$date": 1492509461366
    },
    "sessionID": "abc",
    "resHeight": 768,

    "time_bucket": ["2017-year", "2017-04-month", "2017-16-week", "2017-04-18-day", "2017-04-18 16-hour"],
    "referrer": "Standalone",
    "g_event_id": "abc",

    "user_agent": "abc"
}

I would like to wirte this to a json file. Here's the code that I am using for this purpose:

with open("filename", 'w') as outfile1:
    for row in data:
        outfile1.write(json.dumps(row))

But this gives me a file with only 1 long row of data. I would like to have a row for each json object in my original data. I know there are some other StackOverflow questions that are trying to address somewhat similar situation (by externally inserting '\n' etc.), but it hasn't worked in my case for some reason. I believe there has to be a pythonic way to do this.

How do I achieve this?

You can specify option of display within the dumps method, eg. can you try json.dumps(row, indent=4, separators=(',', ': ')) to see how it goes? I will do a proper response if it works. — Kruupös
– Kruupös, Commented Jul 3, 2017 at 19:51
What kind of python type is your original data? Is it a string, list of dictionaries, files? — Håken Lid
– Håken Lid, Commented Jul 3, 2017 at 19:54
The data in your example is not valid json. Multiple objects must be inside either an array or another object. — Håken Lid
– Håken Lid, Commented Jul 3, 2017 at 20:08
@Patthebug the code in your comment is missing a write() call, that's why there is no output. — emulbreh
– emulbreh, Commented Jul 3, 2017 at 20:09
If you want to get help with this, include a minimal reproducible example. This question is incomplete, since there's no way to tell what variable data is. The example "json" is not valid json, so presumably your actual input data is different. — Håken Lid
– Håken Lid, Commented Jul 3, 2017 at 20:15

newtover · Accepted Answer · 2017-07-03 22:09:22Z

3

The format of the file you are trying to create is called JSON lines.

It seems, you are asking why the jsons are not separated with a newline. Because write method does not append the newline.

If you want implicit newlines you should better use print function:

with open("filename", 'w') as outfile1:
    for row in data:
       print(json.dumps(row), file=outfile1)

answered Jul 3, 2017 at 22:09

newtover

32.3k11 gold badges89 silver badges89 bronze badges

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

Comments

Håken Lid · Accepted Answer · 2017-07-03 20:20:40Z

0

Use the indent argument to output json with extra whitespace. The default is to not output linebreaks or extra spaces.

with open('filename.json', 'w') as outfile1:
     json.dump(data, outfile1, indent=4)

https://docs.python.org/3/library/json.html#basic-usage

answered Jul 3, 2017 at 20:20

Håken Lid

23.2k10 gold badges58 silver badges73 bronze badges

Collectives™ on Stack Overflow

Writing multiple json objects to a json file

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related