/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 vote110 views1 answer
Index of max in tensor
Python
0 vote112 views2 answers
Attributeerror module 'datetime' has no attribute 'now' python
Python
0 vote144 views1 answer
The module in NAME could not be imported: django.contrib.user_auth.password_validation.UserAttributeSimilarityValidator. Check your AUTH_PASSWORD_VALI
Python Django
0 vote115 views1 answer
Python discord if == emoji not working
Python
0 vote105 views1 answer
Discord py server.channels
Python
0 vote117 views1 answer
Change Separator Value When Printing
Python
5 votes114 views1 answer
If statement in one-line for loop python
Python
5 votes129 views2 answers
Python if defined
Python
1 vote116 views1 answer
Name exit not defined python
Python
0 vote123 views1 answer
How to encode hexadecimal python
Python