Create lookup<region_code,name> for regions in Sweden from SCB data

region_lookup.py

import pandas as pd
import requests
import json

session = requests.Session()

res = session.get("http://api.scb.se/OV0104/v1/doris/sv/ssd/START/BE/BE0101/BE0101A/BefolkningNy")
region_variables = json.loads(res.content.decode('utf-8-sig'))['variables']


regions_lookup = {}

for variable in region_variables:
    regions_lookup[variable['text']] = dict(zip(variable['values'], variable['valueTexts']))
regions_lookup['region']

regions_df=pd.DataFrame.from_dict({'code':list(regions_lookup['region'].keys()),'name':list(regions_lookup['region'].values())})
regions_df.to_csv('region_lookup.csv',index=None)