/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 vote197 views1 answer
2nd to last index python
Python
0 vote183 views1 answer
Python enum declare
Python
77 votes184 views5 answers
Python remove last 4 characters from string
Python
100 votes177 views6 answers
Pip3 upgrade
Python
0 vote185 views1 answer
Install lz4 python 3
Python
0 vote174 views1 answer
Check processing bar of loop in python
Python
2 votes183 views1 answer
Python check if string is in input
Python
2 votes195 views1 answer
Register modal in django admin
Python Django
0 vote184 views1 answer
From string to flaot python numpy
Python
0 vote190 views1 answer
Tar dataset
Python