I have a time series data with columns of consumption of different appliance (eg, TV, Electric kettle, washing machine, and so on ) I would like to lag each of the columns by 3 steps.
I am expecting somthing like this
for house 1:
time | TV | TV(-1) | TV(-2) | TV(-3) | Kettle | Kettle(-1) | Kettle(-2) | Kettle(-3) | Washing Mach| Washing Mach(-1)| and so on. Say i have different appliance in each house. so whatever appliance i have, everything should be lagged by 3 steps. i could use column splitter to feed the appliance into a column list loop, -> lag column -> loop end(column append). but i am not getting the end result. the loop stops when it lags 3 steps for 1st iteration.
Can anyone suggest a simple loop solution for this ?