Read multiple keys from a JSON file in Python

Question

I am a little stuck with the following task that I am trying to sort out as I am just learning Python. I need to sort out "city" from the json file that looks like:

[{
    "city": "Las Vegas",
    "operator": "",
    "browser_name": "chromium",
    "browser_version": "55",
    "country_code": "us",
    "country": "United States",
    "location_code": "2e4efc13-6a6a-45ba-a6aa-ec4eb1f4fb2b|north-america.na.us.west.lasvegas|chromium|55",
    "location_tier": "1"
}, {
    "city": "Las Vegas",
    "operator": "",
    "browser_name": "firefox",
    "browser_version": "46",
    "country_code": "us",
    "country": "United States",
    "location_code": "2e4efc13-6a6a-45ba-a6aa-ec4eb1f4fb2b|north-america.na.us.west.lasvegas|firefox|46",
    "location_tier": "1"
}, ...

I have the code like this:

import json, operator

file_path = './response.json'

with open(file_path) as f:
    data = json.loads(f.read())
    print(data[0]['city'])

The thing is that I need comma separated output to a console like "city, city, city...". Would appreciate any help! Thanks a lot!

buran · Accepted Answer · 2022-01-26 12:40:22Z

1

print(', '.join(item['city'] for item in data))

Also, have a look at this answer, using inflect package that will allow for properly constructed list in English, e.g. city, city, and city

answered Jan 26, 2022 at 12:40

buran

14.4k13 gold badges45 silver badges76 bronze badges

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

Comments

Zendem · Accepted Answer · 2022-01-26 12:39:49Z

0

You are very close to the result. You can have a list like this. Code;

import json, operator
file_path = './response.json'
result = []
with open(file_path) as f:
    data = json.loads(f.read())
    for d in data:
        result.append(d['city'])
print(result)

Output; ['Las Vegas', 'Las Vegas']

answered Jan 26, 2022 at 12:39

Zendem

5465 silver badges8 bronze badges

2 Comments

chitown88 Over a year ago

@Zendem, why import operator?

Zendem Over a year ago

I didn't want to change your friend's code. I guess he will use it later.

Collectives™ on Stack Overflow

Read multiple keys from a JSON file in Python

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related