Python Forum
Filling in missing values
Thread Rating:
  • 1 Vote(s) - 4 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Filling in missing values
#5
Hello

Not sure about how your json file looks but why not keep things simple and find the Value which is none. I am not sure what exactly you want to achieve but the below may help

import json

data = []
keys = ["field1","field2","field3","field4", "field5", "field6" ]

with open('test_json.json') as json_data:
    for line in json_data:
        dataline = json.loads(line)
        row = []
        for key in keys:
            row.append(dataline.get(key))
        data.append(row)
Reply


Messages In This Thread
Filling in missing values - by melm0 - Aug-08-2017, 08:44 PM
RE: Filling in missing values - by Bass - Aug-08-2017, 08:46 PM
RE: Filling in missing values - by melm0 - Aug-09-2017, 12:52 AM
RE: Filling in missing values - by sparkz_alot - Aug-09-2017, 11:50 AM
RE: Filling in missing values - by radioactive9 - Aug-09-2017, 03:59 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Filling NaNs in a financial dataset larzz 11 2,013 Jun-07-2023, 03:40 PM
Last Post: snippsat
  groupby on var with missing values error zenvega 0 1,768 May-07-2021, 07:40 PM
Last Post: zenvega

Forum Jump:

User Panel Messages

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