pandas convert from datetime to integer timestamp

by

You can typecast to int using astype(int) and divide it by 10**9 to get the number of seconds to the unix epoch start.

import pandas as pd
df = pd.DataFrame({'time': [pd.to_datetime('2019-01-15 13:25:43')]})
df_unix_sec = pd.to_datetime(df['time']).astype(int)/ 10**9
print(df_unix_sec)

More Related Contents:

  1. Pandas Timedelta in Days
  2. Python pandas convert datetime to timestamp effectively through dt accessor
  3. Python: reduce precision pandas timestamp dataframe
  4. How to combine year, month, and day columns to single datetime column?
  5. Apply multiple functions to multiple groupby columns
  6. Scatter plots in Pandas/Pyplot: How to plot by category [duplicate]
  7. Pandas timeseries plot setting x-axis major and minor ticks and labels
  8. How do I operate on a DataFrame with a Series for every column?
  9. Improve subplot size/spacing with many subplots in matplotlib
  10. Pandas split column into multiple columns by comma
  11. Repeat rows in a pandas DataFrame based on column value
  12. How to use groupby to concatenate strings in python pandas?
  13. Horizontal stacked bar plot and add labels to each section
  14. How to flatten a nested JSON recursively, with flatten_json
  15. Python – How to convert JSON File to Dataframe
  16. How to remove timezone from a Timestamp column in a pandas dataframe
  17. Pandas lookup from one of multiple columns, based on value
  18. How to add a suffix (or prefix) to each column name?
  19. dropping rows from dataframe based on a “not in” condition [duplicate]
  20. Adding two Series with NaNs
  21. Resampling Within a Pandas MultiIndex
  22. Find element’s index in pandas Series
  23. selecting across multiple columns with pandas
  24. How to read a Parquet file into Pandas DataFrame?
  25. Pandas: split column of lists of unequal length into multiple columns
  26. What is as_index in groupby in pandas?
  27. pd.to_datetime is getting half my dates with flipped day / months
  28. Normalize DataFrame by group
  29. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  30. Pandas: Selecting rows based on value counts of a particular column

Leave a Comment