w3resource

Pandas Datetime: Create a conversion between strings and datetime


15. Conversion Between Strings and Datetime

Write a Pandas program to create a conversion between strings and datetime.

Sample Solution :

Python Code :

from datetime import datetime
from dateutil.parser import parse
print("Convert datatime to strings:")
stamp=datetime(2019,7,1)
print(stamp.strftime('%Y-%m-%d'))
print(stamp.strftime('%d/%b/%y'))
print("\nConvert strings to datatime:")
print(parse('Sept 17th 2019'))
print(parse('1/11/2019'))
print(parse('1/11/2019', dayfirst=True))

Sample Output:

Convert datatime to strings:
2019-07-01
01/Jul/19

Convert strings to datatime:
2019-09-17 00:00:00
2019-01-11 00:00:00
2019-11-01 00:00:00

For more Practice: Solve these Related Problems:

  • Write a Pandas program to convert a column of date strings in the UFO dataset into datetime objects.
  • Write a Pandas program to transform datetime objects back into formatted strings and verify the conversion.
  • Write a Pandas program to use pd.to_datetime() to parse a column of date strings and then format the dates using dt.strftime().
  • Write a Pandas program to create a new column that converts UFO reporting dates from string format to datetime and back to string format.

Go to:


Previous: Write a Pandas program to generate sequences of fixed-frequency dates and time spans.
Next: Write a Pandas program to manipulate and convert date times with timezone information.

Python Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.