Analýza futbalových hráčov — Top 5 líg
Livia
2026-03-12
1. Import údajov
| X | name | full_name | age | height | nationality | place_of_birth | price | max_price | position | shirt_nr | foot | club | contract_expires | joined_club | player_agent | outfitter | league |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Ederson | NA | 29 | 1.88 | Brazil Portugal | Osasco (SP) | 45.00 | 70 | Goalkeeper | 31 | left | Man City | 2026-06-30 | 2017-07-01 | Gestifute | Puma | EPL |
| 1 | Stefan Ortega | Stefan Ortega Moreno | 30 | 1.85 | Germany Spain | Hofgeismar | 6.00 | 6 | Goalkeeper | 18 | right | Man City | 2025-06-30 | 2022-07-01 | neblung … | NA | EPL |
| 2 | Scott Carson | Scott Paul Carson | 37 | 1.88 | England | Whitehaven | 0.25 | 6 | Goalkeeper | 33 | right | Man City | 2023-06-30 | 2021-07-20 | Wasserman | Puma | EPL |
| 3 | Rúben Dias | Rúben Santos Gato Alves Dias | 26 | 1.87 | Portugal | Amadora | 75.00 | 75 | Defender - Centre-Back | 3 | right | Man City | 2027-06-30 | 2020-09-29 | Gestifute | Nike | EPL |
| 4 | Nathan Aké | Nathan Benjamin Aké | 28 | 1.80 | Netherlands Cote d’Ivoire | Den Haag | 35.00 | 40 | Defender - Centre-Back | 6 | left | Man City | 2025-06-30 | 2020-08-05 | Wasserman | Nike | EPL |
| 5 | John Stones | NA | 28 | 1.88 | England | Barnsley | 30.00 | 60 | Defender - Centre-Back | 5 | right | Man City | 2026-06-30 | 2016-08-09 | Wasserman | Nike | EPL |
| 6 | Aymeric Laporte | Aymeric Jean Louis Gerard Alphonse Laporte | 28 | 1.89 | Spain France | Agen | 30.00 | 75 | Defender - Centre-Back | 14 | left | Man City | 2025-06-30 | 2018-01-30 | NA | adidas | EPL |
| 7 | Manuel Akanji | Manuel Obafemi Akanji | 27 | 1.88 | Switzerland Nigeria | Wiesendangen | 30.00 | 40 | Defender - Centre-Back | 25 | right | Man City | 2027-06-30 | 2022-09-01 | IFM | Nike | EPL |
| 8 | Sergio Gómez | Sergio Gómez Martín | 22 | 1.71 | Spain | Badalona | 15.00 | 15 | Defender - Left-Back | 21 | left | Man City | 2026-06-30 | 2022-08-16 | SEG | NA | EPL |
| 9 | Benjamin Mendy | NA | 28 | 1.85 | France Senegal | Longjumeau | NA | 45 | Defender - Left-Back | 22 | left | Man City | 2023-06-30 | 2017-07-24 | Sport Cover | adidas | EPL |
2. Počet chýbajúcich hodnôt pred imputáciou
| Premenna | Pocet_NA |
|---|---|
| X | 0 |
| name | 0 |
| full_name | 1132 |
| age | 0 |
| height | 11 |
| nationality | 0 |
| place_of_birth | 17 |
| price | 10 |
| max_price | 6 |
| position | 0 |
| shirt_nr | 0 |
| foot | 36 |
| club | 0 |
| contract_expires | 68 |
| joined_club | 0 |
| player_agent | 259 |
| outfitter | 1609 |
| league | 0 |
3. Vizualizácia chýbajúcich údajov
Vzor chýbajúcich údajov
Agregovaný prehľad chýbajúcich hodnôt
4. Imputácia chýbajúcich číselných údajov
| X | name | full_name | age | height | nationality | place_of_birth | price | max_price | position | shirt_nr | foot | club | contract_expires | joined_club | player_agent | outfitter | league |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Ederson | NA | 29 | 1.88 | Brazil Portugal | Osasco (SP) | 45.00 | 70 | Goalkeeper | 31 | left | Man City | 2026-06-30 | 2017-07-01 | Gestifute | Puma | EPL |
| 1 | Stefan Ortega | Stefan Ortega Moreno | 30 | 1.85 | Germany Spain | Hofgeismar | 6.00 | 6 | Goalkeeper | 18 | right | Man City | 2025-06-30 | 2022-07-01 | neblung … | NA | EPL |
| 2 | Scott Carson | Scott Paul Carson | 37 | 1.88 | England | Whitehaven | 0.25 | 6 | Goalkeeper | 33 | right | Man City | 2023-06-30 | 2021-07-20 | Wasserman | Puma | EPL |
| 3 | Rúben Dias | Rúben Santos Gato Alves Dias | 26 | 1.87 | Portugal | Amadora | 75.00 | 75 | Defender - Centre-Back | 3 | right | Man City | 2027-06-30 | 2020-09-29 | Gestifute | Nike | EPL |
| 4 | Nathan Aké | Nathan Benjamin Aké | 28 | 1.80 | Netherlands Cote d’Ivoire | Den Haag | 35.00 | 40 | Defender - Centre-Back | 6 | left | Man City | 2025-06-30 | 2020-08-05 | Wasserman | Nike | EPL |
| 5 | John Stones | NA | 28 | 1.88 | England | Barnsley | 30.00 | 60 | Defender - Centre-Back | 5 | right | Man City | 2026-06-30 | 2016-08-09 | Wasserman | Nike | EPL |
| 6 | Aymeric Laporte | Aymeric Jean Louis Gerard Alphonse Laporte | 28 | 1.89 | Spain France | Agen | 30.00 | 75 | Defender - Centre-Back | 14 | left | Man City | 2025-06-30 | 2018-01-30 | NA | adidas | EPL |
| 7 | Manuel Akanji | Manuel Obafemi Akanji | 27 | 1.88 | Switzerland Nigeria | Wiesendangen | 30.00 | 40 | Defender - Centre-Back | 25 | right | Man City | 2027-06-30 | 2022-09-01 | IFM | Nike | EPL |
| 8 | Sergio Gómez | Sergio Gómez Martín | 22 | 1.71 | Spain | Badalona | 15.00 | 15 | Defender - Left-Back | 21 | left | Man City | 2026-06-30 | 2022-08-16 | SEG | NA | EPL |
| 9 | Benjamin Mendy | NA | 28 | 1.85 | France Senegal | Longjumeau | 25.00 | 45 | Defender - Left-Back | 22 | left | Man City | 2023-06-30 | 2017-07-24 | Sport Cover | adidas | EPL |
5. Overenie po imputácii
| Premenna | Pocet_NA_po |
|---|---|
| X | 0 |
| name | 0 |
| full_name | 1132 |
| age | 0 |
| height | 0 |
| nationality | 0 |
| place_of_birth | 17 |
| price | 0 |
| max_price | 0 |
| position | 0 |
| shirt_nr | 0 |
| foot | 36 |
| club | 0 |
| contract_expires | 68 |
| joined_club | 0 |
| player_agent | 259 |
| outfitter | 1609 |
| league | 0 |
6. Základné štatistiky hráčov
| league | Pocet | Priemer | SD | Min | Q25 | Median | Q75 | Max |
|---|---|---|---|---|---|---|---|---|
| Bundesliga | 499 | 8.70 | 14.75 | 0.03 | 1.5 | 3.5 | 9 | 120 |
| EPL | 449 | 21.15 | 20.66 | 0.20 | 7.0 | 15.0 | 28 | 170 |
| LaLiga | 481 | 9.91 | 15.16 | 0.10 | 2.0 | 4.0 | 10 | 120 |
| Ligue1 | 430 | 8.02 | 13.29 | 0.10 | 1.5 | 4.0 | 9 | 180 |
| Other | 398 | 5.82 | 9.98 | 0.05 | 0.8 | 2.2 | 6 | 100 |
| SerieA | 355 | 9.73 | 12.86 | 0.03 | 2.0 | 5.0 | 12 | 80 |
| position | Pocet | Priem_vek | Priem_vyska | Priem_cena |
|---|---|---|---|---|
| Attack - Second Striker | 16 | 27.1 | 1.79 | 20.39 |
| Attack - Left Winger | 162 | 25.3 | 1.78 | 16.77 |
| midfield - Attacking Midfield | 168 | 24.8 | 1.79 | 13.85 |
| Attack - Right Winger | 153 | 25.7 | 1.77 | 13.48 |
| midfield - Defensive Midfield | 199 | 26.2 | 1.83 | 12.17 |
| midfield - Central Midfield | 331 | 25.7 | 1.81 | 11.76 |
| Attack - Centre-Forward | 324 | 26.6 | 1.85 | 11.75 |
| Defender - Centre-Back | 468 | 26.4 | 1.88 | 10.56 |
| Defender - Left-Back | 209 | 26.0 | 1.79 | 8.74 |
| Defender - Right-Back | 230 | 26.3 | 1.80 | 7.98 |
| midfield - Left Midfield | 16 | 26.8 | 1.80 | 7.95 |
| midfield - Right Midfield | 20 | 27.3 | 1.78 | 5.58 |
| Goalkeeper | 315 | 28.1 | 1.90 | 4.51 |
| midfield | 1 | 20.0 | 1.81 | 3.00 |
7. Grafy
Scatter plot
Závislosť ceny od výšky — hráči EPL
Boxplot
Trhová cena hráčov podľa ligy
Scatter plot — vek vs cena
Závislosť ceny od veku
Preferovaná noha
Počet hráčov podľa nožnej preferencie
Rozdelenie veku
Rozdelenie veku hráčov podľa ligy
8. Testovanie hypotéz
t-test: Porovnanie priemernej ceny hráčov EPL vs LaLiga
| Test | t_hodnota | df | p_hodnota | Priem_EPL | Priem_LaLiga | |
|---|---|---|---|---|---|---|
| t | Welch Two Sample t-test | 9.406 | 818.54 | 0 | 21.15 | 9.91 |
ANOVA: Porovnanie ceny naprieč ligami
| Df | Sum Sq | Mean Sq | F value | Pr(>F) | |
|---|---|---|---|---|---|
| league | 5 | 64203.5 | 12840.700 | 57.3235 | 0 |
| Residuals | 2606 | 583754.3 | 224.004 | NA | NA |
Lineárna regresia: Predikcia ceny hráča
| Premenna | Estimate | Std. Error | t value | Pr(>|t|) | |
|---|---|---|---|---|---|
| (Intercept) | (Intercept) | 43.4652 | 8.4338 | 5.1537 | 0.0000 |
| age | age | -0.4059 | 0.0659 | -6.1612 | 0.0000 |
| height | height | -12.0894 | 4.5496 | -2.6572 | 0.0079 |