Pandas Excel: Find the sum, mean, max, min value of given column

Last update on December 21 2024 07:52:40 (UTC/GMT +8 hours)

Write a Pandas program to find the sum, mean, max, min value of 'Production (short tons)' column of coalpublic2013.xlsx file. Go to Excel data

Sample Solution:

Python Code :

import pandas as pd
import numpy as np
df = pd.read_excel('E:\coalpublic2013.xlsx')
print("Sum: ",df["Production"].sum()) 
print("Mean: ",df["Production"].mean())
print("Maximum: ",df["Production"].max())
print("Minimum: ",df["Production"].min()) 

Sample Output:

Sum:  27854323
Mean:  557086.46
Maximum:  7602722
Minimum:  0	                                       

Excel Data:

coalpublic2013.xlsx:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a Pandas program to read specific columns from a given excel file.
Next: Write a Pandas program to insert a column in the sixth position of the said excel sheet and fill it with NaN values.