Hi,
I hope with these additional information someone could find time to help me with this issue.
sample date here --> file
'Date as index' (datetime.date)
As I said I'm trying to select a range in a dataframe every time x is in interval [-20 -190] and create a new dataframe with a new column which is the sum of the selected rows and keep the last "encountered" date as index
example and code nelow.
Thks
I hope with these additional information someone could find time to help me with this issue.
sample date here --> file
'Date as index' (datetime.date)
As I said I'm trying to select a range in a dataframe every time x is in interval [-20 -190] and create a new dataframe with a new column which is the sum of the selected rows and keep the last "encountered" date as index
example and code nelow.
Thks
Date x Date sum 2019-01-01 -524 2019-01-05 -1977 2019-01-02 -450 ---> 2019-01-11 -3264 2019-01-03 -580 2019-01-15 -1306 2019-01-04 -408 2019-01-20 -2348 2019-01-05 -15 ... 2019-01-06 -780 ... 2019-01-07 -420 2019-01-08 -640 2019-01-09 -926 2019-01-10 -348 2019-01-11 -150 2019-01-12 -360 2019-01-13 -280 2019-01-14 -648 2019-01-15 -18 2019-01-16 -890 2019-01-17 -320 2019-01-18 -280 2019-01-19 -748 2019-01-20 -110 ... ... for date in df.index.to_series().dt.date.unique(): for row in df.itertuples(): for i in row: if i in range(-20, -190): new_df = pd.DataFrame(columns=df.keys()) new_df.index.name = 'Date' new_df ['sum'] = df.sum(axis = 0) continue