Data Cleaning

parsed_dates = [None] * len(date_array)  # Pre-allocate list for parsed dates
bad_indices = []  # List to store indices of unparseable dates

for i, date_str in enumerate(date_array):
    if not date_str:
        bad_indices.append(i)
    try:
        full_date = parse_iso_datetime(date_str)
        local_date = get_local_naive_datetime_from_utc(full_date)

        parsed_dates[i] = local_date  # Store the adjusted datetime object
    except (ValueError, TypeError):
        bad_indices.append(i)  # Record the index of any unparseable date string