创建多列数据透视表 – 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热门推荐
10 朋友新年祝福语大全 简短
11 新年祝福语简短大方兔年
12 搬新家礼物祝福语简短
13 同学见面花束祝福语简短
14 五一假期祝福语幽默简短
15 离职欢送敬酒祝福语简短
16 对学弟的祝福语简短
17 考老师辞职祝福语简短
18 祝福语驱散霉运的话简短