TIF_E41253310/scripts/checks/diagnose_2024.py

19 lines
647 B
Python

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