UK National Cycling Scene Transformation

rogers1000 / cyclingchaos

Cycling Data Package

6 stars 0 forks source link

UK National Cycling Scene Transformation #40

Open rogers1000 opened 3 months ago

rogers1000 commented 3 months ago

Transform British Cycling ingestion into results df

rogers1000 commented 3 months ago

Need to think about how I implement results from first cycling to British Cycling...

UCI Classification will probably be "British Nat A" etc.

Category will be "Road" or "Criterium"

Need to do mapping between British Cycling IDs and Names and FirstCycling.

Route will likely be location-location

rogers1000 commented 3 months ago

Basis calendar transform done in order to get link to ingest race results.

Will look into make it aligned with FirstCycling and Paralympic unioned calendar.

Not yet looked at results data.

rogers1000 commented 3 months ago

Calendar transform so far...

[x] * Dates transform doesn't work for stage races...
[ ] * Need to work out what if it is a stage race or not
[ ] * Need to work out what category the race is (probably do GB as prefix) for UCI Race Classification
[ ] * Stage Number is related to stage races (not sure yet)
[ ] * distance not sure yet
[ ] * stage profile not sure yet
[ ] * Route uses location but probably too detailed. Need to look into that.

rogers1000 commented 3 months ago

Race Results...

All working for riders who finished... for DNFs or DNSs there is an issue with position. Shouldn't be too complex, hopefully.

rogers1000 commented 3 months ago

Currently working through the transform relating to Race Category as it isn't working in the current transform.

rogers1000 commented 2 months ago

Transform isn't possible with current ingestion process.

Need to look to implement standard scoring for all racers (international riders or riders without proper licence don't collect points but should still be tracked)