how to read json file with a list of strings in python

Question

Here is a sample of json data I created from defaultdict in python.

[{
    "company": [
        "ABCD"
    ],
    "fullname": [
        "Bruce Lamont",
        "Ariel Zilist",
        "Bruce Lamont",
        "Bobby Ramirez"
    ],
    "position": [
        " The Hesh",
        " Server",
        " HESH",
        " Production Assistant"
    ],
    "profile_url": [
        "http://www.url1.com",
        "http://www.url2.com",
        "http://www.url3.com",
        "http://www.url4.com",
    ]
}]

I realized I made a mistake creating such list. json.loads() gives this error

Error

Expecting value: line 1 column 1 (char 0).

I want something like this.

[{
    "company": [
        "name": "THALIA HALL",
        "employee": {
            fullname: "emp_name",
            "position": "position",
            profile: "url"
        },
        {
            fullname: "emp_name",
            "position": "position",
            profile: "url"
        }
    ]
}]

How can I solve this problem? I need to do this on python.

vishal · Accepted Answer · 2018-07-06 11:53:59Z

1

you are adding an extra comma in the end for profile_url array. The proper json should be

[{
    "company": [
        "ABCD"
    ],
    "fullname": [
        "Bruce Lamont",
        "Ariel Zilist",
        "Bruce Lamont",
        "Bobby Ramirez"
    ],
    "position": [
        " The Hesh",
        " Server",
        " HESH",
        " Production Assistant"
    ],
    "profile_url": [
        "http://www.url1.com",
        "http://www.url2.com",
        "http://www.url3.com",
        "http://www.url4.com"
    ]
}]

Use https://jsonformatter.curiousconcept.com/ to check for JSON formatting errors next time.

answered Jul 6, 2018 at 11:53

vishal

1,2453 gold badges11 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

godot · Accepted Answer · 2018-07-06 12:00:41Z

0

import json

j  = '[{"company":["ABCD"],"fullname":["Bruce Lamont","Ariel Zilist","Bruce Lamont","Bobby Ramirez"],"position":[" The Hesh"," Server"," HESH"," Production Assistant"],"profile_url":["http://www.url1.com","http://www.url2.com","http://www.url3.com","http://www.url4.com"]}]'


json_obj = json.loads(j)

you have your JSON as object and now you can user for making csv

edited Jul 6, 2018 at 12:00

answered Jul 6, 2018 at 11:40

godot

3,5556 gold badges27 silver badges45 bronze badges

1 Comment

Sanjib Acharya Over a year ago

I have around 2000 company info stored in a json file as shown in first snippet in my question. Actually I want to convert it into csv. How can I do that?

Collectives™ on Stack Overflow

how to read json file with a list of strings in python

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related