def clean_date()

in datasets/london_bicycles/pipelines/_images/run_csv_transform_kub/csv_transform.py [0:0]


def clean_date(datestr: str) -> str:
    datestr = datestr.strip()
    if len(datestr) < 9:
        datestr = f"{datestr[:-2]}20{datestr[-2:]}"
    if datestr[:-4][-3].isnumeric:
        if datestr[:-4][-2:] == "Fe":
            datestr = f"{datestr[:-6]}Feb{datestr[-4:]}"
    if len(datestr) == 9:
        datestr = datetime.datetime.strptime(datestr, "%d%b%Y").strftime("%Y%m%d")
    else:
        datestr = datetime.datetime.strptime(datestr, "%d%B%Y").strftime("%Y%m%d")
    return datestr