Python code to create lead values for a variable across account with last value of an account as null

Asked May 14 '20 at 13:40

Active May 14 '20 at 13:42

Viewed 273 times

I have a a very large dataset containing id and data points of time series (with some missing values). The following is just an example.

I will need to create a lead variable for a variable across groups built on account id such that last value across each account id is null. Please refer below for more clarity.

id    time    value    lag_value 
A     2000    10       11     
A     2001    11       Nan 
B     2002    1        2
B     2003    2        3 
B     2004    3        Nan

edited May 14 '20 at 13:42

mechanical_meat

163,903
24
228
223

asked May 14 '20 at 13:40

Learner

@mechanical_meat – Learner May 14 '20 at 13:45
Does this work for you?: `df['lag_value'] = df.groupby(['id'])['value'].shift(-1)` – mechanical_meat May 14 '20 at 13:47
Thank you! It works. – Learner May 14 '20 at 14:07

Python code to create lead values for a variable across account with last value of an account as null

0 Answers0