How to select rows where date is in index in Python Pandas DataFrame?

Question

I have DataFrame in Pythonlike below where data is in index (we can name this column "date"):

and I would like to select all column of this DF where data in index is > than 01.01.2020, how can I do it? (be aware that date is in index).

jezrael · Accepted Answer · 2021-02-12 09:50:04Z

1

df.index = pd.to_datetime(df.index, dayfirst=True)
df1 = df[df.index > '2020-01-01']

Or:

df.index = pd.to_datetime(df.index, dayfirst=True)
df1 = df[df.index > pd.to_datetime('2020-01-01')]

answered Feb 12, 2021 at 9:26

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

I have error like below when I sue your code: TypeError: '>' not supported between instances of 'str' and 'Timestamp'