import pandas as pd
import glob
import sys
sys.path.append('Backend')
from app.parsers.column_finder import find_column
from app.parsers.mappings import PEKERJAAN_MAPPING

files = sorted(glob.glob('Data_Tracerstudy/*.csv'))
for f in files:
    if 'pertanyaan' in f.lower():
        continue
    df = pd.read_csv(f, sep=';', encoding='utf-8-sig')
    source_cols = list(df.columns)
    col = find_column(source_cols, PEKERJAAN_MAPPING['status_saat_ini'])
    print(f"File: {f}")
    print(f"  Col found: {repr(col)}")
    if col:
        vals = df[col].dropna().unique()
        print(f"  Unique values ({len(vals)}):")
        for v in vals:
            print(f"    - {repr(v)}")
    print("-" * 50)