2020-04-30
阅读量:
841
pandas建立数据透视表，题目详情见正文。
df表如下：
请将df表汇总转化成下表：
参考代码：
np.random.seed(0)
B = pd.Series(["Allen","Lucy","Tom","Alice","Tim","Lily","Allen","Lucy","Tom","Alice","Tim","Lily"], dtype="string")
C = pd.Series(np.random.randint(20,40,12, dtype="int"))
D = pd.Series(["产品A","产品A","产品A","产品B","产品B","产品B","产品B","产品B","产品B","产品A","产品A","产品A"])
df = pd.DataFrame({'com':D,'name':B, 'sale':C})
df
df1 = pd.pivot(df,index = "com",columns="name",values="sale")
df1代码结果：
0.2622
1
3
关注作者
收藏
评论(0)
发表评论
暂无数据
推荐帖子
anranhui
2020-06-18
2条评论
PhilipLiang
2020-06-18
6条评论
PhilipLiang
2020-06-18
7条评论