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 |
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' |
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.
