search

rogers1000 / cyclingchaos

Cycling Data Package
6 stars 0 forks source link

Results_Pivot - Bonus Seconds not tracked #9

Closed rogers1000 closed 5 months ago

rogers1000 commented 6 months ago

Currently Results_Pivot doesn't track bonus seconds.

Will be part of Phase 5 ingestion to include GC Time (which includes bonus seconds), KOM, Points and Youth jersey.

rogers1000 commented 6 months ago

GC_Time and GC_Position on Stage Level incorrectly labelled.

Should be labelled Stage Time and Stage Position.

rogers1000 commented 5 months ago

Changed Field Names to match what they should be labelled.

Data is now ingested, still need to transform data.

rogers1000 commented 5 months ago

Bonus Seconds will have to be a manual addition to the results function.

Should just be lead() function where stage_number for lead is 1 smaller than the current stage_number.

Probably will have issues surrounding TTT data not being transformed so that might become a bigger priority.

rogers1000 commented 5 months ago

Bonus seconds are now tracked.

There is a data issue that I have noticed with methodology of creating gc_time_stage and comparing that to the stage_time when the time is used from before the finish line - eg TDF Stage 21. I think it's fine as long as I note that down. Bonus Seconds comparisons will be mainly to compare amount of bonuses vs other GC contenders.