import numpy as np
import pandas as pd
a = pd.read_excel(r’C:\Users\Administrator\Desktop\考勤表.xlsx’)
print(a)
b = pd.pivot_table(a,values=[‘金额’],index=[‘姓名’,‘时间’],columns=[‘部门’],aggfunc=np.sum,margins=True,fill_value=0)
print(b)
Python : 透视表
最新推荐文章于 2022-03-14 17:05:22 发布