Python Forum
Append JSON's and write to file
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Append JSON's and write to file
#1
I have a Sample JSON record in a file as below
{ "name":"John", "age":30, "car":"BMW" }

I want to create more JSON records out of it and i want to minimize the i/o by not writing to the file system everytime i create sample record, the code below is to change the age using parameters and hold the JSON records in a list and write to the file system when i am done generating the records.


    # Read the sample file
    with open("C:/myfile.json") as file:
        originalJSON = json.load(file)
    # How many sample Records?
    numberOfRecords = 4
    i = 1
    myOutput = [] # initializing a dummy list to append my json's
    while (i <= numberOfRecords):
            # Change the age
            originalJSON["age"] = i
            myOutput.append(originalJSON)
            i += 1
    # After appending all the JSON's to the list i want to write the JSON array to a file
    with open("C:/multiplerecords.json", 'w') as multipleJsons:
        json.dump(myOutput, multipleJsons)
The output looks like

[{ "name":"John", "age":4, "car":"BMW" }
{ "name":"John", "age":4, "car":"BMW" }
{ "name":"John", "age":4, "car":"BMW" }
{ "name":"John", "age":4, "car":"BMW" }]

$$$ the issue i see is, when i write myOutput list it generates 4 records in it but all of them are duplicates, the last json that was produced is written to the whole list. Instead i am looking for something like below

[{ "name":"John", "age":1, "car":"BMW" }
{ "name":"John", "age":2, "car":"BMW" }
{ "name":"John", "age":3, "car":"BMW" }
{ "name":"John", "age":4, "car":"BMW" }]


###################################################################################################################
Reply


Messages In This Thread
Append JSON's and write to file - by faqsap - May-13-2020, 09:27 PM
RE: Append JSON's and write to file - by bowlofred - May-14-2020, 06:34 AM
RE: Append JSON's and write to file - by faqsap - May-14-2020, 06:22 PM
RE: Append JSON's and write to file - by bowlofred - May-15-2020, 07:26 AM
RE: Append JSON's and write to file - by faqsap - May-15-2020, 04:20 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Last record in file doesn't write to newline gonksoup 3 364 Jan-22-2024, 12:56 PM
Last Post: deanhystad
  parse json field from csv file lebossejames 4 668 Nov-14-2023, 11:34 PM
Last Post: snippsat
  write to csv file problem jacksfrustration 11 1,367 Nov-09-2023, 01:56 PM
Last Post: deanhystad
  python Read each xlsx file and write it into csv with pipe delimiter mg24 4 1,304 Nov-09-2023, 10:56 AM
Last Post: mg24
  How do I read and write a binary file in Python? blackears 6 6,001 Jun-06-2023, 06:37 PM
Last Post: rajeshgk
  Python Script to convert Json to CSV file chvsnarayana 8 2,343 Apr-26-2023, 10:31 PM
Last Post: DeaD_EyE
  Loop through json file and reset values [SOLVED] AlphaInc 2 1,958 Apr-06-2023, 11:15 AM
Last Post: AlphaInc
  Reading data from excel file –> process it >>then write to another excel output file Jennifer_Jone 0 1,046 Mar-14-2023, 07:59 PM
Last Post: Jennifer_Jone
Question How to append integers from file to list? Milan 8 1,358 Mar-11-2023, 10:59 PM
Last Post: DeaD_EyE
  Read text file, modify it then write back Pavel_47 5 1,499 Feb-18-2023, 02:49 PM
Last Post: deanhystad

Forum Jump:

User Panel Messages

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