Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
json format
#2
Load json, modify and dump is the correct method. You do not want to append the file.

You should not worry about the format of your json data. Json files are easy to read, but are not designed to be human readable. You can make the file a little prettier using the indent argument.
import json

data = [
    {"surname" : "xxx", "forename" : "jean", "age" : 24},
    {"surname" : "yyy", "forename" : "paul", "age" : 31},
    {"surname" : "zzz", "forename" : "julia", "age" : 28},
    {"surname" : "aaa", "forename" : "Paul", "age" : 40}
]

with open("test.json", "w") as outfile:
    json.dump(data, outfile, indent=4)
Output:
[ { "surname": "xxx", "forename": "jean", "age": 24 }, { "surname": "yyy", "forename": "paul", "age": 31 }, { "surname": "zzz", "forename": "julia", "age": 28 }, { "surname": "aaa", "forename": "Paul", "age": 40 } ]
Bubu93200 likes this post
Reply


Messages In This Thread
json format - by Bubu93200 - Apr-21-2022, 03:15 PM
RE: json format - by deanhystad - Apr-21-2022, 03:34 PM
RE: json format - by Bubu93200 - Apr-21-2022, 04:43 PM
RE: json format - by davediamond - Apr-21-2022, 03:51 PM
RE: json format - by deanhystad - Apr-21-2022, 05:08 PM
RE: json format - by Bubu93200 - Apr-21-2022, 05:17 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Convert Json to table format python_student 4 15,404 Dec-05-2024, 04:32 PM
Last Post: Larz60+
  format json outputs ! evilcode1 3 2,788 Oct-29-2023, 01:30 PM
Last Post: omemoe277
  Converting cells in excel to JSON format desmondtay 4 3,057 May-23-2022, 10:31 AM
Last Post: Larz60+
  Return in correct json format UtiliseIT 3 3,836 May-13-2019, 11:24 AM
Last Post: snippsat
  how do I format json data in splunk? fxtyom 14 17,292 May-24-2017, 09:23 PM
Last Post: micseydel

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020