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 pandas change objects to float?
Convert Object to Float in Pandas
Read moreHow do I convert a string to a column to a date in Python?
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 I use Pandas to datetime?
Example Data
Read moreHow do Pandas deal with dates?
Working with datetime in Pandas DataFrame
Read moreHow does Python handle date and time?
Python format datetime The way date and time is represented may be different in different places, organizations etc. It’s more common to use mm/dd/yyyy in the US, whereas dd/mm/yyyy is more common in the UK. Python has strftime() and strptime() methods to handle this.
Read moreDo Pandas recognize dates?
No, there is no way in pandas to automatically recognize date columns .
Read more