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