How to filter only specific dates from a dataframe in python?

Question

I have a dataframe with 1000 records. I am trying to filter only the below Dates record from the df

2020-06-09

2020-08-06

2020-08-25

I have tried the below code hoping that my code will filter only those records available for that particular date.

df[(df['Date'] == '2020-06-09') & (df['Date'] = '2020-08-06') & (df['Date'] = '2020-08-25')]

But i am not getting any output. I need to view the dataframe only for those particular dates.

YOLO · Accepted Answer · 2020-08-28 13:33:09Z

1

You can use isin:

df = df[df['date'].isin(['2020-06-09', '2020-08-06', '2020-08-25'])]

Method 2

dates = ['2020-06-09', '2020-08-06', '2020-08-25']
df = df.query("date in @dates")

answered Aug 28, 2020 at 13:33

YOLO

22k5 gold badges25 silver badges42 bronze badges

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

1 Answer 1