How can I remove "days" when computing the difference between two dates?

Question

When computing the difference between two dates using the following:

df_test['Difference'] = (df_test['First_Date'] - df_test['Second Date'])

I get a third column with "x Days".

How can I convert "x Days" into int "x". e.g., "50 days" into "50"?

Someone in a previous thread suggested to use:

df_test['Difference'] = (df_test['First_Date'] - df_test['Second Date']).dt.days

but using that I get an error of type:

"'Series' object has no attribute 'dt"

How I can fix the issue please?

Answer 1

If it is a string variable. then you can do the following and strip of the unwanted part. (say your variable is xDays)

df["xDays"] = df["xDays"].map(lambda x: x[:-5])

if it is a timedelta value you can do following

df["xDays"].dt.days