飲食販売量データ統計量分析


from __future__ import print_function
import pandas as pd

catering_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)

データ+q:2807613749が必要な場合