本文共 487 字，大约阅读时间需要 1 分钟。

import pandas as pdimport numpy as npfrom sqlalchemy import create_engineengine = create_engine("mysql+pymysql://root:admin@localhost:3306/pd_tosql?charset=utf8")formlist = pd.read_sql_query('show tables',con =engine)detail = pd.read_sql_table('goods_list2',con = engine)print(detail)print('-------------------------------------------------')detail_pivot2 = pd.pivot_table(detail,index='id',columns='age',aggfunc=np.sum)print(detail_pivot2)

 下图说明，以3,9确定了一行，count和amounts对应的数字分别为8,5,。

之后同理

转载地址：http://edwsi.baihongyu.com/