Pandas: Shift or lead or lag

19 August 2020

Code

# Import library
import pandas as pd

# Create a DataFrame
df = pd.DataFrame({
    'key': ['Mon', 'Tue', 'Wed', 'Thur'],
    'count': [11,23,12,34]
})

# Shift a column
df['shifted_by_(+1)'] = df['count'].shift(+1)
df['shifted_by_(-1)'] = df['count'].shift(-1)

# Output
print(df)

Output:

    key  count  shifted_by_(+1)  shifted_by_(-1)
0   Mon     11              NaN             23.0
1   Tue     23             11.0             12.0
2   Wed     12             23.0             34.0
3  Thur     34             12.0              NaN






Any errors in code above?
Please send a message.