Hello, I need to create a function that gives me a 30-day window to make a sum and see how many values there are
I usually do this in python using the .rolling function, giving it a 30-day ordering window, however, none of the python scripts that knime handles has allowed me to work with this function, if someone also knows how to accommodate it, what it is for, I would appreciate it
datos_reexpedicion_tdc[‘30D’]=DATE.groupby(by=[‘ID’,‘ACCOUN’]).rolling(‘30d’,on=‘DATES’)[‘Número de tarjeta’].count().reset_index()[‘Number’]
the result of the operation are the values in 30d
Thank you Date.xlsx (321.1 KB)
Forget about python, I managed to integrate it, the problem is that python only recognizes its own datetime, not the one that arrives by default, the only thing that remains in my doubt is if it could be done in knime