Calculating the mean and std on excel file using python

Question

I'm just getting started with Python. In the excel file, there are three columns and roughly 7000–8000 rows. After importing the data into Python, how

import xlrd
file_location = "C:/Users/Roy/Desktop/table.xlsx"
workbook = xlrd.open_workbook(file_location)
sheet=workbook.sheet_by_index(0)

do I calculate the mean and standard deviation for each column?

Answer 1

Use pandas to do this:

import pandas as pd
df = pd.read_excel("C:/Users/Roy/Desktop/table.xlsx")
print(df.mean())
print(df.std())