飲食販売量データ統計量分析
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が必要な場合