Python creating JSON object from string

Question

I'm new to Python and trying to generate a list of dictionaries in JSON format. I get the data from Selenium by iterating through an element. I get the output as string. Here's my selenium snippet:

Company = driver.find_elements_by_xpath("//*[@class='au-target company']")
Category = driver.find_elements_by_xpath("//*[@class='job-category']")

I get my data by using a for loop like this:

for value in Company:
    print(value.text)

for value in Category:
    print(value.text)

Here are my results:

Company A
Company B
Company C
Digital Technology
Manufacturing
Supply Chain

I would like to have my data in the following format

[
    {
        "Company": "Company A",
        "Category": "Digital Technology"
    },
    {
        "Company": "Company B",
        "Category": "Manufacturing"
    },
    {
        "Company": "Company C",
        "Category": "Supply Chain"
    }
]

So far I have been unsuccessful using the json module. Thanks!

Does this answer your question? Python: Combine multiple lists into one JSON array — BcK
– BcK, Commented Dec 21, 2021 at 11:55

mxp-xc · Accepted Answer · 2021-12-21 11:47:32Z

1

You can handle it like this

d = []
for company, category in zip(Company, Category):
    d.append({
        "company": company.text,
        "category": category.text
    })

or

d = [
    {"company": company.text, "category": category.text}
    for company, category in zip(Company, Category)
]

answered Dec 21, 2021 at 11:47

mxp-xc

5242 silver badges6 bronze badges

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

1 Comment

vboxer00 Over a year ago

Thanks! I've gone with your first suggestion, worked like a charm!

shaik moeed · Accepted Answer · 2021-12-21 11:47:04Z

0

Try this,

data = []
for comp, cat in zip(Company, Category):
    data.append({'Company':comp, 'Category': cat})

Output:

data
[
    {
        "Company": "Company A",
        "Category": "Digital Technology"
    },
    {
        "Company": "Company B",
        "Category": "Manufacturing"
    },
    {
        "Company": "Company C",
        "Category": "Supply Chain"
    }
]

answered Dec 21, 2021 at 11:47

shaik moeed

5,5882 gold badges25 silver badges63 bronze badges

Collectives™ on Stack Overflow

Python creating JSON object from string

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related