How to get number of days between two dates using pandas

user_10617728 0
Viewed 5351

I'm trying to get number of days between two dates using below function

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

# Creating a function that returns the number of days
def calculate_days(date):
    today = pd.Timestamp('today')
    return today - date

# Apply the function to the column date
df['days'] = df['date'].apply(lambda x: calculate_days(x))

The results looks like this

153 days 10:16:46.294037

but I want it to say 153. How do I handle this?

python-datetime pandas datetime python
2 Answers

For performance you can subtract values without apply for avoid loops use Series.rsub for subtract from rigth side:

df['date'] = pd.to_datetime(df.date)
df['days'] = df['date'].rsub(pd.Timestamp('today')).dt.days

What working like:

df['days'] = (pd.Timestamp('today') - df['date']).dt.days

If want use your solution:

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

def calculate_days(date):
    today = pd.Timestamp('today')
    return (today - date).days

df['days'] = df['date'].apply(lambda x: calculate_days(x))

Or:

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

def calculate_days(date):
    today = pd.Timestamp('today')
    return (today - date)

df['days'] = df['date'].apply(lambda x: calculate_days(x)).dt.days
user_29010020 
df['date'] = pd.to_datetime(df.date)

a) pandas

(pd.Timestamp("today") - df.date).days

b) this numpy build function allows you to select a weekmask

 np.busday_count(df.date.date(), pd.Timestamp("today").date(), weekmask=[1,1,1,1,1,1,1])
user_131005150
Related