#-*- coding: utf-8 -*-#餐饮销量数据统计量分析from __future__ import print_functionimport pandas as pdcatering_sale = '../data/catering_sale.xls' #餐饮数据data = pd.read_excel(catering_sale, index_col = u'日期') #读取数据,指定“日期”列为索引列data = data[(data[u'销量'] > 400)&(data[u'销量'] < 5000)] #过滤异常数据statistics = data.describe() #保存基本统计量statistics.loc['range'] = statistics.loc['max']-statistics.loc['min'] #极差statistics.loc['var'] = statistics.loc['std']/statistics.loc['mean'] #变异系数statistics.loc['dis'] = statistics.loc['75%']-statistics.loc['25%'] #四分位数间距print(statistics)D:\Download\python3\python3.exe "E:/A正在学习/python data dig/chapter3/demo/code/3-2_statistics_analyze.py" 销量count 195.000000mean 2744.595385std 424.739407min 865.00000025% 2460.60000050% 2655.90000075% 3023.200000max 4065.200000range 3200.200000var 0.154755dis 562.600000Process finished with exit code 0