Select Dataset rows between two dates

Question

Here is my dataset:

dataset

And want to convert my dataset between two dates. I have tried the solution mentioned here. But it didn't work.

Here is a screenshot using:

Boolean Mask

and DatetimeIndex

Looks like your data after filter doesn't have 100 rows, while pd.date_range(..., periods=100, freq='D') does. — Quang Hoang
– Quang Hoang, Commented Jun 5, 2020 at 18:27
what do you mean by "it didn't work"? the boolean mask screen shot seems to show only rows with dates in between the specified start and end date (aka it looks like it worked) — Tom
– Tom, Commented Jun 5, 2020 at 18:50
It should have shown data from 2020-03-25 rather than 2020-04-02 — Saurav
– Saurav, Commented Jun 5, 2020 at 18:53
Please post your code as text instead of images. It would help if you copy and pasted the error messages too. See how to make reproducible pandas examples. — kennyvh
– kennyvh, Commented Jun 6, 2020 at 8:14

Vinit Neogi · Accepted Answer · 2020-06-06 08:10:31Z

1

I tried to recreate the scenario shared by you with the same data. While exploring the results, I observed that the data is not in sorted format.

Try to run sort_values('Date') on your result.

data[(data['Date'] >= '2020-03-25') & (data['Date'] <= '2020-05-22')].sort_values('Date')

You will get above result.

answered Jun 6, 2020 at 8:10

Vinit Neogi

3865 silver badges10 bronze badges

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

1 Answer 1