python資料統計量分析

標籤：chapter   utf-8   指定   xls   das   range   read   down   load   

#-*- 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

 

python資料統計量分析