How to update json file with python

by

The issue here is that you’ve opened a file and read its contents so the cursor is at the end of the file. By writing to the same file handle, you’re essentially appending to the file.

The easiest solution would be to close the file after you’ve read it in, then reopen it for writing.

with open("replayScript.json", "r") as jsonFile:
    data = json.load(jsonFile)

data["location"] = "NewPath"

with open("replayScript.json", "w") as jsonFile:
    json.dump(data, jsonFile)

Alternatively, you can use seek() to move the cursor back to the beginning of the file then start writing, followed by a truncate() to deal with the case where the new data is smaller than the previous.

with open("replayScript.json", "r+") as jsonFile:
    data = json.load(jsonFile)

    data["location"] = "NewPath"

    jsonFile.seek(0)  # rewind
    json.dump(data, jsonFile)
    jsonFile.truncate()

More Related Contents:

  1. Convert Json File to data Frame
  2. How to return a dict as a JSON response from a Flask view?
  3. How to get POSTed JSON in Flask?
  4. How to parse data in JSON format?
  5. Saving utf-8 texts with json.dumps as UTF8, not as \u escape sequence
  6. How to serialize SqlAlchemy result to JSON?
  7. Python JSON serialize a Decimal object
  8. NumPy array is not JSON serializable
  9. Converting XML to JSON using Python?
  10. String to Dictionary in Python [duplicate]
  11. How can I extract a single value from a JSON response?
  12. is not JSON serializable
  13. How to load all entries in an infinite scroll at once to parse the HTML in python
  14. How to normalize json correctly by Python Pandas
  15. django-rest-framework 3.0 create or update in nested serializer
  16. How to remove whitespaces and newlines from every value in a JSON file?
  17. How do I send a POST request as a JSON?
  18. How to json_normalize a column with NaNs
  19. What is faster – Loading a pickled dictionary object or Loading a JSON file – to a dictionary? [closed]
  20. How can I loop over entries in JSON?
  21. JSON dumps custom formatting
  22. Getting values from JSON using Python
  23. How can I parse (read) and use JSON?
  24. JSON object must be str, bytes or bytearray, not dict
  25. How to append to a JSON file in Python?
  26. OpenAI GPT-3 API error: “Cannot specify both model and engine”
  27. List of objects to JSON with Python
  28. Convert JSON to SQLite in Python – How to map json keys to database columns properly?
  29. Python 2.6 JSON decoding performance
  30. How to convert csv to json in python?

Leave a Comment