Homework 1
Contents
Homework 1¶
Part I. HICP data from SDW¶
# import pandas (and other libraries you may want to use)
# import the data files you downloaded from SDW
# Print as a list the codes of the subindices you downloaded.
# For example, if you download items from the __FOOD AND NON-ALCOHOLIC BEVERAGES__ category,
# list all codes type `01XX00` you were able to download.
# create a single dataframe combining data for all HICP subindices you downloaded
# make other changes to the dataframe - set datetime index, rename the columns (up to you, but shortening very long names may be a good idea)
# print the type of the index of the dataframe
# print the data types of the columns in the dataframe
# save as a csv file under the name of the item group
# compute and print the means and standard deviations for each series for the full period
# compute and print the means and standard deviations for each calendar month for each series
# redo the above for the period between January 2017 and December 2021
Part II. GDP data from EUROSTAT¶
# import the data files you downloaded from EUROSTAT
# create a dataframe with a datetime index matching the timing of the series you downloaded
# save as a csv file under the name "Real-GDP-EA.csv"
PART III Combine GDP and inflation data¶
# create a new datafame containing the GDP data and the inflation indices from the first task.
#save as a csv file named "merged-GDP-inflation.csv"