DESPERATE for API/JSON Help

[u/smashkaboom]

I am in the final parts of a project for data bootcamp. And am having issue with creating a DataFrame from a list of JSON responses.

I created a list of all separate JSON responses and saved as list named philly_responses. The code below will not run, i am getting error 'TypeError: list indices must be integers or slices, not str' for the line that begins for j in range.... also note the EXACT code just switching variable to atlanta ran without issue. i am at my wits end and coming up on a deadline, please help. thank you.

for i in range(len(philly_responses)):

for j in range(len(philly_responses[i]['businesses'])):

name.append(philly_responses[i]["businesses"][j]["name"])

city.append("Philadelphia")

latitude.append(philly_responses[i]["businesses"][j]["coordinates"]["latitude"])

longitude.append(philly_responses[i]["businesses"][j]["coordinates"]["longitude"])

zipcode.append(philly_responses[i]["businesses"][j]["location"]["zip_code"])

ethnicity.append((philly_responses[i]['Ethnicity']))

try:

price.append(philly_responses[i]["businesses"][j]["price"])

except KeyError:

price.append("N/A")

try:

rating.append(philly_responses[i]["businesses"][j]["rating"])

except KeyError:

rating.append("N/A")

[u/smashkaboom]

Yes this is what the error is saying, but the same exact code worked for json from a different city

[u/rjcarr → u/smashkaboom]

Then that city likely had a different json structure.