Okay, here we go! Here’s my breakdown of messing around with some data about Lyon rugby.
So, I was killing time the other day and stumbled across some rugby stats online. Specifically, it was about Lyon rugby, and I thought, “Hey, why not see what I can do with this stuff?” I didn’t really have a plan, just wanted to poke around.
First things first, I copied all the data I could find into a spreadsheet. It was a total mess – different formats, random spacing, just a classic data dump. Spent a good hour cleaning it up. You know, removing extra spaces, standardizing date formats, that kind of boring but necessary stuff.
Then came the fun part! I started looking at some basic stats. Like, who were the top scorers? How many games did they win at home versus away? Simple stuff, but it gave me a feel for the data. I used a bunch of spreadsheet formulas for this – SUMIF, AVERAGEIF, the usual suspects. Nothing too fancy.
After that, I wanted to visualize things a bit. Spreadsheets are okay, but charts are way better for seeing patterns. I made a couple of bar graphs showing the number of tries scored by each player. Also threw together a pie chart showing win percentages home vs. away. That was pretty revealing – they definitely played better at home!
- Cleaned up the initial data
- Calculated basic player stats
- Created visualizations (bar graphs, pie charts)
I got a little more ambitious and tried to see if there was any correlation between points scored and wins. Basically, did scoring more points actually mean they were more likely to win? I didn’t have a ton of data, but I threw it into a scatter plot and tried to eyeball a trendline. Seemed like there was a slight positive correlation, but it wasn’t super strong.
To be honest, it was all pretty basic stuff, but it was a fun way to spend an afternoon. I learned a bit more about Lyon rugby, got some practice with my spreadsheet skills, and even made some half-decent charts. Plus, it gave me an excuse to procrastinate on actual work!
Ultimately, I ended up with a cleaner dataset, some simple visualizations, and a slightly better understanding of Lyon rugby’s performance. Nothing groundbreaking, but a satisfying little project!
