Como criar uma equipe de alto desempenho em um ambiente de trabalho remoto?

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…

Smartphone

独家优惠奖金 100% 高达 1 BTC + 180 免费旋转




FIFA 2021 DATA CLEANING CHALLENGE

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

Raw Dataset

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

Add a comment

Related posts:

AI and Predictive Analytics for SEO Strategy

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…

Good or bad Euronews for crypto?

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…

Girl Expelled Over Rainbow Birthday

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…