/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 vote130 views1 answer
Use an async check function for discord.py wait_for?
Python
0 vote109 views1 answer
Sum items in a list with ints and strings in python
Python
0 vote101 views1 answer
Ascii to decimal python
Python
10 votes100 views4 answers
Multiply each element in list python
Python
1 vote120 views1 answer
Django queryset average of unique values
Python Django
0 vote138 views1 answer
Tables in discord.py
Python
0 vote148 views1 answer
How to catch stop itteration in generator as None
Python
0 vote99 views1 answer
How to use django-rest-framework-datatables
Python
0 vote97 views1 answer
How to define a functio in python
Python
0 vote109 views1 answer
How to create copy of all objects in list python
Python