Using the Fifa 20 complete player dataset, our purose was to create a user driven, interactive dashboard which showcases various player information from both their real lives and the Fifa 20 videogame.
-
Create a new repository and title it as you please. Our repository is titled "Fifa_Player_Visualization_Project2".
-
Clone the new repository to your computer.
-
This project utilizes Python, SQL, html, Javascript and CSS. Therefore you will need Pandas, .JS and .HTML files to run the analysis.
-
Push the above changes to GitHub or GitLab.
For this project we utilized PgAdmin to store our database and generate our table. To create this database we had to utilize our ETL skills. These are the steps for creating the database, creating the table and loading it with our Fifa 20 data set:
-
Create a Jupyter notebook file which will be used to extract the data that we would like to use to load our data into ourdatabase. Below is an image of the columns that we extracted from our dataset and in turn used to create a table in our database:
-
We also included a column "Continent" that was not in the original Fifa20 dataset.
-
Once the dataframe has been scrubbed to show only the columns above and we have removed all NaN values, we will begin the load process. This is done by creating a connection to the database. We labeled our database fifa_df1.
-
After the connection is made a file named "fifa_storage.py" for storing the database username and database password will need to be created. This file will be located at the same level as the jupyter notebook file. It should resemble this:
-
Open PgAdmin and create a database titled "fifa_df1". Leave the Jupyter Notebook open as we will use this to push the data into our table and then read the database to verify that the data was loaded correctly.
-
Open a Query Tool and create a table titled "fifa_df1" and create column labels of the variables shown above. Use the "sofifa_id" column for our primary key. Create the table and then as an option you can run "select * from fifa_df1;" to verify that the table was created correctly.
-
Navigate back to your Jupyter Notebook and with the connection established run a "dataframe.to_sql" to push the dataframe to our database.
-
Run a "pd.read_sql_query" to verify that the dataframe was successfully pushed to the database.
-
If no errors return you can navigate back to PgAdmin and in your Query Tool run "select * from fifa_df1" and your Data Output will resemble this:
There are three tabs that we created for this project. There is a Home page, a Comparison page and an About page. Here is a brief summary about each page.
We created this page to show a few visuals of Fifa players that played during the 2019 season. Those visuals include:
-
A d3 circle graph which shows the top 2,000 Fifa players. We visualized this by creating one large circle graph which has 7 interior graphs for each continent. Inside of each continent are the countries that each player in the top 2,000 was born in and within each country are those players.
-
A horizontal bar graph of the count of the top 5 countries that have produced the most Fifa players.
-
A bar graph of the top 11 highest Fifa earns by wage in Euros.
-
A bar graph of Fifa Athletes by Age by Count
-
A pie chart of the clubs with the most players in the top 30.
This page was created to show the comparison of each Fifa players Fifa 20 attributes. There is a drop down cell that allows you to select each individual player and once selected a spider chart populates showing these attributes. There is also a table which populates showing the actual value of each individual attribute. Below these visuals is a summary of what each attribute means.
Lastly this page was used to convey our purpose of the project and provide a brief summary of each page. Similarly to what was done above.
- Pandas
- PgAdmin
- Visual Studio Code
- Python
- Sql
- Javascript
- Javascript (D3)
- HTML
- CSS
- Rachel Kerr
- Jagnoor Singh
- Chris Pope
Email: [email protected]
Email: [email protected]
Email: [email protected]