Okay, so today I decided to mess around with F1 testing lap times. I’ve always been curious about how the teams stack up during those pre-season sessions, so I figured I’d dive in and see what I could find.
First, I googled around a bit to see where I could even get this data. I found a couple of sites that seemed to have the information, though it wasn’t exactly in a super organized format. Lots of tables and stuff, but nothing I could just download and play with.
So, next, I had to, you know, actually get the data. This part was a little tedious. I ended up copying and pasting from a few different websites into a spreadsheet. Yeah, I know, not the most elegant solution, but it worked!
Once I had all the lap times in my spreadsheet, I started playing around with it. I sorted the data by fastest lap time, just to get a basic overview. Of course, it’s testing, so you can’t really read too much into it, but it’s still fun to see who’s putting in the quick laps.
Then, I thought it would be cool to see the progression of lap times over the testing days. So I grouped the data by day and looked at the fastest times for each team on each day. It was interesting to see some teams getting quicker, while others might have been focusing on longer runs or different setups, so their times weren’t necessarily improving.
Little summary
- Gathered F1 Testing lap time by google. I used to many website to collect lap times, but some of the data are missing.
- Copied and pasted lap time.Collected data were pasted into a spreadsheet.
- Analyzed the data. I did some simple checks, like finding the fastest lap time and looking at the average lap time for each team.
Honestly, it was a bit of a messy process, and I’m sure there are way better ways to do this with some fancy programming or something. But hey, I got to poke around some F1 data, and that’s always a good time in my book!
