import pandas as pd
import numpy as np
加载数据
data = pd.read_excel("./meal_order_detail.xlsx")
print(‘data:\n’, data)
print(‘data 的列索引:\n’, data.columns)
print(‘data 的数据类型:\n’, data.dtypes)
print(’*’ * 100)
对 amounts 、counts 进行统计指标
print(‘amounts counts 列的最小值:\n’,data.loc[:,[‘amounts’,‘counts’]].min())
print(type(data.loc[:,[‘amounts’,‘counts’]].min())) # <class ‘pandas.core.series.Series’>
#对 amounts 进行统计指标
#print(‘amounts 列 最小值:\n’, data.loc[:, ‘amounts’].min())
#print(‘amounts 列 最大值:\n’, data.loc[:, ‘amounts’].max())
print(‘amounts 列 均值:\n’, data.loc[:, ‘amounts’].mean())
#print(‘amounts 列 方差:\n’, data.loc[:, ‘amounts’].var())
#print(‘amounts 列 标准差:\n’, data.loc[:, ‘amounts’].std())
#print(‘amounts 列 极差:\n’, data.loc[:, ‘amounts’].pt