def date_for_length()

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]