python api json dict in dataframe

Question

I want to scrape data at the county level from https://apidocs.covidactnow.org

However I could only get a dataframe with one line for each county, and data for each date is stored within a dictionary in each row/county. I would like to access this data and store it in long format (= have one row per county-date).

import requests
import pandas as pd
import os


if __name__ == '__main__':
    os.chdir('/home/username/Desktop/')

    url = 'https://api.covidactnow.org/v2/counties.timeseries.json?apiKey=ENTER_YOUR_KEY'
    response = requests.get(url).json()
    
    data = pd.DataFrame(response)

This seems like a trivial question, but I've tried for hours. What would be the best way to achieve that ?

Matteo Bianchi · Accepted Answer · 2021-04-30 15:34:05Z

0

Do you mean something like that?

import requests

url = 'https://api.covidactnow.org/v2/states.timeseries.csv?apiKey=YOURAPIKEY'

response = requests.get(url)
csv_response = (response.text)

# Then you can transform STRING to CSV

Check this fo string to CSV --> python parsing string to csv format

answered Apr 30, 2021 at 15:34

Matteo Bianchi

4421 gold badge6 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

python api json dict in dataframe

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related