使用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"])

示例

以下是代码 –

import pandas as pd

#创建数据帧
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 ("DataFrame... \n", dataFrame)

print("\n... Pivot ...")
print(pd.pivot_table(dataFrame, index = ["Team ID"]))

输出

这将产生以下输出 –

DataFrame...
   Team ID     Team Name   Team Points   Team Rank
0        5         India            95         One
1        9      Australia            93       Two
2        6     Bangladesh            42       Six
3       11  South Africa            60      Four
4        2      Sri Lanka            80     Three
5        7        England            55      Five

... Pivot ...
          Team Points
Team ID
2                  80
5                  95
6                  42
7                  55
9                  93
11                 60