/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 vote319 views1 answer
How to take second largest value in pandas
Python
0 vote380 views1 answer
Django edit model without loading from db
Python Django
0 vote305 views1 answer
Plot multiplr linear regression model python
Python
1 vote325 views1 answer
Python define an array of dictonary
Python
115 votes298 views6 answers
Pip install python
Python
0 vote315 views1 answer
Disable console messages in Flask server
Python
4 votes405 views2 answers
Read binary file python
Python
8 votes303 views2 answers
Max of two columns pandas
Python
0 vote350 views1 answer
Change order of headers pandas
Python
0 vote304 views2 answers
How to create an empty 2d list in python
Python