import pandas as pd
from datetime import datetime
df = pd.DataFrame({"ts": ["15/0/2022 22:7:9 6 360", "asdsada ssad"], "d": [5, 12]})
def parse_dt(t):
try:
date_str, time_str = t.split(" ")[:2]
day, month, year = date_str.split("/")
hour, minute, second = time_str.split(":")
day = int(day)
month = int(month)
year = int(year)
hour = int(hour)
minute = int(minute)
second = int(second)
month += 1
return pd.Timestamp(datetime(year, month, day, hour, minute, second))
except Exception as e:
print("ignored", t, "with", e)
return pd.NaT
df["ts"] = df["ts"].apply(parse_dt)
print(df)