Breaking News: Grepper is joining You.com. Read the official announcement!

split rows by dates

Carmen Wan answered on August 8, 2022 Popularity 1/10 Helpfulness 1/10

answer split rows by dates

split rows by dates

Comment

df['Start Date'] = df.apply(lambda d: pd.date_range(d['Start Date'],
                                                    d['End Date'], 
                                                    freq='h')[:-1], 
                            axis=1)
df = df.explode('Start Date')
df['End Date'] = df['Start Date'] + pd.Timedelta('1h')

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: stackoverflow.com

Tags: rows whatever

Link to this answer
Share Copy Link