- 1,085
- Italy
Thanks, much appreciatedI have the data saved in a different file format than excel, but here is a link to a text file with time, DR, and time trial ID https://we.tl/t-dVYTqyNcFt
It's 31 MB which was too big to attach directly on here. Guessing you'll have trouble opening the full file in excel since it's 2 million rows, but you can split it by the time trial id to get individual ones.
Not sure how half_sourly gets the data, but I just do it by running a python script and using a package called selenium. If you're interested in this kind of stuff you can get it up and running pretty quickly by just following some tutorials online for web scraping.
Not sure if there's a quicker way to get the data since it is dynamically generated through JavaScript on the website, but if anyone knows of a way please share.
I did have a brief look at the code PD use on their site back when I set the script i use up, but one look was enough to realise it would take more manual effort to decipher that than just get a script to open each page of each time trial and download the data.
Interestingly though if you capture the responses from the website using tools that do that there is more data available than what they display, including which car people use. I just haven't had time to sit down to see if I can automate capturing that data automatically, but might do that in the future if I have nothing to do at work cause I think seeing car specific leaderboards for the gr.3/4 trials would be interesting.
If I'm getting it right the row data is
167.561 : time in seconds
C: DR rank
5014: TT ID as per PD web page link
This evening I will search for a good long movie on Netflix and will start playing with it