experiments/01_grid/05_best_vs_worst_aligned_grid.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true,
    "pycharm": {
     "name": "#%% md\n"
    }
   },
   "source": [
    "# Comparing the best and the worst alignement for grids\n",
    "\n",
    "How sensitive are the grids to missalignment.\n",
    "We compare the best alignment of a grid to its worst."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   },
   "outputs": [],
   "source": [
    "from bisect import bisect\n",
    "\n",
    "from aemeasure import read_as_pd\n",
    "import os\n",
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "sns.set_theme()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   },
   "outputs": [],
   "source": [
    "from _utils import convert_to_percentage_interval\n",
    "\n",
    "from pcpptc import PolygonInstance, Solution\n",
    "from pcpptc.plot import setup_plot, plot_polygon_instance, plot_solution\n",
    "from pcpptc.plot.polgyon_instance import plot_coverage"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Loaded dataframe ./solutions/1.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 14:37:25.626364 and 2021-06-01 01:37:18.179121\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "Index(['instance', 'instance_path', 'runtime', 'timestamp', 'hostname', 'argv',\n",
       "       'git_revision', 'solver', 'solution', 'i', 'coverage', 'touring_cost',\n",
       "       'length', 'turn_sum', 'turn_factor'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "read_as_pd(\"./solutions/1.results.json\").columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Loaded dataframe ./solutions/75.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 09:56:32.369542 and 2021-05-30 23:12:51.253141\n",
      "Loaded dataframe ./solutions/156.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 15:40:10.168809 and 2021-06-02 05:39:33.243133\n",
      "Loaded dataframe ./solutions/119.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 12:59:00.092247 and 2021-05-31 04:52:30.695564\n",
      "Loaded dataframe ./solutions/173.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 16:46:18.925022 and 2021-06-01 05:44:43.928209\n",
      "Loaded dataframe ./solutions/144.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 10:03:49.638596 and 2021-05-30 23:25:05.968252\n",
      "Loaded dataframe ./solutions/185.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 19:44:53.863266 and 2021-06-02 03:48:34.655858\n",
      "Loaded dataframe ./solutions/154.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 10:35:54.058267 and 2021-05-31 11:26:07.922981\n",
      "Loaded dataframe ./solutions/12.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 16:06:17.976001 and 2021-06-01 14:17:40.968197\n",
      "Loaded dataframe ./solutions/197.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 11:22:36.958358 and 2021-05-31 10:36:48.403232\n",
      "Loaded dataframe ./solutions/86.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-26 22:51:38.692059 and 2021-05-29 18:17:30.910563\n",
      "Loaded dataframe ./solutions/35.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 18:15:05.480879 and 2021-06-02 06:51:39.239273\n",
      "Loaded dataframe ./solutions/74.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 14:51:19.517077 and 2021-06-01 01:54:50.299628\n",
      "Loaded dataframe ./solutions/57.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 09:46:35.023238 and 2021-05-31 10:58:58.890563\n",
      "Loaded dataframe ./solutions/58.results.json\n",
      "Executed on: ['algry02']\n",
      "During: 2021-05-28 17:41:41.539291 and 2021-05-30 13:27:55.120445\n",
      "Loaded dataframe ./solutions/14.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 09:46:24.513551 and 2021-05-30 23:07:20.282313\n",
      "Loaded dataframe ./solutions/3.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 15:47:49.114041 and 2021-06-01 17:00:44.628054\n",
      "Loaded dataframe ./solutions/36.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 11:05:59.067423 and 2021-05-31 10:15:11.696160\n",
      "Loaded dataframe ./solutions/80.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 10:50:09.457868 and 2021-05-31 11:41:23.635541\n",
      "Loaded dataframe ./solutions/70.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 10:08:50.282853 and 2021-05-30 15:18:17.455690\n",
      "Loaded dataframe ./solutions/45.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 19:39:34.700957 and 2021-06-02 03:39:56.248293\n",
      "Loaded dataframe ./solutions/21.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 16:21:50.840581 and 2021-06-02 07:37:30.564733\n",
      "Loaded dataframe ./solutions/17.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 15:51:32.614546 and 2021-06-01 17:09:50.954855\n",
      "Loaded dataframe ./solutions/125.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 09:46:18.746628 and 2021-05-31 02:00:00.155651\n",
      "Loaded dataframe ./solutions/101.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 14:41:19.050485 and 2021-06-01 16:23:38.444648\n",
      "Loaded dataframe ./solutions/16.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 10:49:31.112625 and 2021-05-30 04:52:37.596233\n",
      "Loaded dataframe ./solutions/52.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 10:40:33.521001 and 2021-05-31 04:35:54.948451\n",
      "Loaded dataframe ./solutions/167.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 15:00:24.070832 and 2021-06-01 02:03:13.412440\n",
      "Loaded dataframe ./solutions/131.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 10:52:42.906949 and 2021-05-31 00:02:35.679140\n",
      "Loaded dataframe ./solutions/149.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 11:48:23.147122 and 2021-05-30 05:41:13.445531\n",
      "Loaded dataframe ./solutions/92.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 01:25:45.139001 and 2021-05-29 23:34:20.393229\n",
      "Loaded dataframe ./solutions/84.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 10:18:27.390484 and 2021-05-30 23:54:01.140652\n",
      "Loaded dataframe ./solutions/158.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 15:24:11.019208 and 2021-05-30 08:59:51.998695\n",
      "Loaded dataframe ./solutions/41.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-26 20:02:34.012052 and 2021-05-29 15:34:03.435055\n",
      "Loaded dataframe ./solutions/174.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 15:08:53.382748 and 2021-06-01 16:38:30.416197\n",
      "Loaded dataframe ./solutions/191.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 15:11:35.947720 and 2021-06-02 01:09:59.630001\n",
      "Loaded dataframe ./solutions/181.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-26 19:27:44.572499 and 2021-05-29 15:21:04.197921\n",
      "Loaded dataframe ./solutions/29.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 12:47:00.553159 and 2021-06-01 00:20:22.602319\n",
      "Loaded dataframe ./solutions/76.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 16:54:04.039131 and 2021-06-01 19:08:42.744435\n",
      "Loaded dataframe ./solutions/130.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 11:51:06.690400 and 2021-05-31 15:02:15.833875\n",
      "Loaded dataframe ./solutions/118.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 15:33:41.727511 and 2021-05-31 21:32:51.228514\n",
      "Loaded dataframe ./solutions/38.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 17:28:34.050245 and 2021-06-01 06:14:14.037866\n",
      "Loaded dataframe ./solutions/68.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 16:54:35.513890 and 2021-06-02 05:57:13.013389\n",
      "Loaded dataframe ./solutions/143.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-26 19:02:31.291842 and 2021-05-29 14:30:57.210818\n",
      "Loaded dataframe ./solutions/79.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 14:49:22.609555 and 2021-06-01 20:20:46.398136\n",
      "Loaded dataframe ./solutions/5.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 14:10:10.975580 and 2021-05-30 18:01:27.384510\n",
      "Loaded dataframe ./solutions/180.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 16:02:22.852099 and 2021-06-02 07:28:24.776847\n",
      "Loaded dataframe ./solutions/99.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 16:11:43.573054 and 2021-06-01 15:50:45.197805\n",
      "Loaded dataframe ./solutions/161.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 10:04:07.236421 and 2021-05-30 04:05:55.679850\n",
      "Loaded dataframe ./solutions/136.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-26 18:55:02.805937 and 2021-05-29 14:27:09.220477\n",
      "Loaded dataframe ./solutions/115.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 15:25:46.012341 and 2021-06-01 16:52:38.289736\n",
      "Loaded dataframe ./solutions/153.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 16:14:36.547861 and 2021-06-01 21:22:43.162939\n",
      "Loaded dataframe ./solutions/11.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 14:29:48.633076 and 2021-05-30 18:05:04.385570\n",
      "Loaded dataframe ./solutions/32.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 11:50:56.785720 and 2021-05-31 22:16:24.995530\n",
      "Loaded dataframe ./solutions/121.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 10:43:12.693099 and 2021-05-31 11:31:43.173405\n",
      "Loaded dataframe ./solutions/189.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 14:39:38.030293 and 2021-05-30 18:17:28.828599\n",
      "Loaded dataframe ./solutions/50.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 05:07:19.702119 and 2021-05-30 00:04:37.366500\n",
      "Loaded dataframe ./solutions/1.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 14:37:25.626364 and 2021-06-01 01:37:18.179121\n",
      "Loaded dataframe ./solutions/193.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 15:29:22.118815 and 2021-05-31 21:28:14.830110\n",
      "Loaded dataframe ./solutions/96.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 20:43:49.845000 and 2021-06-02 04:36:08.626157\n",
      "Loaded dataframe ./solutions/49.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 09:46:26.905002 and 2021-05-30 18:29:28.792106\n",
      "Loaded dataframe ./solutions/9.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 19:54:30.759068 and 2021-06-02 04:07:56.275416\n",
      "Loaded dataframe ./solutions/48.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 12:17:11.797420 and 2021-05-31 22:43:01.558986\n",
      "Loaded dataframe ./solutions/129.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 15:43:20.392215 and 2021-06-01 16:57:40.104637\n",
      "Loaded dataframe ./solutions/146.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-26 22:42:36.535035 and 2021-05-29 17:55:28.962218\n",
      "Loaded dataframe ./solutions/127.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-26 23:39:05.423452 and 2021-05-29 19:55:23.073227\n",
      "Loaded dataframe ./solutions/44.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 09:04:15.527396 and 2021-05-30 03:10:09.736934\n",
      "Loaded dataframe ./solutions/194.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 16:50:02.209126 and 2021-06-02 08:03:06.570406\n",
      "Loaded dataframe ./solutions/145.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 11:37:37.530798 and 2021-05-31 14:55:14.766020\n",
      "Loaded dataframe ./solutions/53.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 14:15:06.051769 and 2021-05-31 21:24:31.633506\n",
      "Loaded dataframe ./solutions/169.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 11:17:53.372186 and 2021-05-31 10:19:08.476528\n",
      "Loaded dataframe ./solutions/132.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 17:00:27.710137 and 2021-06-01 19:15:33.882564\n",
      "Loaded dataframe ./solutions/188.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 12:43:53.984484 and 2021-05-31 23:32:31.607876\n",
      "Loaded dataframe ./solutions/46.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 09:46:48.192705 and 2021-05-31 06:40:19.429954\n",
      "Loaded dataframe ./solutions/13.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 15:19:47.596514 and 2021-05-30 08:47:09.942776\n",
      "Loaded dataframe ./solutions/114.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 09:34:42.988832 and 2021-05-30 03:57:32.448347\n",
      "Loaded dataframe ./solutions/104.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 19:17:26.649722 and 2021-06-01 12:04:42.464563\n",
      "Loaded dataframe ./solutions/59.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 12:52:24.558680 and 2021-06-01 02:10:38.189497\n",
      "Loaded dataframe ./solutions/71.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 17:41:30.745554 and 2021-06-01 06:22:55.304874\n",
      "Loaded dataframe ./solutions/7.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 15:04:30.886272 and 2021-05-30 08:43:27.323302\n",
      "Loaded dataframe ./solutions/122.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-26 16:18:05.892465 and 2021-05-29 13:11:38.845081\n",
      "Loaded dataframe ./solutions/170.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 14:10:31.275748 and 2021-05-30 07:47:28.696039\n",
      "Loaded dataframe ./solutions/47.results.json\n",
      "Executed on: ['algry02']\n",
      "During: 2021-05-28 23:29:41.311446 and 2021-05-31 21:51:11.276482\n",
      "Loaded dataframe ./solutions/179.results.json\n",
      "Executed on: ['algry02']\n",
      "During: 2021-05-28 23:26:26.668222 and 2021-05-31 21:46:55.886142\n",
      "Loaded dataframe ./solutions/168.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 12:27:33.612684 and 2021-05-31 14:15:38.394281\n",
      "Loaded dataframe ./solutions/126.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 15:05:21.448213 and 2021-06-01 20:22:20.905295\n",
      "Loaded dataframe ./solutions/135.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 09:46:20.407460 and 2021-05-31 11:52:23.601931\n",
      "Loaded dataframe ./solutions/134.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 09:46:16.731364 and 2021-05-31 09:03:09.903264\n",
      "Loaded dataframe ./solutions/199.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 13:01:13.669200 and 2021-06-01 02:18:18.178071\n",
      "Loaded dataframe ./solutions/62.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 14:43:22.807582 and 2021-06-01 17:16:20.629217\n",
      "Loaded dataframe ./solutions/83.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-26 19:06:57.959214 and 2021-05-29 14:38:52.537957\n",
      "Loaded dataframe ./solutions/6.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 16:02:01.891530 and 2021-06-01 14:13:55.022096\n",
      "Loaded dataframe ./solutions/64.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 11:24:56.503143 and 2021-05-30 17:44:48.328830\n",
      "Loaded dataframe ./solutions/22.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 10:11:45.597645 and 2021-05-31 11:11:23.687313\n",
      "Loaded dataframe ./solutions/66.results.json\n",
      "Executed on: ['algry02']\n",
      "During: 2021-05-28 14:50:05.540732 and 2021-05-30 10:48:59.639644\n",
      "Loaded dataframe ./solutions/94.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 10:25:42.228422 and 2021-05-31 11:19:51.780474\n",
      "Loaded dataframe ./solutions/54.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 16:32:33.035020 and 2021-06-02 07:53:11.534105\n",
      "Loaded dataframe ./solutions/163.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 10:37:20.145809 and 2021-05-30 19:03:28.389131\n",
      "Loaded dataframe ./solutions/160.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 15:41:32.993636 and 2021-06-01 16:54:03.184078\n",
      "Loaded dataframe ./solutions/186.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 14:41:40.405317 and 2021-05-31 06:07:10.715231\n",
      "Loaded dataframe ./solutions/137.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 17:14:15.487718 and 2021-06-02 06:08:03.612624\n",
      "Loaded dataframe ./solutions/0.results.json\n",
      "Executed on: ['algry02']\n",
      "During: 2021-05-28 23:07:39.861315 and 2021-05-30 22:58:30.036732\n",
      "Loaded dataframe ./solutions/97.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-26 17:34:56.526647 and 2021-05-29 14:15:27.666997\n",
      "Loaded dataframe ./solutions/40.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 18:18:06.157664 and 2021-06-02 07:12:06.744627\n",
      "Loaded dataframe ./solutions/88.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 14:52:23.642057 and 2021-06-01 18:26:53.121439\n",
      "Loaded dataframe ./solutions/61.results.json\n",
      "Executed on: ['algry02']\n",
      "During: 2021-05-28 19:35:09.707069 and 2021-05-30 22:55:05.800179\n",
      "Loaded dataframe ./solutions/196.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 11:07:01.483478 and 2021-05-31 14:36:02.812409\n",
      "Loaded dataframe ./solutions/93.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 15:44:46.593857 and 2021-06-01 21:19:57.040048\n",
      "Loaded dataframe ./solutions/39.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 09:46:30.937784 and 2021-05-30 14:15:55.362367\n",
      "Loaded dataframe ./solutions/73.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 14:57:03.591352 and 2021-06-01 14:10:15.833193\n",
      "Loaded dataframe ./solutions/91.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 11:59:53.134050 and 2021-05-31 15:41:34.873400\n",
      "Loaded dataframe ./solutions/112.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 13:12:47.065285 and 2021-06-01 05:25:08.117855\n",
      "Loaded dataframe ./solutions/142.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 17:36:48.650290 and 2021-06-02 06:49:19.154868\n",
      "Loaded dataframe ./solutions/110.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 13:58:16.448038 and 2021-06-01 10:41:40.520291\n",
      "Loaded dataframe ./solutions/10.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 13:35:31.179854 and 2021-06-01 07:06:10.338777\n",
      "Loaded dataframe ./solutions/28.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 10:59:24.345431 and 2021-05-30 19:31:18.035851\n",
      "Loaded dataframe ./solutions/37.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 12:02:34.109415 and 2021-05-31 14:09:49.925876\n",
      "Loaded dataframe ./solutions/65.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 13:04:18.568701 and 2021-06-01 06:30:30.555635\n",
      "Loaded dataframe ./solutions/133.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-26 22:00:54.469959 and 2021-05-29 17:48:01.921427\n",
      "Loaded dataframe ./solutions/77.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 12:31:58.972622 and 2021-05-30 06:18:33.848059\n",
      "Loaded dataframe ./solutions/183.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 09:52:22.195613 and 2021-05-31 09:33:55.509282\n",
      "Loaded dataframe ./solutions/98.results.json\n",
      "Executed on: ['algry02']\n",
      "During: 2021-05-28 13:29:28.236111 and 2021-05-30 10:13:25.290402\n",
      "Loaded dataframe ./solutions/128.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 10:39:38.501402 and 2021-05-30 04:36:54.591786\n",
      "Loaded dataframe ./solutions/107.results.json\n",
      "Executed on: ['algry02']\n",
      "During: 2021-05-28 18:43:21.570207 and 2021-05-30 13:56:10.073274\n",
      "Loaded dataframe ./solutions/24.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 16:18:07.058790 and 2021-06-01 21:39:08.648387\n",
      "Loaded dataframe ./solutions/166.results.json\n",
      "Executed on: ['algry02']\n",
      "During: 2021-05-28 15:27:08.691970 and 2021-05-30 11:56:48.762184\n",
      "Loaded dataframe ./solutions/85.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 11:31:56.371921 and 2021-05-31 14:44:00.868481\n",
      "Loaded dataframe ./solutions/81.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 11:30:09.492572 and 2021-05-31 08:58:11.700991\n",
      "Loaded dataframe ./solutions/90.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 11:08:31.647594 and 2021-05-31 01:54:54.793743\n",
      "Loaded dataframe ./solutions/139.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 14:19:30.688333 and 2021-05-30 08:17:09.998517\n",
      "Loaded dataframe ./solutions/78.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-26 23:16:16.141124 and 2021-05-29 18:37:23.622452\n",
      "Loaded dataframe ./solutions/165.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 18:20:29.386180 and 2021-06-01 11:30:27.894314\n",
      "Loaded dataframe ./solutions/164.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 13:54:01.278001 and 2021-05-30 07:34:39.408195\n",
      "Loaded dataframe ./solutions/87.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 17:08:44.606877 and 2021-06-01 19:50:41.745523\n",
      "Loaded dataframe ./solutions/116.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 10:39:47.482017 and 2021-05-30 19:20:04.484902\n",
      "Loaded dataframe ./solutions/141.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 10:55:06.356491 and 2021-05-31 07:35:44.198117\n",
      "Loaded dataframe ./solutions/182.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 10:05:16.791909 and 2021-05-31 13:42:17.158473\n",
      "Loaded dataframe ./solutions/60.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 13:16:24.984107 and 2021-06-01 01:34:52.849849\n",
      "Loaded dataframe ./solutions/184.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 07:20:28.202489 and 2021-05-30 03:06:36.600698\n",
      "Loaded dataframe ./solutions/171.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 19:56:41.261588 and 2021-06-01 12:22:43.087720\n",
      "Loaded dataframe ./solutions/100.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 09:08:22.127863 and 2021-05-30 03:14:26.900263\n",
      "Loaded dataframe ./solutions/2.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 10:14:52.862518 and 2021-05-30 04:28:14.409791\n",
      "Loaded dataframe ./solutions/178.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 14:32:41.380717 and 2021-05-31 06:05:50.623910\n",
      "Loaded dataframe ./solutions/69.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-26 17:43:41.233511 and 2021-05-29 14:20:53.731814\n",
      "Loaded dataframe ./solutions/176.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 12:11:41.715742 and 2021-05-31 22:20:47.240877\n",
      "Loaded dataframe ./solutions/102.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 10:00:35.855804 and 2021-05-30 19:01:34.063442\n",
      "Loaded dataframe ./solutions/67.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 17:52:58.454589 and 2021-06-01 16:00:31.440436\n",
      "Loaded dataframe ./solutions/148.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 16:14:02.645394 and 2021-06-01 19:03:15.869298\n",
      "Loaded dataframe ./solutions/140.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 11:02:00.828034 and 2021-05-31 11:45:36.126197\n",
      "Loaded dataframe ./solutions/151.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 12:47:51.401374 and 2021-05-31 17:18:47.658950\n",
      "Loaded dataframe ./solutions/4.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 13:13:52.918027 and 2021-06-01 06:48:29.558056\n",
      "Loaded dataframe ./solutions/123.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 20:15:06.563912 and 2021-06-02 04:32:55.947392\n",
      "Loaded dataframe ./solutions/157.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-26 17:23:22.503568 and 2021-05-29 14:04:46.048330\n",
      "Loaded dataframe ./solutions/55.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-26 21:53:51.327337 and 2021-05-29 17:10:12.315642\n",
      "Loaded dataframe ./solutions/192.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 09:52:53.015873 and 2021-05-31 02:40:46.933775\n",
      "Loaded dataframe ./solutions/195.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-26 21:14:26.911807 and 2021-05-29 17:04:29.707224\n",
      "Loaded dataframe ./solutions/26.results.json\n",
      "Executed on: ['algry02']\n",
      "During: 2021-05-28 23:13:18.163232 and 2021-05-31 21:44:15.914624\n",
      "Loaded dataframe ./solutions/124.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 11:13:08.635867 and 2021-05-31 20:14:20.437843\n",
      "Loaded dataframe ./solutions/198.results.json\n",
      "Executed on: ['algry02']\n",
      "During: 2021-05-28 16:38:39.016299 and 2021-05-30 12:51:08.303218\n",
      "Loaded dataframe ./solutions/147.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 17:49:57.989952 and 2021-06-01 20:07:00.450571\n",
      "Loaded dataframe ./solutions/111.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 12:43:41.668552 and 2021-05-30 07:25:21.745920\n",
      "Loaded dataframe ./solutions/162.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 13:45:38.160434 and 2021-05-31 23:47:42.392681\n",
      "Loaded dataframe ./solutions/63.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 11:07:31.328334 and 2021-05-30 05:29:11.837230\n",
      "Loaded dataframe ./solutions/82.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 17:26:25.071335 and 2021-06-02 06:17:04.439951\n",
      "Loaded dataframe ./solutions/150.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 11:02:30.860090 and 2021-05-31 00:06:24.737175\n",
      "Loaded dataframe ./solutions/187.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 11:43:03.001940 and 2021-05-31 21:57:35.158952\n",
      "Loaded dataframe ./solutions/72.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 14:51:56.496909 and 2021-05-30 08:28:51.581681\n",
      "Loaded dataframe ./solutions/31.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 05:36:10.397925 and 2021-05-30 01:41:24.735731\n",
      "Loaded dataframe ./solutions/25.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 05:01:03.118215 and 2021-05-29 23:37:07.478294\n",
      "Loaded dataframe ./solutions/34.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-26 19:15:56.759216 and 2021-05-29 14:49:05.169304\n",
      "Loaded dataframe ./solutions/108.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 11:01:43.417862 and 2021-05-31 10:04:51.442858\n",
      "Loaded dataframe ./solutions/105.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 14:04:44.372128 and 2021-05-30 07:39:38.498560\n",
      "Loaded dataframe ./solutions/42.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 09:54:19.759852 and 2021-05-31 12:00:27.371180\n",
      "Loaded dataframe ./solutions/155.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 10:37:59.569441 and 2021-05-31 06:57:04.261828\n",
      "Loaded dataframe ./solutions/138.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 13:59:31.629513 and 2021-06-01 13:12:05.508892\n",
      "Loaded dataframe ./solutions/51.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 16:39:53.742385 and 2021-06-01 23:44:53.957436\n",
      "Loaded dataframe ./solutions/95.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 10:44:39.713586 and 2021-05-31 07:03:29.834559\n",
      "Loaded dataframe ./solutions/8.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-26 16:50:59.134774 and 2021-05-29 13:54:57.174388\n",
      "Loaded dataframe ./solutions/103.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 13:40:37.780117 and 2021-05-31 23:36:39.106038\n",
      "Loaded dataframe ./solutions/43.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 10:27:48.358465 and 2021-05-31 10:01:17.437229\n",
      "Loaded dataframe ./solutions/177.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 14:34:07.402649 and 2021-05-30 18:09:27.764972\n",
      "Loaded dataframe ./solutions/33.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 10:24:39.038722 and 2021-05-31 06:51:34.110914\n",
      "Loaded dataframe ./solutions/15.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 14:40:19.021225 and 2021-06-01 01:46:59.300089\n",
      "Loaded dataframe ./solutions/23.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 11:28:06.578144 and 2021-05-31 14:39:25.034538\n",
      "Loaded dataframe ./solutions/109.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 11:55:45.041140 and 2021-05-31 13:48:08.824244\n",
      "Loaded dataframe ./solutions/89.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 12:02:50.983623 and 2021-05-30 06:08:42.607730\n",
      "Loaded dataframe ./solutions/56.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 12:34:22.761018 and 2021-05-31 14:17:42.262156\n",
      "Loaded dataframe ./solutions/30.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 16:53:26.492791 and 2021-06-02 03:35:23.165488\n",
      "Loaded dataframe ./solutions/117.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 12:37:00.958626 and 2021-05-31 23:56:03.906762\n",
      "Loaded dataframe ./solutions/175.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 09:13:50.010830 and 2021-05-30 03:32:14.990254\n",
      "Loaded dataframe ./solutions/120.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 10:52:19.003574 and 2021-05-31 07:05:26.270082\n",
      "Loaded dataframe ./solutions/20.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-26 20:17:37.774161 and 2021-05-29 16:28:08.309237\n",
      "Loaded dataframe ./solutions/113.results.json\n",
      "Executed on: ['algry02']\n",
      "During: 2021-05-28 18:22:49.500589 and 2021-05-30 13:41:01.666115\n",
      "Loaded dataframe ./solutions/19.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 01:01:04.913401 and 2021-05-29 19:59:22.207687\n",
      "Loaded dataframe ./solutions/106.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 17:08:01.518018 and 2021-06-01 06:02:45.782953\n",
      "Loaded dataframe ./solutions/172.results.json\n",
      "Executed on: ['algry02']\n",
      "During: 2021-05-28 18:37:04.073668 and 2021-05-30 13:46:28.398568\n",
      "Loaded dataframe ./solutions/18.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 15:07:46.160767 and 2021-06-01 20:54:03.575202\n",
      "Loaded dataframe ./solutions/27.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 13:18:33.751521 and 2021-05-31 05:57:57.946164\n",
      "Loaded dataframe ./solutions/152.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 01:05:49.583897 and 2021-05-29 20:15:41.874970\n",
      "Loaded dataframe ./solutions/159.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-21 17:46:24.278878 and 2021-06-01 15:56:36.688071\n",
      "Loaded dataframe ./solutions/190.results.json\n",
      "Executed on: ['algry01' 'algry02']\n",
      "During: 2021-05-27 05:04:06.041238 and 2021-05-29 23:39:44.058165\n"
     ]
    }
   ],
   "source": [
    "tables = []\n",
    "for f in os.listdir(\"./solutions\"):\n",
    "    if not f.endswith(\".results.json\"):\n",
    "        continue\n",
    "    f = os.path.join(\"./solutions\", f)\n",
    "    tables.append(read_as_pd(f))\n",
    "\n",
    "data = pd.concat(tables, ignore_index=True)\n",
    "# data.dropna(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Grid\n",
       "Hexagonal, Line-based     200\n",
       "Hexagonal, Point-based    139\n",
       "Square, Line-based        200\n",
       "Square, Point-based       139\n",
       "Name: instance, dtype: int64"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def descr(solver):\n",
    "    if \"hex\" in solver.lower():\n",
    "        type = \"Hexagonal\"\n",
    "    elif \"square\" in solver.lower():\n",
    "        type = \"Square\"\n",
    "    else:\n",
    "        raise ValueError(f\"Could not detect type of {solver}\")\n",
    "    if \"pb=True\" in solver or \"point_based=True\" in solver:\n",
    "        d = \"Point-based\"\n",
    "    elif \"pb=False\" in solver or \"point_based=False\" in solver:\n",
    "        d = \"Line-based\"\n",
    "    else:\n",
    "        raise ValueError(f\"Could not detect base of {solver}\")\n",
    "    return f\"{type}, {d}\"\n",
    "\n",
    "\n",
    "data[\"Grid\"] = data[\"solver\"].apply(descr)\n",
    "\n",
    "data.groupby(\"Grid\")[\"instance\"].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   },
   "outputs": [],
   "source": [
    "data.dropna(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   },
   "outputs": [],
   "source": [
    "# add instance area\n",
    "instance_paths = list(data[\"instance_path\"].unique())\n",
    "instances = [PolygonInstance.from_json(file_path=f) for f in instance_paths]\n",
    "instance_areas = pd.DataFrame(\n",
    "    data={\"area\": [i.original_area.area for i in instances]}, index=instance_paths\n",
    ")\n",
    "data = data.merge(instance_areas, left_on=\"instance_path\", right_index=True)\n",
    "data[\"relative_coverage\"] = 100 * data[\"coverage\"] / data[\"area\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>instance</th>\n",
       "      <th>Grid</th>\n",
       "      <th>touring_cost_min</th>\n",
       "      <th>touring_cost_max</th>\n",
       "      <th>diff</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Hexagonal, Line-based</td>\n",
       "      <td>458.543796</td>\n",
       "      <td>691.884979</td>\n",
       "      <td>50.887436</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>Square, Line-based</td>\n",
       "      <td>489.389372</td>\n",
       "      <td>869.187125</td>\n",
       "      <td>77.606457</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>Hexagonal, Line-based</td>\n",
       "      <td>605.740807</td>\n",
       "      <td>1008.015307</td>\n",
       "      <td>66.410335</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>Hexagonal, Point-based</td>\n",
       "      <td>818.265721</td>\n",
       "      <td>1112.097697</td>\n",
       "      <td>35.909115</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>Square, Line-based</td>\n",
       "      <td>563.911486</td>\n",
       "      <td>1478.412496</td>\n",
       "      <td>162.171020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>673</th>\n",
       "      <td>98</td>\n",
       "      <td>Square, Line-based</td>\n",
       "      <td>14087.698328</td>\n",
       "      <td>22989.850828</td>\n",
       "      <td>63.190965</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>674</th>\n",
       "      <td>99</td>\n",
       "      <td>Hexagonal, Line-based</td>\n",
       "      <td>3428.514300</td>\n",
       "      <td>4751.984464</td>\n",
       "      <td>38.601856</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>675</th>\n",
       "      <td>99</td>\n",
       "      <td>Hexagonal, Point-based</td>\n",
       "      <td>4525.093461</td>\n",
       "      <td>4797.503462</td>\n",
       "      <td>6.019986</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>676</th>\n",
       "      <td>99</td>\n",
       "      <td>Square, Line-based</td>\n",
       "      <td>3503.858377</td>\n",
       "      <td>6833.882812</td>\n",
       "      <td>95.038785</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>677</th>\n",
       "      <td>99</td>\n",
       "      <td>Square, Point-based</td>\n",
       "      <td>4941.113126</td>\n",
       "      <td>6465.884058</td>\n",
       "      <td>30.858855</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>678 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    instance                    Grid  touring_cost_min  touring_cost_max  \\\n",
       "0          0   Hexagonal, Line-based        458.543796        691.884979   \n",
       "1          0      Square, Line-based        489.389372        869.187125   \n",
       "2          1   Hexagonal, Line-based        605.740807       1008.015307   \n",
       "3          1  Hexagonal, Point-based        818.265721       1112.097697   \n",
       "4          1      Square, Line-based        563.911486       1478.412496   \n",
       "..       ...                     ...               ...               ...   \n",
       "673       98      Square, Line-based      14087.698328      22989.850828   \n",
       "674       99   Hexagonal, Line-based       3428.514300       4751.984464   \n",
       "675       99  Hexagonal, Point-based       4525.093461       4797.503462   \n",
       "676       99      Square, Line-based       3503.858377       6833.882812   \n",
       "677       99     Square, Point-based       4941.113126       6465.884058   \n",
       "\n",
       "           diff  \n",
       "0     50.887436  \n",
       "1     77.606457  \n",
       "2     66.410335  \n",
       "3     35.909115  \n",
       "4    162.171020  \n",
       "..          ...  \n",
       "673   63.190965  \n",
       "674   38.601856  \n",
       "675    6.019986  \n",
       "676   95.038785  \n",
       "677   30.858855  \n",
       "\n",
       "[678 rows x 5 columns]"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "best_aligned = data.groupby([\"instance\", \"Grid\"])[[\"touring_cost\"]].min()\n",
    "worst_aligned = data.groupby([\"instance\", \"Grid\"])[[\"touring_cost\"]].max()\n",
    "t = best_aligned.merge(\n",
    "    right=worst_aligned, suffixes=(\"_min\", \"_max\"), left_index=True, right_index=True\n",
    ").reset_index()\n",
    "t[\"diff\"] = (100 * t[\"touring_cost_max\"] / t[\"touring_cost_min\"]) - 100\n",
    "t"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   },
   "outputs": [],
   "source": [
    "# add instance information\n",
    "\n",
    "instance_data = data.groupby([\"instance\"])[[\"area\", \"turn_factor\"]].min()\n",
    "t = t.merge(right=instance_data, left_on=\"instance\", right_index=True)\n",
    "t.sort_values([\"Grid\"], inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   },
   "outputs": [],
   "source": [
    "data_area_interval = convert_to_percentage_interval(t, on_column=\"area\", percentage=5)\n",
    "data_area_interval.sort_values(by=[\"Grid\"], ascending=False, inplace=True)\n",
    "\n",
    "\n",
    "def rename(x):\n",
    "    return x if \"Square\" in x else x.replace(\"Hexagonal\", \"Triangular\")\n",
    "\n",
    "\n",
    "data_area_interval[\"Grid\"] = data_area_interval[\"Grid\"].apply(rename)\n",
    "t[\"Grid\"] = t[\"Grid\"].apply(rename)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   },
   "outputs": [],
   "source": [
    "plt.figure(figsize=(5, 3.5))\n",
    "sns.lineplot(data=data_area_interval, x=\"area\", y=\"diff\", hue=\"Grid\")\n",
    "plt.legend(loc=\"upper right\")\n",
    "plt.ylabel(\"Difference of touring cost (%)\")\n",
    "plt.xlabel(\"Area ±5%\")\n",
    "plt.title(\"Lower is better\")\n",
    "plt.legend(loc=\"upper left\")\n",
    "plt.tight_layout()\n",
    "plt.savefig(\"././output/05_best_vs_worst_area.pdf\")\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   },
   "outputs": [],
   "source": [
    "plt.figure(figsize=(5, 3.5))\n",
    "sns.boxplot(data=t, x=\"turn_factor\", y=\"diff\", hue=\"Grid\")\n",
    "plt.ylabel(\"Difference of touring cost (%)\")\n",
    "plt.xlabel(\"Optimization Weight of Turn-Cost\")\n",
    "plt.title(\"Lower is better\")\n",
    "plt.legend(loc=\"upper right\")\n",
    "# plt.gca().get_legend().remove()\n",
    "plt.tight_layout()\n",
    "plt.savefig(\"././output/05_best_vs_worst_turn_factor.pdf\")\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Grid\n",
       "Hexagonal, Line-based     200\n",
       "Hexagonal, Point-based    139\n",
       "Square, Line-based        200\n",
       "Square, Point-based       139\n",
       "Name: instance, dtype: int64"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.groupby([\"Grid\"])[\"instance\"].nunique()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}