Removing the timestamp from a datetime in pandas dataframe

by

You can do the following:

dfST['timestamp'] = pd.to_datetime(dfST['timestamp'])

to_datetime() will infer the formatting of the date column. You can also pass errors="coerce" if the column contains non-date values.

After completing the above, you’ll be able to create a new column containing only date values:

dfST['new_date_column'] = dfST['timestamp'].dt.date

More Related Contents:

  1. How to join two dataframes for which column values are within a certain range?
  2. Filtering Pandas DataFrames on dates
  3. How to print pandas DataFrame without index
  4. datetime dtypes in pandas read_csv
  5. python pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  6. Python Pandas Group by date using datetime data
  7. Pandas filter dataframe rows with a specific year
  8. Python/Pandas convert string to time only
  9. Convert Pandas Series to DateTime in a DataFrame
  10. Truncate `TimeStamp` column to hour precision in pandas `DataFrame`
  11. Python pandas integer YYYYMMDD to datetime
  12. Group DataFrame in 5-minute intervals
  13. Pandas custom function to find whether it is the 1st, 2nd etc Monday, Tuesday, etc – all suggestions welcome
  14. What values are valid in Pandas ‘Freq’ tags?
  15. Python: Adding hours to pandas timestamp
  16. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  17. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13
  18. Get weekday/day-of-week for Datetime column of DataFrame
  19. Plot pandas dates in matplotlib
  20. How to identify and label similar rows in a pandas data frame
  21. Renaming column names in Pandas
  22. How can I use the apply() function for a single column?
  23. Pandas select rows and columns based on boolean condition
  24. How to flatten a hierarchical index in columns
  25. AttributeError: ‘DataFrame’ object has no attribute ‘ix’
  26. Writing large Pandas Dataframes to CSV file in chunks
  27. How to merge a Series and DataFrame
  28. Transpose the data in a column every nth rows in PANDAS
  29. start index at 1 for Pandas DataFrame
  30. Multi Index Sorting in Pandas

Leave a Comment