How can I count the occurrences of True and False values in a column using Pandas?

How can I count the occurrences of True and False values in a column using Pandas?

Pandas is a popular Python library used for data analysis. It offers a variety of functions to efficiently manipulate and analyze data, including the ability to count the occurrences of True and False values in a column. To do so, one can use the “value_counts()” function, which calculates the frequency of unique values in a column and returns a Series object. By passing the parameter “dropna=False”, the function will also include the counts of missing values, if any. This simple and straightforward approach allows users to easily keep track of the number of True and False values in a given column, providing valuable insights for their data analysis.

Pandas: Count Occurrences of True and False in a Column


You can use the following basic syntax to count the occurrences of True and False values in a column of a pandas DataFrame:

df['my_boolean_column'].value_counts()

This will count the occurrences of both True and False values.

If you only want to count one of the specific values, you can use the following syntax:

#count occurrences of True
df['my_boolean_column'].values.sum()

#count occurrences of False
(~df['my_boolean_column']).values.sum()

The following example shows how to use this syntax in practice.

Example: Count Occurrences of True and False in Pandas

Suppose we have the following pandas DataFrame that contains information about various basketball players:

import pandas as pd

#create DataFrame
df = pd.DataFrame({'team': ['A', 'A', 'A', 'B', 'B', 'C', 'C'],
                   'points': [18, 22, 19, 14, 14, 28, 20],
                   'all_star': [True, False, False, True, False, True, True]})

#view DataFrame
print(df)

  team  points  all_star
0    A      18      True
1    A      22     False
2    A      19     False
3    B      14      True
4    B      14     False
5    C      28      True
6    C      20      True

We can use the value_counts() function to count the occurrences of both True and False values in the all_star column:

#count occurrences of True and False in all_star column
df['all_star'].value_counts()

True     4
False    3
Name: all_star, dtype: int64

From the output we can see:

  • The value True occurs 4 times in the all_star column.
  • The value False occurs 3 times in the all_star column.

You can also use the following syntax to only count the occurrences of True:

#count occurrences of True in all_star column
df['all_star'].values.sum()

4

And you can use the following syntax to only count the occurrences of False:

#count occurrences of False in all_star column
(~df['all_star']).values.sum()

3

The following tutorials explain how to perform other common tasks in pandas:

Cite this article

stats writer (2024). How can I count the occurrences of True and False values in a column using Pandas?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-count-the-occurrences-of-true-and-false-values-in-a-column-using-pandas/

stats writer. "How can I count the occurrences of True and False values in a column using Pandas?." PSYCHOLOGICAL SCALES, 26 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-count-the-occurrences-of-true-and-false-values-in-a-column-using-pandas/.

stats writer. "How can I count the occurrences of True and False values in a column using Pandas?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-count-the-occurrences-of-true-and-false-values-in-a-column-using-pandas/.

stats writer (2024) 'How can I count the occurrences of True and False values in a column using Pandas?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-count-the-occurrences-of-true-and-false-values-in-a-column-using-pandas/.

[1] stats writer, "How can I count the occurrences of True and False values in a column using Pandas?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.

stats writer. How can I count the occurrences of True and False values in a column using Pandas?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.

Download Post (.PDF)
Slide Up
x
PDF
Scroll to Top