Python

[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]