Pandas DataFrame sum() Method
Example
Return the sum of each column:
import pandas as pd
data = [[10, 18, 11], [13, 15, 8], [9, 20, 3]]
df = pd.DataFrame(data)
print(df.sum())
Try it Yourself »
Definition and Usage
The sum()
method adds all values
in each column and returns the sum for each column.
By specifying the column axis (axis='columns'
), the
sum()
method searches column-wise and returns the sum of each row.
Syntax
dataframe.sum(axis, skipna, level, numeric_only, min_count, kwargs)
Parameters
The axis
,
skipna
, level
, numeric_only
,
min_count
, parameters are
keyword arguments.
Parameter | Value | Description |
---|---|---|
axis | 0 |
Optional, Which axis to check, default 0. |
skip_na | True |
Optional, default True. Set to False if the result should NOT skip NULL values |
level | Number level name |
Optional, default None. Specifies which level ( in a hierarchical multi index) to check along |
numeric_only | None |
Optional. Specifies whether to only check numeric values. Default None |
min_count | None |
Optional. Specifies the minimum number of values that needs to be present to perform the action. Default 0 |
kwargs | Optional, keyword arguments. These arguments has no effect, but could be accepted by a NumPy function |
Return Value
A Series with the sums.
If the level argument is specified, this method will return a DataFrame object.
This function does NOT make changes to the original DataFrame object.