Convert different DATE format to unique date format using python

Convert different DATE format to unique date format using python

How to convert date format dynamically using python


import pandas as pd
import datetime

df = pd.read_csv('G:\ETL_Automation\data\date1.txt')
print(df.dtypes)

df1 = df.apply(lambda col: pd.to_datetime(col, errors='ignore')
 if col.dtypes == object else col, axis=0)

for col in df1.filter(regex='date'):
try:
df1[col] = pd.datetime(df1[col])
except TypeError:
df[col] = pd.to_datetime(df1[col], format='%YYYY-$m-%d')

print(df)


https://youtu.be/5g300S0s2Ws

Post a Comment

0 Comments