创建多列数据透视表 – Python Pandas
我们可以创建一个具有多列的数据透视表。要创建数据透视表，请使用pandas.pivot_table将电子表格样式的数据透视表创建为DataFrame。
首先，导入所需的库-
import pandas as pd
使用团队记录创建一个DataFrame-
dataFrame = pd.DataFrame({'Team ID': {0: 5, 1: 9, 2: 6, 3: 11, 4: 2, 5: 7 },'Team Name': {0: 'India', 1: 'Australia', 2: 'Bangladesh', 3: 'South Africa', 4: 'Sri Lanka', 5: 'England'},'Team Points': {0: 95, 1: 93, 2: 42, 3: 60, 4: 80, 5: 55},'Team Rank': {0: 'One', 1: 'Two', 2: 'Six', 3: 'Four', 4: 'Three', 5: 'Five'}})创建具有多列的数据透视表。我们设置了超过两列-
pd.pivot_table(dataFrame, index = ["Team ID", "Team Name", "Team Rank"])
示例
以下是代码-
import pandas as pd
#createDataFramewithTeamrecords
dataFrame = pd.DataFrame({'Team ID': {0: 5, 1: 9, 2: 6, 3: 11, 4: 2, 5: 7 },'Team Name': {0: 'India', 1: 'Australia', 2: 'Bangladesh', 3: 'South Africa', 4: 'Sri Lanka', 5: 'England'},'Team Points': {0: 95, 1: 93, 2: 42, 3: 60, 4: 80, 5: 55},'Team Rank': {0: 'One', 1: 'Two', 2: 'Six', 3: 'Four', 4: 'Three', 5: 'Five'}})
print("\n... Pivot ...")
#multiplecolumns
print(pd.pivot_table(dataFrame, index = ["Team ID", "Team Name", "Team Rank"]))输出结果这将产生以下输出-
... Pivot ...
Team Points
Team ID Team Name Team Rank
2 Sri Lanka Three 80
5 India One 95
6 Bangladesh Six 42
7 England Five 55
9 Australia Two 93
11 South Africa Four 60热门推荐
1 训练狗狗憋尿
2 狗狗追踪训练
3 狗狗训练要多少钱
5 深圳狗狗训练
6 训练狗狗唤回
7 狗狗叫怎么训练
8 狗狗训练班
10 狗狗社会化训练
11 狗狗叫回训练
12 广州狗狗训练学校
13 狗狗训练躺下
14 狗狗随行训练
15 训练狗狗巡回
16 狗狗要怎么训练
17 狗狗喂食训练
18 训练狗狗躺下