Add column with number of days between dates in DataFrame pandas

Michael Zippo

👻 Check our latest review to choose the best laptop for Machine Learning engineers and Deep learning tasks!

I want to subtract dates in "A" from dates in "B" and add a new column with the difference.

df
          A        B
one 2014-01-01  2014-02-28 
two 2014-02-03  2014-03-01

I"ve tried the following, but get an error when I try to include this in a for loop...

import datetime
date1=df["A"][0]
date2=df["B"][0]
mdate1 = datetime.datetime.strptime(date1, "%Y-%m-%d").date()
rdate1 = datetime.datetime.strptime(date2, "%Y-%m-%d").date()
delta =  (mdate1 - rdate1).days
print delta

What should I do?

👻 Read also: what is the best laptop for engineering students?

Add column with number of days between dates in DataFrame pandas del: Questions

__del__

How can I make a time delay in Python?

5 answers

I would like to know how to put a time delay in a Python script.

2973

Answer #1

import time
time.sleep(5)   # Delays for 5 seconds. You can also use a float value.

Here is another example where something is run approximately once a minute:

import time
while True:
    print("This prints once a minute.")
    time.sleep(60) # Delay for 1 minute (60 seconds).

2973

Answer #2

You can use the sleep() function in the time module. It can take a float argument for sub-second resolution.

from time import sleep
sleep(0.1) # Time in seconds

Add column with number of days between dates in DataFrame pandas del: Questions

__del__

How to delete a file or folder in Python?

5 answers

How do I delete a file or folder in Python?

2639

Answer #1

os.remove() removes a file.
os.rmdir() removes an empty directory.
shutil.rmtree() deletes a directory and all its contents.

Path objects from the Python 3.4+ pathlib module also expose these instance methods:

pathlib.Path.unlink() removes a file or symbolic link.
pathlib.Path.rmdir() removes an empty directory.

We hope this article has helped you to resolve the problem. Apart from Add column with number of days between dates in DataFrame pandas, check other __del__-related topics.

Want to excel in Python? See our review of the best Python online courses 2023. If you are interested in Data Science, check also how to learn programming in R.

By the way, this material is also available in other languages:

Olivia Innsbruck

London | 2023-03-24

Thanks for explaining! I was stuck with Add column with number of days between dates in DataFrame pandas for some hours, finally got it done 🤗. Will use it in my bachelor thesis

Davies Innsbruck

Warsaw | 2023-03-24

StackOverflow is always a bit confusing 😭 Add column with number of days between dates in DataFrame pandas is not the only problem I encountered. Checked yesterday, it works!

Javier Danburry

Rome | 2023-03-24

Simply put and clear. Thank you for sharing. Add column with number of days between dates in DataFrame pandas and other issues with re Python module was always my weak point 😁. Will use it in my bachelor thesis