python返回上一行,获取上一行的值并计算新列pandas python

Is there a way to look back to a previous row, and calculate a new variable? so as long as the previous row is the same case what is the (previous change) - (current change), and attribute it to the previous 'ChangeEvent' in new columns?

here is my DataFrame

>>> df

ChangeEvent StartEvent case change open

0 Homeless Homeless 1 2014-03-08 00:00:00 2014-02-08

1 other Homeless 1 2014-04-08 00:00:00 2014-02-08

2 Homeless Homeless 1 2014-05-08 00:00:00 2014-02-08

3 Jail Homeless 1 2014-06-08 00:00:00 2014-02-08

4 Jail Jail 2 2014-06-08 00:00:00 2014-02-08

to add columns

Jail Homeless case

0 6 1

0 30 1

0 0 1

... and so on

here is the df build

import pandas as pd

import datetime as DT

d = {'case' : pd.Series([1,1,1,1,2]),