Pandas: Subtraction of two timestamps of same time zone or different time zone
Pandas Time Series: Exercise-20 with Solution
Write a Pandas program to subtract two timestamps of same time zone or different time zone.
Python Code :
import pandas as pd print("Subtract two timestamps of same time zone:") date1 = pd.Timestamp('2019-03-01 12:00', tz='US/Eastern') date2 = pd.Timestamp('2019-04-01 07:00', tz='US/Eastern') print("Difference: ", (date2-date1)) print("\nSubtract two timestamps of different time zone:") date1 = pd.Timestamp('2019-03-01 12:00', tz='US/Eastern') date2 = pd.Timestamp('2019-03-01 07:00', tz='US/Pacific') # Remove the time zone and do the subtraction print("Difference: ", (date1.tz_localize(None) - date2.tz_localize(None)))
Subtract two timestamps of same time zone: Difference: 30 days 18:00:00 Subtract two timestamps of different time zone: Difference: 0 days 05:00:00
Python Code Editor:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
What is the difficulty level of this exercise?
Test your Python skills with w3resource's quiz
Python: Tips of the Day
>>> "Python ROCK" if True else " I AM GRUMPY" "Python ROCK"
- New Content published on w3resource:
- Scala Programming Exercises, Practice, Solution
- Python Itertools exercises
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework