/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 vote102 views3 answers
Seaborn heatmap x labels horizontal
Python
4 votes111 views1 answer
Tkinter text in canvas
Python
0 vote107 views1 answer
Php echo shorthand example
Python
0 vote134 views1 answer
The requested resource was not found on this server. django
Python
0 vote139 views1 answer
Template tag django
Python Django
-1 vote92 views1 answer
How to ask a yes or no question on python
Python
1 vote123 views1 answer
How to have add break for a few seconds in python
Python
2 votes92 views3 answers
How to reboot a python script
Python
7 votes141 views2 answers
Python remove html tags
Python
-1 vote106 views3 answers
How to create a new file in terminal
Python