/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

2 votes245 views3 answers
Pandas print dataframe without index
Python
10 votes257 views4 answers
Dataframe column in list
Python
0 vote248 views1 answer
Python set with counts
Python
1 vote299 views2 answers
Run flask app windows
Python Flask
0 vote249 views2 answers
How to fix def multiply(a ,b): a*b
Python
3 votes254 views5 answers
Pdf to text python
Python
-3 votes270 views1 answer
Django socketio web chat example
Python Django
1 vote211 views1 answer
[Solved] ValueError: If using all scalar values, you must pass an index
Python
7 votes238 views1 answer
Python xrange
Python
0 vote237 views1 answer
How to print 's in python
Python