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
#10
(Jun-11-2018, 08:44 AM)buran Wrote:
(Jun-11-2018, 08:18 AM)volcano63 Wrote: This simple code produces the same result (but nobody listens Doh )
Python Code: (Double-click to select all)
1

json.loads(json.dumps(data).replace('null', '"vacio"'))

(Jun-10-2018, 06:50 PM)buran Wrote: 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
the simplest code wouldn't need to import/use json at all

My point was that the approach initially taken by OP would have worked with a slight adjustment. Recursion is the proper way - but solution-like it is simpler with json(not everyone is proficient with recursions - it took me a Scala course to grok it better).
Test everything in a Python shell (iPython, Azure Notebook, etc.)
  • Someone gave you an advice you liked? Test it - maybe the advice was actually bad.
  • Someone gave you an advice you think is bad? Test it before arguing - maybe it was good.
  • You posted a claim that something you did not test works? Be prepared to eat your hat.
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
  encrypt data in json file help jacksfrustration 1 280 Mar-28-2024, 05:16 PM
Last Post: deanhystad
  parse json field from csv file lebossejames 4 799 Nov-14-2023, 11:34 PM
Last Post: snippsat
  Replace a text/word in docx file using Python Devan 4 3,658 Oct-17-2023, 06:03 PM
Last Post: Devan
  Need to replace a string with a file (HTML file) tester_V 1 796 Aug-30-2023, 03:42 AM
Last Post: Larz60+
  Python Script to convert Json to CSV file chvsnarayana 8 2,601 Apr-26-2023, 10:31 PM
Last Post: DeaD_EyE
  Loop through json file and reset values [SOLVED] AlphaInc 2 2,207 Apr-06-2023, 11:15 AM
Last Post: AlphaInc
  How to express null value klatlap 3 883 Mar-25-2023, 10:40 AM
Last Post: klatlap
  Converting a json file to a dataframe with rows and columns eyavuz21 13 4,710 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,546 Dec-27-2022, 09:43 PM
Last Post: deanhystad
  validate large json file with millions of records in batches herobpv 3 1,316 Dec-10-2022, 10:36 PM
Last Post: bowlofred

Forum Jump:

User Panel Messages

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