import pandas as pd # create a sample dataframe df = pd.DataFrame({'values': [1, 2, 3, 4, 5]}) # create a lag column df['lag'] = df['values'].shift(1) # create a lead column df['lead'] = df['values'].shift(-1) print(df)