import pandas as pd data = pd.read_excel('....') if sum(data['calculate'].isnull()) > 0 : print('计算列有缺失值')