Total personnel soignant.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import plotly\n",
    "import plotly.plotly as py\n",
    "#import  plotly.offline  as py\n",
    "import plotly.graph_objs as go\n",
    "from plotly import tools\n",
    "import plotly.graph_objs as graph_objs\n",
    "import json\n",
    "import os\n",
    "from mapboxgl.viz import *\n",
    "from mapboxgl.utils import *\n",
    "from colour import Color\n",
    "\n",
    "%matplotlib inline\n",
    "#py.init_notebook_mode(connected=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Spécialistes par qualification - ANATOMIE ET CYTOLOGIE-PATHOLOGIQUES - 2010</th>\n",
       "      <th>Spécialistes par qualification - ANESTHESIE-REANIMATION - 2010</th>\n",
       "      <th>Spécialistes par qualification - BIOLOGIE MEDICALE - 2010</th>\n",
       "      <th>Spécialistes par qualification - CARDIOLOGIE ET MALADIES VASCULAIRES - 2010</th>\n",
       "      <th>Spécialistes par qualification - CHIRURGIE GENERALE - 2010</th>\n",
       "      <th>Spécialistes par qualification - CHIRURGIE MAXILLO-FACIALE - 2010</th>\n",
       "      <th>Spécialistes par qualification - CHIRURGIE ORTHOPEDIQUE ET TRAUMATOLOGIE - 2010</th>\n",
       "      <th>Spécialistes par qualification - CHIRURGIE PLASTIQUE, RECONSTRUCTRICE ET ESTHETIQUE - 2010</th>\n",
       "      <th>Spécialistes par qualification - CHIRURGIE THORACIQUE ET CARDIO-VASCULAIRE - 2010</th>\n",
       "      <th>Spécialistes par qualification - CHIRURGIE UROLOGIQUE - 2010</th>\n",
       "      <th>...</th>\n",
       "      <th>Spécialistes par qualification - RHUMATOLOGIE - 2010</th>\n",
       "      <th>Spécialistes par qualification - SANTE PUBLIQUE ET MEDECINE SOCIALE - 2010</th>\n",
       "      <th>Spécialistes par qualification - STOMATOLOGIE - 2010</th>\n",
       "      <th>Spécialistes par qualification - CHIRURGIE DE LA FACE ET DU COU - 2010</th>\n",
       "      <th>Spécialistes par qualification - CHIRURGIE INFANTILE - 2010</th>\n",
       "      <th>Spécialistes par qualification - CHIRURGIE ORALE - 2010</th>\n",
       "      <th>Spécialistes par qualification - NEURO-PSYCHIATRIE - 2010</th>\n",
       "      <th>Spécialistes par qualification - ONCO-HEMATOLOGIE - 2010</th>\n",
       "      <th>Spécialistes par qualification - RADIODIAGNOSTIC ET RADIOTHERAPIE - 2010</th>\n",
       "      <th>Spécialistes par qualification - REANIMATION MEDICALE - 2010</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Code</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>01</th>\n",
       "      <td>4.0</td>\n",
       "      <td>34</td>\n",
       "      <td>7.0</td>\n",
       "      <td>17</td>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>12</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>02</th>\n",
       "      <td>3.0</td>\n",
       "      <td>38</td>\n",
       "      <td>11.0</td>\n",
       "      <td>30</td>\n",
       "      <td>21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>6.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>03</th>\n",
       "      <td>3.0</td>\n",
       "      <td>35</td>\n",
       "      <td>6.0</td>\n",
       "      <td>22</td>\n",
       "      <td>9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>16</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.0</td>\n",
       "      <td>...</td>\n",
       "      <td>14</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>04</th>\n",
       "      <td>2.0</td>\n",
       "      <td>14</td>\n",
       "      <td>5.0</td>\n",
       "      <td>11</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>05</th>\n",
       "      <td>3.0</td>\n",
       "      <td>28</td>\n",
       "      <td>5.0</td>\n",
       "      <td>12</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 49 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Spécialistes par qualification - ANATOMIE ET CYTOLOGIE-PATHOLOGIQUES - 2010  \\\n",
       "Code                                                                                \n",
       "01                                                  4.0                             \n",
       "02                                                  3.0                             \n",
       "03                                                  3.0                             \n",
       "04                                                  2.0                             \n",
       "05                                                  3.0                             \n",
       "\n",
       "      Spécialistes par qualification - ANESTHESIE-REANIMATION - 2010  \\\n",
       "Code                                                                   \n",
       "01                                                   34                \n",
       "02                                                   38                \n",
       "03                                                   35                \n",
       "04                                                   14                \n",
       "05                                                   28                \n",
       "\n",
       "      Spécialistes par qualification - BIOLOGIE MEDICALE - 2010  \\\n",
       "Code                                                              \n",
       "01                                                  7.0           \n",
       "02                                                 11.0           \n",
       "03                                                  6.0           \n",
       "04                                                  5.0           \n",
       "05                                                  5.0           \n",
       "\n",
       "      Spécialistes par qualification - CARDIOLOGIE ET MALADIES VASCULAIRES - 2010  \\\n",
       "Code                                                                                \n",
       "01                                                   17                             \n",
       "02                                                   30                             \n",
       "03                                                   22                             \n",
       "04                                                   11                             \n",
       "05                                                   12                             \n",
       "\n",
       "      Spécialistes par qualification - CHIRURGIE GENERALE - 2010  \\\n",
       "Code                                                               \n",
       "01                                                   10            \n",
       "02                                                   21            \n",
       "03                                                    9            \n",
       "04                                                    4            \n",
       "05                                                    6            \n",
       "\n",
       "      Spécialistes par qualification - CHIRURGIE MAXILLO-FACIALE - 2010  \\\n",
       "Code                                                                      \n",
       "01                                                  NaN                   \n",
       "02                                                  NaN                   \n",
       "03                                                  1.0                   \n",
       "04                                                  NaN                   \n",
       "05                                                  NaN                   \n",
       "\n",
       "      Spécialistes par qualification - CHIRURGIE ORTHOPEDIQUE ET TRAUMATOLOGIE - 2010  \\\n",
       "Code                                                                                    \n",
       "01                                                   14                                 \n",
       "02                                                   24                                 \n",
       "03                                                   16                                 \n",
       "04                                                    7                                 \n",
       "05                                                    7                                 \n",
       "\n",
       "      Spécialistes par qualification - CHIRURGIE PLASTIQUE, RECONSTRUCTRICE ET ESTHETIQUE - 2010  \\\n",
       "Code                                                                                               \n",
       "01                                                  1.0                                            \n",
       "02                                                  1.0                                            \n",
       "03                                                  3.0                                            \n",
       "04                                                  NaN                                            \n",
       "05                                                  NaN                                            \n",
       "\n",
       "      Spécialistes par qualification - CHIRURGIE THORACIQUE ET CARDIO-VASCULAIRE - 2010  \\\n",
       "Code                                                                                      \n",
       "01                                                  NaN                                   \n",
       "02                                                  NaN                                   \n",
       "03                                                  NaN                                   \n",
       "04                                                  NaN                                   \n",
       "05                                                  1.0                                   \n",
       "\n",
       "      Spécialistes par qualification - CHIRURGIE UROLOGIQUE - 2010  \\\n",
       "Code                                                                 \n",
       "01                                                  3.0              \n",
       "02                                                  5.0              \n",
       "03                                                  9.0              \n",
       "04                                                  1.0              \n",
       "05                                                  4.0              \n",
       "\n",
       "                                  ...                               \\\n",
       "Code                              ...                                \n",
       "01                                ...                                \n",
       "02                                ...                                \n",
       "03                                ...                                \n",
       "04                                ...                                \n",
       "05                                ...                                \n",
       "\n",
       "      Spécialistes par qualification - RHUMATOLOGIE - 2010  \\\n",
       "Code                                                         \n",
       "01                                                   12      \n",
       "02                                                   15      \n",
       "03                                                   14      \n",
       "04                                                    4      \n",
       "05                                                    3      \n",
       "\n",
       "      Spécialistes par qualification - SANTE PUBLIQUE ET MEDECINE SOCIALE - 2010  \\\n",
       "Code                                                                               \n",
       "01                                                  4.0                            \n",
       "02                                                  6.0                            \n",
       "03                                                  3.0                            \n",
       "04                                                  1.0                            \n",
       "05                                                  9.0                            \n",
       "\n",
       "      Spécialistes par qualification - STOMATOLOGIE - 2010  \\\n",
       "Code                                                         \n",
       "01                                                  3.0      \n",
       "02                                                  4.0      \n",
       "03                                                  3.0      \n",
       "04                                                  1.0      \n",
       "05                                                  1.0      \n",
       "\n",
       "      Spécialistes par qualification - CHIRURGIE DE LA FACE ET DU COU - 2010  \\\n",
       "Code                                                                           \n",
       "01                                                  NaN                        \n",
       "02                                                  NaN                        \n",
       "03                                                  NaN                        \n",
       "04                                                  NaN                        \n",
       "05                                                  NaN                        \n",
       "\n",
       "      Spécialistes par qualification - CHIRURGIE INFANTILE - 2010  \\\n",
       "Code                                                                \n",
       "01                                                  NaN             \n",
       "02                                                  NaN             \n",
       "03                                                  NaN             \n",
       "04                                                  NaN             \n",
       "05                                                  NaN             \n",
       "\n",
       "      Spécialistes par qualification - CHIRURGIE ORALE - 2010  \\\n",
       "Code                                                            \n",
       "01                                                  NaN         \n",
       "02                                                  NaN         \n",
       "03                                                  NaN         \n",
       "04                                                  NaN         \n",
       "05                                                  NaN         \n",
       "\n",
       "      Spécialistes par qualification - NEURO-PSYCHIATRIE - 2010  \\\n",
       "Code                                                              \n",
       "01                                                  NaN           \n",
       "02                                                  NaN           \n",
       "03                                                  1.0           \n",
       "04                                                  NaN           \n",
       "05                                                  NaN           \n",
       "\n",
       "      Spécialistes par qualification - ONCO-HEMATOLOGIE - 2010  \\\n",
       "Code                                                             \n",
       "01                                                  NaN          \n",
       "02                                                  NaN          \n",
       "03                                                  NaN          \n",
       "04                                                  NaN          \n",
       "05                                                  NaN          \n",
       "\n",
       "      Spécialistes par qualification - RADIODIAGNOSTIC ET RADIOTHERAPIE - 2010  \\\n",
       "Code                                                                             \n",
       "01                                                  NaN                          \n",
       "02                                                  NaN                          \n",
       "03                                                  NaN                          \n",
       "04                                                  NaN                          \n",
       "05                                                  NaN                          \n",
       "\n",
       "      Spécialistes par qualification - REANIMATION MEDICALE - 2010  \n",
       "Code                                                                \n",
       "01                                                  NaN             \n",
       "02                                                  3.0             \n",
       "03                                                  3.0             \n",
       "04                                                  NaN             \n",
       "05                                                  1.0             \n",
       "\n",
       "[5 rows x 49 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ds_2018 = pd.read_excel('total.xls')\n",
    "ds_2018 = ds_2018.set_index('Code')\n",
    "ds_2018 = ds_2018.drop('Départements', axis=1)\n",
    "ds_2018.head()\n",
    "ds_2010 = pd.read_excel('total_2010.xls')\n",
    "ds_2010 = ds_2010.set_index('Code')\n",
    "ds_2010 = ds_2010.drop('Départements', axis=1)\n",
    "\n",
    "ds_2010.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['ANATOMIE ET CYTOLOGIE-PATHOLOGIQUES',\n",
       " 'ANESTHESIE-REANIMATION',\n",
       " 'BIOLOGIE MEDICALE',\n",
       " 'CARDIOLOGIE ET MALADIES VASCULAIRES',\n",
       " 'CHIRURGIE DE LA FACE ET DU COU',\n",
       " 'CHIRURGIE GENERALE',\n",
       " 'CHIRURGIE INFANTILE',\n",
       " 'CHIRURGIE MAXILLO-FACIALE',\n",
       " 'CHIRURGIE ORALE',\n",
       " 'CHIRURGIE ORTHOPEDIQUE ET TRAUMATOLOGIE',\n",
       " 'CHIRURGIE PLASTIQUE, RECONSTRUCTRICE ET ESTHETIQUE',\n",
       " 'CHIRURGIE THORACIQUE ET CARDIO-VASCULAIRE',\n",
       " 'CHIRURGIE UROLOGIQUE',\n",
       " 'CHIRURGIE VASCULAIRE',\n",
       " 'CHIRURGIE VISCERALE ET DIGESTIVE',\n",
       " 'DERMATOLOGIE ET VENEREOLOGIE',\n",
       " 'ENDOCRINOLOGIE ET METABOLISME',\n",
       " 'GASTRO-ENTEROLOGIE ET HEPATOLOGIE',\n",
       " 'GENETIQUE MEDICALE',\n",
       " 'GERIATRIE',\n",
       " 'GYNECOLOGIE MEDICALE',\n",
       " 'GYNECOLOGIE MEDICALE ET OBSTETRIQUE - 2018',\n",
       " 'GYNECOLOGIE-OBSTETRIQUE',\n",
       " 'HEMATOLOGIE',\n",
       " 'MEDECINE DU TRAVAIL',\n",
       " 'MEDECINE GENERALE',\n",
       " 'MEDECINE INTERNE',\n",
       " 'MEDECINE NUCLEAIRE',\n",
       " 'MEDECINE PHYSIQUE ET DE READAPTATION',\n",
       " 'NEPHROLOGIE',\n",
       " 'NEURO-PSYCHIATRIE',\n",
       " 'NEUROCHIRURGIE',\n",
       " 'NEUROLOGIE',\n",
       " 'ONCO-HEMATOLOGIE',\n",
       " 'ONCOLOGIE MEDICALE',\n",
       " 'OPHTALMOLOGIE',\n",
       " 'ORL',\n",
       " 'PEDIATRIE',\n",
       " 'PNEUMOLOGIE',\n",
       " 'PSYCHIATRIE',\n",
       " \"PSYCHIATRIE DE L'ENFANT ET DE L'ADOLESCENT\",\n",
       " 'RADIODIAGNOSTIC ET IMAGERIE MEDICALE',\n",
       " 'RADIODIAGNOSTIC ET RADIOTHERAPIE',\n",
       " 'RADIOTHERAPIE ET ONCO-RADIOTHERAPIE',\n",
       " 'REANIMATION MEDICALE',\n",
       " 'RECHERCHE MEDICALE',\n",
       " 'RHUMATOLOGIE',\n",
       " 'SANTE PUBLIQUE ET MEDECINE SOCIALE',\n",
       " 'STOMATOLOGIE']"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ds_2018.columns = list(map(lambda x: x.replace('Spécialistes par qualification - ', ''), ds_2018.columns))\n",
    "ds_2018.columns = list(map(lambda x: x.replace(' - 2018', ''), ds_2018.columns))\n",
    "ds_2018.columns\n",
    "ds_2010.columns = list(map(lambda x: x.replace('Spécialistes par qualification - ', ''), ds_2010.columns))\n",
    "ds_2010.columns = list(map(lambda x: x.replace(' - 2010', ''), ds_2010.columns))\n",
    "sorted(list(ds_2010.columns))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ANATOMIE ET CYTOLOGIE-PATHOLOGIQUES                    1522.0\n",
       "ANESTHESIE-REANIMATION                                10066.0\n",
       "BIOLOGIE MEDICALE                                      2894.0\n",
       "CARDIOLOGIE ET MALADIES VASCULAIRES                    6209.0\n",
       "CHIRURGIE GENERALE                                     3134.0\n",
       "CHIRURGIE ORTHOPEDIQUE ET TRAUMATOLOGIE                3199.0\n",
       "CHIRURGIE PLASTIQUE, RECONSTRUCTRICE ET ESTHETIQUE      873.0\n",
       "CHIRURGIE THORACIQUE ET CARDIO-VASCULAIRE               462.0\n",
       "CHIRURGIE UROLOGIQUE                                   1243.0\n",
       "CHIRURGIE VASCULAIRE                                    493.0\n",
       "CHIRURGIE VISCERALE ET DIGESTIVE                       1020.0\n",
       "DERMATOLOGIE ET VENEREOLOGIE                           3316.0\n",
       "ENDOCRINOLOGIE ET METABOLISME                          1832.0\n",
       "GASTRO-ENTEROLOGIE ET HEPATOLOGIE                      3504.0\n",
       "GENETIQUE MEDICALE                                      247.0\n",
       "dtype: float64"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ds_2018.head()\n",
    "sum_2018 = ds_2018.sum()\n",
    "sum_2010 = ds_2010.sum()\n",
    "sum_2018.head(15)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "result = pd.concat([sum_2010, sum_2018], axis=1).dropna()\n",
    "result = result.drop('ONCO-HEMATOLOGIE')\n",
    "result['diff'] = ((result[1] - result[0]) / result[0])*100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "palette = list(Color('red').range_to(Color('green'), len(result)))\n",
    "unique = list(result['diff'].sort_values().unique())\n",
    "result['color'] = result['diff'].apply(lambda x: palette[unique.index(x)].hex)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<iframe id=\"igraph\" scrolling=\"no\" style=\"border:none;\" seamless=\"seamless\" src=\"https://plot.ly/~Wats0ns/96.embed\" height=\"525px\" width=\"100%\"></iframe>"
      ],
      "text/plain": [
       "<plotly.tools.PlotlyDisplay object>"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "layout = go.Layout(\n",
    "    xaxis=dict(\n",
    "        type='log',\n",
    "        autorange=True,\n",
    "        dtick=2,\n",
    "        title='Nombre de practiciens actuellement (2018)'\n",
    "    ),\n",
    "    yaxis=dict(\n",
    "        type='linear',\n",
    "        autorange=True,\n",
    "        dtick=10,\n",
    "        ticksuffix='%',\n",
    "        tickmode='array',\n",
    "        tickvals=[-100, -75, -50, -20, 20, 50, 100, 150, 200, 400],\n",
    "        title='Évolution de 2010 à 2018'\n",
    "    ),\n",
    "    hovermode='closest',\n",
    ")\n",
    "text = []\n",
    "for item in result.iterrows():\n",
    "    text.append(\"{name}<br>Evolution:{evolution:.2f}%<br>Total:{total}\".format(name=item[0], evolution=item[1][2], total=int(item[1][1]))) \n",
    "\n",
    "points = go.Scatter(\n",
    "        y=result['diff'],\n",
    "        x=result[1],\n",
    "        mode='markers',\n",
    "        marker=dict(\n",
    "            size=result[1]/np.mean(result[1]) * 40,\n",
    "            sizemode='area',\n",
    "            sizeref=2.*100/(40.**2),\n",
    "            sizemin=4,\n",
    "            color=result['color'],            #[[-100.0, 'rgb(165,0,38)'], [0.0, 'rgb(165,0,38)'], [100.0, 'rgb(165,0,38)']],\n",
    "        ),\n",
    "        hoverinfo=\"text\",\n",
    "        text=text,\n",
    ")\n",
    "data = [points]\n",
    "fig = go.Figure(data=data, layout=layout)\n",
    "py.iplot(fig, filename='total_practiciens')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}