in datasets/fec/pipelines/_images/run_csv_transform_kub/csv_transform.py [0:0]
def date_for_length(df: pd.DataFrame, field_name: str) -> pd.DataFrame:
logging.info(f"Evaluating date format on field {field_name}")
date_list = df[field_name].values
new_date_list = []
for item in date_list:
if item != "NaN" and len(item) >= 6 and len(item) <= 8:
if len(item) == 7:
item = "0" + item
new_date_list.append(item)
elif len(item) == 6:
item = "0" + item[0:1] + "0" + item[1:]
new_date_list.append(item)
else:
new_date_list.append(item)
continue
elif len(item) < 6:
item = ""
new_date_list.append(item)
else:
item = ""
new_date_list.append(item)
df[field_name] = new_date_list
return df[field_name]