Math Methods on Pandas Series Objects

By Hemanta Sundaray on 2021-08-15

Let's read the budget.xlsx file into a DataFrame:

import pandas as pd

data = pd.read_excel("budget.xlsx", sheet_name="sheet2")

data

Output:

Budget

sum()

data["Revenue"].sum()

11074400.0

mean()

data["Revenue"].mean()

1006763.6363636364

count()

data["Revenue"].count()

11

max()

data["Revenue"].max()

2161200.0

min()

data["Revenue"].min()

459600.0

len

len(data)

11

describe()

data["Revenue"].describe()

count    1.100000e+01
mean     1.006764e+06
std      5.276084e+05
min      4.596000e+05
25%      5.988000e+05
50%      9.024000e+05
75%      1.248000e+06
max      2.161200e+06
Name: Revenue, dtype: float64

Join the Newsletter