get-raw-data-HICP-countries



In [1]:
### finished:
#### Get raw data on country disaggregated HICP from Dados and compute annual inflation rates by country

In [2]:
%matplotlib inline

import numpy as np
import pandas as pd

import os

In [3]:
path_data = 'G://APM//Dados//EUR'

In [4]:
file_items = path_data + '/IHPC_PAISES_EUR.xlsm'

In [24]:
df_cnames_ctry = pd.read_excel(file_items,sheetname='DADOS_TOT')
df_cnames_ctry = df_cnames_ctry.iloc[0:1]
df_cnames_ctry = df_cnames_ctry.iloc[:,1:]

In [25]:
df_cnames_ctry


Out[25]:
76451 46422 46425 46427 46424 46429 46420 46430 46423 46431 46432 46426 46428 1663537 1875356 1875369 1907172 2025053 2041200 2225322
0 Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH...

In [26]:
df_cnames_ctry.columns


Out[26]:
Index([  76451,   46422,   46425,   46427,   46424,   46429,   46420,   46430,
         46423,   46431,   46432,   46426,   46428, 1663537, 1875356, 1875369,
       1907172, 2025053, 2041200, 2225322],
      dtype='object')

In [28]:
df_cnames_ctry.loc[0,df_cnames_ctry.columns[0]]


Out[28]:
'Índice Harmonizado de Preços no Consumidor (IHPC) dos Países da UE - base 2015=100 - Total e Classes( 00          IHPC (índice global), Países da Área do Euro (composição variável) ) [Cod.:  76451, Mensal, Índice, x10** 0] (Conv.Period.: Média)'

In [66]:
dic = {ind:df_cnames_ctry.loc[0,ind].split()[22] for ind in df_cnames_ctry.columns }

In [67]:
#import pprint
#pprint.pprint(dic)

In [70]:
df_cnames_ctry


Out[70]:
76451 46422 46425 46427 46424 46429 46420 46430 46423 46431 46432 46426 46428 1663537 1875356 1875369 1907172 2025053 2041200 2225322
0 Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH...

In [74]:
dic[df_cnames_ctry.columns[0]]


Out[74]:
'Países'

In [78]:
df_cnames_ctry.rename(columns = dic)


