Answers for "pandas format dataframe columns to date without knowing format"

0

apply format to pandas datetime column

formatted_df = df["Date"].dt.strftime("%m/%d/%y")
Posted by: Guest on August-25-2020
0

pandas transform date format?

import pandas as pd

df = pd.DataFrame({'DOB': {0: '26/1/2016', 1: '26/1/2016'}})
print (df)
         DOB
0  26/1/2016 
1  26/1/2016

df['DOB'] = pd.to_datetime(df.DOB)
print (df)
         DOB
0 2016-01-26
1 2016-01-26

df['DOB1'] = df['DOB'].dt.strftime('%m/%d/%Y')
print (df)
         DOB        DOB1
0 2016-01-26  01/26/2016
1 2016-01-26  01/26/2016
Posted by: Guest on June-10-2021

Code answers related to "pandas format dataframe columns to date without knowing format"

Python Answers by Framework

Browse Popular Code Answers by Language