search

SCasanova / f1dataR

An R package to access Formula 1 Data from the Ergast API and the unofficial F1 data stream via the fastf1 python library.
https://scasanova.github.io/f1dataR/
Other
52 stars 5 forks source link

compare results between season 1950-2024 #247

Closed factorialmap closed 6 months ago

factorialmap commented 6 months ago

In the original structure of the results table, it has a column called race_id that made it possible to compare different seasons.

Is there any way to return data with the range from 1950 to the current date?

image

pbulsink commented 6 months ago

Hi factorialmap,

Thanks for this suggestion.

If you're looking for a full copy of the data in Ergast, that's actually available to download from them in .csv or MySQL format, and that might serve you better than trying to recreate the database through our functions. Take a look here: http://ergast.com/mrd/db/. Note that in the future Ergast will be deprecated and not updated past 2024. We have leads on alternate data sources but they may use a different database schema and primary keys. As such, I think we'd likely prefer not to start providing that information currently, in expectation that it changes in less than a year.

There's some additional information that our package doesn't return to the users from Ergast, so this would avoid dropping those (and all of the Id columns) from all of the tables.

I've done some (other) work from the .csv files and found them easy to work with.

factorialmap commented 6 months ago

it works. Thank you so much for that