Skip to main content
 首页 » 编程设计

python之Pandas:将列标题旋转到行标签

2024年12月31日12telwanggs

我使用以下方法从网站中提取数据:

import pandas as pd   
import matplotlib.pyplot as plt 
 
stat_dict={'Disposals' : 0, 
           'Kicks' : 1, 
           'Marks' : 2, 
           'Handballs' : 3, 
           'Goals' : 4, 
           'Behinds' : 5, 
           'Hitouts' : 6, 
           'Tackles' : 7, 
           'Rebounds' : 8, 
           'Inside50s' : 9, 
           'Clearances': 9, 
           'Clangers' : 10, 
           'FreesFor' : 11, 
           'FreesAgainst' : 12, 
           'ContestedPosessions' : 13, 
           'UncontestedPosesseions' : 14, 
           'ContestedMarks' : 15, 
           'MarksInside50' : 16, 
           'OnePercenters' : 17, 
           'Bounces' : 18, 
           'GoalAssists' : 19, 
           'Timeplayed' : 20} 
 
team_lower_case='fremantle' 
player1="Fyfe, Nat" 
stat_required='Disposals' 
rounds=8 
 
 
 
tables = pd.read_html("https://afltables.com/afl/stats/teams/" +str(team_lower_case)+"/2018_gbg.html") 
 
for df in tables: 
    df.drop(df.columns[rounds+1:], axis=1, inplace=True)   # remove unwanted columns 
    df.columns = df.columns.droplevel(0)    # remove extra index level 
 
 
stat_table=tables[stat_dict[stat_required]] 
 
player_stat=stat_table[stat_table["Player"]==player1] 

产生以下内容:

      Player    R1    R2    R3    R4    R5    R6    R7    R8 
8  Fyfe, Nat  22.0  29.0  38.0  25.0  43.0  27.0  33.0  36.0 

如何为“播放器”列中的数据设置索引?

如何将列标题旋转为行标签,反之亦然? 我正在寻找的输出如下:

 Round  Fyfe, Nat  Neale,Lachie 
    R1        22             37 
    R2        29             28 

我想得到的最终输出是一个散点图,它在 x 轴上绘制列标题,例如R1、R2 等...以及 y 轴上的行数据。

我觉得我应该能够直接绘制数据框,但我成功的唯一方法是执行以下操作:

for round, disp in player_stat.iterrows(): 
    player1_list=[] 
    player1_list.append(disp) 
 
plt.style.use('ggplot') 
plt.scatter(range(1,rounds+1), player1_list, label=player1) 
plt.legend(loc="lower right") 
plt.title("Disposals per round") 
plt.xlabel("Rounds") 
plt.ylabel("Disposals") 
plt.ylim(ymin=0) 

看来我应该使用 .transpose,它接近我想要的并输出以下内容:

                8 
Player  Fyfe, Nat 
R1             22 
R2             29 
R3             38 
R4             25 
R5             43 
R6             27 
R7             33 
R8             36 

请您参考如下方法:

使用set_index通过 T 转置:

stat_table=tables[stat_dict[stat_required]].set_index('Player').T 

print (stat_table) 
Player  Ballantyne, Hayden  Banfield, Bailey  Blakely, Connor  \ 
R1                    10.0              12.0             17.0    
R2                    11.0              14.0             30.0    
R3                    18.0              11.0             21.0    
R4                     9.0              17.0             16.0    
R5                    14.0              18.0             23.0    
R6                     6.0              14.0             31.0    
R7                    14.0              20.0             21.0    
R8                    11.0              12.0             35.0    
 
Player  Brayshaw, Andrew  Cerra, Adam  Cox, Brennan  Crowden, Mitch  \ 
R1                  12.0          NaN           NaN             NaN    
R2                  16.0          9.0           NaN            11.0    
R3                   7.0         10.0           NaN            13.0    
R4                  11.0          7.0           NaN            15.0    
R5                  17.0         15.0           NaN            17.0    
R6                  14.0         11.0           NaN            11.0    
R7                  14.0         18.0           8.0             8.0    
R8                  16.0         14.0          12.0            10.0    
 
Player  Duman, Taylin  Fyfe, Nat  Hamling, Joel   ...    Pearce, Danyle  \ 
R1                NaN       22.0            NaN   ...              12.0    
R2                NaN       29.0           12.0   ...               NaN    
R3                NaN       38.0           11.0   ...               NaN    
R4                NaN       25.0           16.0   ...               NaN    
R5               15.0       43.0           11.0   ...               NaN    
R6               12.0       27.0            9.0   ...               NaN    
R7                8.0       33.0           12.0   ...               NaN    
R8               15.0       36.0           18.0   ...              18.0    
 
Player  Ryan, Luke  Sandilands, Aaron  Sheridan, Tom  Sutcliffe, Cameron  \ 
R1            16.0               16.0            NaN                17.0    
R2            22.0               10.0            NaN                 NaN    
R3            21.0               14.0           14.0                 NaN    
R4            14.0               15.0           11.0                 NaN    
R5            21.0                9.0            NaN                 NaN    
R6            18.0               10.0            NaN                 NaN    
R7            13.0               11.0            NaN                 NaN    
R8            27.0               13.0            NaN                 NaN    
 
Player  Taberner, Matthew  Tucker, Darcy  Walters, Michael  Wilson, Nathan  \ 
R1                   20.0           12.0              18.0            15.0    
R2                   16.0            NaN              26.0            23.0    
R3                   18.0            NaN              23.0            18.0    
R4                   19.0           15.0              21.0            14.0    
R5                    6.0           17.0              18.0            27.0    
R6                    NaN           17.0               2.0            15.0    
R7                    NaN           15.0               NaN            19.0    
R8                    NaN           13.0               NaN             NaN    
 
Player  Totals   
R1       358.0   
R2       399.0   
R3       387.0   
R4       362.0   
R5       407.0   
R6       356.0   
R7       346.0   
R8       404.0   
 
[8 rows x 32 columns] 

然后可以通过 player1 选择列:

player_stat=stat_table[player1] 
print (player_stat) 
R1    22.0 
R2    29.0 
R3    38.0 
R4    25.0 
R5    43.0 
R6    27.0 
R7    33.0 
R8    36.0 
Name: Fyfe, Nat, dtype: float64 

最后一个情节:

plt.scatter((range(1,rounds+1)), stat_table[player1])