/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 vote178 views1 answer
Django print settings
Python Django
0 vote202 views1 answer
How to add space in st.write streamlit
Python
1 vote151 views1 answer
How to multiply in django template
Python
0 vote157 views1 answer
Hidden semi markov model python from scratch
Python
0 vote146 views1 answer
Selenium save webpage as pdf python
Python
5 votes147 views3 answers
How to print hello in python
Python
1 vote202 views1 answer
All subarrays of an array python
Python
0 vote207 views1 answer
Exception Type: AssertionError Exception Value: Expected a `Response`, `HttpResponse` or `HttpStreamingResponse` to be returned from the view, but received a `<class 'django.db.models.query.QuerySet'>`
Python Django
0 vote173 views1 answer
Flask send email gmail
Python
0 vote172 views1 answer
How to read json file from s3 bucket into aws glue job
Python