Who Were The Top Scorers In the 2023/2024 Premier League Season?

I aim to provide the top 10 scorers in the premier league strictly using data from matches played in the premier league during the 2023–2024 season.

Specific stakeholders that may be wondering who the top scorers in the premier league could be the issuer of the golden boot premier league award that is awarded to the top scorer of the season.

The data that could answer this question is data of each player in the premier league as well as their games played and if they scored any goals during the game. This data would be a list of games throughout the 2023–2024 season, names of players who played during those games, and goals scored as well as the names of those who scored.

I collected some subdata using Footystats.org (Data Archive) which is a premier stats and analysis website that has data coverage in over 1500+ football leagues worldwide.

Some data cleaning I did and common bugs I found:

Here are the tables/figures that summarized my finds using SQL:

Some limitations on my analysis could be disallowed goals that were actually legal goals but never accounted for on paper. Another limitation could be the exact opposite, goals scored when offsides or in an illegal manner (not completely crossing the line, foul before the goal, handball goal, etc).

Github Repository With Developed Code For This Assignment: https://github.com/Miguel4350/Module-1-INST414