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
#1
Hi all!!
i am new in forum so i have very much to read!

I have one problem with some code in python. I am trying to replace None values in Json file to "vacio" values.

My example of read file is:

data = []
for reng in open("con_error.json", "r"):
    data.append(json.loads(reng))
and the result is:

[{u'contributors': None,
u'coordinates': None,
u'created_at': u'Sun Jun 10 14:21:53 +0000 2018',
u'entities': {u'hashtags': [],
u'symbols': [],
u'urls': [],
u'user_mentions': [{u'id': 254599256,
u'id_str': u'254599256',
u'indices': [3, 11],
u'name': u'Alejandro Fargosi',
u'screen_name': u'fargosi'}]},
u'favorite_count': 0,
u'favorited': False,
u'filter_level': u'low',
u'geo': None,
u'id': 1005817329459097600L,
u'id_str': u'1005817329459097600',
u'in_reply_to_screen_name': None,
u'in_reply_to_status_id': None}]

Now, i use the next code for replace None for "vacio":

json_string=json.dumps(data).replace("null", "vacio")
and the result is:

'[{"quote_count": 0, "contributors": vacio, "truncated": false, "text": "RT @fargosi: Del 20-4 al 10-6-18, nuestros defensores:\\nMauro Maldonado muerto\\nAbigail Alvarez muerta\\nJorge Cusi muerto\\nDaniel Rios, muerto\\u2026", "is_quote_status": false, "in_reply_to_status_id": vacio, "reply_count": 0, "id": 1005817329459097600, "favorite_count": 0, "entities": {"user_mentions": [{"id": 254599256, "indices": [3, 11], "id_str": "254599256", "screen_name": "fargosi", "name": "Alejandro Fargosi"}], "symbols": [], "hashtags": [], "urls": []}, "retweeted": false, "coordinates": vacio, "timestamp_ms": "1528640513182", "source": "<a href=\\"http://twitter.com/download/iphone\\" rel=\\"nofollow\\">Twitter for iPhone</a>", "in_reply_to_screen_name": vacio, "id_str": "1005817329459097600", "retweet_count": 0, "in_reply_to_user_id": vacio, "favorited": false, "retweeted_status":... }]

Now, i want to transform this result to a new object in format of dict for extract data more easy, such as first result. I tried
json.loads(json_string)
but i have error : No JSON object could be decoded

I next would execute next code, for this reason i need access by dict format:
usuarios = []
texto = []
fechas = []
localizaciones = []

for line in open('con_error.json', 'r'):  
    usuarios.append(json.loads(line)['user']['name']) 
    texto.append(json.loads(line)['text']) 
    fechas.append(json.loads(line)['created_at']) 
    
    localizaciones.append(json.loads(line)['place']['name'])
Thank you very much and sorry if there is some mystake in my post. It is my first post!
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 239 Mar-28-2024, 05:16 PM
Last Post: deanhystad
  parse json field from csv file lebossejames 4 772 Nov-14-2023, 11:34 PM
Last Post: snippsat
  Replace a text/word in docx file using Python Devan 4 3,493 Oct-17-2023, 06:03 PM
Last Post: Devan
  Need to replace a string with a file (HTML file) tester_V 1 778 Aug-30-2023, 03:42 AM
Last Post: Larz60+
  Python Script to convert Json to CSV file chvsnarayana 8 2,554 Apr-26-2023, 10:31 PM
Last Post: DeaD_EyE
  Loop through json file and reset values [SOLVED] AlphaInc 2 2,153 Apr-06-2023, 11:15 AM
Last Post: AlphaInc
  How to express null value klatlap 3 871 Mar-25-2023, 10:40 AM
Last Post: klatlap
  Converting a json file to a dataframe with rows and columns eyavuz21 13 4,559 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,462 Dec-27-2022, 09:43 PM
Last Post: deanhystad
  validate large json file with millions of records in batches herobpv 3 1,286 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