Out[78]:
Países ALEMANHA FRANÇA ITALIA ESPANHA HOLANDA BELGICA AUSTRIA GRECIA PORTUGAL FINLANDIA IRLANDA LUXEMBURGO ESLOVENIA CHIPRE MALTA ESLOVAQUIA ESTONIA LETONIA LITUANIA
0 Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH... Índice Harmonizado de Preços no Consumidor (IH...

In [80]:
rows_to_skip = [0,2]
#rows_to_skip += list(np.arange(4,17))

In [81]:
df_ind_ctry = pd.read_excel(file_items,sheetname='DADOS_TOT',
                         skiprows=rows_to_skip,index_col=0,)
df_ind_ctry.head()


Out[81]:
76451 46422 46425 46427 46424 46429 46420 46430 46423 46431 46432 46426 46428 1663537 1875356 1875369 1907172 2025053 2041200 2225322
1990-01-01 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
1990-02-01 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
1990-03-01 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
1990-04-01 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
1990-05-01 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN

In [82]:
mask_rows_ind = df_ind_ctry.index.year >= 1999
mask_rows_ind


Out[82]:
array([False, False, False, False, False, False, False, False, False,
       False, False, False, False, False, False, False, False, False,
       False, False, False, False, False, False, False, False, False,
       False, False, False, False, False, False, False, False, False,
       False, False, False, False, False, False, False, False, False,
       False, False, False, False, False, False, False, False, False,
       False, False, False, False, False, False, False, False, False,
       False, False, False, False, False, False, False, False, False,
       False, False, False, False, False, False, False, False, False,
       False, False, False, False, False, False, False, False, False,
       False, False, False, False, False, False, False, False, False,
       False, False, False, False, False, False, False, False, False,
        True,  True,  True,  True,  True,  True,  True,  True,  True,
        True,  True,  True,  True,  True,  True,  True,  True,  True,
        True,  True,  True,  True,  True,  True,  True,  True,  True,
        True,  True,  True,  True,  True,  True,  True,  True,  True,
        True,  True,  True,  True,  True,  True,  True,  True,  True,
        True,  True,  True,  True,  True,  True,  True,  True,  True,
        True,  True,  True,  True,  True,  True,  True,  True,  True,
        True,  True,  True,  True,  True,  True,  True,  True,  True,
        True,  True,  True,  True,  True,  True,  True,  True,  True,
        True,  True,  True,  True,  True,  True,  True,  True,  True,
        True,  True,  True,  True,  True,  True,  True,  True,  True,
        True,  True,  True,  True,  True,  True,  True,  True,  True,
        True,  True,  True,  True,  True,  True,  True,  True,  True,
        True,  True,  True,  True,  True,  True,  True,  True,  True,
        True,  True,  True,  True,  True,  True,  True,  True,  True,
        True,  True,  True,  True,  True,  True,  True,  True,  True,
        True,  True,  True,  True,  True,  True,  True,  True,  True,
        True,  True,  True,  True,  True,  True,  True,  True,  True,
        True,  True,  True,  True,  True,  True,  True,  True,  True,
        True,  True,  True,  True,  True,  True,  True,  True,  True,
        True,  True,  True,  True,  True,  True,  True,  True,  True,
        True,  True,  True,  True,  True,  True,  True,  True,  True,
        True,  True,  True,  True,  True,  True,  True,  True,  True], dtype=bool)

In [83]:
df_ind_ctry = df_ind_ctry[mask_rows_ind]
df_ind_ctry.head()


Out[83]:
76451 46422 46425 46427 46424 46429 46420 46430 46423 46431 46432 46426 46428 1663537 1875356 1875369 1907172 2025053 2041200 2225322
1999-01-01 73.87 77.6 76.16 71.6 67.98 71.66 72.44 73.27 67.81 70.44 73.50 71.6 66.16 55.21 70.54 68.26 52.03 55.40 53.41 68.24
1999-02-01 74.06 77.8 76.43 71.8 68.04 72.14 72.59 73.42 67.32 70.44 73.79 72.1 67.41 55.43 69.30 68.31 52.43 55.51 53.53 68.22
1999-03-01 74.27 77.9 76.69 71.9 68.30 72.90 72.66 73.49 68.97 70.71 73.93 72.3 67.48 55.62 70.61 68.34 52.57 55.77 53.51 68.06
1999-04-01 74.51 78.2 76.92 72.0 68.56 73.11 72.94 73.49 69.83 71.18 74.57 72.7 67.81 55.80 70.83 70.34 52.82 55.91 53.44 68.10
1999-05-01 74.57 78.2 76.91 72.2 68.56 73.11 73.08 73.56 69.65 71.25 74.79 73.2 68.00 56.12 71.06 70.86 52.89 56.10 53.68 68.06

In [84]:
df_infl_ctry = df_ind_ctry.pct_change(periods=12)
mask_rows_infl = df_infl_ctry.index.year >= 2000

In [85]:
df_infl_ctry = df_infl_ctry[mask_rows_infl]
df_infl_ctry.tail()


Out[85]:
76451 46422 46425 46427 46424 46429 46420 46430 46423 46431 46432 46426 46428 1663537 1875356 1875369 1907172 2025053 2041200 2225322
2015-11-01 0.001499 0.002002 0.001103 0.000995 -0.004064 0.003727 0.013997 0.004808 -0.001099 0.006227 -0.002291 -0.001002 0.004310 -0.009311 -0.014693 0.013238 -0.003790 0.005445 0.000201 -0.005254
2015-12-01 0.002301 0.002002 0.002705 0.000995 -0.001297 0.004947 0.014502 0.010713 0.003916 0.002913 -0.002494 0.002012 0.008500 -0.006084 -0.005643 0.012528 -0.004600 -0.001714 0.004045 -0.002494
2016-01-01 0.003354 0.004053 0.003343 0.004082 -0.004182 0.002147 0.018416 0.013911 -0.001219 0.007034 0.000302 0.000000 0.004504 -0.007671 -0.010782 0.008101 -0.002804 0.000709 -0.003133 0.006669
2016-02-01 -0.001515 -0.002006 -0.001006 -0.002037 -0.009880 0.003245 0.011149 0.010228 0.000713 0.001733 -0.001402 -0.002014 -0.003110 -0.008867 -0.022058 0.009716 -0.003110 0.003525 -0.005841 0.005363
2016-03-01 -0.000499 0.000998 -0.000998 -0.001994 -0.009885 0.005206 0.016430 0.005791 -0.006695 0.004700 -0.000200 -0.006000 -0.006193 -0.009491 -0.021505 0.010242 -0.004906 0.004602 -0.006194 0.007829

In [86]:
df_infl_ctry.rename(columns = dic)


Out[86]:
Países ALEMANHA FRANÇA ITALIA ESPANHA HOLANDA BELGICA AUSTRIA GRECIA PORTUGAL FINLANDIA IRLANDA LUXEMBURGO ESLOVENIA CHIPRE MALTA ESLOVAQUIA ESTONIA LETONIA LITUANIA
2000-01-01 0.018681 0.016753 0.016675 0.022346 0.028685 0.016327 0.003037 0.013785 0.023448 0.019023 0.023401 0.044693 0.034764 0.078066 0.043805 0.033988 0.136652 0.030505 0.031268 0.008939
2000-02-01 0.019309 0.015424 0.014392 0.023677 0.029688 0.015248 0.021353 0.019477 0.026441 0.016184 0.027239 0.045770 0.026257 0.083709 0.046609 0.033231 0.166698 0.028824 0.034000 0.009381
2000-03-01 0.019523 0.014121 0.016039 0.025035 0.030454 0.016049 0.025186 0.019458 0.027693 0.014142 0.032057 0.049793 0.030083 0.089896 0.051551 0.033509 0.167967 0.031200 0.032144 0.009697
2000-04-01 0.017179 0.010230 0.013001 0.023611 0.030338 0.016824 0.023170 0.017553 0.021051 0.018826 0.025077 0.050894 0.031854 0.092832 0.058591 0.034120 0.161681 0.029869 0.037238 0.008957
2000-05-01 0.017567 0.008951 0.015213 0.024931 0.032235 0.019696 0.024083 0.015633 0.026418 0.024421 0.026875 0.050546 0.028971 0.090699 0.059809 0.036269 0.163358 0.027986 0.030179 0.005436
2000-06-01 0.021322 0.012771 0.017943 0.027701 0.035152 0.024601 0.029888 0.023611 0.022005 0.028159 0.030753 0.054496 0.044451 0.098004 0.052402 0.033286 0.156697 0.031384 0.023862 0.012949
2000-07-01 0.021020 0.011436 0.019304 0.027624 0.036725 0.027505 0.017378 0.019496 0.026157 0.032782 0.028966 0.058824 0.046959 0.089236 0.047212 0.032941 0.092589 0.040456 0.028001 0.014334
2000-08-01 0.020457 0.008895 0.019526 0.027624 0.035688 0.024578 0.034686 0.018506 0.028975 0.035649 0.028801 0.057065 0.036510 0.082899 0.056012 0.032290 0.088449 0.043742 0.024504 0.010363
2000-09-01 0.024191 0.015306 0.023129 0.027548 0.037496 0.029247 0.039508 0.023427 0.030141 0.035684 0.034395 0.055480 0.042295 0.090062 0.045845 0.032018 0.088240 0.046574 0.021999 0.004704
2000-10-01 0.023778 0.014031 0.021290 0.027473 0.040271 0.031950 0.036602 0.022388 0.037793 0.036601 0.034363 0.059459 0.043047 0.091362 0.042244 0.034288 0.086728 0.053756 0.019630 0.013164
2000-11-01 0.024546 0.015306 0.023096 0.028807 0.041060 0.029027 0.036532 0.023268 0.040453 0.036361 0.033431 0.059379 0.045050 0.097865 0.042082 0.018569 0.086396 0.056600 0.016173 0.016556
2000-12-01 0.024864 0.021601 0.017820 0.027360 0.040046 0.029162 0.029739 0.018238 0.036689 0.038242 0.028689 0.046667 0.042841 0.088554 0.037390 0.010169 0.084114 0.050361 0.017428 0.016809
2001-01-01 0.020066 0.012674 0.013431 0.024590 0.028743 0.046409 0.027250 0.022617 0.031844 0.043884 0.028583 0.038770 0.028776 0.084005 0.015754 0.010201 0.074907 0.056402 0.013072 -0.000871
2001-02-01 0.019738 0.017722 0.014962 0.014966 0.026834 0.049836 0.024818 0.018170 0.034153 0.048477 0.026913 0.039788 0.029777 0.087398 0.028402 0.011193 0.063430 0.059709 0.006865 0.000581
2001-03-01 0.022055 0.017722 0.014759 0.021710 0.030406 0.049953 0.021882 0.018820 0.031744 0.051039 0.025295 0.040843 0.030068 0.089574 0.015219 0.016424 0.065961 0.056686 0.014123 0.008003
2001-04-01 0.027312 0.021519 0.020021 0.029851 0.035815 0.054210 0.029077 0.025809 0.037027 0.045780 0.028519 0.041885 0.027440 0.090194 0.016671 0.022271 0.071219 0.062695 0.014433 0.010188
2001-05-01 0.030838 0.027883 0.024462 0.028378 0.037587 0.054728 0.031534 0.028778 0.039446 0.048637 0.032812 0.041612 0.038016 0.098840 0.016731 0.022334 0.073460 0.067626 0.027125 0.020167
2001-06-01 0.028624 0.023960 0.022481 0.028302 0.037481 0.050838 0.029553 0.026133 0.044751 0.045647 0.029706 0.042636 0.027057 0.096884 0.030970 0.026618 0.075459 0.066736 0.031798 0.019756
2001-07-01 0.024915 0.022613 0.022009 0.022849 0.023663 0.053134 0.027169 0.027681 0.041816 0.043136 0.026326 0.040052 0.024349 0.090295 0.008829 0.029991 0.079701 0.059267 0.032141 0.014423
2001-08-01 0.023192 0.022670 0.019791 0.020161 0.020787 0.052131 0.025308 0.024182 0.040023 0.040114 0.027344 0.037275 0.025180 0.087466 0.017994 0.032368 0.076873 0.058159 0.031039 0.026667
2001-09-01 0.021793 0.018844 0.016383 0.020107 0.022519 0.053379 0.019069 0.024088 0.040179 0.040966 0.025648 0.038462 0.018955 0.081830 0.021984 0.032385 0.073332 0.057118 0.036665 0.023412
2001-10-01 0.022573 0.016352 0.017923 0.022727 0.025253 0.050013 0.019763 0.023225 0.031986 0.041802 0.023822 0.038265 0.016368 0.079937 0.027240 0.028240 0.069187 0.047973 0.033418 0.023942
2001-11-01 0.019792 0.012563 0.012936 0.022667 0.025187 0.048073 0.017885 0.018905 0.028954 0.041135 0.021523 0.035669 0.014230 0.071251 0.017831 0.032955 0.067981 0.041814 0.030928 0.019631
2001-12-01 0.020628 0.013682 0.014717 0.022636 0.025117 0.051483 0.019254 0.017648 0.035254 0.039111 0.023499 0.043312 0.009191 0.070462 0.021101 0.035654 0.067029 0.042079 0.031735 0.020302
2002-01-01 0.026055 0.021277 0.024213 0.022667 0.030720 0.048550 0.026393 0.018957 0.047759 0.036567 0.029210 0.052767 0.021724 0.083540 0.022062 0.042076 0.064653 0.042779 0.034588 0.031691
2002-02-01 0.024682 0.018657 0.022366 0.025469 0.031554 0.044609 0.024743 0.017321 0.037783 0.033444 0.025051 0.049745 0.021898 0.079149 0.023193 0.032787 0.043659 0.044779 0.032657 0.028302
2002-03-01 0.025068 0.019900 0.021879 0.025232 0.032267 0.043719 0.025223 0.017031 0.043484 0.033568 0.025949 0.050633 0.017458 0.075397 0.020164 0.030645 0.037586 0.043936 0.032137 0.016746
2002-04-01 0.023504 0.014870 0.020760 0.025033 0.037310 0.042236 0.016797 0.016556 0.040844 0.035865 0.024930 0.051508 0.019335 0.084236 0.023350 0.026627 0.036969 0.045269 0.028988 0.013975
2002-05-01 0.020583 0.011097 0.015627 0.024967 0.037178 0.037772 0.012953 0.016393 0.037949 0.034361 0.018028 0.049938 0.012667 0.075974 0.022594 0.024244 0.033005 0.041416 0.020599 0.005014
2002-06-01 0.018637 0.008621 0.014366 0.023591 0.034361 0.037912 0.008404 0.014943 0.036099 0.035053 0.015369 0.044610 0.012212 0.069093 0.020847 0.021673 0.027824 0.038412 0.009631 -0.003846
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
2013-10-01 0.007366 0.012257 0.006889 0.007014 0.000494 0.013017 0.007110 0.014972 -0.018917 0.000000 0.017201 -0.001002 0.010336 0.011415 -0.005068 0.005385 0.007119 0.021955 -0.000202 0.005193
2013-11-01 0.008594 0.016360 0.008220 0.006024 0.002969 0.011957 0.008946 0.014548 -0.028560 0.000503 0.017832 0.003021 0.011166 0.012039 -0.007878 0.002485 0.004810 0.020585 -0.003335 0.005502
2013-12-01 0.008462 0.013185 0.008392 0.006006 0.003067 0.014018 0.011670 0.019866 -0.018161 0.001706 0.019327 0.003018 0.015369 0.008949 -0.012517 0.010100 0.003911 0.020488 -0.004040 0.004505
2014-01-01 0.007737 0.011224 0.007627 0.006129 0.002721 0.007984 0.011164 0.015332 -0.014028 0.000508 0.018816 0.003036 0.014578 0.008898 -0.015703 0.008979 -0.000498 0.015649 0.004655 0.002498
2014-02-01 0.007099 0.010132 0.010644 0.004094 0.000503 0.003749 0.008372 0.014762 -0.008615 -0.000916 0.015655 0.001004 0.007759 0.001707 -0.012592 0.015945 -0.001195 0.011278 0.005266 0.003099
2014-03-01 0.004711 0.008065 0.007541 0.003000 -0.002175 0.001400 0.008069 0.014519 -0.014878 -0.003902 0.012945 0.002000 0.007654 0.006107 -0.008843 0.014517 -0.001593 0.007054 0.003426 0.003787
2014-04-01 0.007124 0.012170 0.008354 0.004985 0.003359 0.006394 0.007678 0.015641 -0.015865 -0.001100 0.012518 0.003003 0.008752 0.004978 -0.004019 0.005076 -0.001991 0.008054 0.008261 0.003178
2014-05-01 0.004911 0.007078 0.008250 0.003988 0.002072 0.001398 0.006977 0.015315 -0.021356 -0.002793 0.009591 0.004008 0.014248 0.009632 -0.000972 0.003715 -0.000398 0.006418 0.007637 0.000892
2014-06-01 0.005006 0.009091 0.005925 0.002985 0.000493 0.002709 0.005646 0.016979 -0.014645 -0.002492 0.010708 0.005005 0.011874 0.009926 0.000483 0.007070 -0.000794 0.003490 0.007708 0.002780
2014-07-01 0.003724 0.007035 0.005644 0.000000 -0.003590 0.002600 0.005311 0.016675 -0.008424 -0.006792 0.009600 0.004004 0.012405 0.003087 0.008897 0.005671 -0.001490 -0.000199 0.006111 0.004699
2014-08-01 0.003619 0.008048 0.005415 -0.001013 -0.005172 0.003608 0.004023 0.014584 -0.002391 -0.000603 0.012444 0.006000 0.007016 0.000000 0.007802 0.008465 -0.001792 -0.001792 0.008399 0.002696
2014-09-01 0.003201 0.008048 0.003718 -0.000995 -0.002764 0.002604 0.002015 0.014037 -0.010987 -0.000400 0.014916 0.005005 0.002996 -0.000990 0.000195 0.006323 -0.000896 0.002101 0.011836 0.000099
2014-10-01 0.003806 0.008073 0.005333 0.001990 -0.002171 0.003915 0.003227 0.014242 -0.018015 0.001303 0.011877 0.004012 0.004413 0.000693 0.002743 0.007074 -0.000100 0.004718 0.007370 0.002881
2014-11-01 0.002807 0.005030 0.004026 0.002994 -0.004637 0.002525 0.000605 0.015356 -0.012234 0.000804 0.010673 0.002008 0.001506 0.000793 -0.000199 0.006507 -0.000199 0.000101 0.009430 0.003581
2014-12-01 -0.001698 0.000000 0.000902 0.000000 -0.011345 -0.000605 -0.003912 0.008074 -0.025347 -0.002704 0.005518 -0.003009 -0.009423 -0.000698 -0.009582 0.003814 -0.001298 0.000605 0.002738 -0.001096
2015-01-01 -0.005960 -0.004036 -0.003936 -0.005076 -0.014574 -0.006702 -0.006338 0.004795 -0.027566 -0.003657 -0.001405 -0.004036 -0.011535 -0.007015 -0.007371 0.008061 -0.005081 -0.005237 -0.003425 -0.013655
2015-02-01 -0.002719 0.000000 -0.002808 0.001019 -0.011876 -0.004542 -0.004101 0.004578 -0.019077 -0.000916 -0.000801 -0.004012 -0.003300 -0.005113 -0.007631 0.005613 -0.005983 -0.002311 0.000302 -0.015050
2015-03-01 -0.000798 0.002000 -0.000399 0.000000 -0.007826 -0.002796 -0.001201 0.009373 -0.018633 0.004419 0.000399 -0.001996 0.000600 -0.003881 -0.013580 0.005147 -0.003890 0.000100 0.005222 -0.010822
2015-04-01 0.000100 0.003006 0.001198 -0.000992 -0.007286 -0.000298 0.003710 0.009361 -0.018075 0.004904 -0.000798 -0.002994 -0.000299 -0.007429 -0.017321 0.013737 -0.001297 0.003995 0.005695 -0.006337
2015-05-01 0.003391 0.006024 0.003493 0.001986 -0.002659 0.006881 0.008435 0.010157 -0.014253 0.009502 0.001100 0.001996 0.004284 -0.007868 -0.017228 0.012904 -0.000895 0.005281 0.011767 -0.000495
2015-06-01 0.002192 0.002002 0.003295 0.001984 -0.000296 0.004804 0.008622 0.009756 -0.010951 0.007595 0.000700 0.003984 0.004574 -0.009238 -0.020874 0.011469 -0.000894 0.002981 0.006755 -0.002178
2015-07-01 0.002407 0.000998 0.002205 0.004053 -0.000300 0.008079 0.008636 0.011339 -0.012546 0.007140 -0.000901 0.001994 0.001707 -0.006651 -0.024130 0.012266 -0.002189 0.001393 -0.001593 -0.002289
2015-08-01 0.001302 0.000998 0.000997 0.003043 -0.005199 0.004394 0.007513 0.009515 -0.003895 0.006642 -0.001999 0.001988 0.000796 -0.005861 -0.019063 0.014023 -0.002194 0.001596 0.001907 -0.009960
2015-09-01 -0.000897 -0.000998 0.001001 0.001992 -0.011283 0.002797 0.009049 0.005617 -0.007668 0.008910 -0.006753 -0.000996 -0.001792 -0.010004 -0.019087 0.015859 -0.005182 -0.003196 -0.003999 -0.008329
2015-10-01 0.001197 0.002002 0.001501 0.002979 -0.008999 0.004000 0.011561 0.006520 -0.000893 0.007005 -0.003382 -0.000999 -0.000899 -0.011575 -0.018367 0.015754 -0.005277 -0.000300 -0.001403 -0.004458
2015-11-01 0.001499 0.002002 0.001103 0.000995 -0.004064 0.003727 0.013997 0.004808 -0.001099 0.006227 -0.002291 -0.001002 0.004310 -0.009311 -0.014693 0.013238 -0.003790 0.005445 0.000201 -0.005254
2015-12-01 0.002301 0.002002 0.002705 0.000995 -0.001297 0.004947 0.014502 0.010713 0.003916 0.002913 -0.002494 0.002012 0.008500 -0.006084 -0.005643 0.012528 -0.004600 -0.001714 0.004045 -0.002494
2016-01-01 0.003354 0.004053 0.003343 0.004082 -0.004182 0.002147 0.018416 0.013911 -0.001219 0.007034 0.000302 0.000000 0.004504 -0.007671 -0.010782 0.008101 -0.002804 0.000709 -0.003133 0.006669
2016-02-01 -0.001515 -0.002006 -0.001006 -0.002037 -0.009880 0.003245 0.011149 0.010228 0.000713 0.001733 -0.001402 -0.002014 -0.003110 -0.008867 -0.022058 0.009716 -0.003110 0.003525 -0.005841 0.005363
2016-03-01 -0.000499 0.000998 -0.000998 -0.001994 -0.009885 0.005206 0.016430 0.005791 -0.006695 0.004700 -0.000200 -0.006000 -0.006193 -0.009491 -0.021505 0.010242 -0.004906 0.004602 -0.006194 0.007829

195 rows × 20 columns


In [ ]: