Links

ISO Date Conversion

Tags: #pandas #python #date #conversion #isoformat #dateconversion #operations #snippet #dataframe
Description: This notebook provides a guide to converting ISO dates into Pandas-compatible formats.

Input

Import Libraries

import pandas as pd
from dateutil.parser import parse

Create Sample Dataframe

dict1 = {
"Name": ["Peter", "Dolly", "Maggie", "David", "Isabelle"],
"Date": ["20/2/2021", "19/8/2014", "8/9/2000", "4/3/2013", "14/7/1995"],
"Second Date": [
"August 20,2011",
"September 16,1993",
"January 23,2009",
"October 17,2019",
"March 4,2021",
],
}
data = pd.DataFrame(dict1)
data

Model

ISO date format is the standard internationally acceptable format of writing date. It eliminates the differences between the date format of different regions. This template will convert any date to ISO format. There are 2 date formats in the sample data and the conversion of both takes place below
# Converting the first Date into ISO Format
data["Date"] = pd.to_datetime(data["Date"]).dt.strftime("%Y-%m-%d")
# Converting the second date into ISO Format
data["Second Date"] = data["Second Date"].apply(lambda i: parse(i))

Output

Display result

data