/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

4 votes128 views1 answer
Numpy mean 2 arrays
Python
0 vote150 views1 answer
Pong code python
Python
0 vote139 views1 answer
Effient way to find prime no inpython
Python
4 votes139 views1 answer
Try with multiple except python
Python
1 vote159 views3 answers
Python x = x + 1
Python
37 votes134 views3 answers
How to send emails in python
Python
1 vote152 views1 answer
How to change size of xticks
Python
1 vote132 views1 answer
Private instance attribute python
Python
0 vote131 views1 answer
Py insert char at index
Python
1 vote146 views1 answer
Python print dict new line
Python