/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

4 votes189 views4 answers
Python pandas change column values to all caps
Python
0 vote163 views1 answer
Pandas order dataframe by index of other dataframe
Python
1 vote121 views1 answer
Append array to array python
Python
0 vote163 views1 answer
Series astype
Python
23 votes165 views4 answers
Rename row pandas
Python
2 votes163 views1 answer
Random date python
Python
0 vote165 views3 answers
Flask models
Python
0 vote155 views1 answer
Image loader RGB transform
Python
15 votes151 views3 answers
Get the current year in python
Python
42 votes165 views3 answers
Python3 main.py
Python