Iterating through json object in python

Question

I have a response from Foursquare that reads as follows

response: {
    suggestedFilters: {},
    geocode: {},
    headerLocation: "Harlem",
    headerFullLocation: "Harlem",
    headerLocationGranularity: "city",
    query: "coffee",
    totalResults: 56,
    suggestedBounds: {},
    groups: [{
                type: "Recommended Places",
                name: "recommended",
                items: [{
                            reasons: {
                                count: 1,
                                items: [{
                                    summary: "You've been here 6 times",
                                    type: "social",
                                    reasonName: "friendAndSelfCheckinReason",
                                    count: 0
                                }]
                            },
                            venue: {
                                id: "4fdf5edce4b08aca4a462878",
                                name: "The Chipped Cup",
                                contact: {},
                                location: {},
                                categories: [],
                                verified: true,
                                stats: {},
                                url: "http://www.chippedcupcoffee.com",
                                price: {},
                                hasMenu: true,
                                rating: 8.9,
                                ratingColor: "73CF42",
                                ratingSignals: 274,
                                menu: {},
                                allowMenuUrlEdit: true,
                                beenHere: {},
                                hours: {},
                                photos: {},
                                venuePage: {},
                                storeId: "",
                                hereNow: {}
                            },
                            tips: [],
                            referralId: "e-0-4fdf5edce4b08aca4a462878-0"
                        },

]

If I type the following:

for value in json_data['response']['groups'][0]:
print(value['name'])

I get a TypeError: string indices must be integers

I'm just wondering how to iterate through this response to get the names of businesses.

Thanks

Possible duplicate of Iterating through a JSON object

MooingRawr
– MooingRawr

2016-10-14 13:35:15 +00:00
Commented Oct 14, 2016 at 13:35 — MooingRawr
– MooingRawr, Commented Oct 14, 2016 at 13:35
It clearly doesnt look like valid JSON

sisanared
– sisanared

2016-10-14 13:37:09 +00:00
Commented Oct 14, 2016 at 13:37 — sisanared
– sisanared, Commented Oct 14, 2016 at 13:37
You're missing a ] and a }

mugabits
– mugabits

2016-10-14 15:00:00 +00:00
Commented Oct 14, 2016 at 15:00 — mugabits
– mugabits, Commented Oct 14, 2016 at 15:00

larsks · Accepted Answer · 2016-10-14 13:38:40Z

1

json_data['response']['groups'][0] is a dictionary. When you iterate over a dictionary, you are iterating over a list of keys, all of which are strings...so within the loop, value is a string.

So when you ask for value['name'], you are trying to index the string with ['name'], which doesn't make any sense, hence the error.

I think you meant:

for value in json_date['response']['groups']

answered Oct 14, 2016 at 13:38

larsks

318k49 gold badges473 silver badges482 bronze badges

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

Comments

OneCricketeer · Accepted Answer · 2016-10-14 13:55:12Z

1

You went too far. The [0] is the first element of the groups

for value in json_data['response']['groups']

Or you need to actually parse the JSON data from a string with the json.loads function

Also, I think you want

value['venue']['name']

edited Oct 14, 2016 at 13:55

answered Oct 14, 2016 at 13:36

OneCricketeer

193k20 gold badges146 silver badges276 bronze badges

4 Comments

Ron Arevalo Over a year ago

I'm using the requests library which has a build in json function that parses the response I think? Also when I do as you suggested I get a new error: UnicodeEncodeError: 'ascii' codec can't encode character '\xe9' in position 11003: ordinal not in range(128)

OneCricketeer Over a year ago

That error seems to point at an encoding problem, not a problem with my answer. If you update your question with a minimal reproducible example of the requests code, then I'll look into it

Antti Haapala Over a year ago

@RonArevalo that error would also seem to suggest that you use Python 2 (yet parenthesize print like in Python 3); perhaps time to switch to Python 3 as well.

OneCricketeer Over a year ago

@AnttiHaapala Well, the question doesn't contain valid JSON (keys aren't quoted), so maybe that's the error. Hard to say

Collectives™ on Stack Overflow

Iterating through json object in python

2 Answers 2

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related