shape=(29, 36)

player_name                          object
player_short_name                    object
player_id                             int64
player_birthdate                     object
team_name                            object
team_id                               int64
match_name                           object
match_id                              int64
match_date                           object
competition_name                     object
competition_id                        int64
season_name                          object
season_id                             int64
competition_edition_id                int64
position                             object
position_group                       object
minutes_full_all                    float64
physical_check_passed                  bool
total_distance_full_all             float64
total_metersperminute_full_all      float64
running_distance_full_all           float64
hsr_distance_full_all               float64
hsr_count_full_all                  float64
sprint_distance_full_all            float64
sprint_count_full_all               float64
hi_distance_full_all                float64
hi_count_full_all                   float64
medaccel_count_full_all             float64
highaccel_count_full_all            float64
meddecel_count_full_all             float64
highdecel_count_full_all            float64
explacceltohsr_count_full_all       float64
timetohsr                           float64
explacceltosprint_count_full_all    float64
timetosprint                        float64
psv99                               float64

                                player_name player_short_name  player_id player_birthdate                team_name  team_id                                match_name  match_id  match_date competition_name  competition_id season_name  season_id  competition_edition_id position    position_group  minutes_full_all  physical_check_passed  total_distance_full_all  total_metersperminute_full_all  running_distance_full_all  hsr_distance_full_all  hsr_count_full_all  sprint_distance_full_all  sprint_count_full_all  hi_distance_full_all  hi_count_full_all  medaccel_count_full_all  highaccel_count_full_all  meddecel_count_full_all  highdecel_count_full_all  explacceltohsr_count_full_all  timetohsr  explacceltosprint_count_full_all  timetosprint  psv99
