Pandas converting row with unix timestamp (in milliseconds) to datetime

by

You can do this as a post processing step using to_datetime and passing arg unit="ms":

In [5]:
df['UNIXTIME'] = pd.to_datetime(df['UNIXTIME'], unit="ms")
df

Out[5]:
   RUN                UNIXTIME  VALUE
0    1 2015-11-10 13:05:02.320     10
1    2 2015-11-10 13:05:02.364     20
2    3 2015-11-10 13:05:22.364     42

More Related Contents:

  1. How to change the datetime format in Pandas
  2. Filtering Pandas DataFrames on dates
  3. Pandas Dataframe line plot display date on xaxis
  4. How to print pandas DataFrame without index
  5. Changing the formatting of a datetime axis in matplotlib
  6. Generating random dates within a given range in pandas
  7. pandas to_datetime parsing wrong year
  8. How to group a pandas dataframe by a defined time interval?
  9. How do I round datetime column to nearest quarter hour
  10. Pandas filter dataframe rows with a specific year
  11. Python/Pandas convert string to time only
  12. Convert Pandas Series to DateTime in a DataFrame
  13. Pandas: Return Hour from Datetime Column Directly
  14. pandas .plot() x-axis tick frequency — how can I show more ticks?
  15. Leave dates as strings using read_excel function from pandas in python
  16. Combine Date and Time columns using pandas
  17. Convert dataframe index to datetime
  18. Python pandas convert datetime to timestamp effectively through dt accessor
  19. How to add/subtract time (hours, minutes, etc.) from a Pandas DataFrame.Index whos objects are of type datetime.time?
  20. Which is the fastest way to extract day, month and year from a given date?
  21. In Pandas how do I convert a string of date strings to datetime objects and put them in a DataFrame?
  22. Locate first and last non NaN values in a Pandas DataFrame
  23. Group DataFrame in 5-minute intervals
  24. pd.to_datetime is getting half my dates with flipped day / months
  25. Convert a column of timestamps into periods in pandas
  26. Clean way to convert quarterly periods to datetime in pandas
  27. how to specify the datetime format in read_csv
  28. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  29. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13
  30. Python generating a list of dates between two dates

Leave a Comment