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 [ ]:
Content source: BadWizard/Inflation
Similar notebooks: