Pandas: Convert unix/epoch time to a regular time stamp in UTC and Timestamp of a given time zone
Pandas Time Series: Exercise-17 with Solution
Write a Pandas program to convert unix/epoch time to a regular time stamp in UTC. Also convert the said timestamp in to a given time zone.
Python Code :
import pandas as pd epoch_t = 1621132355 time_stamp = pd.to_datetime(epoch_t, unit='s') # UTC (Coordinated Universal Time) is one of the well-known names of UTC+0 time zone which is 0h. # By default, time series objects of pandas do not have an assigned time zone. print("Regular time stamp in UTC:") print(time_stamp) print("\nConvert the said timestamp in to US/Pacific:") print(time_stamp.tz_localize('UTC').tz_convert('US/Pacific')) print("\nConvert the said timestamp in to Europe/Berlin:") print(time_stamp.tz_localize('UTC').tz_convert('Europe/Berlin'))
Regular time stamp in UTC: 2021-05-16 02:32:35 Convert the said timestamp in to US/Pacific: 2021-05-15 19:32:35-07:00 Convert the said timestamp in to Europe/Berlin: 2021-05-16 04:32:35+02: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