Análise da avaliação dos jogadores
Millena Perrut
22/03/2021
#Introdução
Base de dados
library(readr)
FifaData <- read_csv("FifaData.csv")##
## -- Column specification --------------------------------------------------------
## cols(
## .default = col_double(),
## Name = col_character(),
## Nationality = col_character(),
## National_Position = col_character(),
## Club = col_character(),
## Club_Position = col_character(),
## Club_Joining = col_character(),
## Height = col_character(),
## Weight = col_character(),
## Preffered_Foot = col_character(),
## Birth_Date = col_character(),
## Preffered_Position = col_character(),
## Work_Rate = col_character()
## )
## i Use `spec()` for the full column specifications.View(FifaData)
str(FifaData)## spec_tbl_df [17,588 x 53] (S3: spec_tbl_df/tbl_df/tbl/data.frame)
## $ Name : chr [1:17588] "Cristiano Ronaldo" "Lionel Messi" "Neymar" "Luis Suárez" ...
## $ Nationality : chr [1:17588] "Portugal" "Argentina" "Brazil" "Uruguay" ...
## $ National_Position : chr [1:17588] "LS" "RW" "LW" "LS" ...
## $ National_Kit : num [1:17588] 7 10 10 9 1 1 9 11 NA 1 ...
## $ Club : chr [1:17588] "Real Madrid" "FC Barcelona" "FC Barcelona" "FC Barcelona" ...
## $ Club_Position : chr [1:17588] "LW" "RW" "LW" "ST" ...
## $ Club_Kit : num [1:17588] 7 10 11 9 1 1 9 11 9 13 ...
## $ Club_Joining : chr [1:17588] "07/01/2009" "07/01/2004" "07/01/2013" "07/11/2014" ...
## $ Contract_Expiry : num [1:17588] 2021 2018 2021 2021 2021 ...
## $ Rating : num [1:17588] 94 93 92 92 92 90 90 90 90 89 ...
## $ Height : chr [1:17588] "185 cm" "170 cm" "174 cm" "182 cm" ...
## $ Weight : chr [1:17588] "80 kg" "72 kg" "68 kg" "85 kg" ...
## $ Preffered_Foot : chr [1:17588] "Right" "Left" "Right" "Right" ...
## $ Birth_Date : chr [1:17588] "02/05/1985" "06/24/1987" "02/05/1992" "01/24/1987" ...
## $ Age : num [1:17588] 32 29 25 30 31 26 28 27 35 24 ...
## $ Preffered_Position: chr [1:17588] "LW/ST" "RW" "LW" "ST" ...
## $ Work_Rate : chr [1:17588] "High / Low" "Medium / Medium" "High / Medium" "High / Medium" ...
## $ Weak_foot : num [1:17588] 4 4 5 4 4 3 4 3 4 3 ...
## $ Skill_Moves : num [1:17588] 5 4 5 4 1 1 3 4 4 1 ...
## $ Ball_Control : num [1:17588] 93 95 95 91 48 31 87 88 90 23 ...
## $ Dribbling : num [1:17588] 92 97 96 86 30 13 85 89 87 13 ...
## $ Marking : num [1:17588] 22 13 21 30 10 13 25 51 15 11 ...
## $ Sliding_Tackle : num [1:17588] 23 26 33 38 11 13 19 52 27 16 ...
## $ Standing_Tackle : num [1:17588] 31 28 24 45 10 21 42 55 41 18 ...
## $ Aggression : num [1:17588] 63 48 56 78 29 38 80 65 84 23 ...
## $ Reactions : num [1:17588] 96 95 88 93 85 88 88 87 85 81 ...
## $ Attacking_Position: num [1:17588] 94 93 90 92 12 12 89 86 86 13 ...
## $ Interceptions : num [1:17588] 29 22 36 41 30 30 39 59 20 15 ...
## $ Vision : num [1:17588] 85 90 80 84 70 68 78 79 83 44 ...
## $ Composure : num [1:17588] 86 94 80 83 70 60 87 85 91 52 ...
## $ Crossing : num [1:17588] 84 77 75 77 15 17 62 87 76 14 ...
## $ Short_Pass : num [1:17588] 83 88 81 83 55 31 83 86 84 32 ...
## $ Long_Pass : num [1:17588] 77 87 75 64 59 32 65 80 76 31 ...
## $ Acceleration : num [1:17588] 91 92 93 88 58 56 79 93 69 46 ...
## $ Speed : num [1:17588] 92 87 90 77 61 56 82 95 74 52 ...
## $ Stamina : num [1:17588] 92 74 79 89 44 25 79 78 75 38 ...
## $ Strength : num [1:17588] 80 59 49 76 83 64 84 80 93 70 ...
## $ Balance : num [1:17588] 63 95 82 60 35 43 79 65 41 45 ...
## $ Agility : num [1:17588] 90 90 96 86 52 57 78 77 86 61 ...
## $ Jumping : num [1:17588] 95 68 61 69 78 67 84 85 72 68 ...
## $ Heading : num [1:17588] 85 71 62 77 25 21 85 86 80 13 ...
## $ Shot_Power : num [1:17588] 92 85 78 87 25 31 86 91 93 36 ...
## $ Finishing : num [1:17588] 93 95 89 94 13 13 91 87 90 14 ...
## $ Long_Shots : num [1:17588] 90 88 77 86 16 12 82 90 88 17 ...
## $ Curve : num [1:17588] 81 89 79 86 14 21 77 86 82 19 ...
## $ Freekick_Accuracy : num [1:17588] 76 90 84 84 11 19 76 85 82 11 ...
## $ Penalties : num [1:17588] 85 74 81 85 47 40 81 76 91 27 ...
## $ Volleys : num [1:17588] 88 85 83 88 11 13 86 76 93 12 ...
## $ GK_Positioning : num [1:17588] 14 14 15 33 91 86 8 5 9 86 ...
## $ GK_Diving : num [1:17588] 7 6 9 27 89 88 15 15 13 84 ...
## $ GK_Kicking : num [1:17588] 15 15 15 31 95 87 12 11 10 69 ...
## $ GK_Handling : num [1:17588] 11 11 9 25 90 85 6 15 15 91 ...
## $ GK_Reflexes : num [1:17588] 11 8 11 37 89 90 10 6 12 89 ...
## - attr(*, "spec")=
## .. cols(
## .. Name = col_character(),
## .. Nationality = col_character(),
## .. National_Position = col_character(),
## .. National_Kit = col_double(),
## .. Club = col_character(),
## .. Club_Position = col_character(),
## .. Club_Kit = col_double(),
## .. Club_Joining = col_character(),
## .. Contract_Expiry = col_double(),
## .. Rating = col_double(),
## .. Height = col_character(),
## .. Weight = col_character(),
## .. Preffered_Foot = col_character(),
## .. Birth_Date = col_character(),
## .. Age = col_double(),
## .. Preffered_Position = col_character(),
## .. Work_Rate = col_character(),
## .. Weak_foot = col_double(),
## .. Skill_Moves = col_double(),
## .. Ball_Control = col_double(),
## .. Dribbling = col_double(),
## .. Marking = col_double(),
## .. Sliding_Tackle = col_double(),
## .. Standing_Tackle = col_double(),
## .. Aggression = col_double(),
## .. Reactions = col_double(),
## .. Attacking_Position = col_double(),
## .. Interceptions = col_double(),
## .. Vision = col_double(),
## .. Composure = col_double(),
## .. Crossing = col_double(),
## .. Short_Pass = col_double(),
## .. Long_Pass = col_double(),
## .. Acceleration = col_double(),
## .. Speed = col_double(),
## .. Stamina = col_double(),
## .. Strength = col_double(),
## .. Balance = col_double(),
## .. Agility = col_double(),
## .. Jumping = col_double(),
## .. Heading = col_double(),
## .. Shot_Power = col_double(),
## .. Finishing = col_double(),
## .. Long_Shots = col_double(),
## .. Curve = col_double(),
## .. Freekick_Accuracy = col_double(),
## .. Penalties = col_double(),
## .. Volleys = col_double(),
## .. GK_Positioning = col_double(),
## .. GK_Diving = col_double(),
## .. GK_Kicking = col_double(),
## .. GK_Handling = col_double(),
## .. GK_Reflexes = col_double()
## .. )summary(FifaData)## Name Nationality National_Position National_Kit
## Length:17588 Length:17588 Length:17588 Min. : 1.00
## Class :character Class :character Class :character 1st Qu.: 6.00
## Mode :character Mode :character Mode :character Median :12.00
## Mean :12.22
## 3rd Qu.:18.00
## Max. :36.00
## NA's :16513
## Club Club_Position Club_Kit Club_Joining
## Length:17588 Length:17588 Min. : 1.00 Length:17588
## Class :character Class :character 1st Qu.: 9.00 Class :character
## Mode :character Mode :character Median :18.00 Mode :character
## Mean :21.29
## 3rd Qu.:27.00
## Max. :99.00
## NA's :1
## Contract_Expiry Rating Height Weight
## Min. :2017 Min. :45.00 Length:17588 Length:17588
## 1st Qu.:2017 1st Qu.:62.00 Class :character Class :character
## Median :2019 Median :66.00 Mode :character Mode :character
## Mean :2019 Mean :66.17
## 3rd Qu.:2020 3rd Qu.:71.00
## Max. :2023 Max. :94.00
## NA's :1
## Preffered_Foot Birth_Date Age Preffered_Position
## Length:17588 Length:17588 Min. :17.00 Length:17588
## Class :character Class :character 1st Qu.:22.00 Class :character
## Mode :character Mode :character Median :25.00 Mode :character
## Mean :25.46
## 3rd Qu.:29.00
## Max. :47.00
##
## Work_Rate Weak_foot Skill_Moves Ball_Control
## Length:17588 Min. :1.000 Min. :1.000 Min. : 5.00
## Class :character 1st Qu.:3.000 1st Qu.:2.000 1st Qu.:53.00
## Mode :character Median :3.000 Median :2.000 Median :63.00
## Mean :2.934 Mean :2.303 Mean :57.97
## 3rd Qu.:3.000 3rd Qu.:3.000 3rd Qu.:69.00
## Max. :5.000 Max. :5.000 Max. :95.00
##
## Dribbling Marking Sliding_Tackle Standing_Tackle Aggression
## Min. : 4.0 Min. : 3.00 Min. : 5.00 Min. : 3.00 Min. : 2.00
## 1st Qu.:47.0 1st Qu.:22.00 1st Qu.:23.00 1st Qu.:26.00 1st Qu.:44.00
## Median :60.0 Median :48.00 Median :51.00 Median :54.00 Median :59.00
## Mean :54.8 Mean :44.23 Mean :45.57 Mean :47.44 Mean :55.92
## 3rd Qu.:68.0 3rd Qu.:64.00 3rd Qu.:64.00 3rd Qu.:66.00 3rd Qu.:70.00
## Max. :97.0 Max. :92.00 Max. :95.00 Max. :92.00 Max. :96.00
##
## Reactions Attacking_Position Interceptions Vision
## Min. :29.00 Min. : 2.00 Min. : 3.00 Min. :10.00
## 1st Qu.:55.00 1st Qu.:37.00 1st Qu.:26.00 1st Qu.:43.00
## Median :62.00 Median :54.00 Median :52.00 Median :54.00
## Mean :61.77 Mean :49.59 Mean :46.79 Mean :52.71
## 3rd Qu.:68.00 3rd Qu.:64.00 3rd Qu.:64.00 3rd Qu.:64.00
## Max. :96.00 Max. :94.00 Max. :93.00 Max. :94.00
##
## Composure Crossing Short_Pass Long_Pass Acceleration
## Min. : 5.00 Min. : 6.00 Min. :10.00 Min. : 7.0 Min. :11.00
## 1st Qu.:47.00 1st Qu.:38.00 1st Qu.:52.00 1st Qu.:42.0 1st Qu.:57.00
## Median :57.00 Median :54.00 Median :62.00 Median :56.0 Median :68.00
## Mean :55.85 Mean :49.74 Mean :58.12 Mean :52.4 Mean :65.29
## 3rd Qu.:66.00 3rd Qu.:64.00 3rd Qu.:68.00 3rd Qu.:64.0 3rd Qu.:75.00
## Max. :94.00 Max. :91.00 Max. :92.00 Max. :93.0 Max. :96.00
##
## Speed Stamina Strength Balance
## Min. :11.00 Min. :10.00 Min. :20.00 Min. :10.00
## 1st Qu.:58.00 1st Qu.:57.00 1st Qu.:57.00 1st Qu.:56.00
## Median :68.00 Median :66.00 Median :66.00 Median :65.00
## Mean :65.48 Mean :63.48 Mean :65.09 Mean :64.01
## 3rd Qu.:75.00 3rd Qu.:74.00 3rd Qu.:74.00 3rd Qu.:74.00
## Max. :96.00 Max. :95.00 Max. :98.00 Max. :97.00
##
## Agility Jumping Heading Shot_Power
## Min. :11.00 Min. :15.00 Min. : 4.00 Min. : 3.00
## 1st Qu.:55.00 1st Qu.:58.00 1st Qu.:45.00 1st Qu.:45.00
## Median :65.00 Median :65.00 Median :56.00 Median :59.00
## Mean :63.21 Mean :64.92 Mean :52.39 Mean :55.58
## 3rd Qu.:74.00 3rd Qu.:73.00 3rd Qu.:65.00 3rd Qu.:69.00
## Max. :96.00 Max. :95.00 Max. :94.00 Max. :93.00
##
## Finishing Long_Shots Curve Freekick_Accuracy
## Min. : 2.00 Min. : 4.0 Min. : 6.00 Min. : 4.00
## 1st Qu.:29.00 1st Qu.:32.0 1st Qu.:34.00 1st Qu.:31.00
## Median :48.00 Median :52.0 Median :48.00 Median :42.00
## Mean :45.16 Mean :47.4 Mean :47.18 Mean :43.38
## 3rd Qu.:61.00 3rd Qu.:63.0 3rd Qu.:62.00 3rd Qu.:57.00
## Max. :95.00 Max. :91.0 Max. :92.00 Max. :93.00
##
## Penalties Volleys GK_Positioning GK_Diving
## Min. : 7.00 Min. : 3.00 Min. : 1.00 Min. : 1.00
## 1st Qu.:39.00 1st Qu.:30.00 1st Qu.: 8.00 1st Qu.: 8.00
## Median :50.00 Median :44.00 Median :11.00 Median :11.00
## Mean :49.17 Mean :43.28 Mean :16.61 Mean :16.82
## 3rd Qu.:61.00 3rd Qu.:57.00 3rd Qu.:14.00 3rd Qu.:14.00
## Max. :96.00 Max. :93.00 Max. :91.00 Max. :89.00
##
## GK_Kicking GK_Handling GK_Reflexes
## Min. : 1.00 Min. : 1.00 Min. : 1.0
## 1st Qu.: 8.00 1st Qu.: 8.00 1st Qu.: 8.0
## Median :11.00 Median :11.00 Median :11.0
## Mean :16.46 Mean :16.56 Mean :16.9
## 3rd Qu.:14.00 3rd Qu.:14.00 3rd Qu.:14.0
## Max. :95.00 Max. :91.00 Max. :90.0
## #Gráfico de barra
Representação do gráfico de barra
class(FifaData$Rating)## [1] "numeric"barplot(table(FifaData$Rating), col = c("blue"),
main = "Representação gráfica da avaliação dos jogadores",
ylim = c(0,2000))
#Resumo da Variável da Avaliação
summary(FifaData$Rating)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 45.00 62.00 66.00 66.17 71.00 94.00#Histograma
Histograma baseado nos dados fornecidos das avaliações. Pode-se analisar que há picos, agrupamentos mais altos de barras. Sendo assim, há valores mais comuns em um determinado momento e depois há dispersão no número das avaliações dos jogadores.
hist(FifaData$Rating, col = c("pink"),
main = "Histograma da avaliação dos jogadores",
ylim = c(0,5000))
summary(FifaData$Rating)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 45.00 62.00 66.00 66.17 71.00 94.00#Boxplot
O BoxPlot é um gráfico comparativo entre grupos com relação à posição, dispersão e à distribuição de dados. Neste BoxPlot se pode analisar que o máximo é de 85 e mínimo abaixo de 50; Além disso, o terceiro quartil está um pouco acima do 70; o primeiro quartil um pouco acima do 60 e o segundo quartil, também chamado de linha central ou mediana, encontra-se entre o número 68; Dessa forma, este BoxPlot tende a ser simétrico, pois a posição da linha da mediana está entre o primeiro e o terceiro quartil. Assim, a mediana é a medida de tendência central.
boxplot(FifaData$Rating, col = c("yellowgreen"),
main = "BoxPlot da avaliação dos jogadores")