Tutorials References Exercises Videos Menu
Create Website Get Certified Upgrade

Pandas DataFrame count() Method

❮ DataFrame Reference


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