Convert pandas DateTimeIndex to Unix Time?

by

As DatetimeIndex is ndarray under the hood, you can do the conversion without a comprehension (much faster).

In [1]: import numpy as np

In [2]: import pandas as pd

In [3]: from datetime import datetime

In [4]: dates = [datetime(2012, 5, 1), datetime(2012, 5, 2), datetime(2012, 5, 3)]
   ...: index = pd.DatetimeIndex(dates)
   ...: 
In [5]: index.astype(np.int64)
Out[5]: array([1335830400000000000, 1335916800000000000, 1336003200000000000], 
        dtype=int64)

In [6]: index.astype(np.int64) // 10**9
Out[6]: array([1335830400, 1335916800, 1336003200], dtype=int64)

%timeit [t.value // 10 ** 9 for t in index]
10000 loops, best of 3: 119 us per loop

%timeit index.astype(np.int64) // 10**9
100000 loops, best of 3: 18.4 us per loop

More Related Contents:

  1. Difference between map, applymap and apply methods in Pandas
  2. Python Pandas : group by in group by and average?
  3. Python pandas insert list into a cell
  4. Stacked Bar Chart with Centered Labels
  5. How to replace text in a string column of a Pandas dataframe?
  6. Pandas DataFrame Groupby two columns and get counts
  7. Pandas dataframe get first row of each group
  8. Pandas: conditional rolling count
  9. pandas .at versus .loc
  10. What does the term “broadcasting” mean in Pandas documentation?
  11. Selection with .loc in python
  12. Add column to dataframe with constant value
  13. Check if string is in a pandas dataframe
  14. How to use Pandas rolling_* functions on a forward-looking basis
  15. Finding consecutive segments in a pandas data frame
  16. Selecting Pandas Columns by dtype
  17. drop_duplicates not working in pandas?
  18. Turn Pandas Multi-Index into column
  19. Pandas – Strip white space
  20. Filter string data based on its string length
  21. Converting pandas column of comma-separated strings into dummy variables
  22. Creating an empty Pandas DataFrame, and then filling it
  23. Matplotlib showing x-tick labels overlapping
  24. How to remove decimal points in pandas
  25. Check if rows in one dataframe exist in another dataframe
  26. Why doesn’t my pandas rolling().apply() work when the series contains collections?
  27. Pandas custom function to find whether it is the 1st, 2nd etc Monday, Tuesday, etc – all suggestions welcome
  28. Remove ends of string entries in pandas DataFrame column
  29. why is a sum of strings converted to floats
  30. Pandas: Create missing combination rows with zero values

Leave a Comment