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:
data["Revenue"].sum()
11074400.0
data["Revenue"].mean()
1006763.6363636364
data["Revenue"].count()
11
data["Revenue"].max()
2161200.0
data["Revenue"].min()
459600.0
len(data)
11
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