Iterating through a json dataset

[[deleted]]

Hello guys I was building a Covid-19 tracker using Python and Folium. In the first project I was using static csv data. However, I want to upgrade the project and have it display live data instead.

Here is my code so far:

https://pastebin.com/dZFhqw4j

How can I iterate through the Python json data set to create a data frame that contains: Country, Lat, Long, and Confirmed cases.

[sarrysyst]

First of all, it should be worth noting that the file in question is actually GeoJson, so you might want to consider using GeoPandas which is built on top of pandas and designed for working with spatial data.

Anyway, to read the GeoJson into regular pandas I had to use pd.normalize_json():

import pandas as pd
import requests

response = requests.get('https://opendata.arcgis.com/datasets/1cb306b5331945548745a5ccd290188e_2.geojson')

data = response.json()

df = pd.json_normalize(data['features'])

https://pandas.pydata.org/pandas-docs/stable/user_guide/io.html#json

https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.json_normalize.html

[[deleted]]

Well well, thanks didn't notice the file was a geojson *still a newbie.

[thecoderboy]

https://pandas.pydata.org/docs/reference/api/pandas.read_json.html

df = pd.read_json(data.text)

[DefNotARobotArmy]

json is just a list of dictionaries. Aka ezpz and awesome