pandas透视表

import pandas as pd
import numpy as np


# 加载数据
detail = pd.read_excel('meal_order_detail.xlsx')
# print(detail)

columns = detail.columns
# print(columns)

data = detail[['order_id', 'dishes_id', 'dishes_name', 'counts', 'amounts']]
# values 用于关心的数据，统计分析数据
# aggfunc -->可以指定统计指标
# fill_value -->可以将空值变为0
res = pd.pivot_table(data, values=['amounts', 'counts'], index='order_id')
print(res)
# res = pd.pivot_table(data, values=['amounts', 'counts'], columns='dishes_name')
# res.to_csv('菜名分组')
# res = pd.pivot_table(data, index='order_id', values=['amounts', 'counts'], columns='dishes_name', fill_value=0, margins=True)
# print(res)