ISO Date Conversion

​​
​

Template request | Bug report​
Tags: #pandas #python #date #conversion #isoformat #dateconversion #operations #snippet #dataframe
Author: Oketunji Oludolapo​
This notebook will help you understand how to convert any date to ISO date format.
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

Drop First column

Create Pivot Table

Last modified 3mo ago