TIF_E41253310/scripts/checks/inspect_all_2024_cols.py

15 lines
476 B
Python

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}")