Pandas: Difference between two dates or times

Pandas Time Series: Exercise-4 with Solution

Write a Pandas program to print the day after and before a specified date. Also print the days between two given dates.

Sample Solution:

Python Code :

import pandas as pd
import datetime
from datetime import datetime, date
today = datetime(2012, 10, 30)
print("Current date:", today)
tomorrow = today + pd.Timedelta(days=1)
print("Tomorrow:", tomorrow)
yesterday = today - pd.Timedelta(days=1)
print("Yesterday:", yesterday)
date1 = datetime(2016, 8, 2)
date2 = datetime(2016, 7, 19)
print("\nDifference between two dates: ",(date1 - date2))

Sample Output:

Current date: 2012-10-30 00:00:00
Tomorrow: 2012-10-31 00:00:00
Yesterday: 2012-10-29 00:00:00

Difference between two dates:  14 days, 0:00:00        

Python Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a Pandas program to create a date from a given year, month, day and another date from a given string formats.
Next: Write a Pandas program to create a time-series with two index labels and random values. Also print the type of the index.

What is the difficulty level of this exercise?

Test your Python skills with w3resource's quiz

Python: Tips of the Day

Merging two dicts in Python 3.5+ with a single expression


# How to merge two dictionaries
# in Python 3.5+

x = {'p': 1, 'q': 3}
y = {'q': 5, 'r': 8}

z = {**x, **y}

{'r': 4, 'p': 1, 'q': 3}

z = dict(x, **y)


{'p': 1, 'q': 5, 'r': 8}