This code outputs dates along with values as a series. I wanted to manipulate the values but I ended up losing the dates.
rgdp = fred.get_series('GDPC1')
fgdp=rgdp
rlistgdp=[]
for a in range(len(rgdp)):
rgdp2=((rgdp.iloc[a]/rgdp.iloc[a-1])**4-1) * 100
rlistgdp.append(rgdp2)
rlistgdp
How can I keep the dates along with the new values?
CodePudding user response:
series = pd.Series([100,150,200,300], index=['a','b','c','d'])
series
a 100
b 150
c 200
d 300
dtype: int64
series2 = series.copy()
for i in range(1, len(series)):
series2[i] = ((series[i]/series[i-1])**4-1) * 100
series2
a 100
b 406
c 216
d 406
dtype: int64
Notice that I used copy()
so fgpd doesn't get modified.
The range is set to start in 1 because I don't know how you plan to modify the first value.