import pandas as pd, numpy as np df = pd.DataFrame({'currency':['USD','','EUR','']}) (df['currency'].values == '').sum() # 2 len(df[df['currency'] == '']) # 2 df.loc[df['currency'] == ''].count().iloc[0] # 2