MotoGP Riders: Active Years Per Category
Which years was a rider active in any of the MotoGP World Championship classes?
@kaggle.mikeenting_motogp_riders_active_years_per_category
Which years was a rider active in any of the MotoGP World Championship classes?
@kaggle.mikeenting_motogp_riders_active_years_per_category
This dataset shows the years in which they were active in each of the MotoGP World Championship classes, starting in 1949.
The source of this dataset is this Kaggle dataset (not owned by me). In this notebook, I show the steps that are made to create this dataset.
In this notebook that looks at the winning percentage of Marc Marquez at clockwise VS anticlockwise circuits, I wanted to know in which years he raced in which of the classes (125cc, Moto2 and MotoGP). To generalise this notebook to make it work for any rider, which I did here, a dataset that includes this data is required. Since I couldn't find one around, I made one myself.
CREATE TABLE active_years_per_category (
"rider_name" VARCHAR,
"motogp" VARCHAR,
"moto2" VARCHAR,
"moto3" VARCHAR,
"motoe" VARCHAR,
"n_350cc" VARCHAR -- 350cc,
"n_250cc" VARCHAR -- 250cc,
"n_125cc" VARCHAR -- 125cc,
"n_80cc" VARCHAR -- 80cc,
"n_50cc" VARCHAR -- 50cc
);Anyone who has the link will be able to view this.