Calculate Delta Between Two Dates using Python and pandas

Question

I'm trying to calculate the difference between two datetime columns (dtype = datetime64[ns]) in pandas. I can successfully calculate the delta in hours, but I want the result to be days.

Example

foo_df = pd.DataFrame({'date_1': ['2019-08-07 09:25:07'], 
                       'date_2': ['2019-08-08 01:01:00']}).astype('datetime64[ns]')

foo_df['delta'] =  foo_df['date_2'] - foo_df['date_1']

result

    date_1              date_2              delta
0   2019-08-07 09:25:07 2019-08-08 01:01:00 15:35:53

Desired Result

    date_1              date_2              delta
0   2019-08-07 09:25:07 2019-08-08 01:01:00 1

NOTE: The delta should be 1 because date_2 is the next day. I only need to calculate if the day is different. I can do this if I convert the date columns to strings, but ideally, I'd like to avoid that since this should be possible to do with dtype; datetime64[ns]

are you looking for (foo_df['date_2'].dt.date - foo_df['date_1'].dt.date).dt.days ? — anky
– anky, Commented Jan 21, 2020 at 2:45
dt.days() should work, since you are interested in that part of the datetime — sammywemmy
– sammywemmy, Commented Jan 21, 2020 at 2:45

hongsy · Accepted Answer · 2020-01-21 14:49:45Z

1

Subtract the dates, then get the number of days from the Timedelta:

foo_df['delta'] = (foo_df.date_2.dt.date - foo_df.date_1.dt.date).dt.days

edited Jan 21, 2020 at 14:49

answered Jan 21, 2020 at 7:08

hongsy

1,5763 gold badges28 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

Calculate Delta Between Two Dates using Python and 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