/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 vote209 views1 answer
How to make download link in Jupyter appmode
Python
1 vote229 views1 answer
How to veiw and edit files with python
Python
0 vote224 views1 answer
How to make ui dialog pop in front pyqt
Python
66 votes209 views6 answers
Python for loop index
Python
2 votes211 views2 answers
Iterate through attributes of class python
Python
0 vote171 views1 answer
Combine picture and audio python
Python
0 vote212 views1 answer
Change creation date filesystem py
Python
2 votes202 views1 answer
Embed variables python
Python
0 vote201 views1 answer
Python format method align center
Python
17 votes221 views5 answers
ModuleNotFoundError: No module named 'tkinter'
Python