Okay, so I wanted to mess around with some data, and I thought, why not look at the Spanish League table from 2017? I’m a huge football fan, so this seemed like a fun little project.
Getting Started
First things first, I needed to find the data. I remember that season pretty well, but I definitely didn’t have the exact standings memorized. So, I hit up Google and started searching for “spanish league table 2017”.
After trying find websites, I finally found one that looked promising with good data and a nice layout table.
Wrangling the Data
Once I had the data, I needed to do something with it. I played with the idea to import everything into Excel. Here’s how I thought to put it:
- Team: Obviously, this is where the team names go.
- Played: How many games they’d played.
- Won: Number of wins.
- Drawn: Number of draws.
- Lost: Number of losses.
- Goals For: Goals they scored.
- Goals Against: Goals scored against them.
- Goal Difference: The difference between goals for and against.
- Points: Total points.
I copied and pasted all table, and then, I was staring at this spreadsheet, and it finally hit me: I had the 2017 Spanish League table, all neatly organized! I spent some time messing around, like sorting by points to see the final standings, checking out goal differences, and stuff like that.
It was a cool to make a table and remind myself that how close that season was!
