{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# WRC Overall\n", "\n", "Generate a graphic enriched tabel summarising rally evolution over multiple stages, rebased to a specific driver." ] }, { "cell_type": "code", "execution_count": 163, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "The autoreload extension is already loaded. To reload it, use:\n", " %reload_ext autoreload\n" ] } ], "source": [ "if __name__=='__main__':\n", " %load_ext autoreload\n", " %autoreload 2\n", " \n", " import notebookimport\n", " \n", " sr = __import__(\"Charts - Stage Results\")\n" ] }, { "cell_type": "code", "execution_count": 164, "metadata": {}, "outputs": [], "source": [ "# TO DO\n", "# do a step line chart for relative / rebased positions ahead / behind" ] }, { "cell_type": "code", "execution_count": 165, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "\n", "from IPython.display import HTML\n", "\n", "import dakar_utils as dakar\n", "from dakar_utils import moveColumn, sparkline2, sparklineStep, moreStyleDriverSplitReportBaseDataframe\n" ] }, { "cell_type": "code", "execution_count": 178, "metadata": {}, "outputs": [], "source": [ "dbname2='mexico19.db'\n", "conn2 = sqlite3.connect(dbname2)\n", "\n", "c2 = conn2.cursor()\n" ] }, { "cell_type": "code", "execution_count": 167, "metadata": {}, "outputs": [], "source": [ "from IPython.display import HTML" ] }, { "cell_type": "code", "execution_count": 168, "metadata": {}, "outputs": [], "source": [ "def _rebaseTimes(times, bib=None):\n", " if bib is None: return times\n", " return times - times.loc[bib]" ] }, { "cell_type": "code", "execution_count": 169, "metadata": {}, "outputs": [], "source": [ "REBASER=306" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": 170, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | Code | \n", "
---|---|
entryId | \n", "\n", " |
19180 | \n", "OGI | \n", "
19181 | \n", "SUN | \n", "
19182 | \n", "LAP | \n", "
19183 | \n", "MEE | \n", "
19184 | \n", "SOR | \n", "
\n", " | date | \n", "code | \n", "section | \n", "order | \n", "index | \n", "
---|---|---|---|---|---|
1 | \n", "Friday 8th March | \n", "SS2 | \n", "Section 2 | \n", "2 | \n", "2 | \n", "
2 | \n", "Friday 8th March | \n", "SS3 | \n", "Section 2 | \n", "2 | \n", "2 | \n", "
3 | \n", "Friday 8th March | \n", "SS4 | \n", "Section 2 | \n", "2 | \n", "2 | \n", "
\n", " | date | \n", "code | \n", "section | \n", "order | \n", "index | \n", "
---|---|---|---|---|---|
1 | \n", "Friday 8th March | \n", "SS2 | \n", "Section 2 | \n", "2 | \n", "2 | \n", "
2 | \n", "Friday 8th March | \n", "SS3 | \n", "Section 2 | \n", "2 | \n", "2 | \n", "
3 | \n", "Friday 8th March | \n", "SS4 | \n", "Section 2 | \n", "2 | \n", "2 | \n", "
\n", " | overallPosition | \n", "overallGapToLeader | \n", "Pos | \n", "SS_1_overall | \n", "Gap | \n", "stagePosition | \n", "stageWinnerGap | \n", "SS_1 | \n", "
---|---|---|---|---|---|---|---|---|
Code | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
LAP | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "1 | \n", "0.6 | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "0.6 | \n", "
MIK | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "2 | \n", "0.5 | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "0.5 | \n", "
MEE | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "3 | \n", "-0.0 | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "-0.0 | \n", "
EVA | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "4 | \n", "-0.0 | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "-0.0 | \n", "
NEU | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "5 | \n", "-0.0 | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "-0.0 | \n", "
TÄN | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "6 | \n", "-0.0 | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "-0.0 | \n", "
OGI | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "7 | \n", "-0.0 | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "-0.0 | \n", "
SUN | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "8 | \n", "-0.9 | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "-0.9 | \n", "
SOR | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "9 | \n", "-0.9 | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "-0.9 | \n", "
LAT | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "10 | \n", "-1.1 | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "<img src=\"data:image/png;base64,iVBORw0KGgoAAA... | \n", "-1.1 | \n", "
overallPosition | overallGapToLeader | Pos | SS_1 Overall | SS_2 Overall | SS_3 Overall | SS_4 Overall | Gap | stagePosition | stageWinnerGap | SS_1 | SS_2 | SS_3 | SS_4 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Code | ||||||||||||||
MIK | \n", "\n", " | \n", " | 1 | \n", "0.5 | \n", "2.9 | \n", "0.7 | \n", "1.6 | \n", "\n", " | \n", " | \n", " | 0.5 | \n", "2.4 | \n", "-2.2 | \n", "0.9 | \n", "
OGI | \n", "\n", " | \n", " | 2 | \n", "-0 | \n", "-0 | \n", "-0 | \n", "-0 | \n", "\n", " | \n", " | \n", " | -0 | \n", "-0 | \n", "-0 | \n", "-0 | \n", "
EVA | \n", "\n", " | \n", " | 3 | \n", "-0 | \n", "-6 | \n", "-7.8 | \n", "-8.1 | \n", "\n", " | \n", " | \n", " | -0 | \n", "-6 | \n", "-1.8 | \n", "-0.3 | \n", "
MEE | \n", "\n", " | \n", " | 4 | \n", "-0 | \n", "-5.7 | \n", "-9 | \n", "-9.6 | \n", "\n", " | \n", " | \n", " | -0 | \n", "-5.7 | \n", "-3.3 | \n", "-0.6 | \n", "
LAT | \n", "\n", " | \n", " | 5 | \n", "-1.1 | \n", "-15.4 | \n", "-17.1 | \n", "-17.1 | \n", "\n", " | \n", " | \n", " | -1.1 | \n", "-14.3 | \n", "-1.7 | \n", "-0 | \n", "
LAP | \n", "\n", " | \n", " | 6 | \n", "0.6 | \n", "-16.5 | \n", "-19.6 | \n", "-20.5 | \n", "\n", " | \n", " | \n", " | 0.6 | \n", "-17.1 | \n", "-3.1 | \n", "-0.9 | \n", "
TÄN | \n", "\n", " | \n", " | 7 | \n", "-0 | \n", "-19 | \n", "-26.1 | \n", "-26.6 | \n", "\n", " | \n", " | \n", " | -0 | \n", "-19 | \n", "-7.1 | \n", "-0.5 | \n", "
NEU | \n", "\n", " | \n", " | 8 | \n", "-0 | \n", "-41.7 | \n", "-48.1 | \n", "-48.3 | \n", "\n", " | \n", " | \n", " | -0 | \n", "-41.7 | \n", "-6.4 | \n", "-0.2 | \n", "
SUN | \n", "\n", " | \n", " | 0 | \n", "-0.9 | \n", "0 | \n", "0 | \n", "0 | \n", "\n", " | \n", " | \n", " | -0.9 | \n", "0 | \n", "0 | \n", "0 | \n", "
SOR | \n", "\n", " | \n", " | 0 | \n", "-0.9 | \n", "-1.1 | \n", "-1.6 | \n", "0 | \n", "\n", " | \n", " | \n", " | -0.9 | \n", "-0.2 | \n", "-0.5 | \n", "0 | \n", "