Em um mundo cada vez mais conectado e digital, o trabalho remoto se tornou uma prática comum. Embora ofereça muitos benefícios, como flexibilidade de horários e eliminação do tempo de deslocamento…
FIFA 2021 is one of the popular FIFA series of football simulation games. Developed by EA Sports, the game was released on October 9, 2020, and is available on multiple platforms, including PlayStation 4, PlayStation 5, Xbox One, Xbox Series X/S, and PC.
Cleaning data involves the process of removing or correcting any inaccuracies or inconsistencies in the data set. This can include removing duplicate entries, fixing spelling errors, and standardizing data formats. In addition, data cleaning can also involve removing irrelevant or outdated data, such as retired players or teams that are no longer active. By cleaning FIFA 2021 data, analysts and researchers can ensure that the data they are working with is accurate and reliable, which is essential for making informed decisions and drawing meaningful insights. Proper data cleaning can also improve the efficiency of data analysis, making it easier to identify patterns and trends in the data.
THE DATASET
The dataset contains 18979 rows and 77 columns.
Below are some of the columns contained in the dataset and their definitions
ID: Unique identification number for each Player
Name: Player’s Name
Long Name: Player’s Full Name
photo URL: URL to the Player’s photo
player URL: URL to the Player’s profile page
OVA- Overall rating, a score that represents the Player’s overall ability.
POT- Potential rating, a score that represents the Player’s potential to improve.
Contract: The team the Player is currently playing for and the contract details.
Positions: The various positions on the field that the Player can play.
W/F: Player’s weak foot rating
SM: Player’s skill move rating
A/W: Player’s attacking work rate
D/W: Player’s defensive work rate
IR: Player’s international reputation rating
PAC: Player’s pace rating
SHO: Player’s Shooting rating (1–5)
PAS: Player’s Passing rating
DRI: Player’s Dribbling rating
DEF: Player’s Defensive rating
PHY: Player’s Physical rating
Data Exploration
Issues discovered:
2. Check for null values
3. Handling extra spaces in the Club column
4. Cleaning the contract column
5. Cleaning the Height column
6. Cleaning the Weight column
7. Cleaning the Value, Wage, and Release columns
8. Removing currency symbols
Welcome to the realm of artificial intelligence and predictive analytics, where digital marketers are embracing machine learning algorithms to transform their SEO tactics. Search engine optimization…
The European Parliament has generally voted for the new rules to trace crypto-asset transfers within the EU. The approval of the Markets in Crypto-assets (MiCA) legislation marks a significant…
Did you hear the one about the teen girl who got expelled from high school when her mother posted her birthday snaps to Facebook? She was wearing a sweater with rainbow stripes, blowing out 15…