Download and Prep the Data: $3$ Marks

Import the libraries needed

import pandas as pd

import numpy as np

import matplotlib.pyplot as plt

import seaborn as sns

Load data and store in dataframe

df $=$ pd$.$read$\_$csv$(\text{'}$data$.$csv$\text{'})$

Find out what type of variable you are dealing with. This will help you find the right visualization method for that variable.

df$.$info$()$

Data Cleaning

Fill the missing value for the continuous variables with Mean$($average$)$ for proper data visualization

df$.$fillna$($df$.$mean$(),$ inplace$=$True$)$

Visualisation Questions $-2$ X $5=10$ Marks

Question $1$

What kind of a correlation exists between "Nationality" and "Overall Score"? Use appropriate visuals to demonstrate the same. Clearly mention in markdown cells below the visual.

plt$.$figure$($figsize$=(12,6))$

sns$.$boxplot$($x$=$'Nationality', y$=$'Overall Score', data$=$df$)$

plt$.$xticks$($rotation$=90)$

plt$.$title$(\text{'}$Overall Score Distribution by Nationality'$)$

plt$.$show$()$

Your observation about the relationship for distribution of overall score in different Nationalities.

The boxplot shows the distribution of overall scores for different nationalities. Some nationalities have a higher median overall score compared to others, indicating a potential correlation between nationality and overall score.

The reason for selecting the chart type you did in a markdown cell below

A boxplot is chosen because it effectively displays the distribution of scores, including the median, quartiles, and potential outliers, which helps in understanding the spread and central tendency of the data for each nationality.

Question $2$

What kind of a correlation exists between "Popular Clubs" and "Overall Score"? Use appropriate visuals to demonstrate the same. Clearly mention in markdown cells below the visual.

plt$.$figure$($figsize$=(12,6))$

sns$.$boxplot$($x$=$'Popular Clubs', y$=$'Overall Score', data$=$df$)$

plt$.$xticks$($rotation$=90)$

plt$.$title$(\text{'}$Overall Score Distribution by Popular Clubs'$)$

plt$.$show$()$

Your observation about the relationship for distribution of overall score in different Popular Clubs.

The boxplot shows the distribution of overall scores for different popular clubs. Some clubs have a higher median overall score compared to others, indicating a potential correlation between club affiliation and overall score.

The reason for selecting the chart type you did in a markdown cell below

A boxplot is chosen because it effectively displays the distribution of scores, including the median, quartiles, and potential outliers, which helps in understanding the spread and central tendency of the data for each club.

Question $3$

Demonstrate the distribution of Ages in some Popular Clubs. Use appropriate visuals to demonstrate the same. Clearly mention in markdown cells below the visual.

plt$.$figure$($figsize$=(12,6))$

sns$.$histplot$($data$=$df$,$ x$=$'Age', hue$=$'Popular Clubs', multiple$=$'stack'$)$

plt$.$title$(\text{'}$Age Distribution in Popular Clubs'$)$

plt$.$show$()$

Your observation about the relationship for distribution of overall score in different Age groups.

The histogram shows the age distribution across different popular clubs. It helps in understanding which age groups are more prevalent in certain clubs.

The reason for selecting the chart type you did in a markdown cell below

A histogram is chosen because it effectively displays the frequency distribution of ages, allowing for easy comparison between different clubs.

Question $4$

Demonstrate and visualize clubs with the highest number of different countries. Clearly mention in markdown cells below the visual.

club$\_$nationality$\_$count $=$ df$.$groupby$(\text{'}$Popular Clubs'$)[\text{'}$Nationality$\text{'}].$nunique$().$sort$\_$values$($ascending$=$False$)$

plt$.$figure$($figsize$=(12,6))$

club$\_$nationality$\_$count.plot$($kind$=$'bar'$)$

plt$.$title$(\text{'}$Number of Different Nationalities in Popular Clubs'$)$

plt$.$show$()$

Your observation about the relationship for distribution of overall score in different Age groups.

The bar chart shows the number of different nationalities in each popular club. Some clubs have a more diverse set of nationalities compared to others.

The reason for selecting the chart type you did in a markdown cell below

A bar chart is chosen because it effectively displays the count of different nationalities in each club, making it easy to compare diversity across clubs.

Question $5$

Use a single heat map to visualize the relationship between the features. Explain the features considered by you to plot the heatmap. Perform the data preprocessing required. The heatmap should plot the target variable $($overall score$)$ proportional to other variables$($features$)$ considered. The plot should have labels for x axis and y axis. Write down your observations in a markdown cell below the visual.

# Selecting relevant features

features $=[\text{'}$Age$\text{'},$ 'Overall Score', 'Height', 'Weight', 'Potential', 'Value'$]$

correlation$\_$matrix $=$ df$[$features$].$corr$()$

plt$.$figure$($figsize$=(10,8))$

sns$.$heatmap$($correlation$\_$matrix, annot$=$True, cmap$=$'coolwarm', linewidths$=0\mathrm{.}5)$

plt$.$title$(\text{'}$Correlation Heatmap'$)$

plt$.$show$()$

Summarize your observations

The heatmap shows the correlation between different features. For example, there is a strong positive correlation between 'Overall Score' and 'Potential'. The heatmap helps in identifying which features are strongly correlated with the target variable 'OveralDownload and Prep the Data: $3$ Marks Import the libraries needed $[]$ Start coding or generate with AI$.$ Load data and store in dataframe $[]$ Start coding or generate with AI$.$ Find out what type of variable you are dealing with. This will help you find the right visualization method for that variable. $[]$ Start coding or generate with AI$.$ Data Cleaning Fill the missing value for the continous variables with Mean$($average$)$ for proper data visualization $[]$ Start coding or generate with AI$.$ Visualisation Questions $-2$ X $5=10$ Marks Question $1$ What kind of a correlation exists between "Nationality" and "Overall Score" Use appropriate visuals to demonstrate the same. Clearly mention in markdown cells below the visual $1.$Your observation about the relationship for distribution of overall score in different Nationalities. $2.$The reason for selecting the chart type you did in a markdown cell below $[]$ Start coding or generate with AI$.[]$ Start coding or generate with AI$.[]$ Start coding or generate with AI$.$ Question $2$ What kind of a correlation exists between "Popular Clubs" and "Overall Score" Use appropriate visuals to demonstrate the same. Clearly mention in markdown cells below the visual $1.$Your observation about the relationship for distribution of overall score in different Popular Clubs. $2.$The reason for selecting the chart type you did in a markdown cell below $[]$ Start coding or generate with AI$.[]$ Start coding or generate with AI$.$ Question $3$ Demonstrate the distribution of Ages in some Popular Clubs Use appropriate visuals to demonstrate the same. Clearly mention in markdown cells below the visual $1.$Your observation about the relationship for distribution of overall score in different Age groups. $2.$The reason for selecting the chart type you did in a markdown cell below $[]$ Start coding or generate with AI$.[]$ Start coding or generate with AI$.$ Question $4$ Demonstrate and visualize clubs with highest number of different countries. Clearly mention in markdown cells below the visual $1.$Your observation about the relationship for distribution of overall score in different Age groups. $2.$The reason for selecting the chart type you did in a markdown cell below $[]$ Start coding or generate with AI$.$ Question $5$ Use a single heat map to visualize the relationship between the features. Explain the features considered by you to plot the heatmap. Perform the data preprocessing required. The heatmap should plot the target variable $($overall score$)$ proportional to other variables$($features$)$ considered. The plot should have labels for x axis and y axis. Write down your observations in a markdown cell below the visual $[]$ Summarize your observations $[]************$ END OF ASSIGNMENT $****************[]$