w3resource

Pandas: Difference between two dates or times


4. Date Arithmetic

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        

For more Practice: Solve these Related Problems:

  • Write a Pandas program to calculate the day immediately after and before a specified date using timedelta arithmetic.
  • Write a Pandas program to compute the number of days between two dates while excluding weekends.
  • Write a Pandas program to determine the previous and next business day from a given date using custom offsets.
  • Write a Pandas program to generate a list of dates between two given dates and then display their corresponding weekday names.

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 Programming skills with w3resource's quiz.



Follow us on Facebook and Twitter for latest update.