Way to turn dates into a date range in pandas?

Question

If you have a list of dates based on a condition ex:

df

date                  random_values
2020-03-01                   1
2020-03-02                   2
2020-03-03                   2
2020-04-01                   8
2020-04-02                   9 
2020-04-03                   10
2020-05-01                   7
2020-05-02                   8 
2020-05-03                   10
2020-05-04                   20

ex condition: df['date'].where(df.random_values >= 8)

which would produce the following dates:

While this amount of dates is fine for example, my data had hundreds of dates. I want to cut down the dates so it produces an output similar to this:

2020-04-01: 2020-04-03
2020-05-01: 2020-05-04

I am just trying to cut down the number of dates and make them easily into date ranges. Any easy way to do this?

I am just indexing the data to get the dates. The random_values does not change. — user15288243
– user15288243, Commented Apr 11, 2021 at 2:59

Scott Boston · Accepted Answer · 2021-04-11 03:57:04Z

1

Try this also:

df = pd.read_clipboard()

df['date'] = pd.to_datetime(df['date'])

s  = df.loc[df['random_values'] >= 8, 'date']
grp = (s.diff() != pd.Timedelta(days=1)).cumsum()

s.groupby(grp).agg(lambda x: f"{x.iloc[0].strftime('%Y-%m-%d')}: {x.iloc[-1].strftime('%Y-%m-%d')}")

Output:

date
1    2020-04-01: 2020-04-03
2    2020-05-02: 2020-05-04
Name: date, dtype: object

answered Apr 11, 2021 at 3:57

Scott Boston

154k15 gold badges160 silver badges207 bronze badges

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

Collectives™ on Stack Overflow

Way to turn dates into a date range in pandas?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related