0                      Ander Herrera Agüera     Ander Herrera        688       1989-08-14  Athletic Club de Bilbao      273  Athletic Club de Bilbao v Real Madrid CF   1021404  2023-08-12     ESP - LaLiga               4   2023/2024         28                     546      LDM          Midfield             31.00                   True                   4079.0                          131.58                      755.0                  242.0                21.0                      34.0                    3.0                 276.0               24.0                     38.0                       1.0                     37.0                       3.0                            1.0       0.76                               0.0           NaN   26.1
1                           Antonio Rüdiger        A. Rüdiger        993       1993-03-03           Real Madrid CF      262  Athletic Club de Bilbao v Real Madrid CF   1021404  2023-08-12     ESP - LaLiga               4   2023/2024         28                     546      RCB  Central Defender             45.53                   True                   4761.0                          104.56                      376.0                  152.0                20.0                      78.0                    5.0                 230.0               25.0                     50.0                       2.0                     38.0                       5.0                            2.0       0.88                               2.0          1.45   28.2
2                     Daniel Carvajal Ramos     Dani Carvajal       2189       1992-01-11           Real Madrid CF      262  Athletic Club de Bilbao v Real Madrid CF   1021404  2023-08-12     ESP - LaLiga               4   2023/2024         28                     546       RB         Full Back             99.27                   True                  11016.0                          110.97                     1302.0                  540.0                57.0                     133.0                    9.0                 673.0               66.0                    118.0                       8.0                     90.0                      19.0                            7.0       0.58                               2.0          1.12   28.2
3                    David Olatukunbo Alaba          D. Alaba       2395       1992-06-24           Real Madrid CF      262  Athletic Club de Bilbao v Real Madrid CF   1021404  2023-08-12     ESP - LaLiga               4   2023/2024         28                     546      LCB  Central Defender             99.27                   True                  10511.0                          105.89                     1222.0                  358.0                36.0                     149.0                    6.0                 507.0               42.0                    118.0                       7.0                     98.0                       8.0                            4.0       0.81                               1.0          1.33   28.3
4                         Iker Muniain Goñi      Iker Muniain       4444       1992-12-19  Athletic Club de Bilbao      273  Athletic Club de Bilbao v Real Madrid CF   1021404  2023-08-12     ESP - LaLiga               4   2023/2024         28                     546       LW     Wide Attacker             49.20                   True                   5576.0                          113.33                      773.0                  262.0                30.0                      93.0                    6.0                 355.0               36.0                     72.0                       3.0                     63.0                      12.0                            3.0       0.86                               1.0          1.69   28.5
5                    Iñaki Williams Arthuer    Iñaki Williams       4461       1994-06-15  Athletic Club de Bilbao      273  Athletic Club de Bilbao v Real Madrid CF   1021404  2023-08-12     ESP - LaLiga               4   2023/2024         28                     546       CF    Center Forward             99.27                   True                  10439.0                          105.16                     1557.0                  540.0                71.0                     383.0                   16.0                 923.0               87.0                    125.0                      11.0                     95.0                      30.0                            9.0       0.70                               4.0          1.39   32.5
6                      Íñigo Lekue Martínez       Íñigo Lekue       4463       1993-05-04  Athletic Club de Bilbao      273  Athletic Club de Bilbao v Real Madrid CF   1021404  2023-08-12     ESP - LaLiga               4   2023/2024         28                     546       LB         Full Back             74.52                   True                   8662.0                          116.24                     1249.0                  748.0                58.0                     178.0                   11.0                 926.0               69.0                     97.0                       7.0                     89.0                      18.0                            6.0       0.57                               4.0          1.22   31.5
7                  José Luis Sanmartín Mato            Joselu       5449       1990-03-27           Real Madrid CF      262  Athletic Club de Bilbao v Real Madrid CF   1021404  2023-08-12     ESP - LaLiga               4   2023/2024         28                     546       CF    Center Forward             15.77                   True                   2032.0                          128.88                      335.0                  169.0                15.0                      56.0                    2.0                 225.0               17.0                     18.0                       1.0                     22.0                       0.0                            1.0       0.93                               0.0           NaN   27.7
8                               Luka Modrić         L. Modrić       6462       1985-09-09           Real Madrid CF      262  Athletic Club de Bilbao v Real Madrid CF   1021404  2023-08-12     ESP - LaLiga               4   2023/2024         28                     546       RF     Wide Attacker             15.77                   True                   1841.0                          116.77                      228.0                   61.0                10.0                      34.0                    2.0                  95.0               12.0                     22.0                       1.0                     17.0                       2.0                            1.0       0.93                               1.0          1.62   28.5
9                     Óscar de Marcos Arana   Óscar De Marcos       8259       1989-04-14  Athletic Club de Bilbao      273  Athletic Club de Bilbao v Real Madrid CF   1021404  2023-08-12     ESP - LaLiga               4   2023/2024         28                     546       RB         Full Back             99.27                   True                  11983.0                          120.72                     2147.0                  977.0                94.0                     212.0                   18.0                1189.0              112.0                    153.0                       9.0                    126.0                      30.0                            9.0       0.74                               1.0          2.78   27.5
10                               Toni Kroos          T. Kroos      10520       1990-01-04           Real Madrid CF      262  Athletic Club de Bilbao v Real Madrid CF   1021404  2023-08-12     ESP - LaLiga               4   2023/2024         28                     546       LM          Midfield             24.62                   True                   3103.0                          126.05                      475.0                  120.0                11.0                       2.0                    0.0                 122.0               11.0                     32.0                       1.0                     22.0                       2.0                            1.0       0.73                               0.0           NaN   24.3
11                       Mikel Vesga Arruti       Mikel Vesga      11692       1993-04-08  Athletic Club de Bilbao      273  Athletic Club de Bilbao v Real Madrid CF   1021404  2023-08-12     ESP - LaLiga               4   2023/2024         28                     546      LDM          Midfield             68.27                   True                   8921.0                          130.68                     1718.0                  599.0                48.0                      73.0                    5.0                 672.0               53.0                     97.0                       4.0                     86.0                      11.0                            3.0       0.81                               2.0          1.74   27.6
12                      Aurélien Tchouaméni     A. Tchouaméni      12218       2000-01-27           Real Madrid CF      262  Athletic Club de Bilbao v Real Madrid CF   1021404  2023-08-12     ESP - LaLiga               4   2023/2024         28                     546       DM          Midfield             99.27                   True                  11674.0                          117.60                     1987.0                  628.0                56.0                      66.0                    4.0                 694.0               60.0                    141.0                       9.0                    111.0                      21.0                            5.0       0.74                               0.0           NaN   25.9
13       Federico Santiago Valverde Dipetta       F. Valverde      12251       1998-07-22           Real Madrid CF      262  Athletic Club de Bilbao v Real Madrid CF   1021404  2023-08-12     ESP - LaLiga               4   2023/2024         28                     546       RM          Midfield             99.27                   True                  11098.0                          111.80                     1518.0                  776.0                74.0                     379.0                   19.0                1155.0               93.0                    120.0                       6.0                     83.0                      16.0                            5.0       0.64                               2.0          1.32   31.1
14  Vinícius José Paixão de Oliveira Júnior   Vinícius Júnior      12253       2000-07-12           Real Madrid CF      262  Athletic Club de Bilbao v Real Madrid CF   1021404  2023-08-12     ESP - LaLiga               4   2023/2024         28                     546       CF    Center Forward             83.50                   True                   8893.0                          106.50                     1432.0                  516.0                71.0                     271.0                   18.0                 787.0               89.0                    100.0                      16.0                     89.0                      29.0                           13.0       0.75                               4.0          1.52   29.4
15                     Éder Gabriel Militão      Éder Militão      12662       1998-01-18           Real Madrid CF      262  Athletic Club de Bilbao v Real Madrid CF   1021404  2023-08-12     ESP - LaLiga               4   2023/2024         28                     546      RCB  Central Defender             53.73                   True                   5451.0                          101.45                      543.0                  194.0                24.0                     151.0                    8.0                 345.0               32.0                     63.0                       6.0                     43.0                       5.0                            6.0       0.74                               3.0          1.27   31.8
16                 Gorka Guruzeta Rodríguez    Gorka Guruzeta      13902       1996-09-12  Athletic Club de Bilbao      273  Athletic Club de Bilbao v Real Madrid CF   1021404  2023-08-12     ESP - LaLiga               4   2023/2024         28                     546       CF    Center Forward             50.07                   True                   5960.0                          119.04                     1078.0                  464.0                35.0                      45.0                    5.0                 509.0               40.0                     59.0                       3.0                     53.0                      10.0                            2.0       1.48                               0.0           NaN   25.7
17                     Daniel Vivian Moreno       Dani Vivian      13903       1999-07-05  Athletic Club de Bilbao      273  Athletic Club de Bilbao v Real Madrid CF   1021404  2023-08-12     ESP - LaLiga               4   2023/2024         28                     546      RCB  Central Defender             99.27                   True                  11233.0                          113.16                     1390.0                  589.0                62.0                     208.0                   12.0                 797.0               74.0                    125.0                       5.0                    108.0                      15.0                            5.0       0.88                               2.0          1.92   30.5
18               Alejandro Berenguer Remiro    Álex Berenguer      14102       1995-07-04  Athletic Club de Bilbao      273  Athletic Club de Bilbao v Real Madrid CF   1021404  2023-08-12     ESP - LaLiga               4   2023/2024         28                     546       RW     Wide Attacker             50.07                   True                   5793.0                          115.71                      944.0                  402.0                41.0                     145.0                   10.0                 547.0               51.0                     69.0                       5.0                     55.0                      14.0                            2.0       0.80                               0.0           NaN   30.0
19                        Eduardo Camavinga      E. Camavinga      22103       2002-11-10           Real Madrid CF      262  Athletic Club de Bilbao v Real Madrid CF   1021404  2023-08-12     ESP - LaLiga               4   2023/2024         28                     546       LM          Midfield             74.65                   True                   9022.0                          120.86                     1496.0                  512.0                47.0                      89.0                    4.0                 601.0               51.0                    107.0                       7.0                    104.0                      11.0                            6.0       0.75                               1.0          1.72   29.5
