# Import Packages import numpy as np import pandas_datareader import datetime import pydst import pandas as pd import matplotlib.pyplot as plt # a. Check Variables in NAN1 Dst = pydst.Dst(lang="da") Dst.get_variables(table_id="NAN1")["values"][0][:20] # b. Importing desired variables from NAN1 gdp = Dst.get_data(table_id="NAN1", variables={ "TRANSAKT": ["B1GQK"], "PRISENHED": ["LAN_M"], "Tid": ["*"] }) priv_cons = Dst.get_data(table_id="NAN1", variables={ "TRANSAKT": ["P31S1MD"], "PRISENHED": ["LAN_M"], "Tid": ["*"] }) publ_cons = Dst.get_data(table_id="NAN1", variables={ "TRANSAKT": ["P3S13D"], "PRISENHED": ["LAN_M"], "Tid": ["*"]
import pandas as pd import numpy as np import matplotlib.pyplot as plt import pydst dst = pydst.Dst(lang='da') columns_dict = {} columns_dict['TRANSAKT'] = 'variable' columns_dict['PRISENHED'] = 'unit' columns_dict['TID'] = 'year' columns_dict['INDHOLD'] = 'value' columns_dict['HOVED'] = 'Type' columns_dict['PERPCT'] = 'Type' var_dict = {} # var is for variable #var_dict['P.1 Output'] = 'Y' #var_dict['P.3 Final consumption expenditure'] = 'C' #var_dict['P.3 Government consumption expenditure'] = 'G' #var_dict['P.5 Gross capital formation'] = 'I' #var_dict['P.6 Export of goods and services'] = 'X' #var_dict['P.7 Import of goods and services'] = 'M' #VARIABLES var_dict['B.1*g Bruttonationalprodukt, BNP'] = 'Y' var_dict['P.31 Privatforbrug'] = 'C' var_dict['P.3 Offentlige forbrugsudgifter'] = 'G' var_dict['P.5g Bruttoinvesteringer'] = 'I' var_dict['P.6 Eksport af varer og tjenester'] = 'X' var_dict['P.7 Import af varer og tjenester'] = 'M' var_dict['ÅRSSTIGNING'] = 'Inflation'
#Import relevent packages: Panda, numpy, matplotlib and pydst #Note: Sometimes you need to run code 2 times, before yoour packages will be uploaded import pandas as pd import numpy as np import matplotlib.pyplot as plt import pydst dst = pydst.Dst(lang = 'da') #Lang = Danish #Get columns dictionary from DST columns_dict = {} columns_dict['TRANSAKT'] = 'variable' columns_dict['PRISENHED'] = 'unit' columns_dict['TID'] = 'year' columns_dict['INDHOLD'] = 'value' var_dict = {} # var is for variable #Get variable dictionary from DST var_dict['B.1*g Bruttpmationalprodukt, BNP'] = 'Y' var_dict['P.31 Privatforbrug'] = 'C' var_dict['P.3 Offentlige forbrugsudgifter'] = 'G' var_dict['P.5g Bruttoinvesteringer'] = 'I' var_dict['P.6 Eksport af varer og tjenester'] = 'X' var_dict['P.7 Import af varer og tjenester'] = 'M' #UNITS unit_dict = {} unit_dict['2010-priser, kædede værdier'] = 'realle'
#import several libraries need for the program to function. import tkinter as tk from tkinter import ttk import pandas as pd import numpy as np import matplotlib matplotlib.use("TkAgg") from matplotlib import pyplot as plt from matplotlib import style from matplotlib.figure import Figure from matplotlib.backends.backend_tkagg import FigureCanvasTkAgg, NavigationToolbar2Tk import pydst #set the default language for the DST API Dst = pydst.Dst(lang='en') #Text fonts later referenced in the code LARGE_FONT = ("Verdana", 12) NORM_FONT = ("Verdana", 9) SMALL_FONT = ("Verdana", 8) #We create several global variables which will be referenced and changed. metadatadictionary = {} apidictionary = {} tableid = "empty" dataset = pd.DataFrame datasetpivot = pd.DataFrame #We create the main class, which defines the container in which all frames are defined. Think of it as the app itself.
#%% [markdown] # # Data Analysis Project #%% import pandas as pd import numpy as np import seaborn as sns import matplotlib.pyplot as plt # from matplotlib_venn import venn2 import pydst # Danmarks Statistik #%% Dst = pydst.Dst(lang='en') # Set language to English #%% Dst.get_subjects() # Get overview of Statistics Denmark's subjects #%% Dst.get_data(table_id='BB1S') #%% Var = Dst.get_variables(table_id='BB1S') #%% Var[:] #%% Var['values'][4][:10] #%% [markdown] #