How do I round datetime column to nearest quarter hour

by

You can use round(freq). There is also a shortcut column.dt for datetime functions access (as @laurens-koppenol suggests).

Here’s one-liner:

df['old column'].dt.round('15min')

String aliases for valid frequencies can be found here. Full working example:

In [1]: import pandas as pd    
In [2]: df = pd.DataFrame([pd.Timestamp('2015-07-18 13:53:33.280'),
                           pd.Timestamp('2015-07-18 13:33:33.330')],
                         columns=['old column'])

In [3]: df['new column']=df['old column'].dt.round('15min')  
In [4]: df
Out[4]: 
               old column          new column
0 2015-07-18 13:53:33.280 2015-07-18 14:00:00
1 2015-07-18 13:33:33.330 2015-07-18 13:30:00

More Related Contents:

  1. Calculate Time Difference Between Two Pandas Columns in Hours and Minutes
  2. Changing the formatting of a datetime axis in matplotlib
  3. How to change the datetime format in Pandas
  4. Convert DataFrame column type from string to datetime
  5. How to make a timezone aware datetime object in Python?
  6. Filtering Pandas DataFrames on dates
  7. Pandas Dataframe line plot display date on xaxis
  8. How to convert a UTC datetime to a local datetime using only standard library?
  9. Generating random dates within a given range in pandas
  10. Getting today’s date in YYYY-MM-DD in Python?
  11. pandas to_datetime parsing wrong year
  12. How to group a pandas dataframe by a defined time interval?
  13. Python/Pandas convert string to time only
  14. Convert Pandas Series to DateTime in a DataFrame
  15. Convert dataframe index to datetime
  16. Python pandas convert datetime to timestamp effectively through dt accessor
  17. How to add/subtract time (hours, minutes, etc.) from a Pandas DataFrame.Index whos objects are of type datetime.time?
  18. Which is the fastest way to extract day, month and year from a given date?
  19. In Pandas how do I convert a string of date strings to datetime objects and put them in a DataFrame?
  20. Locate first and last non NaN values in a Pandas DataFrame
  21. Group DataFrame in 5-minute intervals
  22. pd.to_datetime is getting half my dates with flipped day / months
  23. Pandas custom function to find whether it is the 1st, 2nd etc Monday, Tuesday, etc – all suggestions welcome
  24. What values are valid in Pandas ‘Freq’ tags?
  25. Clean way to convert quarterly periods to datetime in pandas
  26. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  27. Convert dates to pd.to_datetime where month could be either a number or month name
  28. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13
  29. Pandas: groupby forward fill with datetime index
  30. Pandas: select all dates with specific month and day

Leave a Comment