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'].diff() # create a lead column df['lead'] = df['values'].diff(periods=-1) print(df)