How to sum rows and columns on a Pandas DataFrame using Python
• 1 minHere 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"])
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"])
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!