I see that finding the last 30 days of the dataframe by
import datetime
days30=df[df.Date > datetime.datetime.now() - pd.to_timedelta("30day")]
This gives last 30 days considering today's date. But I am interested in getting the last 30 days that is available in the dataframe. So tried this method
lastdayfrom = df['Date'].max()
days30 = df.loc[lastdayfrom - pd.Timedelta(days=30):lastdayfrom].reset_index()
This threw error message -TypeError: '<' not supported between instances of 'int' and 'Timestamp'
How do I get the last date to use in filtering the last available date with out making date as index if possible?
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…