Formula 1 data on Kaggle

[Anonymous]

Hi,

I am working on the formula 1 dataset on Kaggle but I find sometimes it's difficult to understand the data as I don't know much about F1. The files are here: https://www.kaggle.com/rohanrao/formula-1-world-championship-1950-2020

I am sorry if I am being obtuse, but I don't understand how one driver could win multiple times in one race?

For example, in the driver_standings file, driverid=1 has 11 wins when raceid=918. Since raceid is unqiue for each Formula 1 Grand Prix, how can it be possible?

Thank you.

Jing

[v-henryk-mstf]

Hi @Anonymous ,

If the problem has been solved, you can mark the correct response as the standard answer to help the other members find it more quickly.

If there is still confusion, please point it out and I will answer it for you as soon as possible!

Best Regards,
Henry

[HotChilli]

Where do you get this from "driverid=1 has 11 wins when raceid=918" I'm not seeing it.  Record 67034 has driver id = 1.

Ah, I see it now in compact view, the driver has 11 wins so that's either career wins or season wins (possibly up to and including the current race) so not just this race

[Anonymous · Accepted solution]

Don't worry. I get it now. It is cummulative number of wins in each season, though I still don't understand why sometimes it doesn't count a win when a driver's final position is 1, but I assume it's due to F1's complicated rules.

[Anonymous]

Hi Hotchilli

Thank you for your reply.

Please see the file "races.csv" from the link. Each raceid is unqiue for each Formula 1 Grand Prix, not for each season.

Thank you.

Jing