Using python3,
how do I make a program to calculate the mean and std dv forevery interval of 10 elements on an excel file?
I understand that you can do this:
import pandas as pd
data_file = ‘path file/ something.xlsx’
myData= pd.read_excel(data_file, sheet_name=0, header=0,index_col=False, keep_default_na=True)
and then you can get the mean and std dv of a particular setin a column like:
print(myData[[‘collumn name’]][10:20].mean())
but I have to do this with a lot of data and really need tomake it more simple and automatic but I don’t know how ;-;
Solution
#PYTHON 3.7.2
# ensure after copying and pasting the code, indenting is sameas that in code snapshot attached
import
OR
OR