Keep only date part when using pandas.to_datetime

by

Since version 0.15.0 this can now be easily done using .dt to access just the date component:

df['just_date'] = df['dates'].dt.date

The above returns a datetime.date dtype, if you want to have a datetime64 then you can just normalize the time component to midnight so it sets all the values to 00:00:00:

df['normalised_date'] = df['dates'].dt.normalize()

This keeps the dtype as datetime64, but the display shows just the date value.

More Related Contents:

  1. datetime dtypes in pandas read_csv
  2. how to specify the datetime format in read_csv
  3. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13
  4. Convert Excel style date with pandas
  5. Combine Date and Time columns using python pandas
  6. How to convert columns into one datetime column in pandas?
  7. pandas out of bounds nanosecond timestamp after offset rollforward plus adding a month offset
  8. Create a day-of-week column in a Pandas dataframe using Python
  9. python – Using pandas structures with large csv(iterate and chunksize)
  10. Python: Pandas Series – Why use loc?
  11. Convert pandas Series to DataFrame
  12. Converting between datetime and Pandas Timestamp objects
  13. Remove name, dtype from pandas output of dataframe or series
  14. OSError: Initializing from file failed on csv in Pandas
  15. Convert a column of datetimes to epoch in Python
  16. How to define format when using pandas to_datetime?
  17. pandas bar plot combined with line plot shows the time axis beginning at 1970
  18. Specifying date format when converting with pandas.to_datetime
  19. Read specific columns with pandas or other python module
  20. how to test if a variable is pd.NaT?
  21. Datetime conversion – How to extract the inferred format?
  22. Calculate summary statistics of columns in dataframe
  23. double quoted elements in csv cant read with pandas
  24. Convert a column of timestamps into periods in pandas
  25. Python: Adding hours to pandas timestamp
  26. How to combine year, month, and day columns to single datetime column?
  27. UnicodeDecodeError when reading CSV file in Pandas
  28. How to return a csv file/Pandas DataFrame in JSON format using FastAPI?
  29. Python generating a list of dates between two dates
  30. Sorting a pandas series

Leave a Comment