/Python/Pandas count empty string values

Pandas count empty string values

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

Source: stackoverflow.com

Similar codes

1 vote116 views1 answer
Count missing values groupby
Python
84 votes169 views6 answers
Python loop through list
Python
5 votes118 views2 answers
Check if dataframe contains infinity
Python
2 votes162 views1 answer
Matplotlib plot adjust margins
Python
0 vote149 views1 answer
Alan watts
Python
1 vote115 views1 answer
How to convert a pandas series from int to float in python
Python
1 vote139 views1 answer
Python write to command prompt
Python
0 vote136 views1 answer
Python replace two spaces with one
Python
0 vote120 views1 answer
Split an array into subarrays python
Python
33 votes124 views4 answers
Split word python
Python