Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
json format
#4
(Apr-21-2022, 03:34 PM)deanhystad Wrote: 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 } ]

Thanks a lot.
This output format isn't enough compact.
I prefer this one :
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}
]

Is it allowed for json format ?
If yes, I will add code to obtain this format (not with json library).
Is there other format to obtain this type of output? I can make my format but I would like to use known format.
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,498 Dec-05-2024, 04:32 PM
Last Post: Larz60+
  format json outputs ! evilcode1 3 2,803 Oct-29-2023, 01:30 PM
Last Post: omemoe277
  Converting cells in excel to JSON format desmondtay 4 3,077 May-23-2022, 10:31 AM
Last Post: Larz60+
  Return in correct json format UtiliseIT 3 3,850 May-13-2019, 11:24 AM
Last Post: snippsat
  how do I format json data in splunk? fxtyom 14 17,357 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