seoLogs_splitDate.py

# Split Date & Time
df[['Date_Time', 'header']] = df['header'].str.split("\] ", 1,
        expand=True)
df['Date_Time'] = df['Date_Time'].str.replace(':.*', '')

# Convert the Date_Time column from string to datetime format
df['Date'] = pd.to_datetime(df['Date_Time'], errors='coerce',
                            infer_datetime_format=True)

# Remove Time column, for clarity's sake
df = df.drop(['Date_Time'], axis=1)

# Check that the Date column has been converted to a time series
df.info()