import pandas as pd

for code in ['E0','E1','F1','I1']:
    d = pd.read_csv(f'E:/soccer/league_data/{code}_2526.csv', encoding='utf-8-sig')
    no_result = d[d['FTR'].isna()]
    has_result = d[d['FTR'].notna()]
    print(f"\n{code}: {len(d)} total, {len(has_result)} with results, {len(no_result)} without")
    if len(no_result) > 0:
        print(no_result[['Date','HomeTeam','AwayTeam','B365H','B365D','B365A']].head(10).to_string())