# csvdatetimetest.py
import pandas as pd

# Load the CSV
df = pd.read_csv('SPEAR_CRSF-2025-05-12-135644.csv')  # Adjust path if needed
#df = pd.read_csv('Bixler2Kop-2025-04-27.csv')  # Adjust path if needed
#df = pd.read_csv('Bixler2Kop-2025-05-27.csv')  # Adjust path if needed

# Convert Time column (with milliseconds) to datetime.time
#df['Time'] = pd.to_datetime(df['Time'], format='%H:%M:%S.%f').dt.time
df['Time'] = pd.to_datetime(df['Time'], format='mixed').dt.time

# Convert Date column (optional)
df['Date'] = pd.to_datetime(df['Date']).dt.date

# Print results
print(df.head())
print("\nData types:")
print(df.dtypes)
