상세 컨텐츠

본문 제목

데이터분석(4)_ 데이터프레임 활용하기

카테고리 없음

by teminam 2023. 5. 24. 14:22

본문

 

# https://www.koreabaseball.com/Record/Player/HitterDetail/Daily.aspx?playerId=53827
url = 'https://www.koreabaseball.com/Record/Player/HitterDetail/Daily.aspx?playerId=53827'
df = pd.read_html(url, index_col=0)
df  # 하나의 리스트로 묶여 있음
 
[        상대   AVG1   PA  AB   R   H  2B  3B  HR  RBI  SB  CS  BB  HBP  SO  GDP  \
 4월                                                                              
 04.01  KIA  0.500    4   2   2   1   0   0   0    0   0   0   2    0   0    0   
 04.02  KIA  0.000    5   5   0   0   0   0   0    0   0   0   0    0   2    0   
 04.04   롯데  0.333    4   3   1   1   0   0   0    0   1   0   1    0   1    0   
 04.07   한화  0.500    5   4   2   2   0   0   1    3   0   1   0    0   0    0   
 04.08   한화  0.333    6   6   1   2   1   0   0    0   0   0   0    0   1    0   
 04.09   한화  0.500    4   4   1   2   0   0   0    1   1   0   0    0   0    0   
 04.11   삼성  0.500    4   4   0   2   0   0   0    0   0   1   0    0   0    0   
 04.12   삼성  0.000    4   2   0   0   0   0   0    0   0   1   2    0   1    0   
 04.13   삼성  0.750    5   4   1   3   1   0   1    4   0   0   1    0   0    1   
 04.14   NC  0.333    3   3   0   1   0   0   0    0   0   0   0    0   1    0   
 04.15   NC  0.000    4   4   0   0   0   0   0    0   0   0   0    0   0    1   
 04.16   NC  0.333    4   3   0   1   0   0   0    0   0   0   1    0   1    0   
 04.18   KT  0.250    4   4   0   1   0   0   0    1   0   0   0    0   1    0   
 04.19   KT  0.667    4   3   0   2   1   0   0    0   0   0   1    0   1    0   
 04.20   KT  0.000    5   5   0   0   0   0   0    0   0   0   0    0   0    0   
 04.21   키움  0.250    4   4   0   1   0   0   0    0   0   0   0    0   0    0   
 04.22   키움  0.750    4   4   1   3   1   0   0    0   0   1   0    0   0    0   
 04.23   키움  0.200    5   5   1   1   0   0   0    1   0   0   0    0   0    0   
 04.25   LG  0.800    5   5   1   4   2   0   0    3   0   0   0    0   0    1   
 04.26   LG  0.200    5   5   1   1   0   0   0    2   0   0   0    0   0    0   
 04.27   LG  0.000    4   4   0   0   0   0   0    0   0   0   0    0   1    1   
 04.28   두산  0.500    4   4   0   2   0   0   0    1   0   0   0    0   1    0   
 04.29   두산  0.250    4   4   0   1   1   0   0    3   1   0   0    0   0    0   
 04.30   두산  0.667    3   3   0   2   0   0   0    0   0   1   0    0   0    0   
 합계      합계  0.351  103  94  12  33   7   0   2   19   3   5   8    0  11    4   
 
         AVG2  
 4월            
 04.01  0.500  
 04.02  0.143  
 04.04  0.200  
 04.07  0.286  
 04.08  0.300  
 04.09  0.333  
 04.11  0.357  
 04.12  0.333  
 04.13  0.382  
 04.14  0.378  
 04.15  0.341  
 04.16  0.341  
 04.18  0.333  
 04.19  0.353  
 04.20  0.321  
 04.21  0.317  
 04.22  0.344  
 04.23  0.333  
 04.25  0.365  
 04.26  0.354  
 04.27  0.337  
 04.28  0.345  
 04.29  0.341  
 04.30  0.351  
 합계     0.351  ,
         상대   AVG1  PA  AB  R   H  2B  3B  HR  RBI  SB  CS  BB  HBP  SO  GDP  \
 5월                                                                            
 05.02   KT  0.500   4   4  0   2   0   0   0    1   0   0   0    0   2    0   
 05.03   KT  0.500   4   4  1   2   0   0   1    3   0   0   0    0   0    0   
 05.04   KT  0.000   4   3  1   0   0   0   0    0   0   0   1    0   1    0   
 05.05   키움  0.667   4   3  0   2   0   0   0    1   0   0   1    0   0    0   
 05.06   키움  0.250   4   4  0   1   0   0   0    0   1   0   0    0   1    1   
 05.07   키움  0.667   6   6  0   4   0   0   0    2   0   0   0    0   0    0   
 05.11  KIA      -   0   0  0   0   0   0   0    0   0   0   0    0   0    0   
 05.12   한화  0.000   4   4  0   0   0   0   0    0   0   0   0    0   2    0   
 05.13   한화  0.250   5   4  0   1   1   0   0    1   0   0   1    0   1    0   
 05.14   한화  0.750   6   4  2   3   0   0   1    1   1   0   1    1   0    0   
 05.16   NC  0.250   5   4  0   1   0   0   0    0   0   0   1    0   0    0   
 05.17   NC  0.000   5   5  0   0   0   0   0    0   0   0   0    0   3    0   
 05.19   롯데  0.500   5   4  1   2   1   0   0    0   0   0   1    0   1    0   
 05.20   롯데  0.000   5   5  0   0   0   0   0    0   0   0   0    0   2    0   
 05.21   롯데  0.400   5   5  1   2   1   0   0    3   0   0   0    0   0    0   
 합계      합계  0.339  66  59  6  20   3   0   2   12   2   0   6    1  13    1   
 
         AVG2  
 5월            
 05.02  0.357  
 05.03  0.363  
 05.04  0.352  
 05.05  0.361  
 05.06  0.357  
 05.07  0.373  
 05.11  0.373  
 05.12  0.361  
 05.13  0.357  
 05.14  0.369  
 05.16  0.366  
 05.17  0.353  
 05.19  0.357  
 05.20  0.345  
 05.21  0.346  
 합계     0.346  ]
 
 

 

 
list