Skip to content
Snippets Groups Projects
Challenges_Encountered.txt 757 B
Challenges 

I] Question 1

a) Had to clean up data for Players whose country of origin was unknown in the database.
This was especially true for years before 1912

II] Question 2

a) There was incorrect data in the Salaries.csv file, in the teamId field, for the Year 2016,
for some of the teams in the database. The Entire Database used a fixed convention for teamId, 
however this convention was changed for the Year 2016 in the Salaries.csv file. When a database
join was performed between the data in the Salaries.csv file and the Teams.csv file, this resulted 
in the salary data for 12 teams being omitted from the results. The data in the Salaries.csv file
had to be manually cleaned to match the convention in the rest of the database to fix this.