Untitled

import requests
import json


url = 'http://ec.europa.eu/eurostat/wdds/rest/data/v2.1/json/en/tec00118?groupedIndicators=1&filterNonGeo=1&precision=1&geo=AT&geo=BE&geo=BG&geo=CY&geo=CZ&geo=DE&geo=DK&geo=EE&geo=EL&geo=ES&geo=FI&geo=FR&geo=HR&geo=HU&geo=IE&geo=IT&geo=LT&geo=LU&geo=LV&geo=MT&geo=PL&geo=PT&geo=RO&geo=SE&geo=SI&geo=SK&unit=RCH_A_AVG&unitLabel=label&shortLabel=1&coicop=CP00&time=2013&time=2014&time=2015&time=2016&time=2017&time=2018&time=2019&time=2020&time=2021'


response = requests.get(url)


if response.status_code == 200:
    data = json.loads(response.text)
    print(data)
else:
    print('Nie udało się pobrać danych')

#print(data['dimension']['geo']['category']['index'])
#print(data['value'].values())
print()
print()
print()

#print(data['dimension']['time']['category']['index'])

del data['version']
del data['label']
del data['href']
del data['source']
del data['updated']
del data['extension']
print(data.keys())
print()
figures = list(data['value'].values())

# TO JEST ISTOTNE PONIŻEJ

# lista krajow
countries = list(data['dimension']['geo']['category']['index'])
#lista lat
time = list(data['dimension']['time']['category']['index'])
#lista statystyk
figures_split = [figures[x:x+26] for x in range(0, len(figures),26)]

print('oto listy')
print (figures_split)
print(countries)
print(figures)
print(time)