text_plain_output_1.png
import pandas as pd

medal = pd.read_excel('../input/2021-olympics-in-tokyo/Medals.xlsx', index_col=0)
athlete = pd.read_excel('../input/2021-olympics-in-tokyo/Athletes.xlsx', index_col=0)
gender = pd.read_excel('../input/2021-olympics-in-tokyo/EntriesGender.xlsx', index_col=0)
team = pd.read_excel('../input/2021-olympics-in-tokyo/Teams.xlsx', index_col=0)
coach = pd.read_excel('../input/2021-olympics-in-tokyo/Coaches.xlsx', index_col=0)

def miss(data):
    missing_value = data.isnull().sum().sort_values(ascending=False)
    missing_perc = (data.isnull().sum() * 100 / data.shape[0]).sort_values(ascending=False)
    value = pd.concat([missing_value, missing_perc], axis=1, keys=['Count', '%'])

miss(team)