Get year, month or day from numpy datetime64

by

I find the following tricks give between 2x and 4x speed increase versus the pandas method described in this answer (i.e. pd.DatetimeIndex(dates).year etc.). The speed of [dt.year for dt in dates.astype(object)] I find to be similar to the pandas method. Also these tricks can be applied directly to ndarrays of any shape (2D, 3D etc.)

dates = np.arange(np.datetime64('2000-01-01'), np.datetime64('2010-01-01'))
years = dates.astype('datetime64[Y]').astype(int) + 1970
months = dates.astype('datetime64[M]').astype(int) % 12 + 1
days = dates - dates.astype('datetime64[M]') + 1

More Related Contents:

  1. Converting between datetime, Timestamp and datetime64
  2. Pandas: Subtracting two date columns and the result being an integer
  3. Convert numpy.datetime64 to string object in python
  4. Pandas: How to create a datetime object from Week and Year?
  5. pd.Timestamp versus np.datetime64: are they interchangeable for selected uses?
  6. Using datetime as ticks in Matplotlib
  7. Convert a column of timestamps into periods in pandas
  8. How can I implement for loop in Python?
  9. Python: Justifying NumPy array
  10. Numpy where function multiple conditions
  11. How to print pandas DataFrame without index
  12. testing whether a Numpy array contains a given row
  13. How do I convert a datetime to date?
  14. Limit number of threads in numpy
  15. Convert string date to timestamp in Python
  16. Dropping infinite values from dataframes in pandas?
  17. itertools product speed up
  18. Passing Numpy arrays to a C function for input and output
  19. Faster alternatives to numpy.argmax/argmin which is slow
  20. more efficient way to calculate distance in numpy?
  21. Finding the nearest value and return the index of array in Python
  22. 2D array indexing
  23. Get time zone information of the system in Python?
  24. Locate first and last non NaN values in a Pandas DataFrame
  25. Equivalent of `polyfit` for a 2D polynomial in Python
  26. setting spacing between grouped bar plots in matplotlib
  27. Numpy Vector (N,1) dimension -> (N,) dimension conversion
  28. Custom data types in numpy arrays
  29. Get UTC offset from time zone name in python
  30. Why does numpy.histogram (Python) leave off one element as compared to hist in Matlab?

Leave a Comment