script.py

import pandas as pd
try:
    awenh = pd.read_excel(r'c:\Repositories\SimplePeat\Data\CMON\inputs\CMON_litter_awenh.xlsx')
    stands = pd.read_excel(r'c:\Repositories\SimplePeat\Data\CMON\inputs\CMON_stand_attributes_bm_annual.xlsx')
    cmondata = pd.read_excel(r'c:\Repositories\SimplePeat\Data\CMON\inputs\CMON-data_to_model_latest.xlsx', skiprows=1)

    print("awenh columns:", list(awenh.columns))
    print("awenh dtypes:\n", awenh.dtypes)
    print("\nawenh unique stands:", sorted(awenh['stand'].unique().tolist()) if 'stand' in awenh.columns else "no stand col")
    print("awenh year range:", awenh['year'].min(), '-', awenh['year'].max())

    print("\nstands columns:", list(stands.columns))
    print("stands year col exists:", 'year' in stands.columns)
    if 'year' in stands.columns:
        print("stands year range:", stands['year'].min(), '-', stands['year'].max())

    print("\ncmondata columns:", list(cmondata.columns))
    print("cmondata shape:", cmondata.shape)
    print(cmondata[['KOEALA','Ta_AVERAGE']].head(10).to_string())
except Exception as e:
    print(e)