MySql
Project
This project aims to clean the “FIFA 23” dataset using Python. The main steps of the project are as follows: Importing the dataset, correcting missing or erroneous data, validating data types, and cleaning unnecessary characters. Performing data analysis (e.g., player distribution, positions, age, and overall player ratings analysis), creating data visualizations (e.g., maps, bar charts, scatter plots), and reporting the project’s results.
DFDs and System & Analysis
3.7/5
The first step involves importing the “FIFA 23” dataset into Python for further processing.Correcting Missing or Erroneous Data: Identifying and rectifying missing or incorrect data entries to ensure data accuracy.Ensuring that the data types for each attribute are appropriate and consistent.Cleaning Unnecessary Characters: Removing any unwanted or irrelevant characters from the dataset.
Examining the distribution of players across different attributes such as nationality, club, and position.Analyzing the distribution of players by their playing positions.Investigating the age distribution of players.Overall Player Rating Analysis: Assessing and summarizing the distribution of player ratings.Summarizing the key insights obtained from the data analysis and visualizations. Communicating the outcomes of the project, including any trends or patterns discovered during the data cleaning and analysis stages.
Languages and programs used
- MySQL
- Excel
