I'd like to filter a df by date. But I want all the values with any date before today's date (python). i.e From the table below, I'd like the rows that have a date before today's date (row 1 to 3).

Thanks

CodePudding user response：

You can try this?

from datetime import datetime

df[df['date'] < datetime.now()]

Output:

  ID                date
0  1 2022-03-25 06:00:00
1  2 2022-04-25 06:00:00
2  3 2022-05-25 06:00:00