How to sum rows and columns on a Pandas DataFrame using Python
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
Here are ways to sum DataFrame rows & columns using native Pandas methods.
Sum of columns - method 1
Sum of columns - method 2
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
Related Articles
Continue your learning journey with these related topics
Getting Started
3 min readHow long does it take to learn Python for Data Science in 2023
Learn how long it takes to learn Python for Data Science in 2021.
What does it take to be a Data Scientist in 2021?
4/18/2023Read More
DataFrame
1 min readHow to merge two time-series DataFrames with different time intervals
Learn how to merge time-series DataFrames with different frequencies in Pandas using the resample and merge/concat methods.
4/8/2023Read More
Finance
2 min readHow to do Financial Analysis with Pandas using Python
Learn how to use yfinance, a Python library to fetch financial market data such as stock prices, dividends, financial statements, options, and sustainability data for a company or index. With yfinance, you can easily retrieve and analyze financial data for informed decision-making.
4/6/2023Read More
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