/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

1 vote141 views1 answer
Pythn programme for adding user unputs
Python
108 votes149 views6 answers
Dataframe sort by column
Python
0 vote135 views1 answer
Install models python
Python
0 vote132 views1 answer
Rickroll
Python
1 vote161 views2 answers
Python loop invalid input
Python
0 vote166 views1 answer
Check if key exists in sesson python flask
Python
0 vote130 views1 answer
Read_table python
Python
2 votes140 views1 answer
How to represent equation in Pytho
Python
8 votes219 views2 answers
Python inner join based on two columns
Python
0 vote127 views1 answer
Python turn list of strings into list of doubles
Python