Visualising WRC Rally Results and Timing Data
Index
1
Introduction
2
Accessing Data from the WRC Live Timing API
2.1
Current Season Rallies
2.2
Itinerary Lookup
2.2.1
Leg Sections
2.2.2
Time Controls
2.2.3
Stage Details
2.2.4
Road Order Start Lists
2.3
Competitor Details
2.3.1
Looking Up Entries by Group
2.3.2
Driver & Codriver Details
2.3.3
Summarising Essential Entry Data
2.4
Penalties and Retirements
2.5
Results and Stage Winner
2.6
Stage Result
2.6.1
Getting Stage Results for Multiple Stages
2.7
Stage Times
2.7.1
Getting Stage Times for Multiple Stages
2.7.2
Getting Wide Stage Times for Multiple Stages
2.7.3
Getting Wide Stage Positions
2.7.4
Getting Generic Wide Dataframes
2.8
Split Times
2.8.1
Driver Split Times Detail
2.8.2
Wide Driver Split Times
2.8.3
Multiple Stage Long Splits Data
3
Visualising Results for a Single Stage
3.1
Load Base Data
3.2
Get Stage Results Data
3.3
Previewing Stage Results Data
3.3.1
Adding Entry Metadata
3.4
Adding Stage Metadata to Table Captions
3.5
Colour Highlighting Stage Results
3.5.1
Heatmap Style Column Cell Backgrounds
3.6
An Aside — Calculating DIFF and GAP times
3.7
Rebasing Stage Results
3.8
Colour Highlighting Rebased Values
4
Visualising Results for Multiple Stages
4.1
Load Base Data
4.2
Retrieving Mutliple Stage Results
4.2.1
Reshaping Overall Position Data
4.2.2
Reshaping Overall Rally Time Data
4.2.3
Reshaping Time to First Data
4.2.4
Mapping Stage and Driver Identifiers to Meaningful Labels
4.2.5
Rebasing Overall Times
4.2.6
Finding Changes in Rebased Gaps Across Stages
4.3
Visualising Overall Results
4.3.1
Visualising First Position
4.3.2
Visualising Position Changes Over a Rally
4.3.3
Visualising Position Gains/Losses
4.3.4
Per Driver Position Charts
4.3.5
Visualising Time to First
4.3.6
Visualising Rebased Gaps
4.4
Retrieving Stage Times and Results
4.5
Visualising Stage Times
4.5.1
Stage Position Sparklines
4.5.2
Gap to Stage Winner Sparklines
4.5.3
Stage Position Charts
4.5.4
Individual Stage position Charts
5
Finding Pace Across Stages
5.1
Load Base Data
5.2
Defining Pace
5.3
Calculating Stage Pace
5.3.1
Calculating Pace for a Single Stage
5.3.2
Calculating Pace for Multiple Stages
5.4
Rebasing Stage Pace
5.5
The Ultimate Rally
6
Visualising Stage Pace
6.1
Load Base Data
6.2
Pace Maps
6.3
A Pace Map Function
6.4
Off-the-Pace Charts
6.5
Comparing Pace Across Stages
7
Working With Split Times
7.1
Load Base Data
7.2
Get Splits Data
7.2.1
Split Locations
7.2.2
Mapping Split Codes to Split Numbers
7.2.3
Split Times
7.2.4
Wide Driver Split Times
7.3
Rebasing Split Times
7.4
Visualising Rebased Split Times Using Sparklines
7.5
Finding the Rank Position at Each Split Point
7.6
Finding Split Section Durations
7.6.1
Finding Split Section Ranks
7.7
Adding Overall Stage Time to the Split Times
7.8
Calculating the Ultimate Stage from Ultimate Split Times
7.8.1
Rebasing to Ultimate Split Times
7.8.2
Per Split Ultimate Rebasing
7.8.3
Ultimate Stage Rebasing
7.8.4
Actual Best Elapsed Time Rebasing
7.9
Visualising Rebased Times
7.9.1
Context Sensitive Cell Colouring
7.9.2
Using Sparklines to Summarise Rebased Deltas
8
Visualising Pace Across Splits
8.1
Load Base Data
8.1.1
Obtaining Split Distances
8.2
Calculating Splits Pace
8.3
Visualising the Splits Pace
8.3.1
Pace Over Each Section
8.3.2
Splits Sections Pace Maps
8.3.3
Off-the-Pace Splits Pace Mapping
RallyDataJunkie.com
Visualising WRC Rally Timing and Results Data
Visualising WRC Rally Timing and Results Data
A RallyDataJunkie Adventure
Tony Hirst
Index