datetime to string with series in pandas

by

There is no .str accessor for datetimes and you can’t do .astype(str) either.

Instead, use .dt.strftime:

>>> series = pd.Series(['20010101', '20010331'])
>>> dates = pd.to_datetime(series, format="%Y%m%d")
>>> dates.dt.strftime('%Y-%m-%d')
0    2001-01-01
1    2001-03-31
dtype: object

See the docs on customizing date string formats here: strftime() and strptime() Behavior.

For old pandas versions <0.17.0, one can instead can call .apply with the Python standard library’s datetime.strftime:

>>> dates.apply(lambda x: x.strftime('%Y-%m-%d'))
0    2001-01-01
1    2001-03-31
dtype: object

More Related Contents:

  1. How to change the datetime format in Pandas
  2. Filtering Pandas DataFrames on dates
  3. Pandas Dataframe line plot display date on xaxis
  4. How to print pandas DataFrame without index
  5. Changing the formatting of a datetime axis in matplotlib
  6. Generating random dates within a given range in pandas
  7. Pandas: Subtracting two date columns and the result being an integer
  8. How to change the datetime tick label frequency for matplotlib plots
  9. pandas to_datetime parsing wrong year
  10. Splitting timestamp column into separate date and time columns
  11. Python/Pandas convert string to time only
  12. Convert Pandas Series to DateTime in a DataFrame
  13. Convert dataframe index to datetime
  14. Python pandas convert datetime to timestamp effectively through dt accessor
  15. How to add/subtract time (hours, minutes, etc.) from a Pandas DataFrame.Index whos objects are of type datetime.time?
  16. Which is the fastest way to extract day, month and year from a given date?
  17. In Pandas how do I convert a string of date strings to datetime objects and put them in a DataFrame?
  18. Locate first and last non NaN values in a Pandas DataFrame
  19. Group DataFrame in 5-minute intervals
  20. pd.to_datetime is getting half my dates with flipped day / months
  21. Pandas custom function to find whether it is the 1st, 2nd etc Monday, Tuesday, etc – all suggestions welcome
  22. filter pandas dataframe by time
  23. Convert a column of timestamps into periods in pandas
  24. Clean way to convert quarterly periods to datetime in pandas
  25. Average time for datetime list
  26. Python: Adding hours to pandas timestamp
  27. how to specify the datetime format in read_csv
  28. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  29. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13
  30. Python generating a list of dates between two dates

Leave a Comment