How to count the rows with the conditions?-CodePudding

I have a data set something like this:

import pandas as pd
 
# initialize data of lists.
data = {'name':['x', 'y', 'z'],
        'value':['fb', 'nan', 'ti']}
 
# Create DataFrame
df = pd.DataFrame(data)

I now want to check the column of value and count the number of rows if value does not have 'fb' and 'nan' (null values).

How can I do this?

CodePudding user response：

df[~df.value.isin(['fb','nan'])].shape[0]

In this case, we are checking when the value is not in this list and selecting those rows only. From there we can get the shape using shape of that dataframe.

Output

This would be the result dataframe

  name value
2    z    ti

If in future you want to also ignore the rows where the value column is NA (NA values, such as None or numpy.NaN),then you can use this

df[(~df.value.isin(['fb','nan'])) &  (~df.value.isnull())].shape[0]

CodePudding user response：

To count values that are not fb and nan:

(~df.value.str.contains('fb|nan')).sum()

Omit the tilde if you want to count the fb and nan values.

CodePudding user response：

Just make a condition checking for "fb" or NaN, and use sum to get the count of True's:

>>> (df['value'].eq('fb') | df['value'].isna()).sum()
3