Code: Alles auswählen
import pandas as pd
d = {'id': ['A','A','A','A','B','B'],
'date' : ['20210201', '20210202', '20210210','20210220', '20210303', '20210310']}
df = pd.DataFrame(d)
df.date = pd.to_datetime(df.date, format = '%Y%m%d')
#df['prev_date'] = df.groupby('id')['date'].shift()
df['date_2weeks'] = df.date - pd.to_timedelta(14, unit = 'd')
Code: Alles auswählen
df['count'] = [0,1,2,1,0,1]