/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

10 votes311 views3 answers
Pandas create new column conditional on other columns
Python
0 vote342 views1 answer
How to add phone number to django user model
Python
103 votes338 views4 answers
Separate a string in python
Python
0 vote377 views1 answer
Python increment char a to b az to ba
Python
2 votes400 views2 answers
Python datetime add
Python
1 vote367 views1 answer
How to save a dictionary to excel in python
Python
5 votes320 views1 answer
Python pip yaml
Python
0 vote350 views1 answer
List in one line of text in python
Python
18 votes348 views2 answers
Absolute value python
Python
0 vote348 views6 answers
Django wht post save signal not firing
Python