Pandas DataFrame count() Method

Example

Count the number of (not NULL) values in each row:

import pandas as pd

data = {
"Duration": [50, 40, None, None, 90, 20],
"Pulse": [109, 140, 110, 125, 138, 170]
}

df = pd.DataFrame(data)

print(df.count())

Try it Yourself »

Definition and Usage

The count() method counts the number of not empty values for each row, or column if you specify the axis parameter as axis='columns', and returns a Series object with the result for each row (or column).

Syntax

dataframe.count(axis, level, numeric_only)

Parameters

The axis, level, numeric_only parameters are keyword arguments.

Parameter	Value	Description
axis	`0 1 'index' 'columns'`	Optional, Which axis to check, default 0.
level	Number level name	Optional, Specifies which level ( in a hierarchical multi index) to count along
numeric_only	`'True' 'False'`	Optional, Default False, set to true if the count method should only count numeric values

Return Value

A Series object with the count result for each row/column.

If the level argument is specified, this method will return a DataFrame object.

This function does NOT make changes to the original DataFrame object.

❮ DataFrame Reference