Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Formula 1 data on Kaggle

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

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

4 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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.

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    4 years ago

    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