/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

0 vote199 views1 answer
Python get all items from generator
Python
0 vote186 views1 answer
Change increment in for loop python
Python
46 votes235 views6 answers
Install requests python
Python
0 vote218 views1 answer
Django check if get parameter exists
Python Django
3 votes186 views2 answers
How to change role permissions in discord.py
Python
0 vote181 views1 answer
Class indexing
Python
0 vote245 views1 answer
Shutdown flask server with request
Python Flask
0 vote222 views1 answer
Failed to build wxPython
Python
15 votes183 views3 answers
Save numpy array to csv
Python
0 vote199 views1 answer
Pandas use map lambda to fillna python
Python