import sys
sys.path.append('Backend')
import pandas as pd
import datetime
from app.parsers.converters import parse_2024_value, parse_date, konversi_jawaban
from app.parsers.mappings import *
from app.parsers.column_finder import find_column, get_value

df = pd.read_csv('Data_Tracerstudy/Data_2024_Tracer_study.csv', sep=';', encoding='utf-8-sig')

# Check date parsing issues
dates = df['15. Tanggal Masuk Awal Studi Lanjut Anda? f18d'].dropna()
print('Sample dates from column 15:')
for d in dates.head(10):
    parsed = parse_date(d)
    print(f'  raw: {repr(d)} -> parsed: {parsed} (type: {type(parsed)})')

# Check date parser implementation