how to get difference of consecutive rows by shifting between columns

import pandas as pd
df = pd.DataFrame({'A':[1,4,3,7], 'B':[3,1,6,4]})                 
df['diff'] = df['A'] - df['B'].shift()

Leave a Comment