Pandas: Converting integer or float epoch times to Timestamp and DatetimeIndex

Last update on April 04 2025 13:48:04 (UTC/GMT +8 hours)

26. Convert Epoch Times to Timestamps

Write a Pandas program to convert integer or float epoch times to Timestamp and DatetimeIndex.

Sample Solution:

Python Code :

import pandas as pd
dates1 = pd.to_datetime([1329806505, 129806505, 1249892905,
                1249979305, 1250065705], unit='s')
print("Convert integer or float epoch times to Timestamp and DatetimeIndex upto second:")
print(dates1)
print("\nConvert integer or float epoch times to Timestamp and DatetimeIndex upto milisecond:")
dates2 = pd.to_datetime([1249720105100, 1249720105200, 1249720105300,
                1249720105400, 1249720105500], unit='ms')
print(dates2)

Sample Output:

Convert integer or float epoch times to Timestamp and DatetimeIndex upto second:
DatetimeIndex(['2012-02-21 06:41:45', '1974-02-11 09:21:45',
               '2009-08-10 08:28:25', '2009-08-11 08:28:25',
               '2009-08-12 08:28:25'],
              dtype='datetime64[ns]', freq=None)

Convert integer or float epoch times to Timestamp and DatetimeIndex upto milisecond:
DatetimeIndex(['2009-08-08 08:28:25.100000', '2009-08-08 08:28:25.200000',
               '2009-08-08 08:28:25.300000', '2009-08-08 08:28:25.400000',
               '2009-08-08 08:28:25.500000'],
              dtype='datetime64[ns]', freq=None)

For more Practice: Solve these Related Problems:

Write a Pandas program to convert a list of integer and float epoch times into a DatetimeIndex and verify the output format.
Write a Pandas program to create a DataFrame with mixed epoch time values, convert the column to Timestamps, and check the data type.
Write a Pandas program to transform epoch times to Timestamps and then set the resulting series as the DataFrame index.
Write a Pandas program to convert a series of epoch times to Timestamps and then filter out dates falling on weekends.

Python Code Editor:

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

Previous: Write a Pandas program to extract the day name from a specified date. Add 2 days and 1 business day with the specified date.
Next: Write a Pandas program to calculate one, two, three business day(s) from a specified date. Also find the next business month end from a specific date.