Extracting URLs from JSON file with python

Question

The JSON file is like this:

[
        {
            "src": "https://",
            "viewcount": "0"
        },
        {
            "src": "https://",
            "viewcount": "0"
        }

]

I wish to extract all the values under src (all of which are urls) with python.

How can I do so?

Thank you.

Joshua · Accepted Answer · 2021-06-25 02:11:50Z

1

Try loading JSON first.

Sample output:

import json

myjsonstr =  '[{"src": "https://google.com","viewcount": "0"},{"src": "https://yahoo.com","viewcount": "0"}]'

myjsonobj = json.loads(myjsonstr)

for eachitem in myjsonobj:
    print(eachitem["src"])

answered Jun 25, 2021 at 2:11

Joshua

5614 silver badges13 bronze badges

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

Comments

Edoardo Facchinelli · Accepted Answer · 2021-06-25 02:03:41Z

0

You're looking for the json module. loads will try to parse a string (watch out, there's an extra/missing bracket in what you posted).

After that, it's a regular dict.

import json

source = """[
        {
            "src": "https://",
            "viewcount": "0"
        },
        {
            "src": "https://",
            "viewcount": "0"
        }
    ]  
"""

urls = [x['src'] for x in json.loads(j)]

['https://', 'https://']

answered Jun 25, 2021 at 2:03

Edoardo Facchinelli

4225 silver badges12 bronze badges

Collectives™ on Stack Overflow

Extracting URLs from JSON file with python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related