import pandas as pd
import numpy as np
from sqlalchemy import create_engine
engine = 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,。
之后同理