Okay, here’s my blog post about working with the “football premier league 2017” data:
So, I got this idea to mess around with some football data, specifically the 2017 Premier League season. I’m a big football fan, and I thought it would be cool to see if I could pull some interesting insights from it, maybe even build a simple table showing the final standings.
Getting Started
First things first, I needed the data. I figured there were probably a bunch of places online where I could find it, maybe in a CSV file or something. I spent a little time Googling around, trying different search terms like “premier league 2017 results” and “premier league 2017 data.”
I found some websites, but some are pretty messy, some are not completed.
Cleaning Up the Data (The Pain!)
The real work began when I tried to make sense of the data, It wasn’t exactly straightforward. There were things like, I had to deal with those. After spending a few hours staring at spreadsheets, I started feeling a little overwhelmed. There were a lot of numbers! I had to figure out what each column meant, and how I could use them to calculate things like wins, losses, draws, goals for, goals against, and points.
Building the Table
My next step was to put the data into some kind of structure. I’m not a big fan of super complicated databases for a small project like this, so I decide to do it by meself, all by hand.
I went through the data, team by team. For each team, I figured out the number of wins, losses, and draws, using their goal difference. I also calculated their points (3 for a win, 1 for a draw).
The Results
Finally, I had my table! It wasn’t pretty, but it showed the final standings of the 2017 Premier League season. It had all the basic stuff: team names, wins, losses, draws, goals for, goals against, goal difference, and points.
I thought it was a good test for me.
