If your date column is a string of the format ‘2017-01-01’ you can use pandas astype to convert it to datetime . You can try it with other formats then ‘%Y-%m-%d’ but at least this works.
Read moreHow do pandas change objects to float?
Convert Object to Float in Pandas
Read moreHow do you change an object to a date in Python?
The date column is indeed a string, which—remember—is denoted as an object type in Python. You can convert it to the datetime type with the . to_datetime() method in pandas .
Read moreHow do I convert pandas to datetime?
Steps to Convert Strings to Datetime in Pandas DataFrame
Read moreHow do Pandas represent time?
In pandas, a single point in time is represented as a Timestamp . We can use the to_datetime() function to create Timestamps from strings in a wide variety of date/time formats. Let’s import pandas and convert a few dates and times to Timestamps.
Read moreHow do I use Pandas to datetime?
Example Data
Read moreDo Pandas recognize dates?
No, there is no way in pandas to automatically recognize date columns .
Read more