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
0 Comments
Thanks for your message.