Python Forum
Replace null values in Json file
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Replace null values in Json file
#3
1. the way you read the json is not right
with open("con_error.json", "r") as f:
    data = json.load(f)
now you have your json as data dict

2. if use str.replace to replace "null"(?!). what you do is to read json, then immediately dump it back as string. So then why read it as json at all? just read the file as text and replace "null" if you are going to do this

3. once you read the json properly as a dict you can loop over it and replace None. However it looks like complex data structure, so I cannot be more specific
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply


Messages In This Thread
Replace null values in Json file - by burnsssss - Jun-10-2018, 05:08 PM
RE: Replace null values in Json file - by Grok_It - Jun-10-2018, 06:29 PM
RE: Replace null values in Json file - by buran - Jun-10-2018, 06:50 PM
RE: Replace null values in Json file - by burnsssss - Jun-11-2018, 07:50 AM
RE: Replace null values in Json file - by volcano63 - Jun-10-2018, 07:26 PM
RE: Replace null values in Json file - by buran - Jun-11-2018, 07:57 AM
RE: Replace null values in Json file - by volcano63 - Jun-11-2018, 08:18 AM
RE: Replace null values in Json file - by buran - Jun-11-2018, 08:44 AM
RE: Replace null values in Json file - by volcano63 - Jun-11-2018, 08:56 AM
RE: Replace null values in Json file - by burnsssss - Jun-11-2018, 08:52 AM
RE: Replace null values in Json file - by buran - Jun-11-2018, 08:58 AM
RE: Replace null values in Json file - by burnsssss - Jun-11-2018, 09:45 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Replace values in Yaml file with value in dictionary PelleH 0 155 Jun-12-2024, 02:40 PM
Last Post: PelleH
  encrypt data in json file help jacksfrustration 1 487 Mar-28-2024, 05:16 PM
Last Post: deanhystad
  parse json field from csv file lebossejames 4 931 Nov-14-2023, 11:34 PM
Last Post: snippsat
  Replace a text/word in docx file using Python Devan 4 4,468 Oct-17-2023, 06:03 PM
Last Post: Devan
  Need to replace a string with a file (HTML file) tester_V 1 924 Aug-30-2023, 03:42 AM
Last Post: Larz60+
  Python Script to convert Json to CSV file chvsnarayana 8 2,817 Apr-26-2023, 10:31 PM
Last Post: DeaD_EyE
  Loop through json file and reset values [SOLVED] AlphaInc 2 2,450 Apr-06-2023, 11:15 AM
Last Post: AlphaInc
  How to express null value klatlap 3 1,002 Mar-25-2023, 10:40 AM
Last Post: klatlap
  Converting a json file to a dataframe with rows and columns eyavuz21 13 5,326 Jan-29-2023, 03:59 PM
Last Post: eyavuz21
Photo How to select NULL and blank values from MySQL table into csv python300 9 2,762 Dec-27-2022, 09:43 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