in datasets/san_francisco_311/pipelines/_images/run_csv_transform_kub/csv_transform.py [0:0]
def convert_dt_format(dt_str: str) -> str:
if not dt_str or str(dt_str).lower() == "nan" or str(dt_str).lower() == "nat":
return ""
elif (
dt_str.strip()[2] == "/"
): # if there is a '/' in 3rd position, then we have a date format mm/dd/yyyy
return datetime.datetime.strptime(dt_str, "%m/%d/%Y %H:%M:%S %p").strftime(
"%Y-%m-%d %H:%M:%S"
)
else:
return str(dt_str)