Okay, so I’ve been wanting to mess around with some NFL stats for a while, just for kicks, you know? And with the 2023 season all wrapped up, I figured it was the perfect time to jump in. Here’s how I went about it.
First off, I needed to get my hands on the data. I poked around a bit and found a few places that had what I was looking for. I ended up going with one that seemed pretty reliable and had all the stats in a format that was easy to work with. It wasn’t too hard to grab the data from there, and I got it into my computer.
Once I had the data, I needed a way to actually, like, do stuff with it. I’m not exactly a programmer, but I know my way around a spreadsheet, so I figured that would be good enough. I fired up my favorite spreadsheet program.
Then I needed to import the data into the spreadsheet. This took a little bit of fiddling, but it was not too bad. The data was pretty clean, thankfully. I got it to import all the player names, teams, and all those juicy stats like passing yards, touchdowns, receptions, you name it.
Digging into the Data
Now for the fun part – actually digging into the numbers! I started by just sorting and filtering to see who the top performers were in different categories. You know, who threw for the most yards, who scored the most touchdowns, that kind of thing. It was pretty cool to see all the familiar names pop up at the top of the lists.
But I wanted to go a little deeper than that. I started playing around with some simple formulas to calculate things like yards per attempt, completion percentage, and stuff like that. It was pretty neat to see how different players stacked up when you looked at those kinds of advanced stats.
- Sorting and Filtering: I spent a good chunk of time just sorting the data by different columns and filtering it to show only certain players or teams.
- Basic Formulas: I used some simple formulas to calculate some basic stats.
- Comparison: I created some tables to compare players side-by-side.
I even made a few tables comparing players head-to-head. Like, I wanted to see how this quarterback compared to that quarterback in terms of passing yards, touchdowns, and interceptions. That was pretty interesting.
Wrapping Up
All in all, it was a fun little project. I spent a few hours messing around with the data and learned a lot about the 2023 NFL season. Plus, I got to brush up on my spreadsheet skills, which is always a good thing.
This is not like I am going to publish any groundbreaking analysis or anything. But it was a fun way to kill some time and geek out on some football stats. If you are into this kind of thing, I definitely recommend giving it a try. It is not as hard as you might think!