import sys
sys.path.append('Backend')
import pandas as pd

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

print(f"Data 2024 columns count: {len(df.columns)}")
print(f"Data 2024 rows count: {len(df)}")

for i, col in enumerate(df.columns):
    unique_vals = df[col].dropna().unique()
    sample_vals = unique_vals[:3] if len(unique_vals) > 0 else ['ALL_NULL']
    print(f"[{i+1}] {col}")
    print(f"    Sample: {sample_vals}")