FIFA19 dataset analysis

HARSHITA GARG
Analytics Vidhya
Published in
8 min readFeb 21, 2021

--

How do different factors affect the wages of players in the FIFA19 game dataset

FIFA is the Fédération Internationale de Football Association and FIFA 19 is part of the FIFA series of football video games. It is one of the best-selling video games of all times and is extremely popular among children and adults alike.

In this article, we will try to analyze the FIFA dataset to see which key factors affect the wages of the players in the game. The dataset can be downloaded from here. In this analysis, we will aim to answer the questions like ; Does the age of a player affect his wages? Secondly, does the height, weight, or position of players affect their wages? Which clubs spend the maximum amount of money on their players? And finally, players of which countries get paid the most amount of money?

Data Preparation

We start with reading the .csv file and putting it into a data frame. There are nearly 18,000 rows and 89 columns in the dataset. Carefully looking at the data frame reveals that nearly 48 rows have missing data for around 50% of the variables. These rows were removed from the frame.

#Read data into a frame
import pandas as pd
import numpy as np
data = pd.read_csv("C:/Users/~/data.csv")
print(data.head())
#remove rows with many null values. 48 such rows are deleted
clean_data =…

--

--

HARSHITA GARG
Analytics Vidhya

Data Scientist and a Data Enthusiast, Love finding hidden patterns in data. Always trying to find the ‘Whys’ behind the data. Knowledge sharing.