# Post query and get pandas dataframe in return

from pyjstat import pyjstat
import requests

POST_URL = 'https://data.ssb.no/api/v0/en/table/03024'

#API query
payload = {"query": [{"code": "VareGrupper2", "selection": {"filter": "item", "values": ["01", "02"] } }, {"code": "ContentsCode", "selection": {"filter": "item", "values": ["Vekt", "Kilopris"] } }, {"code": "Tid", "selection": {"filter": "top", "values": ["53"] } } ], "response": {"format": "json-stat"} }

resultat = requests.post(POST_URL, json = payload)
print(resultat)

dataset = pyjstat.Dataset.read(resultat.text)
df = dataset.write('dataframe')
df.head()
df.info()