How to sum rows and columns on a Pandas DataFrame using Python

1 min readDataFramePandasRowsColumnsMath
7-Day Challenge

Land Your First Data Science Job

A proven roadmap to prepare for $75K+ entry-level data roles. Perfect for Data Scientist ready to level up their career.

Build portfolios that hiring managers love
Master the Python and SQL essentials to be industry-ready
Practice with real interview questions from tech companies
Access to the $100k/y Data Scientist Cheatsheet

Join thousands of developers who transformed their careers through our challenge. Unsubscribe anytime.

Here are ways to sum DataFrame rows & columns using native Pandas methods.

Sum of columns - method 1

# to work with dataframe
import pandas as pd

# We create our sample dataset with negative covariance
df = pd.DataFrame({"col1": range(10),
                   "col2": range(10)})

# Summing two columns
df["sum"] = df["col1"] + df["col2"]

# We check
print(df["sum"])
When you want specific columns

Sum of columns - method 2

# to work with dataframe
import pandas as pd

# We create our sample dataset with negative covariance
df = pd.DataFrame({"col1": range(10),
                   "col2": range(10)})

# Summing all columns using the dataframe method
df["sum"] = df.sum(axis=1)

# We check
print(df["sum"])
When you want specific columns

Sum of rows

# to work with dataframe
import pandas as pd

# We create our sample dataset with negative covariance
df = pd.DataFrame({"col1": range(10),
                   "col2": range(10)})

# Summing all rows per columns using the dataframe method .sum()
print(df.sum(axis=0))

Here you are! You are now an expert at summing columns and rows!

7-Day Challenge

Land Your First Data Science Job

A proven roadmap to prepare for $75K+ entry-level data roles. Perfect for Data Scientist ready to level up their career.

Build portfolios that hiring managers love
Master the Python and SQL essentials to be industry-ready
Practice with real interview questions from tech companies
Access to the $100k/y Data Scientist Cheatsheet

Join thousands of developers who transformed their careers through our challenge. Unsubscribe anytime.

Free Newsletter

Master Data Science in Days, Not Months 🚀

Skip the theoretical rabbit holes. Get practical data science skills delivered in bite-sized lessons – Approach used by real data scientist. Not bookworms. 📚

Weekly simple and practical lessons
Access to ready to use code examples
Skip the math, focus on results
Learn while drinking your coffee

By subscribing, you agree to receive our newsletter. You can unsubscribe at any time.