In Pandas how do I convert a string of date strings to datetime objects and put them in a DataFrame?

by 
>>> import pandas as pd
>>> date_stngs = ('2008-12-20','2008-12-21','2008-12-22','2008-12-23')
>>> a = pd.Series([pd.to_datetime(date) for date in date_stngs])
>>> a
0    2008-12-20 00:00:00
1    2008-12-21 00:00:00
2    2008-12-22 00:00:00
3    2008-12-23 00:00:00

UPDATE

Use pandas.to_datetime(pd.Series(..)). It’s concise and much faster than above code.

>>> pd.to_datetime(pd.Series(date_stngs))
0   2008-12-20 00:00:00
1   2008-12-21 00:00:00
2   2008-12-22 00:00:00
3   2008-12-23 00:00:00

More Related Contents:

  1. Convert Pandas Column to DateTime
  2. Converting between datetime, Timestamp and datetime64
  3. How to join two dataframes for which column values are within a certain range?
  4. Calculate Time Difference Between Two Pandas Columns in Hours and Minutes
  5. Extracting just Month and Year separately from Pandas Datetime column
  6. Combine Date and Time columns using python pandas
  7. datetime to string with series in pandas
  8. pandas datetime to unix timestamp seconds
  9. python pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  10. How to group a pandas dataframe by a defined time interval?
  11. Python Pandas Group by date using datetime data
  12. Removing the timestamp from a datetime in pandas dataframe
  13. Subtract a year from a datetime column in pandas
  14. pandas .plot() x-axis tick frequency — how can I show more ticks?
  15. Convert a column of datetimes to epoch in Python
  16. Pandas: How to create a datetime object from Week and Year?
  17. How to define format when using pandas to_datetime?
  18. pd.Timestamp versus np.datetime64: are they interchangeable for selected uses?
  19. pandas bar plot combined with line plot shows the time axis beginning at 1970
  20. how to test if a variable is pd.NaT?
  21. Python pandas integer YYYYMMDD to datetime
  22. Pandas parse non-english string dates
  23. Group DataFrame in 5-minute intervals
  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