[vc_row][vc_column width=”1/1″][vc_column_text]Alle Datenreihen können direkt in Python importiert werden.
Der folgende Beispiel-Code zeigt die Schritte auf. Der Code kann als Jupyter Notebook direkt heruntergeladen werden.[/vc_column_text][vc_button border_width=”0″]Download Jupyter Notebook[/vc_button][vc_column_text]
import requests import pandas as pd from pandas.io.json import json_normalize username = 'USER' password = 'PASSWORD' url_tokens = 'http://nova-db.com/api/v1/tokens' url_series = 'http://nova-db.com/api/v1/series/' #TOKEN REQUEST r = requests.post(url_tokens, auth=(username, password)) r.status_code # 200 for successful response response = r.json() print(response) # Series of interest series = 'population' # Optional search parameters. Set to "None" to get all. params = {'region': 'Zuerich', 'year': 2016} # Prepare token for bearer authentication token = response['token'] token_bearer = 'Bearer ' + token print(token_bearer) headers = { 'Authorization': token_bearer, } #DATA REQUEST s = requests.get(url_series + series, params=params, headers=headers) s.status_code # 200 for successful response result = s.json() #reformat to dataframe df = pd.DataFrame.from_dict(json_normalize(result), orient='columns') df.head()
[/vc_column_text][/vc_column][/vc_row]