Pandas-and-Requests-Example.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Read csv into pandas - CrossRef example from OpenRefine lesson\n",
    "data = pandas.read_csv(\"https://raw.githubusercontent.com/LibraryCarpentry/lc-open-refine/gh-pages/data/doaj-article-sample.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "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>Title</th>\n",
       "      <th>Authors</th>\n",
       "      <th>DOI</th>\n",
       "      <th>URL</th>\n",
       "      <th>Date</th>\n",
       "      <th>Language</th>\n",
       "      <th>Subjects</th>\n",
       "      <th>ISSNs</th>\n",
       "      <th>Publisher</th>\n",
       "      <th>Citation</th>\n",
       "      <th>Licence</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The Fisher Thermodynamics of Quasi-Probabilities</td>\n",
       "      <td>Flavia Pennini|Angelo Plastino</td>\n",
       "      <td>10.3390/e17127853</td>\n",
       "      <td>https://doaj.org/article/b75e8d5cca3f46cbbd63e...</td>\n",
       "      <td>01/11/2015</td>\n",
       "      <td>English</td>\n",
       "      <td>Fisher information|quasi-probabilities|complem...</td>\n",
       "      <td>1099-4300</td>\n",
       "      <td>MDPI AG</td>\n",
       "      <td>Entropy, Vol 17, Iss 12, Pp 7848-7858 (2015)</td>\n",
       "      <td>CC BY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Aflatoxin Contamination of the Milk Supply: A ...</td>\n",
       "      <td>Naveed Aslam|Peter C. Wynn</td>\n",
       "      <td>10.3390/agriculture5041172</td>\n",
       "      <td>https://doaj.org/article/0edc5af6672641c0bd456...</td>\n",
       "      <td>01/11/2015</td>\n",
       "      <td>English</td>\n",
       "      <td>aflatoxins|AFM1|AFB1|milk marketing chains|hep...</td>\n",
       "      <td>2077-0472</td>\n",
       "      <td>MDPI AG</td>\n",
       "      <td>Agriculture (Basel), Vol 5, Iss 4, Pp 1172-118...</td>\n",
       "      <td>CC BY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Metagenomic Analysis of Upwelling-Affected Bra...</td>\n",
       "      <td>Rafael R. C. Cuadrat|Juliano C. Cury|Alberto M...</td>\n",
       "      <td>10.3390/ijms161226101</td>\n",
       "      <td>https://doaj.org/article/d9fe469f75a0442382b84...</td>\n",
       "      <td>01/11/2015</td>\n",
       "      <td>English</td>\n",
       "      <td>PKS|NRPS|metagenomics|environmental genomics|u...</td>\n",
       "      <td>1422-0067</td>\n",
       "      <td>MDPI AG</td>\n",
       "      <td>International Journal of Molecular Sciences, V...</td>\n",
       "      <td>CC BY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Synthesis and Reactivity of a Cerium(III) Scor...</td>\n",
       "      <td>Fabrizio Ortu|Hao Zhu|Marie-Emmanuelle Boulon|...</td>\n",
       "      <td>10.3390/inorganics3040534</td>\n",
       "      <td>https://doaj.org/article/95606ed39deb4f43b96f7...</td>\n",
       "      <td>01/11/2015</td>\n",
       "      <td>EN</td>\n",
       "      <td>lanthanide|cerium|scorpionate|tris(pyrazolyl)b...</td>\n",
       "      <td>2304-6740</td>\n",
       "      <td>MDPI AG</td>\n",
       "      <td>Inorganics (Basel), Vol 3, Iss 4, Pp 534-553 (...</td>\n",
       "      <td>CC BY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Performance and Uncertainty Evaluation of Snow...</td>\n",
       "      <td>Magali Troin|Richard Arsenault|François Brissette</td>\n",
       "      <td>10.3390/hydrology2040289</td>\n",
       "      <td>https://doaj.org/article/18b1d70730d44573ab5c2...</td>\n",
       "      <td>01/11/2015</td>\n",
       "      <td>EN</td>\n",
       "      <td>snow models|hydrological models|snowmelt|uncer...</td>\n",
       "      <td>2306-5338</td>\n",
       "      <td>MDPI AG</td>\n",
       "      <td>Hydrology, Vol 2, Iss 4, Pp 289-317 (2015)</td>\n",
       "      <td>CC BY</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               Title  \\\n",
       "0   The Fisher Thermodynamics of Quasi-Probabilities   \n",
       "1  Aflatoxin Contamination of the Milk Supply: A ...   \n",
       "2  Metagenomic Analysis of Upwelling-Affected Bra...   \n",
       "3  Synthesis and Reactivity of a Cerium(III) Scor...   \n",
       "4  Performance and Uncertainty Evaluation of Snow...   \n",
       "\n",
       "                                             Authors  \\\n",
       "0                     Flavia Pennini|Angelo Plastino   \n",
       "1                         Naveed Aslam|Peter C. Wynn   \n",
       "2  Rafael R. C. Cuadrat|Juliano C. Cury|Alberto M...   \n",
       "3  Fabrizio Ortu|Hao Zhu|Marie-Emmanuelle Boulon|...   \n",
       "4  Magali Troin|Richard Arsenault|François Brissette   \n",
       "\n",
       "                          DOI  \\\n",
       "0           10.3390/e17127853   \n",
       "1  10.3390/agriculture5041172   \n",
       "2       10.3390/ijms161226101   \n",
       "3   10.3390/inorganics3040534   \n",
       "4    10.3390/hydrology2040289   \n",
       "\n",
       "                                                 URL        Date Language  \\\n",
       "0  https://doaj.org/article/b75e8d5cca3f46cbbd63e...  01/11/2015  English   \n",
       "1  https://doaj.org/article/0edc5af6672641c0bd456...  01/11/2015  English   \n",
       "2  https://doaj.org/article/d9fe469f75a0442382b84...  01/11/2015  English   \n",
       "3  https://doaj.org/article/95606ed39deb4f43b96f7...  01/11/2015       EN   \n",
       "4  https://doaj.org/article/18b1d70730d44573ab5c2...  01/11/2015       EN   \n",
       "\n",
       "                                            Subjects      ISSNs Publisher  \\\n",
       "0  Fisher information|quasi-probabilities|complem...  1099-4300   MDPI AG   \n",
       "1  aflatoxins|AFM1|AFB1|milk marketing chains|hep...  2077-0472   MDPI AG   \n",
       "2  PKS|NRPS|metagenomics|environmental genomics|u...  1422-0067   MDPI AG   \n",
       "3  lanthanide|cerium|scorpionate|tris(pyrazolyl)b...  2304-6740   MDPI AG   \n",
       "4  snow models|hydrological models|snowmelt|uncer...  2306-5338   MDPI AG   \n",
       "\n",
       "                                            Citation Licence  \n",
       "0       Entropy, Vol 17, Iss 12, Pp 7848-7858 (2015)   CC BY  \n",
       "1  Agriculture (Basel), Vol 5, Iss 4, Pp 1172-118...   CC BY  \n",
       "2  International Journal of Molecular Sciences, V...   CC BY  \n",
       "3  Inorganics (Basel), Vol 3, Iss 4, Pp 534-553 (...   CC BY  \n",
       "4         Hydrology, Vol 2, Iss 4, Pp 289-317 (2015)   CC BY  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Get the first 10 rows of data\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "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>Title</th>\n",
       "      <th>Authors</th>\n",
       "      <th>DOI</th>\n",
       "      <th>URL</th>\n",
       "      <th>Date</th>\n",
       "      <th>Language</th>\n",
       "      <th>Subjects</th>\n",
       "      <th>ISSNs</th>\n",
       "      <th>Publisher</th>\n",
       "      <th>Citation</th>\n",
       "      <th>Licence</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>Crystal structure of [3-(1H-benzimidazol-2-yl)...</td>\n",
       "      <td>Zhimin Liu|Shengrun Zheng|Sisi Feng</td>\n",
       "      <td>10.1107/S2056989014026656</td>\n",
       "      <td>https://doaj.org/article/cb1912c6567f4f99aa0ff...</td>\n",
       "      <td>01/01/2015</td>\n",
       "      <td>EN</td>\n",
       "      <td>crystal structure|3-(1H-benzimidazol-2-yl)prop...</td>\n",
       "      <td>2056-9890</td>\n",
       "      <td>International Union of Crystallography</td>\n",
       "      <td>Acta Crystallographica Section E: Crystallogra...</td>\n",
       "      <td>CC BY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>Crystal structure of bis(3-bromopyridine-κN)bi...</td>\n",
       "      <td>Rajni Kant|Gurvinder Kour|Sumati Anthal|Neerup...</td>\n",
       "      <td>10.1107/S2056989014027339</td>\n",
       "      <td>https://doaj.org/article/004df1cd5dfd42e2b78d5...</td>\n",
       "      <td>01/01/2015</td>\n",
       "      <td>EN</td>\n",
       "      <td>Crystal structure|nickel complex|xanthate liga...</td>\n",
       "      <td>2056-9890</td>\n",
       "      <td>International Union of Crystallography</td>\n",
       "      <td>Acta Crystallographica Section E: Crystallogra...</td>\n",
       "      <td>CC BY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>Crystal structure of 4,4′-(ethane-1,2-diyl)bis...</td>\n",
       "      <td>Ines Hauptvogel|Wilhelm Seichter|Edwin Weber</td>\n",
       "      <td>10.1107/S2056989014027182</td>\n",
       "      <td>https://doaj.org/article/4f6b74ada72746ba85bbd...</td>\n",
       "      <td>01/01/2015</td>\n",
       "      <td>EN</td>\n",
       "      <td>crystal structure|4,4′-(ethane-1,2-diyl)bis(2,...</td>\n",
       "      <td>2056-9890</td>\n",
       "      <td>International Union of Crystallography</td>\n",
       "      <td>Acta Crystallographica Section E: Crystallogra...</td>\n",
       "      <td>CC BY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>Crystal structure of (Z)-4-[1-(4-acetylanilino...</td>\n",
       "      <td>Refaat M. Mahfouz|Zeynep Demircioğlu|Mohamed S...</td>\n",
       "      <td>10.1107/S2056989014026899</td>\n",
       "      <td>https://doaj.org/article/5a5102b0e73d4f2fbc55e...</td>\n",
       "      <td>01/01/2015</td>\n",
       "      <td>EN</td>\n",
       "      <td>crystal structure|Schiff bases|pyrazolone deri...</td>\n",
       "      <td>2056-9890</td>\n",
       "      <td>International Union of Crystallography</td>\n",
       "      <td>Acta Crystallographica Section E: Crystallogra...</td>\n",
       "      <td>CC BY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1000</th>\n",
       "      <td>Metagenomic Analysis of Upwelling-Affected Bra...</td>\n",
       "      <td>Rafael R. C. Cuadrat|Juliano C. Cury|Alberto M...</td>\n",
       "      <td>10.3390/ijms161226101</td>\n",
       "      <td>https://doaj.org/article/d9fe469f75a0442382b84...</td>\n",
       "      <td>01/11/2015</td>\n",
       "      <td>English</td>\n",
       "      <td>PKS|NRPS|metagenomics|environmental genomics|u...</td>\n",
       "      <td>1422-0067</td>\n",
       "      <td>MDPI AG</td>\n",
       "      <td>International Journal of Molecular Sciences, V...</td>\n",
       "      <td>CC BY</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  Title  \\\n",
       "996   Crystal structure of [3-(1H-benzimidazol-2-yl)...   \n",
       "997   Crystal structure of bis(3-bromopyridine-κN)bi...   \n",
       "998   Crystal structure of 4,4′-(ethane-1,2-diyl)bis...   \n",
       "999   Crystal structure of (Z)-4-[1-(4-acetylanilino...   \n",
       "1000  Metagenomic Analysis of Upwelling-Affected Bra...   \n",
       "\n",
       "                                                Authors  \\\n",
       "996                 Zhimin Liu|Shengrun Zheng|Sisi Feng   \n",
       "997   Rajni Kant|Gurvinder Kour|Sumati Anthal|Neerup...   \n",
       "998        Ines Hauptvogel|Wilhelm Seichter|Edwin Weber   \n",
       "999   Refaat M. Mahfouz|Zeynep Demircioğlu|Mohamed S...   \n",
       "1000  Rafael R. C. Cuadrat|Juliano C. Cury|Alberto M...   \n",
       "\n",
       "                            DOI  \\\n",
       "996   10.1107/S2056989014026656   \n",
       "997   10.1107/S2056989014027339   \n",
       "998   10.1107/S2056989014027182   \n",
       "999   10.1107/S2056989014026899   \n",
       "1000      10.3390/ijms161226101   \n",
       "\n",
       "                                                    URL        Date Language  \\\n",
       "996   https://doaj.org/article/cb1912c6567f4f99aa0ff...  01/01/2015       EN   \n",
       "997   https://doaj.org/article/004df1cd5dfd42e2b78d5...  01/01/2015       EN   \n",
       "998   https://doaj.org/article/4f6b74ada72746ba85bbd...  01/01/2015       EN   \n",
       "999   https://doaj.org/article/5a5102b0e73d4f2fbc55e...  01/01/2015       EN   \n",
       "1000  https://doaj.org/article/d9fe469f75a0442382b84...  01/11/2015  English   \n",
       "\n",
       "                                               Subjects      ISSNs  \\\n",
       "996   crystal structure|3-(1H-benzimidazol-2-yl)prop...  2056-9890   \n",
       "997   Crystal structure|nickel complex|xanthate liga...  2056-9890   \n",
       "998   crystal structure|4,4′-(ethane-1,2-diyl)bis(2,...  2056-9890   \n",
       "999   crystal structure|Schiff bases|pyrazolone deri...  2056-9890   \n",
       "1000  PKS|NRPS|metagenomics|environmental genomics|u...  1422-0067   \n",
       "\n",
       "                                   Publisher  \\\n",
       "996   International Union of Crystallography   \n",
       "997   International Union of Crystallography   \n",
       "998   International Union of Crystallography   \n",
       "999   International Union of Crystallography   \n",
       "1000                                 MDPI AG   \n",
       "\n",
       "                                               Citation Licence  \n",
       "996   Acta Crystallographica Section E: Crystallogra...   CC BY  \n",
       "997   Acta Crystallographica Section E: Crystallogra...   CC BY  \n",
       "998   Acta Crystallographica Section E: Crystallogra...   CC BY  \n",
       "999   Acta Crystallographica Section E: Crystallogra...   CC BY  \n",
       "1000  International Journal of Molecular Sciences, V...   CC BY  "
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Get the last 10 rows of data from CrossRef csv\n",
    "data.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Licence\n",
       "CC BY          954\n",
       "CC BY-NC        11\n",
       "CC BY-NC-ND     30\n",
       "dtype: int64"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Get the count of licenses by type\n",
    "data.groupby(['Licence']).size()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1001, 11)"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Get the shape of the data, number of rows and columns\n",
    "data.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x11406fb00>"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAjQAAAIECAYAAAAO8bSuAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAAPYQAAD2EBqD+naQAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAIABJREFUeJzt3Xtc1HW+x/H3CIpgMIkII8YxKyLNLmhl2Kq0JpYStbVZaaw9MrqYekwt5eFd10tarkdNK3PLtm21zh5WTxZpR9OKNBfEW1qZrdAqYEqDFwKF3/nD4+80AZsW8Juv83o+HvN4yO/7m+EzLhsvv3NzWZZlCQAAwGBNnB4AAADglyJoAACA8QgaAABgPIIGAAAYj6ABAADGI2gAAIDxCBoAAGA8ggYAABiPoAEAAMYjaAAAgPHOOWg2btyo22+/XbGxsXK5XPrb3/7ms25ZliZPnqzY2FiFhoYqOTlZu3bt8jmntLRU6enpcrvdcrvdSk9P13fffedzzo4dO9SzZ0+Fhoaqbdu2mjp1qviUBgAAUJtzDprjx4/rmmuu0cKFC2tdnz17tubOnauFCxdqy5Yt8ng86t27t44ePWqfM2DAAOXn5ys7O1vZ2dnKz89Xenq6vV5WVqbevXsrNjZWW7Zs0YIFC/Tss89q7ty5P+MuAgCA853rl3w4pcvlUlZWlu68805Jp3dnYmNjNWLECI0ZM0aSVFFRoZiYGD3zzDN69NFHtXv3bnXs2FGbNm1S165dJUmbNm1SUlKS9uzZo4SEBC1evFiZmZkqLi5WSEiIJGnWrFlasGCBvvnmG7lcrp+crbq6WgcOHFB4ePhZnQ8AAJxnWZaOHj2q2NhYNWlyDvsu1i8gycrKyrK//uqrryxJVl5ens95aWlp1u9+9zvLsixr6dKlltvtrnFbbrfb+uMf/2hZlmWlp6dbaWlpPut5eXmWJGvfvn21zvL9999bXq/Xvnz22WeWJC5cuHDhwoWLgZfCwsJzapJg1aOioiJJUkxMjM/xmJgY7d+/3z4nOjq6xnWjo6Pt6xcVFeniiy+ucRtn1tq3b1/j+jNnztSUKVNqHC8sLFRERMS53xkAANDoysrKFBcXp/Dw8HO6Xr0GzRk/fojHsiyfY7U9BPRT51j/98hYXQ8fZWZmauTIkfbXZ/5CIiIiCBoAAAxzrk8Xqdeg8Xg8kk7vorRp08Y+XlJSYu+weDweFRcX17juoUOHfM45s1vzw9uQau7+nBESEmI/3wYAAASWen0fmvbt28vj8Wjt2rX2scrKSm3YsEHdunWTJCUlJcnr9erTTz+1z9m8ebO8Xq/PORs3blRlZaV9zpo1axQbG1vjoSgAAIBzDppjx44pPz9f+fn5kqSvv/5a+fn5KigokMvl0ogRIzRjxgxlZWVp586devDBBxUWFqYBAwZIkjp06KBbb71VGRkZ2rRpkzZt2qSMjAylpqYqISFB0umXdYeEhOjBBx/Uzp07lZWVpRkzZmjkyJG8YgkAANR0Tk8htixr/fr1tT4bedCgQZZlWVZ1dbU1adIky+PxWCEhIVaPHj2sHTt2+NzG4cOHrYEDB1rh4eFWeHi4NXDgQKu0tNTnnO3bt1vdu3e3QkJCLI/HY02ePNmqrq4+6zm9Xq8lyfJ6ved6FwEAgEN+7u/vX/Q+NP6srKxMbrdbXq+XJwUDAGCIn/v7m89yAgAAxiNoAACA8QgaAABgPIIGAAAYj6ABAADGI2gAAIDxCBoAAGA8ggYAABiPoAEAAMYjaAAAgPGCnR4g0F08drXTI5w3/jGrn9MjAAAcwg4NAAAwHkEDAACMR9AAAADjETQAAMB4BA0AADAeQQMAAIxH0AAAAOMRNAAAwHgEDQAAMB5BAwAAjEfQAAAA4xE0AADAeAQNAAAwHkEDAACMR9AAAADjETQAAMB4BA0AADAeQQMAAIxH0AAAAOMRNAAAwHgEDQAAMB5BAwAAjEfQAAAA4xE0AADAeAQNAAAwHkEDAACMR9AAAADjETQAAMB4BA0AADAeQQMAAIxH0AAAAOMRNAAAwHgEDQAAMB5BAwAAjEfQAAAA4xE0AADAeAQNAAAwHkEDAACMR9AAAADjETQAAMB4BA0AADAeQQMAAIxH0AAAAOMRNAAAwHgEDQAAMB5BAwAAjEfQAAAA4xE0AADAeAQNAAAwHkEDAACMR9AAAADjETQAAMB49R40p06d0vjx49W+fXuFhobqkksu0dSpU1VdXW2fY1mWJk+erNjYWIWGhio5OVm7du3yuZ3S0lKlp6fL7XbL7XYrPT1d3333XX2PCwAAzgP1HjTPPPOMXnjhBS1cuFC7d+/W7NmzNWfOHC1YsMA+Z/bs2Zo7d64WLlyoLVu2yOPxqHfv3jp69Kh9zoABA5Sfn6/s7GxlZ2crPz9f6enp9T0uAAA4DwTX9w1+8sknuuOOO9SvXz9J0sUXX6y//OUv+vvf/y7p9O7MvHnzNG7cON11112SpGXLlikmJkZvvPGGHn30Ue3evVvZ2dnatGmTunbtKklasmSJkpKS9PnnnyshIaG+xwYAAAar9x2aX/3qV/qf//kfffHFF5Kkbdu26aOPPlLfvn0lSV9//bWKioqUkpJiXyckJEQ9e/ZUTk6OpNNR5Ha77ZiRpBtvvFFut9s+58cqKipUVlbmcwEAAIGh3ndoxowZI6/XqyuuuEJBQUGqqqrS9OnTdf/990uSioqKJEkxMTE+14uJidH+/fvtc6Kjo2vcdnR0tH39H5s5c6amTJlSn3cFAAAYot53aFasWKHXX39db7zxhvLy8rRs2TI9++yzWrZsmc95LpfL52vLsnyO/Xi9tnN+KDMzU16v174UFhbWw70BAAAmqPcdmqeeekpjx47VfffdJ0m66qqrtH//fs2cOVODBg2Sx+ORdHoXpk2bNvb1SkpK7F0bj8ej4uLiGrd96NChGjs7Z4SEhCgkJKS+7w4AADBAve/QnDhxQk2a+N5sUFCQ/bLt9u3by+PxaO3atfZ6ZWWlNmzYoG7dukmSkpKS5PV69emnn9rnbN68WV6v1z4HAADgjHrfobn99ts1ffp0/du//ZuuvPJKbd26VXPnztVDDz0k6fRDSSNGjNCMGTMUHx+v+Ph4zZgxQ2FhYRowYIAkqUOHDrr11luVkZGhF198UZL0yCOPKDU1lVc4AQCAGuo9aBYsWKAJEyZoyJAhKikpUWxsrB599FFNnDjRPufpp59WeXm5hgwZotLSUnXt2lVr1qxReHi4fc6f//xnDR8+3H41VFpamhYuXFjf4wIAgPOAy7Isy+khGkJZWZncbre8Xq8iIiKcHqdOF49d7fQI541/zOrn9AgAgF/o5/7+5rOcAACA8QgaAABgPIIGAAAYj6ABAADGI2gAAIDxCBoAAGA8ggYAABiPoAEAAMYjaAAAgPEIGgAAYDyCBgAAGI+gAQAAxiNoAACA8QgaAABgPIIGAAAYj6ABAADGI2gAAIDxCBoAAGA8ggYAABiPoAEAAMYjaAAAgPEIGgAAYDyCBgAAGI+gAQAAxiNoAACA8QgaAABgPIIGAAAYj6ABAADGI2gAAIDxCBoAAGA8ggYAABiPoAEAAMYjaAAAgPEIGgAAYDyCBgAAGI+gAQAAxiNoAACA8QgaAABgPIIGAAAYj6ABAADGI2gAAIDxCBoAAGA8ggYAABiPoAEAAMYjaAAAgPEIGgAAYDyCBgAAGI+gAQAAxiNoAACA8QgaAABgPIIGAAAYj6ABAADGI2gAAIDxCBoAAGA8ggYAABiPoAEAAMYjaAAAgPEIGgAAYDyCBgAAGI+gAQAAxiNoAACA8QgaAABgPIIGAAAYr0GC5p///KceeOABtWrVSmFhYbr22muVm5trr1uWpcmTJys2NlahoaFKTk7Wrl27fG6jtLRU6enpcrvdcrvdSk9P13fffdcQ4wIAAMPVe9CUlpbqpptuUtOmTfXuu+/qs88+03PPPacLL7zQPmf27NmaO3euFi5cqC1btsjj8ah37946evSofc6AAQOUn5+v7OxsZWdnKz8/X+np6fU9LgAAOA8E1/cNPvPMM4qLi9Mrr7xiH7v44ovtP1uWpXnz5mncuHG66667JEnLli1TTEyM3njjDT366KPavXu3srOztWnTJnXt2lWStGTJEiUlJenzzz9XQkJCje9bUVGhiooK++uysrL6vmsAAMBP1fsOzapVq3TdddfpnnvuUXR0tBITE7VkyRJ7/euvv1ZRUZFSUlLsYyEhIerZs6dycnIkSZ988oncbrcdM5J04403yu122+f82MyZM+2Hp9xut+Li4ur7rgEAAD9V70Gzb98+LV68WPHx8Xrvvff02GOPafjw4XrttdckSUVFRZKkmJgYn+vFxMTYa0VFRYqOjq5x29HR0fY5P5aZmSmv12tfCgsL6/NuAQAAP1bvDzlVV1fruuuu04wZMyRJiYmJ2rVrlxYvXqzf/e539nkul8vnepZl+Rz78Xpt5/xQSEiIQkJC6uMuAAAAw9T7Dk2bNm3UsWNHn2MdOnRQQUGBJMnj8UhSjZ2WkpISe9fG4/GouLi4xm0fOnSoxs4OAABAvQfNTTfdpM8//9zn2BdffKF27dpJktq3by+Px6O1a9fa65WVldqwYYO6desmSUpKSpLX69Wnn35qn7N582Z5vV77HAAAgDPq/SGnJ598Ut26ddOMGTPUv39/ffrpp3rppZf00ksvSTr9UNKIESM0Y8YMxcfHKz4+XjNmzFBYWJgGDBgg6fSOzq233qqMjAy9+OKLkqRHHnlEqamptb7CCQAABLZ6D5rrr79eWVlZyszM1NSpU9W+fXvNmzdPAwcOtM95+umnVV5eriFDhqi0tFRdu3bVmjVrFB4ebp/z5z//WcOHD7dfDZWWlqaFCxfW97gAAOA84LIsy3J6iIZQVlYmt9str9eriIgIp8ep08VjVzs9wnnjH7P6OT0CAOAX+rm/v/ksJwAAYDyCBgAAGI+gAQAAxiNoAACA8QgaAABgPIIGAAAYj6ABAADGI2gAAIDxCBoAAGA8ggYAABiPoAEAAMYjaAAAgPEIGgAAYDyCBgAAGI+gAQAAxiNoAACA8QgaAABgPIIGAAAYj6ABAADGI2gAAIDxCBoAAGA8ggYAABiPoAEAAMYjaAAAgPEIGgAAYDyCBgAAGI+gAQAAxiNoAACA8QgaAABgPIIGAAAYj6ABAADGI2gAAIDxCBoAAGA8ggYAABiPoAEAAMYjaAAAgPEIGgAAYDyCBgAAGI+gAQAAxiNoAACA8QgaAABgPIIGAAAYj6ABAADGI2gAAIDxCBoAAGA8ggYAABiPoAEAAMYjaAAAgPEIGgAAYDyCBgAAGI+gAQAAxiNoAACA8QgaAABgPIIGAAAYj6ABAADGI2gAAIDxCBoAAGA8ggYAABiPoAEAAMYjaAAAgPEIGgAAYDyCBgAAGK/Bg2bmzJlyuVwaMWKEfayiokLDhg1TVFSUWrRoobS0NH3zzTc+1ysoKNDtt9+uFi1aKCoqSsOHD1dlZWVDjwsAAAzUoEGzZcsWvfTSS7r66qt9jo8YMUJZWVlavny5PvroIx07dkypqamqqqqSJFVVValfv346fvy4PvroIy1fvlx//etfNWrUqIYcFwAAGKrBgubYsWMaOHCglixZopYtW9rHvV6vli5dqueee0633HKLEhMT9frrr2vHjh16//33JUlr1qzRZ599ptdff12JiYm65ZZb9Nxzz2nJkiUqKytrqJEBAIChGixonnjiCfXr10+33HKLz/Hc3FydPHlSKSkp9rHY2Fh16tRJOTk5kqRPPvlEnTp1UmxsrH1Onz59VFFRodzc3Fq/X0VFhcrKynwuAAAgMAQ3xI0uX75ceXl52rJlS421oqIiNWvWzGfXRpJiYmJUVFRknxMTE+Oz3rJlSzVr1sw+58dmzpypKVOm1NM9AAAAJqn3HZrCwkL9+7//u15//XU1b978rK9nWZZcLpf99Q//XNc5P5SZmSmv12tfCgsLz314AABgpHoPmtzcXJWUlKhLly4KDg5WcHCwNmzYoPnz5ys4OFgxMTGqrKxUaWmpz/VKSkrsXRmPx1NjJ6a0tFQnT56ssXNzRkhIiCIiInwuAAAgMNR70PTq1Us7duxQfn6+fbnuuus0cOBA+89NmzbV2rVr7escPHhQO3fuVLdu3SRJSUlJ2rlzpw4ePGifs2bNGoWEhKhLly71PTIAADBcvT+HJjw8XJ06dfI51qJFC7Vq1co+PnjwYI0aNUqtWrVSZGSkRo8erauuusp+AnFKSoo6duyo9PR0zZkzR0eOHNHo0aOVkZHBzgsAAKihQZ4U/FP+8Ic/KDg4WP3791d5ebl69eqlV199VUFBQZKkoKAgrV69WkOGDNFNN92k0NBQDRgwQM8++6wT4wIAAD/nsizLcnqIhlBWVia32y2v1+vXuzoXj13t9AjnjX/M6uf0CACAX+jn/v7ms5wAAIDxCBoAAGA8ggYAABiPoAEAAMYjaAAAgPEIGgAAYDyCBgAAGI+gAQAAxiNoAACA8QgaAABgPIIGAAAYj6ABAADGI2gAAIDxCBoAAGA8ggYAABiPoAEAAMYjaAAAgPEIGgAAYDyCBgAAGI+gAQAAxiNoAACA8QgaAABgPIIGAAAYj6ABAADGI2gAAIDxCBoAAGA8ggYAABiPoAEAAMYjaAAAgPEIGgAAYDyCBgAAGI+gAQAAxiNoAACA8QgaAABgPIIGAAAYj6ABAADGI2gAAIDxCBoAAGA8ggYAABiPoAEAAMYjaAAAgPEIGgAAYDyCBgAAGI+gAQAAxiNoAACA8QgaAABgPIIGAAAYj6ABAADGI2gAAIDxCBoAAGA8ggYAABiPoAEAAMYjaAAAgPEIGgAAYDyCBgAAGI+gAQAAxiNoAACA8QgaAABgPIIGAAAYj6ABAADGI2gAAIDxCBoAAGA8ggYAABiv3oNm5syZuv766xUeHq7o6Gjdeeed+vzzz33Oqaio0LBhwxQVFaUWLVooLS1N33zzjc85BQUFuv3229WiRQtFRUVp+PDhqqysrO9xAQDAeaDeg2bDhg164okntGnTJq1du1anTp1SSkqKjh8/bp8zYsQIZWVlafny5froo4907NgxpaamqqqqSpJUVVWlfv366fjx4/roo4+0fPly/fWvf9WoUaPqe1wAAHAecFmWZTXkNzh06JCio6O1YcMG9ejRQ16vV61bt9af/vQn3XvvvZKkAwcOKC4uTu+884769Omjd999V6mpqSosLFRsbKwkafny5XrwwQdVUlKiiIiIn/y+ZWVlcrvd8nq9Z3W+Uy4eu9rpEc4b/5jVz+kRAAC/0M/9/d3gz6Hxer2SpMjISElSbm6uTp48qZSUFPuc2NhYderUSTk5OZKkTz75RJ06dbJjRpL69OmjiooK5ebm1vp9KioqVFZW5nMBAACBoUGDxrIsjRw5Ur/61a/UqVMnSVJRUZGaNWumli1b+pwbExOjoqIi+5yYmBif9ZYtW6pZs2b2OT82c+ZMud1u+xIXF9cA9wgAAPijBg2aoUOHavv27frLX/7yk+daliWXy2V//cM/13XOD2VmZsrr9dqXwsLCnz84AAAwSoMFzbBhw7Rq1SqtX79eF110kX3c4/GosrJSpaWlPueXlJTYuzIej6fGTkxpaalOnjxZY+fmjJCQEEVERPhcAABAYKj3oLEsS0OHDtV//dd/ad26dWrfvr3PepcuXdS0aVOtXbvWPnbw4EHt3LlT3bp1kyQlJSVp586dOnjwoH3OmjVrFBISoi5dutT3yAAAwHDB9X2DTzzxhN544w2tXLlS4eHh9k6L2+1WaGio3G63Bg8erFGjRqlVq1aKjIzU6NGjddVVV+mWW26RJKWkpKhjx45KT0/XnDlzdOTIEY0ePVoZGRnsvAAAgBrqPWgWL14sSUpOTvY5/sorr+jBBx+UJP3hD39QcHCw+vfvr/LycvXq1UuvvvqqgoKCJElBQUFavXq1hgwZoptuukmhoaEaMGCAnn322foeFwAAnAca/H1onML70AQe3ocGAMznt+9DAwAA0NAIGgAAYDyCBgAAGI+gAQAAxiNoAACA8QgaAABgPIIGAAAYj6ABAADGI2gAAIDxCBoAAGA8ggYAABiPoAEAAMYjaAAAgPEIGgAAYDyCBgAAGI+gAQAAxiNoAACA8QgaAABgPIIGAAAYj6ABAADGI2gAAIDxCBoAAGA8ggYAABiPoAEAAMYjaAAAgPEIGgAAYDyCBgAAGI+gAQAAxiNoAACA8QgaAABgPIIGAAAYj6ABAADGI2gAAIDxCBoAAGA8ggYAABiPoAEAAMYjaAAAgPEIGgAAYDyCBgAAGI+gAQAAxiNoAACA8QgaAABgPIIGAAAYj6ABAADGI2gAAIDxCBoAAGA8ggYAABiPoAEAAMYjaAAAgPEIGgAAYDyCBgAAGI+gAQAAxiNoAACA8QgaAABgPIIGAAAYj6ABAADGC3Z6AAAAfspVy65yeoTzxo5BO5weoUGwQwMAAIxH0AAAAOMRNAAAwHgEDQAAMB5BAwAAjEfQAAAA4/n1y7YXLVqkOXPm6ODBg7ryyis1b948de/e3emxgPPfZLfTE5wfJnudngAIGH67Q7NixQqNGDFC48aN09atW9W9e3fddtttKigocHo0AADgZ/w2aObOnavBgwfr4YcfVocOHTRv3jzFxcVp8eLFTo8GAAD8jF8+5FRZWanc3FyNHTvW53hKSopycnJqvU5FRYUqKirsr73e01u9ZWVlDTdoPaiuOOH0COcNf//f2igVltMTnB/4maw3VeVVTo9w3vD3/1aemc+yzu2/Q34ZNN9++62qqqoUExPjczwmJkZFRUW1XmfmzJmaMmVKjeNxcXENMiP8j3ue0xMAPzKL5yLB/7gfN+Pn8ujRo3K7z35WvwyaM1wul8/XlmXVOHZGZmamRo4caX9dXV2tI0eOqFWrVnVeB2enrKxMcXFxKiwsVEREhNPjAPxMwu/wM1l/LMvS0aNHFRsbe07X88ugiYqKUlBQUI3dmJKSkhq7NmeEhIQoJCTE59iFF17YYDMGooiICP6PCr/CzyT8DT+T9eNcdmbO8MsnBTdr1kxdunTR2rVrfY6vXbtW3bp1c2gqAADgr/xyh0aSRo4cqfT0dF133XVKSkrSSy+9pIKCAj322GNOjwYAAPyM3wbNvffeq8OHD2vq1Kk6ePCgOnXqpHfeeUft2rVzerSAExISokmTJtV4SA9wCj+T8Df8TDrPZZ3r66IAAAD8jF8+hwYAAOBcEDQAAMB4BA0AADAeQQMAAIxH0MA2atQoVVZWOj0G4OPEiRO1fqZLdXW1Tpzgs9AAnEbQwJaVlaXExERt3brV6VEASdLKlSt19dVX1xou5eXluuaaa7R69WoHJkMgO3HihKZOnaprr71WF154oVq2bKnOnTtrxowZ+v77750eL2ARNLDt3LlTycnJSkpK0rRp01RdXe30SAhwixYt0pgxY9SiRYsaay1atNDYsWO1YMECByZDoDp58qRuvvlm/f73v1dcXJwyMjI0ePBgtWnTRpMnT1avXr106tQpp8cMSLwPDWpYv369Bg8erNatW2vs2LEKCgryWU9LS3NoMgSatm3basOGDbrssstqXd+7d6969OihAwcONPJkCFTz58/X9OnT9cEHH6hDhw4+a7t27dKvf/1rTZw4UU888YRDEwYugga1Wrlype6+++4auzQul0tVVVUOTYVAExoaqq1bt+qKK66odX3Pnj1KTExUeXl5I0+GQNWzZ0/99re/1bBhw2pd/4//+A9lZWXpgw8+aNzBwENO8FVeXq7hw4fr3nvv1YQJE1RZWanq6mr7QsygMbVr1055eXl1rufm5vJxKGhUn332mW6++eY613/9619r165djTgRzvDbz3JC48vJydGgQYMUEhKijz/+WF26dHF6JAS43/zmNxo3bpx69+6t1q1b+6yVlJRo/Pjxuu+++xyaDoHou+++U1RUVJ3rUVFR8nq9jTgRzuAhJ9iaNWum4cOHa/r06XzAGvxCWVmZunbtqgMHDmjQoEFKSEiQy+XS7t279dprryk2NlabN29WRESE06MiQAQFBamoqKhGYJ9RXFys2NhYdrMdQNDAtnHjRvXo0cPpMQAfpaWlGjNmjN58802VlZVJkiIiItS/f3/NmjVLkZGRDk+IQNKkSRNde+21Cg6u/QGOU6dOadu2bQSNAwga/EvHjx/XihUrVF5erpSUFMXHxzs9EgJUdXW1iouLZVmWPB6PmjThKYBofBMmTDir86ZNm9bAk+DHCBrYCgoKlJ6erry8PN14441aunSpevfurS+//FLS6VecvPvuu+ziAAD8DkEDW//+/VVYWKgnnnhCb731lr744gtdeumlWrp0qZo0aaIhQ4bo8OHDWrdundOjIkD07t1bLpfrX57jcrn03nvvNdJEAPwVQQObx+PRqlWrdMMNN+jIkSOKiorSxx9/rKSkJEnStm3b1KtXL3377bcOT4pAUdd7fUjSsWPHtGLFClVUVPB8BTQaItt/8bJt2A4dOmS/p0dkZKTCwsIUExNjr3s8HpWWljo1HgJQbR9rUFVVpRdeeEHTpk2Tx+PR1KlTHZgMgaquN3mUfCMbjY+ggc2yLJ9/efzUv0KAxrZixQqNHz9eZWVlGjdunB5//HE1bdrU6bEQQIhs/0XQwMfEiRMVFhYmSaqsrNT06dPldrslqdZPPAYaw/vvv68xY8boiy++0MiRI/XUU0/pggsucHosgMj2IzyHBrbk5OSz2pVZv359I0wDnP5og7Fjx+rDDz9URkaGJkyYoOjoaKfHAohsP0TQAPBbTZo0UWhoqB577DFdeumldZ43ZMiQRpwKgYzI9l8EDQC/ddFFF53VK0oKCgoaaSIEOiLbfxE0AACcJSLbfxE0AIxSVFSkmJgYXoUHwAcfhgLAKJdffrm+/vprp8cAbEVFRWJvwHkEDQCj8IsD/obI9g8EDWxffvml7r//fpWVldVY83q9GjBggPbt2+fAZADgv4hs/0DQwDZnzhzFxcUpIiKixprb7VZcXJzmzJnjwGQz/ASDAAAQDUlEQVTA/xszZowiIyOdHgOAnyFoYNu4caPuueeeOtf79+/PJ22jUY0aNUqVlZU+x8aPH68LL7zQoYmAmohs/8CrnGALDQ3Vnj177A+o/LH9+/erQ4cOfAQCGs0ll1yi0NBQvf7660pMTHR6HEDS6Y+BCQ0NrfFKu+rqan3//ff2x8egcbFDA5vb7dZXX31V5/revXtrfTgKaCg7d+5UcnKykpKSNG3aNFVXVzs9EgLcypUrdfXVV9f6D7vy8nJdc801Wr16tQOTgR0a2Pr376+TJ08qKyur1vU77rhDzZo101tvvdXIkyHQrV+/XoMHD1br1q01duxYBQUF+aynpaU5NBkCTZ8+ffTb3/5WGRkZta4vXbpUb731lrKzsxt5MhA0sG3dulVJSUlKTU3V008/rYSEBEnSnj17NHv2bK1evVo5OTnq3Lmzw5MiEK1cuVJ33313jV0al8ulqqoqh6ZCoGnbtq02bNigyy67rNb1vXv3qkePHjpw4EAjTwYecoItMTFR//mf/6mNGzcqKSlJkZGRioyMVLdu3fThhx/qzTffJGbQ6MrLyzV8+HDde++9mjBhgiorK1VdXW1fiBk0piNHjujUqVN1rp86dUqlpaWNOBHOCHZ6APiX1NRU7d+/X9nZ2dq7d68sy9Lll1+ulJQUnuiGRpeTk6NBgwYpJCREH3/8sbp06eL0SAhw7dq1U15enq644opa13Nzc+t8YQUaFg85AfBbzZo10/DhwzV9+nSFhIQ4PQ6gzMxMLV++XJ9++qlat27ts1ZSUqKuXbvqvvvu08yZMx2aMHARNLCtW7dOQ4cO1aZNm2q8msnr9apbt2564YUX1L17d4cmRKDZuHGjevTo4fQYgK2srExdu3bVgQMHNGjQICUkJMjlcmn37t167bXXFBsbq82bN/OKUAcQNLClpaXp5ptv1pNPPlnr+vz587V+/fo6XwUFNIbjx49rxYoVKi8vV0pKiuLj450eCQGmtLRUY8aM0Ztvvml/VExERIT69++vWbNm8SZ7DiFoYGvXrp2ys7PVoUOHWtf37NmjlJQUFRQUNPJkCFQFBQVKT09XXl6ebrzxRi1dulS9e/fWl19+Ken0m0G+++677OLAEdXV1SouLpZlWfJ4PGrShNfZOIm/fdiKi4vVtGnTOteDg4N16NChRpwIgW706NGqrKzU4sWLFRYWpj59+ig+Pl4HDx5UcXGx+vbtq8mTJzs9JgJUkyZN1KZNG8XGxhIzfoBXOcHWtm1b7dixo873V9i+fbvatGnTyFMhkG3cuFGrVq3SDTfcoL59+yoqKkp//OMfFRMTI+n05zr16tXL4SkRSHr37l3jIw9+zOVy6b333mukiXAGQQNb3759NXHiRN12221q3ry5z1p5ebkmTZqk1NRUh6ZDIDp06JD9EtjIyEiFhYXZMSNJHo+H9/xAo6rr5dqSdOzYMa1YsUIVFRWNOBHO4Dk0sBUXF6tz584KCgrS0KFDfZ69//zzz6uqqkp5eXk+v1CAhtSkSRMVFRUpOjpakhQeHq5t27bpkksukXT6ZzY2NpY314Ojqqqq9MILL2jatGkKCwvT1KlT9cADDzg9VsBhhwa2mJgY5eTk6PHHH1dmZqbOtK7L5VKfPn20aNEiYgaNbuLEifabOlZWVmr69Olyu92SxCe/w3ErVqzQ+PHjVVZWpnHjxunxxx//l89FRMNhhwa1Ki0ttd8pOD4+Xi1btnR6JASg5OTkn3y+gnT6wyuBxvT+++9rzJgx+uKLLzRy5Eg99dRTuuCCC5weK6ARNAAAnKXc3FyNHTtWH374oTIyMjRhwgT7IVE4i6ABAOAsNWnSRKGhoXrsscd06aWX1nnekCFDGnEqSAQNAABn7aKLLjqrl23zBqSNj6ABAADG460NAQD4BYqKisTegPMIGgAAfoHLL79cX3/9tdNjBDyCBoDf+vLLL3X//ffbn2j8Q16vVwMGDNC+ffscmAz4f+zO+AeCBoDfmjNnjuLi4hQREVFjze12Ky4uTnPmzHFgMgD+hqAB4Lc2btyoe+65p871/v37a926dY04EVDTmDFjFBkZ6fQYAY+gAeC39u/f/y/ftCwqKkqFhYWNOBEC3ahRo1RZWelzbPz48brwwgsdmghnEDQA/Jbb7dZXX31V5/revXtrfTgKaChZWVlKTEzU1q1bnR4FP0LQAPBbPXr00IIFC+pcnz9/vrp3796IEyHQ7dy5U8nJyUpKStK0adNUXV3t9Ej4P7yxHgC/tXXrViUlJSk1NVVPP/20EhISJEl79uzR7NmztXr1auXk5Khz584OT4pAs379eg0ePFitW7fW2LFjFRQU5LOelpbm0GSBi6AB4NfefvttPfTQQzp8+LDP8VatWunll1/mFwccs3LlSt199901dmlcLpeqqqocmipwETQA/F55ebmys7O1d+9eWZalyy+/XCkpKQoLC3N6NASg8vJyjRkzRi+99JIyMzM1btw4BQcHOz1WwCNoAAA4Szk5ORo0aJBCQkK0bNkydenSxemR8H94UjAAv7Vu3Tp17NixzncKvvLKK/Xhhx86MBkCVXJysu644w7l5uYSM36GHRoAfistLU0333yznnzyyVrX58+fr/Xr1ysrK6uRJ0Og2rhxo3r06OH0GKgFQQPAb7Vr107Z2dnq0KFDret79uxRSkqKCgoKGnky4P8dP35cK1asUHl5uVJSUhQfH+/0SAGJh5wA+K3i4mI1bdq0zvXg4GAdOnSoESdCoCsoKFDPnj0VHh6u3r17q6CgQJ07d9bDDz+sYcOG6dprr9XGjRudHjMgETQA/Fbbtm21Y8eOOte3b9+uNm3aNOJECHSjR49WZWWlFi9erLCwMPXp00fx8fE6ePCgiouL1bdvX02ePNnpMQMSDzkB8FvDhg3TBx98oC1btqh58+Y+a+Xl5brhhht08803a/78+Q5NiEDj8Xi0atUq3XDDDTpy5IiioqL08ccfKykpSZK0bds29erVS99++63DkwYeggaA3youLlbnzp0VFBSkoUOHKiEhQS6XS7t379bzzz+vqqoq5eXlKSYmxulRESCCgoJ04MAB+2fuggsu0Pbt23XJJZdIOv0zGxsbyxvrOYB3AgLgt2JiYpSTk6PHH39cmZmZOvPvL5fLpT59+mjRokXEDBqVZVlyuVz21z/8M5xF0ADwa+3atdM777yj0tJS+52C4+Pj1bJlS6dHQ4CaOHGi/S7VlZWVmj59utxutyTpxIkTTo4W0HjICQCAs5ScnHxWuzLr169vhGnwQwQNAAAwHi/bBgAAxiNoAACA8QgaAABgPIIGAAAYj6ABAADGI2gAADhLX375pe6//36VlZXVWPN6vRowYID27dvnwGQgaAAAOEtz5sxRXFycIiIiaqy53W7FxcVpzpw5DkwGggYAgLO0ceNG3XPPPXWu9+/fX+vWrWvEiXAGQQMAwFnav3+/oqOj61yPiopSYWFhI06EMwgaAADOktvt1ldffVXn+t69e2t9OAoNj6ABAOAs9ejRQwsWLKhzff78+erevXsjToQz+CwnAADO0tatW5WUlKTU1FQ9/fTTSkhIkCTt2bNHs2fP1urVq5WTk6POnTs7PGngIWgAADgHb7/9th566CEdPnzY53irVq308ssvKy0tzaHJAhtBAwDAOSovL1d2drb27t0ry7J0+eWXKyUlRWFhYU6PFrAIGgAAYDyeFAwAwFlat26dOnbsWOc7BV955ZX68MMPHZgMBA0AAGdp3rx5ysjIqPOdgh999FHNnTvXgclA0AAAcJa2bdumW2+9tc71lJQU5ebmNuJEOIOgAQDgLBUXF6tp06Z1rgcHB+vQoUONOBHOIGgAADhLbdu21Y4dO+pc3759u9q0adOIE+EMggYAgLPUt29fTZw4Ud9//32NtfLyck2aNEmpqakOTAZetg0AwFkqLi5W586dFRQUpKFDhyohIUEul0u7d+/W888/r6qqKuXl5SkmJsbpUQMOQQMAwDnYv3+/Hn/8cb333ns68yvU5XKpT58+WrRokS6++GJnBwxQBA0AAD9DaWmp/U7B8fHxatmypdMjBTSCBgAAGI8nBQMAAOMRNAAAwHgEDQAAMB5BAwAAjEfQAGhULpdLf/vb35weA8B5JtjpAQCcfx588EF99913tYbLwYMHeXkrgHpH0ABoVB6Px+kRAJyHeMgJQKP68UNO33zzje677z5FRkaqRYsWuu6667R582Z7/b//+7/VpUsXNW/eXJdccommTJmiU6dO+dzeyy+/rN/85jcKCwtTfHy8Vq1a5fM9d+3apX79+ikiIkLh4eHq3r27vvrqK3v9lVdeUYcOHdS8eXNdccUVWrRoUQP+DQBoCOzQAHDMsWPH1LNnT7Vt21arVq2Sx+NRXl6eqqurJUnvvfeeHnjgAc2fP9+OkEceeUSSNGnSJPt2pkyZotmzZ2vOnDlasGCBBg4cqP379ysyMlL//Oc/1aNHDyUnJ2vdunWKiIjQxx9/bEfRkiVLNGnSJC1cuFCJiYnaunWrMjIy1KJFCw0aNKjx/1IA/DwWANSzQYMGWXfccUeta5KsrKwsy7Is68UXX7TCw8Otw4cP13pu9+7drRkzZvgc+9Of/mS1adPG5/bGjx9vf33s2DHL5XJZ7777rmVZlpWZmWm1b9/eqqysrPV7xMXFWW+88YbPsWnTpllJSUk/cS8B+BN2aAA4Jj8/X4mJiYqMjKx1PTc3V1u2bNH06dPtY1VVVfr+++914sQJhYWFSZKuvvpqe71FixYKDw9XSUmJ/T26d++upk2b1rj9Q4cOqbCwUIMHD1ZGRoZ9/NSpU3K73fVyHwE0DoIGgGNCQ0P/5Xp1dbWmTJmiu+66q8Za8+bN7T//OFZcLpf9sNW/+h5nzlmyZIm6du3qsxYUFPSvhwfgVwgaAI65+uqr9fLLL+vIkSO17tJ07txZn3/+uS677LJf9D2WLVumkydP1gifmJgYtW3bVvv27dPAgQN/9vcA4DyCBkCD8Hq9ys/P9zn242i5//77NWPGDN15552aOXOm2rRpo61btyo2NlZJSUmaOHGiUlNTFRcXp3vuuUdNmjTR9u3btWPHDv3+978/qzmGDh2qBQsW6L777lNmZqbcbrc2bdqkG264QQkJCZo8ebKGDx+uiIgI3XbbbaqoqNDf//53lZaWauTIkfX29wGgYfGybQAN4oMPPlBiYqLPZeLEiT7nNGvWTGvWrFF0dLT69u2rq666SrNmzbIf7unTp4/efvttrV27Vtdff71uvPFGzZ07V+3atTvrOVq1aqV169bZr6jq0qWLlixZYu/WPPzww3r55Zf16quv6qqrrlLPnj316quvqn379vX3lwGgwbksy7KcHgIAAOCXYIcGAAAYj6ABAADGI2gAAIDxCBoAAGA8ggYAABiPoAEAAMYjaAAAgPEIGgAAYDyCBgAAGI+gAQAAxiNoAACA8f4XkWeqqU67AgkAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x11a7a3978>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Plot number of licenses by type\n",
    "data.groupby(['Licence']).size().plot(kind='bar')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "For a nice tutorial on Pandas and Bokeh, see:\n",
    "https://programminghistorian.org/en/lessons/visualizing-with-bokeh"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Collecting plotly\n",
      "  Downloading https://files.pythonhosted.org/packages/25/e6/716d30f51604daedaf12b1064e1d1e48d1c0a224ac41a83496b39862124d/plotly-3.2.1-py2.py3-none-any.whl (37.0MB)\n",
      "\u001b[K    100% |████████████████████████████████| 37.0MB 34kB/s eta 0:00:011\n",
      "\u001b[?25hCollecting retrying>=1.3.3 (from plotly)\n",
      "  Downloading https://files.pythonhosted.org/packages/44/ef/beae4b4ef80902f22e3af073397f079c96969c69b2c7d52a57ea9ae61c9d/retrying-1.3.3.tar.gz\n",
      "Requirement already satisfied: pytz in /anaconda3/lib/python3.6/site-packages (from plotly)\n",
      "Requirement already satisfied: nbformat>=4.2 in /anaconda3/lib/python3.6/site-packages (from plotly)\n",
      "Requirement already satisfied: decorator>=4.0.6 in /anaconda3/lib/python3.6/site-packages (from plotly)\n",
      "Requirement already satisfied: requests in /anaconda3/lib/python3.6/site-packages (from plotly)\n",
      "Requirement already satisfied: six in /anaconda3/lib/python3.6/site-packages (from plotly)\n",
      "Requirement already satisfied: ipython_genutils in /anaconda3/lib/python3.6/site-packages (from nbformat>=4.2->plotly)\n",
      "Requirement already satisfied: traitlets>=4.1 in /anaconda3/lib/python3.6/site-packages (from nbformat>=4.2->plotly)\n",
      "Requirement already satisfied: jsonschema!=2.5.0,>=2.4 in /anaconda3/lib/python3.6/site-packages (from nbformat>=4.2->plotly)\n",
      "Requirement already satisfied: jupyter_core in /anaconda3/lib/python3.6/site-packages (from nbformat>=4.2->plotly)\n",
      "Requirement already satisfied: chardet<3.1.0,>=3.0.2 in /anaconda3/lib/python3.6/site-packages (from requests->plotly)\n",
      "Requirement already satisfied: idna<2.7,>=2.5 in /anaconda3/lib/python3.6/site-packages (from requests->plotly)\n",
      "Requirement already satisfied: urllib3<1.23,>=1.21.1 in /anaconda3/lib/python3.6/site-packages (from requests->plotly)\n",
      "Requirement already satisfied: certifi>=2017.4.17 in /anaconda3/lib/python3.6/site-packages (from requests->plotly)\n",
      "Building wheels for collected packages: retrying\n",
      "  Running setup.py bdist_wheel for retrying ... \u001b[?25ldone\n",
      "\u001b[?25h  Stored in directory: /Users/cerdmann/Library/Caches/pip/wheels/d7/a9/33/acc7b709e2a35caa7d4cae442f6fe6fbf2c43f80823d46460c\n",
      "Successfully built retrying\n",
      "Installing collected packages: retrying, plotly\n",
      "Successfully installed plotly-3.2.1 retrying-1.3.3\n",
      "\u001b[33mYou are using pip version 9.0.1, however version 18.0 is available.\n",
      "You should consider upgrading via the 'pip install --upgrade pip' command.\u001b[0m\n"
     ]
    }
   ],
   "source": [
    "# Example of installing Python module\n",
    "!pip install plotly"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "import json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{\"status\":\"ok\",\"message-type\":\"journal\",\"message-version\":\"1.0.0\",\"message\":{\"last-status-check-time\":1537311111267,\"counts\":{\"total-dois\":3583,\"current-dois\":1850,\"backfile-dois\":1733},\"breakdowns\":{\"dois-by-issued-year\":[[2018,697],[2017,694],[2016,459],[2015,453],[2014,328],[2013,284],[2012,137],[2010,119],[2011,101],[2009,69],[2008,56],[2003,39],[2004,33],[2001,21],[2005,20],[2006,18],[2007,17],[1999,16],[2000,12],[2002,10]]},\"publisher\":\"MDPI AG\",\"coverage\":{\"affiliations-current\":0.0,\"similarity-checking-current\":0.999459445476532,\"funders-backfile\":0.06231967732310295,\"licenses-backfile\":0.9976918697357178,\"funders-current\":0.26972973346710205,\"affiliations-backfile\":0.0,\"resource-links-backfile\":0.0,\"orcids-backfile\":0.00865551084280014,\"update-policies-current\":0.0,\"open-references-backfile\":1.0,\"orcids-current\":0.36918920278549194,\"similarity-checking-backfile\":0.9976918697357178,\"references-backfile\":0.9699942469596863,\"award-numbers-backfile\":0.06116560846567154,\"update-policies-backfile\":0.0,\"licenses-current\":0.999459445476532,\"award-numbers-current\":0.2572973072528839,\"abstracts-backfile\":0.0,\"resource-links-current\":0.0,\"abstracts-current\":0.10378378629684448,\"open-references-current\":1.0,\"references-current\":0.9897297024726868},\"title\":\"Entropy\",\"subjects\":[{\"name\":\"General Physics and Astronomy\",\"ASJC\":3100}],\"coverage-type\":{\"all\":{\"last-status-check-time\":1537311109329,\"affiliations\":0.0,\"abstracts\":0.0535714291036129,\"orcids\":0.1947544664144516,\"licenses\":0.9983258843421936,\"references\":0.9799107313156128,\"funders\":0.1693638414144516,\"similarity-checking\":0.9983258843421936,\"award-numbers\":0.1623883992433548,\"update-policies\":0.0,\"resource-links\":0.0,\"open-references\":1.0},\"backfile\":{\"last-status-check-time\":1537311108830,\"affiliations\":0.0,\"abstracts\":0.0,\"orcids\":0.00865551084280014,\"licenses\":0.9976918697357178,\"references\":0.9699942469596863,\"funders\":0.06231967732310295,\"similarity-checking\":0.9976918697357178,\"award-numbers\":0.06116560846567154,\"update-policies\":0.0,\"resource-links\":0.0,\"open-references\":1.0},\"current\":{\"last-status-check-time\":1537311108125,\"affiliations\":0.0,\"abstracts\":0.10378378629684448,\"orcids\":0.36918920278549194,\"licenses\":0.999459445476532,\"references\":0.9897297024726868,\"funders\":0.26972973346710205,\"similarity-checking\":0.999459445476532,\"award-numbers\":0.2572973072528839,\"update-policies\":0.0,\"resource-links\":0.0,\"open-references\":1.0}},\"flags\":{\"deposits-abstracts-current\":true,\"deposits-orcids-current\":true,\"deposits\":true,\"deposits-affiliations-backfile\":false,\"deposits-update-policies-backfile\":false,\"deposits-similarity-checking-backfile\":true,\"deposits-award-numbers-current\":true,\"deposits-resource-links-current\":false,\"deposits-articles\":true,\"deposits-affiliations-current\":false,\"deposits-funders-current\":true,\"deposits-references-backfile\":true,\"deposits-abstracts-backfile\":false,\"deposits-licenses-backfile\":true,\"deposits-award-numbers-backfile\":true,\"deposits-open-references-backfile\":true,\"deposits-open-references-current\":true,\"deposits-references-current\":true,\"deposits-resource-links-backfile\":false,\"deposits-orcids-backfile\":true,\"deposits-funders-backfile\":true,\"deposits-update-policies-current\":false,\"deposits-similarity-checking-current\":true,\"deposits-licenses-current\":true},\"ISSN\":[\"1099-4300\"],\"issn-type\":[{\"value\":\"1099-4300\",\"type\":\"electronic\"}]}}\n"
     ]
    }
   ],
   "source": [
    "crossref_url = 'http://api.crossref.org/journals/1099-4300'\n",
    "response = requests.get(crossref_url)\n",
    "print(response.text)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [],
   "source": [
    "json_data = json.loads(response.text)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Pretty printing has been turned ON\n"
     ]
    }
   ],
   "source": [
    "pprint(json_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "MDPI AG\n"
     ]
    }
   ],
   "source": [
    "print(json_data['message']['publisher'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "/Users/cerdmann\r\n"
     ]
    }
   ],
   "source": [
    "# Command line example, print working directory\n",
    "!pwd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\u001b[34mAnacondaProjects\u001b[m\u001b[m     \u001b[34mDownloads\u001b[m\u001b[m            \u001b[34mPictures\u001b[m\u001b[m\r\n",
      "\u001b[34mApplications\u001b[m\u001b[m         \u001b[34mLibrary\u001b[m\u001b[m              \u001b[34mPublic\u001b[m\u001b[m\r\n",
      "\u001b[34mBox Sync\u001b[m\u001b[m             \u001b[34mMovies\u001b[m\u001b[m               \u001b[34mZotero\u001b[m\u001b[m\r\n",
      "\u001b[34mDesktop\u001b[m\u001b[m              \u001b[34mMusic\u001b[m\u001b[m                \u001b[34mstudio-link\u001b[m\u001b[m\r\n",
      "\u001b[34mDocuments\u001b[m\u001b[m            Pandas Example.ipynb\r\n"
     ]
    }
   ],
   "source": [
    "# Command line example, list files\n",
    "!ls"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Command line example, create a file\n",
    "!touch abc.txt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}