PYTHON

pandas shift column

df['PREV_CLOSE']=df['Close'].shift(1)
df

pandas shift column down

>>> df.shift(periods=3)
#Shifted down by 3 periods
#If you want to shift up insert the number of periods as a negative number
            Col1  Col2  Col3
2020-01-01   NaN   NaN   NaN
2020-01-02   NaN   NaN   NaN
2020-01-03   NaN   NaN   NaN
2020-01-04  10.0  13.0  17.0
2020-01-05  20.0  23.0  27.0

pandas shift all columns

import pandas as pd  
info= pd.DataFrame({'a_data': [45, 28, 39, 32, 18],  
'b_data': [26, 38, 41, 35, 45],  
'c_data': [22, 19, 11, 25, 16]})  

#shifting code
info.shift(periods=2)  

info.shift(periods=2,axis=1,fill_value= 70)