makexu93
4/7/2019 - 10:10 AM

Convert Date in String Format (DD.MM.YYYY) into Date Format in Pandas

Convert Date in String Format (DD.MM.YYYY) into Date Format in Pandas (Python).

import_convert_date.py
content_copyfile_download
import pandas as pd

## when importing CSV
dateparse = lambda x: pd.datetime.strptime(x, '%d.%m.%y')
mydata = pd.read_csv('/Users/Mr_Nobody/Desktop/movie_data.csv',parse_dates = ['input_date_String'],date_parser=dateparse)

## existing dataframe
mydata["Date"] = pd.to_datetime(mydata["input_date_String"], format = '%d.%m.%y')