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.
import pandas as pd
from dateutil.parser import parse
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
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))
data
Last modified 1mo ago