Tutorials References Exercises Sign Up Menu
Create Website Get Certified Pro

Pandas DataFrame sum() Method

❮ DataFrame Reference


Return the sum of each column:

import pandas as pd

data = [[10, 18, 11], [13, 15, 8], [9, 20, 3]]

df = pd.DataFrame(data)

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.


dataframe.sum(axis, skipna, level, numeric_only, min_count, kwargs)


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.

❮ DataFrame Reference