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