# -*- coding: utf-8 -*-
"""
Created on Wed Sep 23 12:52:13 2026

@author: chuffard
"""
##THESE ARE NOT RED CHANNEL!!!!!!!!!!!!!!!!

import numpy as np
from datetime import datetime
import numpy as np
import pandas as pd
import sys
import os.path
import warnings
import glob
import matplotlib.pyplot as plt
from matplotlib.backends.backend_pdf import PdfPages
warnings.filterwarnings("ignore")
import re

SES73 = pd.read_csv("S:/Analyses/Station M data/Station M attenuance/SES_out_atn73.csv")
SES60 = pd.read_csv("S:/Analyses/Station M data/Station M attenuance/SES_out_atn60.csv")
SES61 = pd.read_csv("S:/Analyses/Station M data/Station M attenuance/SES_out_atn61.csv")
SES62 = pd.read_csv("S:/Analyses/Station M data/Station M attenuance/SES_out_atn62.csv")
SES64 = pd.read_csv("S:/Analyses/Station M data/Station M attenuance/SES_out_atn64.csv")
SES66 = pd.read_csv("S:/Analyses/Station M data/Station M attenuance/SES_out_atn66.csv")
SES68 = pd.read_csv("S:/Analyses/Station M data/Station M attenuance/SES_out_atn68.csv")
SES70 = pd.read_csv("S:/Analyses/Station M data/Station M attenuance/SES_out_atn70.csv")
SES71 = pd.read_csv("S:/Analyses/Station M data/Station M attenuance/SES_out_atn71.csv")

combined_SES = pd.concat([SES60, SES61, SES62, SES64, SES66, SES68, SES70, SES71, SES73], ignore_index=True)

combined_SES["integers"] = combined_SES["file_name"].str.findall(r"\d+").apply(lambda x: [int(i) for i in x[-12:]] if isinstance(x, list) else [])


combined_SES['extracted'] = combined_SES['file_name'].str.replace('-', ' ').str.extract(r"t_([\d\s]+)")[0].str.split().apply(lambda x: [int(i) for i in x] if x else [])
combined_SES['date'] = pd.to_datetime(combined_SES['extracted'].str[0].astype(str).str.zfill(6), format='%y%m%d').dt.date
# 2. Extract right portion and convert to Time (HHMMSS)
combined_SES['time'] = pd.to_datetime(combined_SES['extracted'].str[1].astype(str).str.zfill(6), format='%H%M%S').dt.time
date_str = combined_SES['extracted'].str[0].astype(str).str.zfill(6)
time_str = combined_SES['extracted'].str[1].astype(str).str.zfill(6)
# 2. Combine and convert to a single datetime object
combined_SES['DateTime'] = pd.to_datetime(date_str + time_str, format='%y%m%d%H%M%S')