Citation Data Clean and API.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Earth Science Citation Replication Project"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 0. Import Packages"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [],
   "source": [
    "import csv\n",
    "import pandas as pd\n",
    "from time import sleep\n",
    "from datetime import datetime\n",
    "import re\n",
    "import os\n",
    "import json\n",
    "import requests\n",
    "import matplotlib.pyplot as plt\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "*Be sure to either keep this notebook in the same folder as your data, or use os to change directories"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#os.chdir('yourDataDirectory')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 1. Import and clean your input file:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "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>Unnamed: 0</th>\n",
       "      <th>PT</th>\n",
       "      <th>AU</th>\n",
       "      <th>BA</th>\n",
       "      <th>BE</th>\n",
       "      <th>GP</th>\n",
       "      <th>AF</th>\n",
       "      <th>BF</th>\n",
       "      <th>CA</th>\n",
       "      <th>TI</th>\n",
       "      <th>...</th>\n",
       "      <th>WC</th>\n",
       "      <th>SC</th>\n",
       "      <th>GA</th>\n",
       "      <th>UT</th>\n",
       "      <th>PM</th>\n",
       "      <th>OA</th>\n",
       "      <th>HC</th>\n",
       "      <th>HP</th>\n",
       "      <th>DA</th>\n",
       "      <th>INSTITUTION</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1289</td>\n",
       "      <td>J</td>\n",
       "      <td>Nusbaumer, J; Noone, D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nusbaumer, Jesse; Noone, David</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Numerical Evaluation of the Modern and Future ...</td>\n",
       "      <td>...</td>\n",
       "      <td>Meteorology &amp; Atmospheric Sciences</td>\n",
       "      <td>Meteorology &amp; Atmospheric Sciences</td>\n",
       "      <td>GN9IH</td>\n",
       "      <td>WOS:000439508000007</td>\n",
       "      <td>30381797.0</td>\n",
       "      <td>Green Accepted, Bronze</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6/19/20</td>\n",
       "      <td>CUBoulder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1320</td>\n",
       "      <td>J</td>\n",
       "      <td>Wagner, A; Heinzeller, D; Wagner, S; Rummler, ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Wagner, Andreas; Heinzeller, Dominikus; Wagner...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Explicit Convection and Scale-Aware Cumulus Pa...</td>\n",
       "      <td>...</td>\n",
       "      <td>Meteorology &amp; Atmospheric Sciences</td>\n",
       "      <td>Meteorology &amp; Atmospheric Sciences</td>\n",
       "      <td>GL4CL</td>\n",
       "      <td>WOS:000437094500014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronze</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6/19/20</td>\n",
       "      <td>CUBoulder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1716</td>\n",
       "      <td>B</td>\n",
       "      <td>Barry, RG; Hall-McKim, EA</td>\n",
       "      <td>Barry, RG; HallMcKim, EA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Barry, Roger G.; Hall-McKim, Eileen A.</td>\n",
       "      <td>Barry, RG; HallMcKim, EA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Setting, History of Studies, and the Clima...</td>\n",
       "      <td>...</td>\n",
       "      <td>Environmental Sciences; Meteorology &amp; Atmosphe...</td>\n",
       "      <td>Environmental Sciences &amp; Ecology; Meteorology ...</td>\n",
       "      <td>BO7BJ</td>\n",
       "      <td>WOS:000522817700002</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronze</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6/19/20</td>\n",
       "      <td>CUBoulder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4787</td>\n",
       "      <td>J</td>\n",
       "      <td>Guillod, BP; Orlowsky, B; Miralles, DG; Teulin...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Guillod, B. P.; Orlowsky, B.; Miralles, D. G.;...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Land-surface controls on afternoon precipitati...</td>\n",
       "      <td>...</td>\n",
       "      <td>Environmental Sciences; Meteorology &amp; Atmosphe...</td>\n",
       "      <td>Environmental Sciences &amp; Ecology; Meteorology ...</td>\n",
       "      <td>AP3QK</td>\n",
       "      <td>WOS:000341991600008</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DOAJ Gold, Green Published</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6/19/20</td>\n",
       "      <td>CUBoulder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>245</td>\n",
       "      <td>J</td>\n",
       "      <td>D'Ambro, EL; Schobesberger, S; Gaston, CJ; Lop...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>D'Ambro, Emma L.; Schobesberger, Siegfried; Ga...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Chamber-based insights into the factors contro...</td>\n",
       "      <td>...</td>\n",
       "      <td>Environmental Sciences; Meteorology &amp; Atmosphe...</td>\n",
       "      <td>Environmental Sciences &amp; Ecology; Meteorology ...</td>\n",
       "      <td>IV8BG</td>\n",
       "      <td>WOS:000484490100002</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DOAJ Gold, Green Published</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6/19/20</td>\n",
       "      <td>CUBoulder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>432</td>\n",
       "      <td>J</td>\n",
       "      <td>Rangarajan, R; Laskar, AH; Bhattacharya, SK; S...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rangarajan, Ravi; Laskar, Amzad H.; Bhattachar...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>An insight into the western Pacific wintertime...</td>\n",
       "      <td>...</td>\n",
       "      <td>Engineering, Civil; Geosciences, Multidiscipli...</td>\n",
       "      <td>Engineering; Geology; Water Resources</td>\n",
       "      <td>ER5VE</td>\n",
       "      <td>WOS:000398871100009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/16/20</td>\n",
       "      <td>Houston</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>316</td>\n",
       "      <td>J</td>\n",
       "      <td>Ahmad, L; Khan, SD; Shah, MT; Jehan, N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ahmad, Laeiq; Khan, Shuhab D.; Shah, M. Tahir;...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Gold mineralization in Bubin area, Gilgit-Balt...</td>\n",
       "      <td>...</td>\n",
       "      <td>Geosciences, Multidisciplinary</td>\n",
       "      <td>Geology</td>\n",
       "      <td>FU1NZ</td>\n",
       "      <td>WOS:000423618000007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/16/20</td>\n",
       "      <td>Houston</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>698</td>\n",
       "      <td>J</td>\n",
       "      <td>Baier, BC; Brune, WH; Lefer, BL; Miller, DO; M...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Baier, Bianca C.; Brune, William H.; Lefer, Ba...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Direct ozone production rate measurements and ...</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WOS:000356991000010</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Houston</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>839</td>\n",
       "      <td>J</td>\n",
       "      <td>Hossain, F; Siddique-E-Akbor, AHM; Yigzaw, W; ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Hossain, Faisal; Siddique-E-Akbor, A. H. M.; Y...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CROSSING THE \"VALLEY OF DEATH\" Lessons Learned...</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WOS:000342552400008</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Houston</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>552</td>\n",
       "      <td>J</td>\n",
       "      <td>Bird, DE; Hall, SA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bird, Dale E.; Hall, Stuart A.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Early seafloor spreading in the South Atlantic...</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WOS:000379772500008</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Houston</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 69 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Unnamed: 0 PT                                                 AU  \\\n",
       "0          1289  J                             Nusbaumer, J; Noone, D   \n",
       "1          1320  J  Wagner, A; Heinzeller, D; Wagner, S; Rummler, ...   \n",
       "2          1716  B                          Barry, RG; Hall-McKim, EA   \n",
       "3          4787  J  Guillod, BP; Orlowsky, B; Miralles, DG; Teulin...   \n",
       "4           245  J  D'Ambro, EL; Schobesberger, S; Gaston, CJ; Lop...   \n",
       "..          ... ..                                                ...   \n",
       "995         432  J  Rangarajan, R; Laskar, AH; Bhattacharya, SK; S...   \n",
       "996         316  J             Ahmad, L; Khan, SD; Shah, MT; Jehan, N   \n",
       "997         698  J  Baier, BC; Brune, WH; Lefer, BL; Miller, DO; M...   \n",
       "998         839  J  Hossain, F; Siddique-E-Akbor, AHM; Yigzaw, W; ...   \n",
       "999         552  J                                 Bird, DE; Hall, SA   \n",
       "\n",
       "                           BA   BE   GP  \\\n",
       "0                         NaN  NaN  NaN   \n",
       "1                         NaN  NaN  NaN   \n",
       "2    Barry, RG; HallMcKim, EA  NaN  NaN   \n",
       "3                         NaN  NaN  NaN   \n",
       "4                         NaN  NaN  NaN   \n",
       "..                        ...  ...  ...   \n",
       "995                       NaN  NaN  NaN   \n",
       "996                       NaN  NaN  NaN   \n",
       "997                       NaN  NaN  NaN   \n",
       "998                       NaN  NaN  NaN   \n",
       "999                       NaN  NaN  NaN   \n",
       "\n",
       "                                                    AF  \\\n",
       "0                       Nusbaumer, Jesse; Noone, David   \n",
       "1    Wagner, Andreas; Heinzeller, Dominikus; Wagner...   \n",
       "2               Barry, Roger G.; Hall-McKim, Eileen A.   \n",
       "3    Guillod, B. P.; Orlowsky, B.; Miralles, D. G.;...   \n",
       "4    D'Ambro, Emma L.; Schobesberger, Siegfried; Ga...   \n",
       "..                                                 ...   \n",
       "995  Rangarajan, Ravi; Laskar, Amzad H.; Bhattachar...   \n",
       "996  Ahmad, Laeiq; Khan, Shuhab D.; Shah, M. Tahir;...   \n",
       "997  Baier, Bianca C.; Brune, William H.; Lefer, Ba...   \n",
       "998  Hossain, Faisal; Siddique-E-Akbor, A. H. M.; Y...   \n",
       "999                     Bird, Dale E.; Hall, Stuart A.   \n",
       "\n",
       "                           BF   CA  \\\n",
       "0                         NaN  NaN   \n",
       "1                         NaN  NaN   \n",
       "2    Barry, RG; HallMcKim, EA  NaN   \n",
       "3                         NaN  NaN   \n",
       "4                         NaN  NaN   \n",
       "..                        ...  ...   \n",
       "995                       NaN  NaN   \n",
       "996                       NaN  NaN   \n",
       "997                       NaN  NaN   \n",
       "998                       NaN  NaN   \n",
       "999                       NaN  NaN   \n",
       "\n",
       "                                                    TI  ...  \\\n",
       "0    Numerical Evaluation of the Modern and Future ...  ...   \n",
       "1    Explicit Convection and Scale-Aware Cumulus Pa...  ...   \n",
       "2    The Setting, History of Studies, and the Clima...  ...   \n",
       "3    Land-surface controls on afternoon precipitati...  ...   \n",
       "4    Chamber-based insights into the factors contro...  ...   \n",
       "..                                                 ...  ...   \n",
       "995  An insight into the western Pacific wintertime...  ...   \n",
       "996  Gold mineralization in Bubin area, Gilgit-Balt...  ...   \n",
       "997  Direct ozone production rate measurements and ...  ...   \n",
       "998  CROSSING THE \"VALLEY OF DEATH\" Lessons Learned...  ...   \n",
       "999  Early seafloor spreading in the South Atlantic...  ...   \n",
       "\n",
       "                                                    WC  \\\n",
       "0                   Meteorology & Atmospheric Sciences   \n",
       "1                   Meteorology & Atmospheric Sciences   \n",
       "2    Environmental Sciences; Meteorology & Atmosphe...   \n",
       "3    Environmental Sciences; Meteorology & Atmosphe...   \n",
       "4    Environmental Sciences; Meteorology & Atmosphe...   \n",
       "..                                                 ...   \n",
       "995  Engineering, Civil; Geosciences, Multidiscipli...   \n",
       "996                     Geosciences, Multidisciplinary   \n",
       "997                                                NaN   \n",
       "998                                                NaN   \n",
       "999                                                NaN   \n",
       "\n",
       "                                                    SC     GA  \\\n",
       "0                   Meteorology & Atmospheric Sciences  GN9IH   \n",
       "1                   Meteorology & Atmospheric Sciences  GL4CL   \n",
       "2    Environmental Sciences & Ecology; Meteorology ...  BO7BJ   \n",
       "3    Environmental Sciences & Ecology; Meteorology ...  AP3QK   \n",
       "4    Environmental Sciences & Ecology; Meteorology ...  IV8BG   \n",
       "..                                                 ...    ...   \n",
       "995              Engineering; Geology; Water Resources  ER5VE   \n",
       "996                                            Geology  FU1NZ   \n",
       "997                                                NaN    NaN   \n",
       "998                                                NaN    NaN   \n",
       "999                                                NaN    NaN   \n",
       "\n",
       "                      UT          PM                          OA   HC   HP  \\\n",
       "0    WOS:000439508000007  30381797.0      Green Accepted, Bronze  NaN  NaN   \n",
       "1    WOS:000437094500014         NaN                      Bronze  NaN  NaN   \n",
       "2    WOS:000522817700002         NaN                      Bronze  NaN  NaN   \n",
       "3    WOS:000341991600008         NaN  DOAJ Gold, Green Published  NaN  NaN   \n",
       "4    WOS:000484490100002         NaN  DOAJ Gold, Green Published  NaN  NaN   \n",
       "..                   ...         ...                         ...  ...  ...   \n",
       "995  WOS:000398871100009         NaN                         NaN  NaN  NaN   \n",
       "996  WOS:000423618000007         NaN                         NaN  NaN  NaN   \n",
       "997  WOS:000356991000010         NaN                         NaN  NaN  NaN   \n",
       "998  WOS:000342552400008         NaN                         NaN  NaN  NaN   \n",
       "999  WOS:000379772500008         NaN                         NaN  NaN  NaN   \n",
       "\n",
       "          DA INSTITUTION  \n",
       "0    6/19/20   CUBoulder  \n",
       "1    6/19/20   CUBoulder  \n",
       "2    6/19/20   CUBoulder  \n",
       "3    6/19/20   CUBoulder  \n",
       "4    6/19/20   CUBoulder  \n",
       "..       ...         ...  \n",
       "995  7/16/20     Houston  \n",
       "996  7/16/20     Houston  \n",
       "997      NaN     Houston  \n",
       "998      NaN     Houston  \n",
       "999      NaN     Houston  \n",
       "\n",
       "[1000 rows x 69 columns]"
      ]
     },
     "execution_count": 91,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Import csv\n",
    "\n",
    "data = pd.read_csv(\"master_sample.csv\", encoding=\"ISO-8859-1\")\n",
    "data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Data Clean up"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "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>CR</th>\n",
       "      <th>DI</th>\n",
       "      <th>INSTITUTION</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Bacmeister JT, 2018, CLIMATIC CHANGE, V146, P5...</td>\n",
       "      <td>10.1029/2017JD028081</td>\n",
       "      <td>CUBoulder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Arnault J, 2016, J HYDROMETEOROL, V17, P1489, ...</td>\n",
       "      <td>10.1175/MWR-D-17-0238.1</td>\n",
       "      <td>CUBoulder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AMAP, 2017, SNOW WAT IC PERM ARC; AMAP, 2011, ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CUBoulder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Aires Filipe, 2014, Journal of Climate, V27, P...</td>\n",
       "      <td>10.5194/acp-14-8343-2014</td>\n",
       "      <td>CUBoulder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ATKINSON R, 1987, INT J CHEM KINET, V19, P799,...</td>\n",
       "      <td>10.5194/acp-19-11253-2019</td>\n",
       "      <td>CUBoulder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>Araguas-Araguas L, 2000, HYDROL PROCESS, V14, ...</td>\n",
       "      <td>10.1016/j.jhydrol.2017.01.047</td>\n",
       "      <td>Houston</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>Ahmad L, 2016, EARTH SCI INFORM, V9, P113, DOI...</td>\n",
       "      <td>10.1007/s12517-017-3354-9</td>\n",
       "      <td>Houston</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>NaN</td>\n",
       "      <td>10.1016/j.atmosenv.2015.05.033</td>\n",
       "      <td>Houston</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>NaN</td>\n",
       "      <td>10.1175/BAMS-D-13-00176.1</td>\n",
       "      <td>Houston</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>NaN</td>\n",
       "      <td>10.1093/gji/ggw147</td>\n",
       "      <td>Houston</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    CR  \\\n",
       "0    Bacmeister JT, 2018, CLIMATIC CHANGE, V146, P5...   \n",
       "1    Arnault J, 2016, J HYDROMETEOROL, V17, P1489, ...   \n",
       "2    AMAP, 2017, SNOW WAT IC PERM ARC; AMAP, 2011, ...   \n",
       "3    Aires Filipe, 2014, Journal of Climate, V27, P...   \n",
       "4    ATKINSON R, 1987, INT J CHEM KINET, V19, P799,...   \n",
       "..                                                 ...   \n",
       "995  Araguas-Araguas L, 2000, HYDROL PROCESS, V14, ...   \n",
       "996  Ahmad L, 2016, EARTH SCI INFORM, V9, P113, DOI...   \n",
       "997                                                NaN   \n",
       "998                                                NaN   \n",
       "999                                                NaN   \n",
       "\n",
       "                                 DI INSTITUTION  \n",
       "0              10.1029/2017JD028081   CUBoulder  \n",
       "1           10.1175/MWR-D-17-0238.1   CUBoulder  \n",
       "2                               NaN   CUBoulder  \n",
       "3          10.5194/acp-14-8343-2014   CUBoulder  \n",
       "4         10.5194/acp-19-11253-2019   CUBoulder  \n",
       "..                              ...         ...  \n",
       "995   10.1016/j.jhydrol.2017.01.047     Houston  \n",
       "996       10.1007/s12517-017-3354-9     Houston  \n",
       "997  10.1016/j.atmosenv.2015.05.033     Houston  \n",
       "998       10.1175/BAMS-D-13-00176.1     Houston  \n",
       "999              10.1093/gji/ggw147     Houston  \n",
       "\n",
       "[1000 rows x 3 columns]"
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Select three columns: Cited References, DOI of paper, and Institution\n",
    "citedref = data[['CR', 'DI', 'INSTITUTION']]\n",
    "citedref"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "For each row, take column 'CR', split it at ; and append new row, keeping DOI and Institution\n",
    "*See notes later"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "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>CR</th>\n",
       "      <th>DI</th>\n",
       "      <th>INSTITUTION</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Bacmeister JT, 2018, CLIMATIC CHANGE, V146, P5...</td>\n",
       "      <td>10.1029/2017JD028081</td>\n",
       "      <td>CUBoulder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Bao JW, 2006, MON WEATHER REV, V134, P1063, DO...</td>\n",
       "      <td>10.1029/2017JD028081</td>\n",
       "      <td>CUBoulder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Bonne JL, 2015, J GEOPHYS RES-ATMOS, V120, P29...</td>\n",
       "      <td>10.1029/2017JD028081</td>\n",
       "      <td>CUBoulder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bosilovich MG, 2015, J CLIMATE, V28, P3631, DO...</td>\n",
       "      <td>10.1029/2017JD028081</td>\n",
       "      <td>CUBoulder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Coplen TB, 2008, GEOPHYS RES LETT, V35, DOI 10...</td>\n",
       "      <td>10.1029/2017JD028081</td>\n",
       "      <td>CUBoulder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55575</th>\n",
       "      <td>Robb LJ., 2013, INTRO ORE FORMING PR</td>\n",
       "      <td>10.1007/s12517-017-3354-9</td>\n",
       "      <td>Houston</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55576</th>\n",
       "      <td>Smythe DM, 2013, MINER ENG, V52, P52, DOI 10.1...</td>\n",
       "      <td>10.1007/s12517-017-3354-9</td>\n",
       "      <td>Houston</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55577</th>\n",
       "      <td>Sweatman T, 1995, AUST AGEN INT DEV, V91</td>\n",
       "      <td>10.1007/s12517-017-3354-9</td>\n",
       "      <td>Houston</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55578</th>\n",
       "      <td>White NC, 1995, SOC EC GEOLOGISTS NE, V23, P9</td>\n",
       "      <td>10.1007/s12517-017-3354-9</td>\n",
       "      <td>Houston</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55579</th>\n",
       "      <td>Zhu Y., 2011, GEOSCI FRONT, V2, P367, DOI DOI ...</td>\n",
       "      <td>10.1007/s12517-017-3354-9</td>\n",
       "      <td>Houston</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>55580 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                      CR  \\\n",
       "0      Bacmeister JT, 2018, CLIMATIC CHANGE, V146, P5...   \n",
       "1      Bao JW, 2006, MON WEATHER REV, V134, P1063, DO...   \n",
       "2      Bonne JL, 2015, J GEOPHYS RES-ATMOS, V120, P29...   \n",
       "3      Bosilovich MG, 2015, J CLIMATE, V28, P3631, DO...   \n",
       "4      Coplen TB, 2008, GEOPHYS RES LETT, V35, DOI 10...   \n",
       "...                                                  ...   \n",
       "55575               Robb LJ., 2013, INTRO ORE FORMING PR   \n",
       "55576  Smythe DM, 2013, MINER ENG, V52, P52, DOI 10.1...   \n",
       "55577           Sweatman T, 1995, AUST AGEN INT DEV, V91   \n",
       "55578      White NC, 1995, SOC EC GEOLOGISTS NE, V23, P9   \n",
       "55579  Zhu Y., 2011, GEOSCI FRONT, V2, P367, DOI DOI ...   \n",
       "\n",
       "                              DI INSTITUTION  \n",
       "0           10.1029/2017JD028081   CUBoulder  \n",
       "1           10.1029/2017JD028081   CUBoulder  \n",
       "2           10.1029/2017JD028081   CUBoulder  \n",
       "3           10.1029/2017JD028081   CUBoulder  \n",
       "4           10.1029/2017JD028081   CUBoulder  \n",
       "...                          ...         ...  \n",
       "55575  10.1007/s12517-017-3354-9     Houston  \n",
       "55576  10.1007/s12517-017-3354-9     Houston  \n",
       "55577  10.1007/s12517-017-3354-9     Houston  \n",
       "55578  10.1007/s12517-017-3354-9     Houston  \n",
       "55579  10.1007/s12517-017-3354-9     Houston  \n",
       "\n",
       "[55580 rows x 3 columns]"
      ]
     },
     "execution_count": 93,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "citedref = (citedref.set_index(citedref.columns.drop('CR',1).tolist())\n",
    "   ...:    .CR.str.split('; ', expand=True)\n",
    "   ...:    .stack()\n",
    "   ...:    .reset_index()\n",
    "   ...:    .rename(columns={0:'CR'})\n",
    "   ...:    .loc[:, citedref.columns]\n",
    "   ...: )\n",
    "citedref"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Quickly summarize how many cited references by institution:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "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>CR</th>\n",
       "      <th>DI</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INSTITUTION</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Berkeley</th>\n",
       "      <td>16851</td>\n",
       "      <td>15990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CUBoulder</th>\n",
       "      <td>24042</td>\n",
       "      <td>22785</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Houston</th>\n",
       "      <td>1602</td>\n",
       "      <td>1602</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UCLA</th>\n",
       "      <td>13085</td>\n",
       "      <td>13085</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                CR     DI\n",
       "INSTITUTION              \n",
       "Berkeley     16851  15990\n",
       "CUBoulder    24042  22785\n",
       "Houston       1602   1602\n",
       "UCLA         13085  13085"
      ]
     },
     "execution_count": 94,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "citedref_summary = citedref.groupby('INSTITUTION').count()\n",
    "citedref_summary"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Does it add up?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "55580"
      ]
     },
     "execution_count": 95,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "citedref_summary.CR.sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Yep! "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Now... \n",
    "Rather than trying to split the unstructured, dirty data, we'll use regex to pull out the DOI into new column:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "metadata": {},
   "outputs": [],
   "source": [
    "citedref['citedDOI'] = citedref['CR'].str.extract('(10\\.\\S*[^,\\s])', expand=True)[0]\n",
    "citedref['citedDOI'] = citedref.citedDOI.str.rstrip(']')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "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>CR</th>\n",
       "      <th>DI</th>\n",
       "      <th>INSTITUTION</th>\n",
       "      <th>citedDOI</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Bacmeister JT, 2018, CLIMATIC CHANGE, V146, P5...</td>\n",
       "      <td>10.1029/2017JD028081</td>\n",
       "      <td>CUBoulder</td>\n",
       "      <td>10.1007/s10584-016-1750-x</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Bao JW, 2006, MON WEATHER REV, V134, P1063, DO...</td>\n",
       "      <td>10.1029/2017JD028081</td>\n",
       "      <td>CUBoulder</td>\n",
       "      <td>10.1175/MWR3123.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Bonne JL, 2015, J GEOPHYS RES-ATMOS, V120, P29...</td>\n",
       "      <td>10.1029/2017JD028081</td>\n",
       "      <td>CUBoulder</td>\n",
       "      <td>10.1002/2014JD022602</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bosilovich MG, 2015, J CLIMATE, V28, P3631, DO...</td>\n",
       "      <td>10.1029/2017JD028081</td>\n",
       "      <td>CUBoulder</td>\n",
       "      <td>10.1175/JCLI-D-14-00623.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Coplen TB, 2008, GEOPHYS RES LETT, V35, DOI 10...</td>\n",
       "      <td>10.1029/2017JD028081</td>\n",
       "      <td>CUBoulder</td>\n",
       "      <td>10.1029/2008GL035481</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55575</th>\n",
       "      <td>Robb LJ., 2013, INTRO ORE FORMING PR</td>\n",
       "      <td>10.1007/s12517-017-3354-9</td>\n",
       "      <td>Houston</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55576</th>\n",
       "      <td>Smythe DM, 2013, MINER ENG, V52, P52, DOI 10.1...</td>\n",
       "      <td>10.1007/s12517-017-3354-9</td>\n",
       "      <td>Houston</td>\n",
       "      <td>10.1016/j.mineng.2013.03.010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55577</th>\n",
       "      <td>Sweatman T, 1995, AUST AGEN INT DEV, V91</td>\n",
       "      <td>10.1007/s12517-017-3354-9</td>\n",
       "      <td>Houston</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55578</th>\n",
       "      <td>White NC, 1995, SOC EC GEOLOGISTS NE, V23, P9</td>\n",
       "      <td>10.1007/s12517-017-3354-9</td>\n",
       "      <td>Houston</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55579</th>\n",
       "      <td>Zhu Y., 2011, GEOSCI FRONT, V2, P367, DOI DOI ...</td>\n",
       "      <td>10.1007/s12517-017-3354-9</td>\n",
       "      <td>Houston</td>\n",
       "      <td>10.1016/J.GSF.2011.05.006</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>55580 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                      CR  \\\n",
       "0      Bacmeister JT, 2018, CLIMATIC CHANGE, V146, P5...   \n",
       "1      Bao JW, 2006, MON WEATHER REV, V134, P1063, DO...   \n",
       "2      Bonne JL, 2015, J GEOPHYS RES-ATMOS, V120, P29...   \n",
       "3      Bosilovich MG, 2015, J CLIMATE, V28, P3631, DO...   \n",
       "4      Coplen TB, 2008, GEOPHYS RES LETT, V35, DOI 10...   \n",
       "...                                                  ...   \n",
       "55575               Robb LJ., 2013, INTRO ORE FORMING PR   \n",
       "55576  Smythe DM, 2013, MINER ENG, V52, P52, DOI 10.1...   \n",
       "55577           Sweatman T, 1995, AUST AGEN INT DEV, V91   \n",
       "55578      White NC, 1995, SOC EC GEOLOGISTS NE, V23, P9   \n",
       "55579  Zhu Y., 2011, GEOSCI FRONT, V2, P367, DOI DOI ...   \n",
       "\n",
       "                              DI INSTITUTION                      citedDOI  \n",
       "0           10.1029/2017JD028081   CUBoulder     10.1007/s10584-016-1750-x  \n",
       "1           10.1029/2017JD028081   CUBoulder             10.1175/MWR3123.1  \n",
       "2           10.1029/2017JD028081   CUBoulder          10.1002/2014JD022602  \n",
       "3           10.1029/2017JD028081   CUBoulder     10.1175/JCLI-D-14-00623.1  \n",
       "4           10.1029/2017JD028081   CUBoulder          10.1029/2008GL035481  \n",
       "...                          ...         ...                           ...  \n",
       "55575  10.1007/s12517-017-3354-9     Houston                           NaN  \n",
       "55576  10.1007/s12517-017-3354-9     Houston  10.1016/j.mineng.2013.03.010  \n",
       "55577  10.1007/s12517-017-3354-9     Houston                           NaN  \n",
       "55578  10.1007/s12517-017-3354-9     Houston                           NaN  \n",
       "55579  10.1007/s12517-017-3354-9     Houston     10.1016/J.GSF.2011.05.006  \n",
       "\n",
       "[55580 rows x 4 columns]"
      ]
     },
     "execution_count": 97,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "citedref"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Export this to CSV:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "metadata": {},
   "outputs": [],
   "source": [
    "citedref.to_csv('citedRef_master.csv', encoding='utf-8')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Crossref\n",
    "\n",
    "#### Rather than cleaning up the sloppy citation data, we'll use the articles' DOIs to get the journal metadata from the CrossRef API. We'll start by creating variables for the APIs url and the header we'll need to send along with it.\n",
    "\n",
    "*Note: insert you're own email into the header* "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "metadata": {},
   "outputs": [],
   "source": [
    "url = 'http://api.crossref.org/works/'\n",
    "header = {'User-Agent': 'EarthSciCitations (https://github.com/samteplitzky/Earth-Science-Citation-Replication-Project; mailto:steplitz@berkeley.edu)'}"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now we'll use requests to send a query for each DOI to the CrossRef API. this will get the article metadata from CrossRef, write to new csv.\n",
    "\n",
    "*This takes a loooooooooong time to run!. Best to execute at the end of your work day. Should be completed by tomorrow. It took ten hours when I ran it.*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "start time:  2020-07-22 18:57:46.605824\n",
      "end time:  2020-07-23 05:42:16.779777\n"
     ]
    }
   ],
   "source": [
    "timestamp=datetime.timestamp(datetime.now())\n",
    "print('start time: ',datetime.fromtimestamp(timestamp))\n",
    "with open('citedRefsMeta.csv', 'w', newline='', encoding='utf-8') as f:\n",
    "    writer = csv.writer(f)\n",
    "    writer.writerow(['Inst','citingDOI','CR','citedDOI', 'title', 'journal_book', 'date','issn1', 'issn1Type', 'issn2', 'issn2Type', 'isbn'])\n",
    "    for i, row in citedref.iterrows():\n",
    "        sleep(.2)\n",
    "        if pd.notna(row['citedDOI']):\n",
    "            query = url+row['citedDOI']\n",
    "            #print(query)\n",
    "            response = requests.get(query, headers=header)\n",
    "            if response.status_code == 200:\n",
    "                data = json.loads(response.content.decode('utf-8'))\n",
    "                \n",
    "                if 'container-title' in data['message']:\n",
    "                    journal = data['message']['container-title']\n",
    "                    if len(journal) > 0:\n",
    "                        journal = journal[0]\n",
    "                    else: journal = 'nan'                    \n",
    "                else:\n",
    "                    journal='nan'\n",
    "                    \n",
    "                year = data['message']['created']['date-parts'][0][0]\n",
    "                \n",
    "                if 'title' in data['message']:\n",
    "                    title = data['message']['title']\n",
    "                    if len(title) > 0:\n",
    "                        title = title[0]\n",
    "                    else:\n",
    "                        title = 'nan'\n",
    "                else:\n",
    "                    title='nan'\n",
    "                    \n",
    "                if 'ISBN' in data['message']:                     \n",
    "                    isbn = data['message']['ISBN'][0]\n",
    "                    \n",
    "                    writer.writerow([row['INSTITUTION'], row['DI'], row['CR'], row['citedDOI'], title, journal, year, 'nan', 'nan', 'nan', 'nan', isbn])\n",
    "                else:\n",
    "                    \n",
    "                    if 'ISSN' in data['message']:\n",
    "                        issn1 = data['message']['issn-type'][0]['value']\n",
    "                        issn1Type = data['message']['issn-type'][0]['type']\n",
    "                        \n",
    "                        if len(data['message']['issn-type'])>1:\n",
    "                            issn2 = data['message']['issn-type'][1]['value']\n",
    "                            issn2Type = data['message']['issn-type'][1]['type']\n",
    "                            writer.writerow([row['INSTITUTION'], row['DI'], row['CR'], row['citedDOI'], title, journal, year, issn1, issn1Type, issn2, issn2Type,'nan'])\n",
    "                        \n",
    "                        else:\n",
    "                            writer.writerow([row['INSTITUTION'], row['DI'], row['CR'], row['citedDOI'], title, journal, year, issn1, issn1Type, 'nan', 'nan','nan'])\n",
    "                    else:\n",
    "                        writer.writerow([row['INSTITUTION'], row['DI'], row['CR'], row['citedDOI'], title, journal, year, 'nan', 'nan', 'nan', 'nan','nan'])\n",
    "            else:\n",
    "                writer.writerow([row['INSTITUTION'], row['DI'], row['CR'], row['citedDOI'],'nan','nan', 'nan', 'nan', 'nan', 'nan', 'nan','nan'])\n",
    "        else:\n",
    "            writer.writerow([row['INSTITUTION'], row['DI'], row['CR'], row['citedDOI'], 'nan','nan','nan', 'nan', 'nan', 'nan', 'nan','nan'])\n",
    "\n",
    "timestamp=datetime.timestamp(datetime.now())\n",
    "print('end time: ',datetime.fromtimestamp(timestamp))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## All done? Yay, good morning!\n",
    "read in the new citedRefsMeta.csv file to a pandas dataframe:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "metadata": {},
   "outputs": [],
   "source": [
    "citedRefsMeta = pd.read_csv('citedRefsMeta.csv', encoding='utf-8')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "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>Inst</th>\n",
       "      <th>citingDOI</th>\n",
       "      <th>CR</th>\n",
       "      <th>citedDOI</th>\n",
       "      <th>title</th>\n",
       "      <th>journal_book</th>\n",
       "      <th>date</th>\n",
       "      <th>issn1</th>\n",
       "      <th>issn1Type</th>\n",
       "      <th>issn2</th>\n",
       "      <th>issn2Type</th>\n",
       "      <th>isbn</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>CUBoulder</td>\n",
       "      <td>10.1029/2017JD028081</td>\n",
       "      <td>Bacmeister JT, 2018, CLIMATIC CHANGE, V146, P5...</td>\n",
       "      <td>10.1007/s10584-016-1750-x</td>\n",
       "      <td>Projected changes in tropical cyclone activity...</td>\n",
       "      <td>Climatic Change</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>0165-0009</td>\n",
       "      <td>print</td>\n",
       "      <td>1573-1480</td>\n",
       "      <td>electronic</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CUBoulder</td>\n",
       "      <td>10.1029/2017JD028081</td>\n",
       "      <td>Bao JW, 2006, MON WEATHER REV, V134, P1063, DO...</td>\n",
       "      <td>10.1175/MWR3123.1</td>\n",
       "      <td>Interpretation of Enhanced Integrated Water Va...</td>\n",
       "      <td>Monthly Weather Review</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>0027-0644</td>\n",
       "      <td>print</td>\n",
       "      <td>1520-0493</td>\n",
       "      <td>electronic</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CUBoulder</td>\n",
       "      <td>10.1029/2017JD028081</td>\n",
       "      <td>Bonne JL, 2015, J GEOPHYS RES-ATMOS, V120, P29...</td>\n",
       "      <td>10.1002/2014JD022602</td>\n",
       "      <td>The summer 2012 Greenland heat wave: In situ a...</td>\n",
       "      <td>Journal of Geophysical Research: Atmospheres</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>2169-897X</td>\n",
       "      <td>print</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CUBoulder</td>\n",
       "      <td>10.1029/2017JD028081</td>\n",
       "      <td>Bosilovich MG, 2015, J CLIMATE, V28, P3631, DO...</td>\n",
       "      <td>10.1175/JCLI-D-14-00623.1</td>\n",
       "      <td>Evaluating Observation Influence on Regional W...</td>\n",
       "      <td>Journal of Climate</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>0894-8755</td>\n",
       "      <td>print</td>\n",
       "      <td>1520-0442</td>\n",
       "      <td>electronic</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CUBoulder</td>\n",
       "      <td>10.1029/2017JD028081</td>\n",
       "      <td>Coplen TB, 2008, GEOPHYS RES LETT, V35, DOI 10...</td>\n",
       "      <td>10.1029/2008GL035481</td>\n",
       "      <td>Extreme changes in stable hydrogen isotopes an...</td>\n",
       "      <td>Geophysical Research Letters</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>0094-8276</td>\n",
       "      <td>print</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55575</th>\n",
       "      <td>Houston</td>\n",
       "      <td>10.1007/s12517-017-3354-9</td>\n",
       "      <td>Robb LJ., 2013, INTRO ORE FORMING PR</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55576</th>\n",
       "      <td>Houston</td>\n",
       "      <td>10.1007/s12517-017-3354-9</td>\n",
       "      <td>Smythe DM, 2013, MINER ENG, V52, P52, DOI 10.1...</td>\n",
       "      <td>10.1016/j.mineng.2013.03.010</td>\n",
       "      <td>Rare Earth Element deportment studies utilisin...</td>\n",
       "      <td>Minerals Engineering</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>0892-6875</td>\n",
       "      <td>print</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55577</th>\n",
       "      <td>Houston</td>\n",
       "      <td>10.1007/s12517-017-3354-9</td>\n",
       "      <td>Sweatman T, 1995, AUST AGEN INT DEV, V91</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55578</th>\n",
       "      <td>Houston</td>\n",
       "      <td>10.1007/s12517-017-3354-9</td>\n",
       "      <td>White NC, 1995, SOC EC GEOLOGISTS NE, V23, P9</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55579</th>\n",
       "      <td>Houston</td>\n",
       "      <td>10.1007/s12517-017-3354-9</td>\n",
       "      <td>Zhu Y., 2011, GEOSCI FRONT, V2, P367, DOI DOI ...</td>\n",
       "      <td>10.1016/J.GSF.2011.05.006</td>\n",
       "      <td>Geochemistry of hydrothermal gold deposits: A ...</td>\n",
       "      <td>Geoscience Frontiers</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>1674-9871</td>\n",
       "      <td>print</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>55580 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Inst                  citingDOI  \\\n",
       "0      CUBoulder       10.1029/2017JD028081   \n",
       "1      CUBoulder       10.1029/2017JD028081   \n",
       "2      CUBoulder       10.1029/2017JD028081   \n",
       "3      CUBoulder       10.1029/2017JD028081   \n",
       "4      CUBoulder       10.1029/2017JD028081   \n",
       "...          ...                        ...   \n",
       "55575    Houston  10.1007/s12517-017-3354-9   \n",
       "55576    Houston  10.1007/s12517-017-3354-9   \n",
       "55577    Houston  10.1007/s12517-017-3354-9   \n",
       "55578    Houston  10.1007/s12517-017-3354-9   \n",
       "55579    Houston  10.1007/s12517-017-3354-9   \n",
       "\n",
       "                                                      CR  \\\n",
       "0      Bacmeister JT, 2018, CLIMATIC CHANGE, V146, P5...   \n",
       "1      Bao JW, 2006, MON WEATHER REV, V134, P1063, DO...   \n",
       "2      Bonne JL, 2015, J GEOPHYS RES-ATMOS, V120, P29...   \n",
       "3      Bosilovich MG, 2015, J CLIMATE, V28, P3631, DO...   \n",
       "4      Coplen TB, 2008, GEOPHYS RES LETT, V35, DOI 10...   \n",
       "...                                                  ...   \n",
       "55575               Robb LJ., 2013, INTRO ORE FORMING PR   \n",
       "55576  Smythe DM, 2013, MINER ENG, V52, P52, DOI 10.1...   \n",
       "55577           Sweatman T, 1995, AUST AGEN INT DEV, V91   \n",
       "55578      White NC, 1995, SOC EC GEOLOGISTS NE, V23, P9   \n",
       "55579  Zhu Y., 2011, GEOSCI FRONT, V2, P367, DOI DOI ...   \n",
       "\n",
       "                           citedDOI  \\\n",
       "0         10.1007/s10584-016-1750-x   \n",
       "1                 10.1175/MWR3123.1   \n",
       "2              10.1002/2014JD022602   \n",
       "3         10.1175/JCLI-D-14-00623.1   \n",
       "4              10.1029/2008GL035481   \n",
       "...                             ...   \n",
       "55575                           NaN   \n",
       "55576  10.1016/j.mineng.2013.03.010   \n",
       "55577                           NaN   \n",
       "55578                           NaN   \n",
       "55579     10.1016/J.GSF.2011.05.006   \n",
       "\n",
       "                                                   title  \\\n",
       "0      Projected changes in tropical cyclone activity...   \n",
       "1      Interpretation of Enhanced Integrated Water Va...   \n",
       "2      The summer 2012 Greenland heat wave: In situ a...   \n",
       "3      Evaluating Observation Influence on Regional W...   \n",
       "4      Extreme changes in stable hydrogen isotopes an...   \n",
       "...                                                  ...   \n",
       "55575                                                NaN   \n",
       "55576  Rare Earth Element deportment studies utilisin...   \n",
       "55577                                                NaN   \n",
       "55578                                                NaN   \n",
       "55579  Geochemistry of hydrothermal gold deposits: A ...   \n",
       "\n",
       "                                       journal_book    date      issn1  \\\n",
       "0                                   Climatic Change  2016.0  0165-0009   \n",
       "1                            Monthly Weather Review  2006.0  0027-0644   \n",
       "2      Journal of Geophysical Research: Atmospheres  2015.0  2169-897X   \n",
       "3                                Journal of Climate  2015.0  0894-8755   \n",
       "4                      Geophysical Research Letters  2008.0  0094-8276   \n",
       "...                                             ...     ...        ...   \n",
       "55575                                           NaN     NaN        NaN   \n",
       "55576                          Minerals Engineering  2013.0  0892-6875   \n",
       "55577                                           NaN     NaN        NaN   \n",
       "55578                                           NaN     NaN        NaN   \n",
       "55579                          Geoscience Frontiers  2011.0  1674-9871   \n",
       "\n",
       "      issn1Type      issn2   issn2Type isbn  \n",
       "0         print  1573-1480  electronic  NaN  \n",
       "1         print  1520-0493  electronic  NaN  \n",
       "2         print        NaN         NaN  NaN  \n",
       "3         print  1520-0442  electronic  NaN  \n",
       "4         print        NaN         NaN  NaN  \n",
       "...         ...        ...         ...  ...  \n",
       "55575       NaN        NaN         NaN  NaN  \n",
       "55576     print        NaN         NaN  NaN  \n",
       "55577       NaN        NaN         NaN  NaN  \n",
       "55578       NaN        NaN         NaN  NaN  \n",
       "55579     print        NaN         NaN  NaN  \n",
       "\n",
       "[55580 rows x 12 columns]"
      ]
     },
     "execution_count": 131,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "citedRefsMeta"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Isolate Journal and Book Titles"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0                                     Climatic Change\n",
       "1                              Monthly Weather Review\n",
       "2        Journal of Geophysical Research: Atmospheres\n",
       "3                                  Journal of Climate\n",
       "4                        Geophysical Research Letters\n",
       "                             ...                     \n",
       "55575                                             NaN\n",
       "55576                            Minerals Engineering\n",
       "55577                                             NaN\n",
       "55578                                             NaN\n",
       "55579                            Geoscience Frontiers\n",
       "Name: journal_book, Length: 55580, dtype: object"
      ]
     },
     "execution_count": 132,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "citedRefsMeta['journal_book']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Follow up**: You may notice the appears of Nan or null values in the 'journal_book' column. We will ignore these for now, but note how many there are for future data clean up."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 133,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "11280"
      ]
     },
     "execution_count": 133,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "citedRefsMeta['journal_book'].isna().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 134,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "10635"
      ]
     },
     "execution_count": 134,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "citedRefsMeta['citedDOI'].isna().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Take Counts for each title\n",
    "\n",
    "The following five cells leads you through the steps needed to visualize the 80/20 rule (do 80% of citations come from 20% of titles). You will:\n",
    "- count the number of times a journal title is cited\n",
    "- create a cumulative summation of the counts\n",
    "- calculate the title percent (each additional title is what percent of the total?)\n",
    "- calculate the citation percent (each title accounts for what percent of total citations?)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "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>journal_book</th>\n",
       "      <th>counts</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Journal of Geophysical Research</td>\n",
       "      <td>2509</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Geophysical Research Letters</td>\n",
       "      <td>2451</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Atmospheric Chemistry and Physics</td>\n",
       "      <td>1310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Journal of Climate</td>\n",
       "      <td>1241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Science</td>\n",
       "      <td>1225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2710</th>\n",
       "      <td>Pastoralism</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2711</th>\n",
       "      <td>Journal of Colloid Science</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2712</th>\n",
       "      <td>COMPEL - The international journal for computa...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2713</th>\n",
       "      <td>The Geophysics of Sea Ice</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2714</th>\n",
       "      <td>Journal of Archaeological Method and Theory</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2715 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           journal_book  counts\n",
       "0                       Journal of Geophysical Research    2509\n",
       "1                          Geophysical Research Letters    2451\n",
       "2                     Atmospheric Chemistry and Physics    1310\n",
       "3                                    Journal of Climate    1241\n",
       "4                                               Science    1225\n",
       "...                                                 ...     ...\n",
       "2710                                        Pastoralism       1\n",
       "2711                         Journal of Colloid Science       1\n",
       "2712  COMPEL - The international journal for computa...       1\n",
       "2713                          The Geophysics of Sea Ice       1\n",
       "2714        Journal of Archaeological Method and Theory       1\n",
       "\n",
       "[2715 rows x 2 columns]"
      ]
     },
     "execution_count": 135,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "citedRefsMeta_count = citedRefsMeta['journal_book'].value_counts().rename_axis('journal_book').reset_index(name='counts')\n",
    "citedRefsMeta_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 136,
   "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>journal_book</th>\n",
       "      <th>counts</th>\n",
       "      <th>cumsum</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Journal of Geophysical Research</td>\n",
       "      <td>2509</td>\n",
       "      <td>2509</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Geophysical Research Letters</td>\n",
       "      <td>2451</td>\n",
       "      <td>4960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Atmospheric Chemistry and Physics</td>\n",
       "      <td>1310</td>\n",
       "      <td>6270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Journal of Climate</td>\n",
       "      <td>1241</td>\n",
       "      <td>7511</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Science</td>\n",
       "      <td>1225</td>\n",
       "      <td>8736</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2710</th>\n",
       "      <td>Pastoralism</td>\n",
       "      <td>1</td>\n",
       "      <td>44296</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2711</th>\n",
       "      <td>Journal of Colloid Science</td>\n",
       "      <td>1</td>\n",
       "      <td>44297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2712</th>\n",
       "      <td>COMPEL - The international journal for computa...</td>\n",
       "      <td>1</td>\n",
       "      <td>44298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2713</th>\n",
       "      <td>The Geophysics of Sea Ice</td>\n",
       "      <td>1</td>\n",
       "      <td>44299</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2714</th>\n",
       "      <td>Journal of Archaeological Method and Theory</td>\n",
       "      <td>1</td>\n",
       "      <td>44300</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2715 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           journal_book  counts  cumsum\n",
       "0                       Journal of Geophysical Research    2509    2509\n",
       "1                          Geophysical Research Letters    2451    4960\n",
       "2                     Atmospheric Chemistry and Physics    1310    6270\n",
       "3                                    Journal of Climate    1241    7511\n",
       "4                                               Science    1225    8736\n",
       "...                                                 ...     ...     ...\n",
       "2710                                        Pastoralism       1   44296\n",
       "2711                         Journal of Colloid Science       1   44297\n",
       "2712  COMPEL - The international journal for computa...       1   44298\n",
       "2713                          The Geophysics of Sea Ice       1   44299\n",
       "2714        Journal of Archaeological Method and Theory       1   44300\n",
       "\n",
       "[2715 rows x 3 columns]"
      ]
     },
     "execution_count": 136,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "citedRefsMeta_count['cumsum'] = citedRefsMeta_count['counts'].cumsum()\n",
    "citedRefsMeta_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "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>journal_book</th>\n",
       "      <th>counts</th>\n",
       "      <th>cumsum</th>\n",
       "      <th>titlenum</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Journal of Geophysical Research</td>\n",
       "      <td>2509</td>\n",
       "      <td>2509</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Geophysical Research Letters</td>\n",
       "      <td>2451</td>\n",
       "      <td>4960</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Atmospheric Chemistry and Physics</td>\n",
       "      <td>1310</td>\n",
       "      <td>6270</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Journal of Climate</td>\n",
       "      <td>1241</td>\n",
       "      <td>7511</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Science</td>\n",
       "      <td>1225</td>\n",
       "      <td>8736</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2710</th>\n",
       "      <td>Pastoralism</td>\n",
       "      <td>1</td>\n",
       "      <td>44296</td>\n",
       "      <td>2711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2711</th>\n",
       "      <td>Journal of Colloid Science</td>\n",
       "      <td>1</td>\n",
       "      <td>44297</td>\n",
       "      <td>2712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2712</th>\n",
       "      <td>COMPEL - The international journal for computa...</td>\n",
       "      <td>1</td>\n",
       "      <td>44298</td>\n",
       "      <td>2713</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2713</th>\n",
       "      <td>The Geophysics of Sea Ice</td>\n",
       "      <td>1</td>\n",
       "      <td>44299</td>\n",
       "      <td>2714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2714</th>\n",
       "      <td>Journal of Archaeological Method and Theory</td>\n",
       "      <td>1</td>\n",
       "      <td>44300</td>\n",
       "      <td>2715</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2715 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           journal_book  counts  cumsum  \\\n",
       "0                       Journal of Geophysical Research    2509    2509   \n",
       "1                          Geophysical Research Letters    2451    4960   \n",
       "2                     Atmospheric Chemistry and Physics    1310    6270   \n",
       "3                                    Journal of Climate    1241    7511   \n",
       "4                                               Science    1225    8736   \n",
       "...                                                 ...     ...     ...   \n",
       "2710                                        Pastoralism       1   44296   \n",
       "2711                         Journal of Colloid Science       1   44297   \n",
       "2712  COMPEL - The international journal for computa...       1   44298   \n",
       "2713                          The Geophysics of Sea Ice       1   44299   \n",
       "2714        Journal of Archaeological Method and Theory       1   44300   \n",
       "\n",
       "      titlenum  \n",
       "0            1  \n",
       "1            2  \n",
       "2            3  \n",
       "3            4  \n",
       "4            5  \n",
       "...        ...  \n",
       "2710      2711  \n",
       "2711      2712  \n",
       "2712      2713  \n",
       "2713      2714  \n",
       "2714      2715  \n",
       "\n",
       "[2715 rows x 4 columns]"
      ]
     },
     "execution_count": 137,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "citedRefsMeta_count['titlenum'] = range(1, 1+len(citedRefsMeta_count))\n",
    "citedRefsMeta_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 139,
   "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>journal_book</th>\n",
       "      <th>counts</th>\n",
       "      <th>cumsum</th>\n",
       "      <th>titlenum</th>\n",
       "      <th>titlepct</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Journal of Geophysical Research</td>\n",
       "      <td>2509</td>\n",
       "      <td>2509</td>\n",
       "      <td>1</td>\n",
       "      <td>0.036832</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Geophysical Research Letters</td>\n",
       "      <td>2451</td>\n",
       "      <td>4960</td>\n",
       "      <td>2</td>\n",
       "      <td>0.073665</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Atmospheric Chemistry and Physics</td>\n",
       "      <td>1310</td>\n",
       "      <td>6270</td>\n",
       "      <td>3</td>\n",
       "      <td>0.110497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Journal of Climate</td>\n",
       "      <td>1241</td>\n",
       "      <td>7511</td>\n",
       "      <td>4</td>\n",
       "      <td>0.147330</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Science</td>\n",
       "      <td>1225</td>\n",
       "      <td>8736</td>\n",
       "      <td>5</td>\n",
       "      <td>0.184162</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>2710</th>\n",
       "      <td>Pastoralism</td>\n",
       "      <td>1</td>\n",
       "      <td>44296</td>\n",
       "      <td>2711</td>\n",
       "      <td>99.852670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2711</th>\n",
       "      <td>Journal of Colloid Science</td>\n",
       "      <td>1</td>\n",
       "      <td>44297</td>\n",
       "      <td>2712</td>\n",
       "      <td>99.889503</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2712</th>\n",
       "      <td>COMPEL - The international journal for computa...</td>\n",
       "      <td>1</td>\n",
       "      <td>44298</td>\n",
       "      <td>2713</td>\n",
       "      <td>99.926335</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2713</th>\n",
       "      <td>The Geophysics of Sea Ice</td>\n",
       "      <td>1</td>\n",
       "      <td>44299</td>\n",
       "      <td>2714</td>\n",
       "      <td>99.963168</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2714</th>\n",
       "      <td>Journal of Archaeological Method and Theory</td>\n",
       "      <td>1</td>\n",
       "      <td>44300</td>\n",
       "      <td>2715</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2715 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           journal_book  counts  cumsum  \\\n",
       "0                       Journal of Geophysical Research    2509    2509   \n",
       "1                          Geophysical Research Letters    2451    4960   \n",
       "2                     Atmospheric Chemistry and Physics    1310    6270   \n",
       "3                                    Journal of Climate    1241    7511   \n",
       "4                                               Science    1225    8736   \n",
       "...                                                 ...     ...     ...   \n",
       "2710                                        Pastoralism       1   44296   \n",
       "2711                         Journal of Colloid Science       1   44297   \n",
       "2712  COMPEL - The international journal for computa...       1   44298   \n",
       "2713                          The Geophysics of Sea Ice       1   44299   \n",
       "2714        Journal of Archaeological Method and Theory       1   44300   \n",
       "\n",
       "      titlenum    titlepct  \n",
       "0            1    0.036832  \n",
       "1            2    0.073665  \n",
       "2            3    0.110497  \n",
       "3            4    0.147330  \n",
       "4            5    0.184162  \n",
       "...        ...         ...  \n",
       "2710      2711   99.852670  \n",
       "2711      2712   99.889503  \n",
       "2712      2713   99.926335  \n",
       "2713      2714   99.963168  \n",
       "2714      2715  100.000000  \n",
       "\n",
       "[2715 rows x 5 columns]"
      ]
     },
     "execution_count": 139,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "citedRefsMeta_count['titlepct'] = 100*(citedRefsMeta_count.titlenum/2715)\n",
    "citedRefsMeta_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 140,
   "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>journal_book</th>\n",
       "      <th>counts</th>\n",
       "      <th>cumsum</th>\n",
       "      <th>titlenum</th>\n",
       "      <th>titlepct</th>\n",
       "      <th>citationpct</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Journal of Geophysical Research</td>\n",
       "      <td>2509</td>\n",
       "      <td>2509</td>\n",
       "      <td>1</td>\n",
       "      <td>0.036832</td>\n",
       "      <td>5.663657</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Geophysical Research Letters</td>\n",
       "      <td>2451</td>\n",
       "      <td>4960</td>\n",
       "      <td>2</td>\n",
       "      <td>0.073665</td>\n",
       "      <td>11.196388</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Atmospheric Chemistry and Physics</td>\n",
       "      <td>1310</td>\n",
       "      <td>6270</td>\n",
       "      <td>3</td>\n",
       "      <td>0.110497</td>\n",
       "      <td>14.153499</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Journal of Climate</td>\n",
       "      <td>1241</td>\n",
       "      <td>7511</td>\n",
       "      <td>4</td>\n",
       "      <td>0.147330</td>\n",
       "      <td>16.954853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Science</td>\n",
       "      <td>1225</td>\n",
       "      <td>8736</td>\n",
       "      <td>5</td>\n",
       "      <td>0.184162</td>\n",
       "      <td>19.720090</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2710</th>\n",
       "      <td>Pastoralism</td>\n",
       "      <td>1</td>\n",
       "      <td>44296</td>\n",
       "      <td>2711</td>\n",
       "      <td>99.852670</td>\n",
       "      <td>99.990971</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2711</th>\n",
       "      <td>Journal of Colloid Science</td>\n",
       "      <td>1</td>\n",
       "      <td>44297</td>\n",
       "      <td>2712</td>\n",
       "      <td>99.889503</td>\n",
       "      <td>99.993228</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2712</th>\n",
       "      <td>COMPEL - The international journal for computa...</td>\n",
       "      <td>1</td>\n",
       "      <td>44298</td>\n",
       "      <td>2713</td>\n",
       "      <td>99.926335</td>\n",
       "      <td>99.995485</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2713</th>\n",
       "      <td>The Geophysics of Sea Ice</td>\n",
       "      <td>1</td>\n",
       "      <td>44299</td>\n",
       "      <td>2714</td>\n",
       "      <td>99.963168</td>\n",
       "      <td>99.997743</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2714</th>\n",
       "      <td>Journal of Archaeological Method and Theory</td>\n",
       "      <td>1</td>\n",
       "      <td>44300</td>\n",
       "      <td>2715</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2715 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           journal_book  counts  cumsum  \\\n",
       "0                       Journal of Geophysical Research    2509    2509   \n",
       "1                          Geophysical Research Letters    2451    4960   \n",
       "2                     Atmospheric Chemistry and Physics    1310    6270   \n",
       "3                                    Journal of Climate    1241    7511   \n",
       "4                                               Science    1225    8736   \n",
       "...                                                 ...     ...     ...   \n",
       "2710                                        Pastoralism       1   44296   \n",
       "2711                         Journal of Colloid Science       1   44297   \n",
       "2712  COMPEL - The international journal for computa...       1   44298   \n",
       "2713                          The Geophysics of Sea Ice       1   44299   \n",
       "2714        Journal of Archaeological Method and Theory       1   44300   \n",
       "\n",
       "      titlenum    titlepct  citationpct  \n",
       "0            1    0.036832     5.663657  \n",
       "1            2    0.073665    11.196388  \n",
       "2            3    0.110497    14.153499  \n",
       "3            4    0.147330    16.954853  \n",
       "4            5    0.184162    19.720090  \n",
       "...        ...         ...          ...  \n",
       "2710      2711   99.852670    99.990971  \n",
       "2711      2712   99.889503    99.993228  \n",
       "2712      2713   99.926335    99.995485  \n",
       "2713      2714   99.963168    99.997743  \n",
       "2714      2715  100.000000   100.000000  \n",
       "\n",
       "[2715 rows x 6 columns]"
      ]
     },
     "execution_count": 140,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "citedRefsMeta_count['citationpct'] = 100*citedRefsMeta_count['cumsum']/(44300)\n",
    "citedRefsMeta_count"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Plot 80/20 rule"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The cell below will tell you what percent of titles are represented by 80% of the total citations?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 141,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "7.8821362799263355"
      ]
     },
     "execution_count": 141,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ind=np.argmin(abs(80.-citedRefsMeta_count.citationpct))\n",
    "pctile = citedRefsMeta_count.titlepct[ind]\n",
    "pctile"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Plot 80/20 rule using the code below:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 142,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYUAAAEGCAYAAACKB4k+AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAgAElEQVR4nO3deZxcZZ3v8c+vt3R39k4nIUkDnUAbkM1gI4sOBMKoSGRxgDsaHVCWy1UkOKMCOnNl7lwEBq6DqBeMIIsXg2xDAGdAzYaMgEkgiQlJICQhdNams3a6O7397h/ndKWqekmlU0t3n+/79apX1Tl1Tp1fdSXP75znec7zmLsjIiICkJfrAEREpO9QUhARkRglBRERiVFSEBGRGCUFERGJKch1AIejvLzcKysrcx1GZ2vWBM+TJ+c2DhGRLixZsuRDdx/d1Xv9OilUVlayePHiXIfR2dSpwfOCBbmMQkSkS2b2fnfvqfpIRERilBRERCRGSUFERGKUFEREJEZJQUREYjKWFMzsl2a23cxWxK0rM7Pfm9m74fPIcL2Z2X1mttbMlpvZqZmKS0REupfJLqmPAD8FHotbdwsw193vNLNbwuWbgQuAqvBxOnB/+CwiMmC4O00t7TQ0t9LQ3EZTSxsNzcGjsSVY19jcRmP8+ubW2HJjc1vCNn/90bHcOK0qrTFmLCm4+ytmVpm0+mJgavj6UWABQVK4GHjMg3G8XzezEWY2zt23ZCo+EZFk7k5zW3tCwdxREDc0tyYW4rHCPCi4G5rbaGgJC+zY68SCvrGljXTOVvCRsUPT92GhbN+8NrajoHf3LWY2Jlw/AfggbruacF2npGBm1wHXARx11FGZjVZE+pzWtvawIE48y25sDs7A48+yg0K8tYtCPG59UkHe1t5/5phpbGlN+2f2lTuarYt1Xf4y7j4LmAVQXV3df349kYhob3eaWjufZccX5I2xde0JZ9lNHdvHn2Un7dfc1p7rr9hnNDS3pf0zs50UtnVUC5nZOGB7uL4GODJuuwpgc5ZjE4kEd2d/a3tCFUfHWXZDS9fVIgc7y+54HVSxqNDuSVFBHqVF+ZQW5lNSlE9pUQElsddxz4X5lBQVBNvGljteB+vLBhelPb5sJ4XngSuBO8PnOXHrbzCzJwgamHerPUGirKWtPanRsTWhuuRA3XZrXOHeRV12cjVLeMbej2pIsq4gz2KFb2lRAcWF+QkFc0fB3VEwl3QqtAvitokv6IPCPz+vq4qRviNjScHMZhM0KpebWQ3wA4Jk8KSZXQ1sBC4PN/8P4HPAWqAB+Gqm4hLJtrZ2Z1dDMzv2NVO3L+65vpkd+/bH1nWs393QoiqSHpgRnmUXdDqDDgrgAkoK84JCOO6MPPksu7QoP67AL4gV4kUF0b59K5O9j77YzVvTutjWgW9kKhaRdGppa2dnpwJ+f+dCP3zsamiO3Jl5cUehXJh4Jp18lt35jLrzWXZsffhZgwryMOvbZ9v9WV9paBbJmaaWtoQz9R379lNX35y0Lnxdv589Tenv8ZFtRfl5sYI7vgok+cw54Sy7MPGMOr5aJH7fksJ88vp4FYl0T0lBBpz2dqe2fj9bdzdR100B31H476hvZl8GenAcrjzjQMF8iGfZiYV7sH1J0vaF+dGuIpHuKSlIv9PS1s7W3U3U7Gxk065GNu1sZNOuhtjyll1Nfa5OfmhxAaMGF1E2uIiywYOC10OK4tYVMWrwIMqGFFFWWkRxoapIJDeUFKTPaWppiyvsg+eanQ2x11v3NOW0jt4MRpQUHijIuyvgBxcxakgRI0uLIt94Kf2HkoJkXVNLG+/XNSQU9DU7G6kJX39Yvz+r8eTnGSNL4wr1uAJ+VHhm31HAlw0OCvm+3q1QpLeUFCRjdje0sLa2nve217O2tp6124PHBzsb0jr+S1eGlxQyfkQJ5UPiz947F/CjBhcxrLhQDaMiISUFOWy7G1pYuXk372zbG1f478voGX/5kEFMGFlCxYgSKkaWMGFkCRNGHHgeWlyYsWOLDGRKCnJIdje0sGLzbv6yKXzU7Gbjjoa0HiPP4IhhxQkFfcXI0oRCv7gwP63HFJGAkoJ0a09TCytqgsJ/+abdrNi0m/fr0pMAJowo4ehRpZ0K/YqRJRwxvFhdJkVyRElBYrbsbmTRhp0sWr+DRRt2sGbb3sOq+y/MNypHDebYMUM4dswQjhkdPE8aPZjSIv3TE+mL9D8zwjbtauSP79Ty5/U7+POGHdTsbOzV5+TnGVVjhvDR8cOCBBAW/keVlVKgM36RfkVJIUIam9t4fV0dC9+p5ZV3a1lXu++QPyPPoGrMUE6qGM5JE4ZzUsVwjj9iGCVFquMXGQiUFAa4jXUN/GHVNuat3s6f1+845Dt9q8YM4eSKEZw0YRgnVYzgo+OUAEQGMiWFAWjt9nqeX7qJl1duY822vSnvV5hvnFwxgtMqyzitciTVR5cxvFRdO0WiRElhgNi6u4nnl21iztLNrNy8J6V9CvKMU48ayaeqyjl9YhmnHDlCXT1FIk5JoR9ramnjd29v46nFH/Dq2g9T6il0ZFkJZ1eN5uyPjOasY0bpJi8RSaCk0A9t3d3EY69t4Nd/3siuhpYet83PM06rHMn5x49l2vFjqRxVqtE3RaRbSgr9yLIPdvHQq+v5j79sobWHYULzDM46ppyLThnPp08Yy4jS9E/uLSIDk5JCP/D6ujp+9Lt3+POGHT1ud+KEYVw6pYLPnzyOMcOKsxSdiAwkSgp92LIPdnHP79bwx3c/7Hab4SWF/M2pFVxeXcHx44ZlMToRGYiUFPqgdbX13PXSal5eua3bbSaNHszXPjmRL5w6QUNGiEjaqDTpQ+r3t/KTee/yy1fX09LWdZvBp44t5+q/msg5VaM1B4CIpJ2SQh/x0oqt/OD5FWzb0/UcBKdPLOO7n53Mx48uy3JkIhIlSgo5truxhdueX8m/v7Wpy/dPqRjOtz8zmU8dW66upCKScUoKOfTKO7V89+nlbN3T1Om9I4YV870Lj+fzJ49TMhCRrFFSyIG2duee363h/gXvdXqvIM+49uxJ3HDusQwepJ9HRLJLpU6W7djXzI2z3+LVtZ27mR53xFD+zxWncML44TmITERESSGr1tXWc9XDizrNaZxncP05xzDz/CoGFWhAOhHJHSWFLFm8YQfXPLa401hFY4YO4mczTuW0SvUqEpHcU1LIgpdWbOHGJ5bS3Jo4wc1plSP52YxTGTNUQ1KISN+gpJBhLy7fzMwnltKWNIDdZR+v4IeXnkRRgeYwFpG+Q0khg7pLCDedX8XMaVXqaioifY6SQobU7WvulBDyDO78wslccdqROYxMRKR7Oam7MLNvmdlKM1thZrPNrNjMJprZG2b2rpn9xsz67SQAe5taWbu9vlNC+NEVH1NCEJE+LetJwcwmADcC1e5+IpAP/C1wF/Bv7l4F7ASuznZs6bCutp412/bi3jkhXDJlQg4jExE5uFxVHxUAJWbWApQCW4DzgC+F7z8K3Abc3+OnrFkDU6dmLMhD1dru7Nm0m49sWQvAE7++BYBJo4cw5rVBuQxNRCQlWb9ScPdNwD3ARoJksBtYAuxy99Zwsxqgy9NqM7vOzBab2eKWlp7nJ84mB96rraeppS1hfcXIUsYMVUIQkf4h61cKZjYSuBiYCOwCngIu6GLTLicUcPdZwCyA6upqZ8GCzAR6iGYtfI87/nM1cOAK4al7/h/3XH4yqJeRiPQlPZRJuWhoPh9Y7+617t4CPAucBYwws44kVQFszkFsvbJy827ufnlNwrrBgwq4/dIT1e1URPqVXCSFjcAZZlZqQYk5DXgbmA9cFm5zJTAnB7EdsubWdr791HJa43oa5eflUTV2KMWFGsdIRPqXXLQpvAE8DbwJ/CWMYRZwM/D3ZrYWGAU8lO3YeuNn89eyasuehHXHjB5Mse5UFpF+KCe9j9z9B8APklavAz6Rg3B6bf2H+zrNiXDRKeMpe73f3mIhIhGn09lecndue34lzW0HBrkrHzKIf77ohBxGJSJyeJQUemne6u0sfKc2Yd0/TT+ekYN1lSAi/ZeSQi+0t3un3kanTyzjolPG5ygiEZH0UFLohReWb2b11r2xZTO47aIT1P1URPo9JYVD1NrWzr1/eDdh3cWnjOf4ccNyFJGISPooKRyiZ96sYf2H+2LL+XnGTed/JIcRiYikz0GTgpkNNrO88PVHzOwiMyvMfGh9T0tbO/fNXZuw7orqCirLB+coIhGR9ErlSuEVoDgc8nou8FXgkUwG1Ve9sGwzm3Y1xpaL8vP45nlVOYxIRCS9UkkK5u4NwBeAn7j7pcBHMxtW3+Pu/HzhuoR1l1dXMH5ESY4iEhFJv5SSgpmdCcwAfhuui9w0nn96r4412w70OMozuO7sSTmMSEQk/VJJCjOBW4F/d/eVZjaJYPC6SPn1GxsTlj974hEcPUptCSIysBz0jN/dXyFoV+hYXkcwnWZk1O7dz8srtyas+8oZlbkJRkQkgw6aFMzsI8C3gcr47d39vMyF1bc8vaQmYWjsSaMHc8akshxGJCKSGam0DTwFPAA8CLQdZNsBx915cvEHCeu+9ImjdPeyiAxIqSSFVne/P+OR9FHLa3Yn3KxWlJ/H35xakcOIREQyJ5WG5hfM7OtmNs7MyjoeGY+sj5izNHFW0HOPG62RUEVkwErlSuHK8Pk7cescGPD9MdvanReXJyaFi06ZkKNoREQyL5XeRxOzEUhf9Mb6Orbv3R9bHlyUz7Tjx+QwIhGRzEql91Eh8D+As8NVC4Cfu3tLBuPqE/7w9vaE5c+ccATFhfk5ikZEJPNSqT66HygE/m+4/JVw3TWZCqqvmL8mMSl8+oSxOYpERCQ7UkkKp7n7KXHL88xsWaYC6ivW1dYn9DoqzDc+VTU6hxGJiGReKr2P2szsmI6FcJiLAX+/wrzViVcJp08cxZBBkRvySUQiJpVS7jvAfDNbBxhwNMHw2QNactXRucepgVlEBr5Ueh/NNbMqYDJBUljt7vsPslu/1tTSxqL1OxPWnaekICIR0G1SMLPz3H2emX0h6a1jzAx3fzbDseXMmxt30tzWHluuGFnCRM2uJiIR0NOVwjnAPODzXbznwIBNCm+s25GwfMakUTmKREQku7pNCu7+g/Dl/3L39fHvmdmAvqHt9XV1CcunT4zMqB4iEnGp9D56pot1T6c7kL5if2sbb32wK2GdrhREJCp6alM4DjgBGJ7UrjAMKM50YLmyastemlsPtCeMH17MkWWlOYxIRCR7empTmAxMB0aQ2K6wF7g2k0Hl0tKNib2Ophw1MkeRiIhkX09tCnOAOWZ2pru/lsWYcmpZze6E5VOOHJ6jSEREsi+Vm9feMrNvEFQlxaqN3P1rGYsqh5YmtSecUjEiR5GIiGRfKg3NvwKOAD4DLAQqCKqQBpxdDc0J4x3lGZxUoSsFEYmOVJLCse7+T8A+d38UuBA46XAOamYjzOxpM1ttZqvM7MxwRrffm9m74XPWK/OTq44+MnYopUUa70hEoiOVpNAxb8IuMzsRGA5UHuZxfwy85O7HAacAq4BbgLnuXgXMDZezallS1dGUo1R1JCLRkkpSmBWetf8j8DzwNnBXbw9oZsMIJux5CMDdm919F3Ax8Gi42aPAJb09Rm+pPUFEoi6VpDDX3Xe6+yvuPsndxwC/O4xjTgJqgYfN7C0ze9DMBgNj3X0LQPjc5Qh0ZnadmS02s8W1tbWHEUZnKzYl9zxSUhCRaMnFHc0FwKnA/e4+BdjHIVQVufssd6929+rRo9M36U1d/f6E+ZiL8vOoGjMkbZ8vItIf5OKO5hqgxt3fCJefJkgK28xsnLtvMbNxwPZuPyED1mxN7FBVNXYIBfmp5EwRkYEj63c0u/tWM/vAzCa7+xpgGkE7xdvAlcCd4fOc3h6jN1YlJYXjjhiWzcOLiPQJubqj+ZvA42ZWBKwjmMktD3jSzK4GNgKXp/mYPVq9ZU/C8vHjhmbz8CIifUJP1Uffdfd/Bb5kZl9Mft/db+ztQd19KVDdxVvTevuZh2u1rhRERHqsPloVPi/ORiC51NrWzjvbkpKCrhREJIJ6qj56IXx+tLttBooNdQ3sjxsuu3zIIMqHDMphRCIiuXHQ7jXhkBMj4pZHmtnLmQ0ruzpdJRyhqwQRiaZU+lyODu84BsDdd9LNjWX9VfwgeADH6v4EEYmoVJJCm5kd1bFgZkcDnrmQsm9DUlKoHKWZ1kQkmlIZAvT7wKtmtjBcPhu4LnMhZd/7dQ0Jy0eXD85RJCIiuXXQpODuL5nZqcAZgAHfcvcPMx5ZFq2vS7xSmDhKSUFEoimlyQLCJPBihmPJifr9rdTGjXlUkGdUjCzJYUQiIrkT+cF93k+6SqgYWaIxj0QksiJf+m1Mbk9Q1ZGIRFhPw1yU9bSju+9IfzjZt2lXY8LykWWqOhKR6OqpTWEJQddT6+I9J5gsp9/bsrspYXnccCUFEYmunoa5mJjNQHJly+7EK4Vxww9nqggRkf4tpd5H4RzNVcRNruPur2QqqGzavEtXCiIiHQ6aFMzsGmAmUAEsJbhf4TXgvMyGlh3JVwrjR+hKQUSiK5XeRzOB04D33f1cYApQm9GosqSlrT1hXmaAI1R9JCIRlkpSaHL3JgAzG+Tuqwmm6uz3tu1pwuNGcSofUsSggvzcBSQikmOptCnUhENnPwf83sx2ApszG1Z2qOeRiEiiVMY+ujR8eZuZzQeGA/+Z0aiyJDkpqOpIRKIulUl2ftXx2t0XuvvzwC8zGlWWbEm6cW28koKIRFwqbQonxC+YWT7w8cyEk12dqo9GqPpIRKKt26RgZrea2V7gZDPbY2Z7w+XtwJysRZhBdfuaE5ZHa15mEYm4bpOCu9/h7kOBu919mLsPDR+j3P3WLMaYMTv2JXZHLRtSlKNIRET6hlQamm81s4sIZlwDWODuA2Juhbr6xCuFUYOVFEQk2lJpaL6D4Aa2t8PHzHBdv7cjqfqoTElBRCIulfsULgQ+5u7tAGb2KPAW0K+rkNydnQ3JVwpqUxCRaEt1kp0Rca+HZyKQbNvT1EpL24HbmUsK8ykp0t3MIhJtqVwp3AG8Fd64ZgRtC9/LaFRZoKojEZHOUmlonm1mCwgGxTPgZnffmunAMi2559Eo9TwSEUmpoXmuu29x9+fdfY67bzWzudkILpOSex7pSkFEpOc5mouBUqA8nGSnY1rOYcD4LMSWUbsbWxKWR5YqKYiI9FR99N+BmwgSwBIOJIU9wM8yHFfG1e9vTVgeWpzSJHQiIgNaT3M0/xj4sZl9091/ksWYsqK+KTEpDBmkpCAictA2hUwlBDPLN7O3zOzFcHmimb1hZu+a2W/MLKP1OclXCkN0pSAikvJ9CpkwE1gVt3wX8G/uXgXsBK7O5MH3NCVXHxVm8nAiIv1CT6OkfjJ8TvttvmZWQXCn9IPhsgHnAU+HmzwKXJLu48br1Kag6iMRkR6vFO4Ln1/LwHHvBb4LtIfLo4Bd7t5RUtcAE7ra0cyuM7PFZra4tra21wHUNyX2PlKbgohIz72PWszsYWCCmd2X/Ka739ibA5rZdGC7uy8xs6kdq7vY1LtYh7vPAmYBVFdXd7lNKtSmICLSWU8l4XTgfIJqnSVpPOYngYvM7HNAMcF9D/cCI8ysILxaqAA2p/GYnexV7yMRkU566pL6IfCEma1y92XpOmA4Qc+tAOGVwrfdfYaZPQVcBjwBXEmGZ3fTfQoiIp2l0vuozsz+3cy2m9k2M3smbChOt5uBvzeztQRtDA9l4BgxnZOCeh+JiKRyevww8Gvg8nD5y+G6vz7cg7v7AmBB+Hod8InD/cwUj9up+mjwIA2bLSKSypXCGHd/2N1bw8cjwOgMx5VRTS3ttLUfaKMuKshjUIGSgohIKkmh1sy+HN6BnG9mXwbqMh1YJu3dn9gdVfcoiIgEUkkKXwOuALYCWwgag7+WyaAyrdO4R2pkFhEBUptkZyNwURZiyZpO9yjoSkFEBMjt2Ec5k5wUBispiIgAEU0KTS1tCcuDi9TILCICEU0Kjc3tCcslSgoiIsAhJAUzO8PM5pnZf5lZRkcwzbTGpCuF4kIlBRER6HmO5iPcfWvcqr8naHA24E/AcxmOLWOSk0KJkoKICNBz76MHzGwJcLe7NwG7gC8RDHe9JxvBZUpTs5KCiEhXuq0+cvdLgKXAi2b2FeAmgoRQSoYnwMm0TlcKalMQEQEO0qbg7i8AnwFGAM8Ca9z9Pnfv/ew2fYDaFEREutbTdJwXmdmrwDxgBfC3wKVmNtvMjslWgJnQqOojEZEu9dSm8L+BM4ES4D/c/RMEQ1tXAbcTJIl+Kfk+BVUfiYgEekoKuwkK/hJge8dKd3+XfpwQQL2PRES601ObwqUEjcqtBL2OBozk6iO1KYiIBA42HedPshhL1qj3kYhI1yI5zEWnNgVdKYiIABFNCp27pEbyzyAi0kkkS8Pm1sQB8dSmICISUFIACvMj+WcQEekkkqVhS5snLBfmW44iERHpWyKZFJrbEq8UinSlICICRDQptLSp+khEpCuRLA1bktsUCiL5ZxAR6SSSpaHaFEREuha5pODundoUCvMi92cQEelS5ErD1vbEq4SCPCMvT1cKIiIQwaSgexRERLoXuRKxc88jXSWIiHSIXFLodI9CgYa4EBHpELmkkNzzqEhXCiIiMdFLCrpHQUSkW1kvEc3sSDObb2arzGylmc0M15eZ2e/N7N3weWQmjq+7mUVEupeLErEV+Ad3Px44A/iGmX0UuAWY6+5VwNxwOe063aOgpCAiEpP1EtHdt7j7m+HrvcAqYAJwMfBouNmjwCWZOL7aFEREupfT02QzqwSmAG8AY919CwSJAxjTzT7XmdliM1tcW1t7yMfUfQoiIt3LWYloZkOAZ4Cb3H1Pqvu5+yx3r3b36tGjRx/ycdWmICLSvZyUiGZWSJAQHnf3Z8PV28xsXPj+OGB7Jo7dqU1BvY9ERGJy0fvIgIeAVe7+o7i3ngeuDF9fCczJxPGTu6SqTUFE5ICCHBzzk8BXgL+Y2dJw3feAO4EnzexqYCNweSYO3qmhWVcKIiIxWU8K7v4q0N3p+bRMH19tCiIi3YtciZjcppCvYbNFRGIilxTak+ZT0AQ7IiIHRK5ETJ5kRxPsiIgcELmk0NbFzGsiIhKIfFJQm4KIyAFKCkoKIiIx0UsKruojEZHuRC8pqKFZRKRbkUsKrW26UhAR6U7kkkJy9ZHaFEREDoheUmhPuqPZlBRERDrkYkC8nEq+eS1fo6SK5ExLSws1NTU0NTXlOpQBqbi4mIqKCgoLC1PeJ3JJIXmYC7UpiOROTU0NQ4cOpbKyEtNVe1q5O3V1ddTU1DBx4sSU94tc9VGnYS70D1EkZ5qamhg1apQSQgaYGaNGjTrkq7DIJQVdKYj0LUoImdObv23kkkKnNgUlBRGRmMglhc7DXETuTyAiPXjggQd47LHHAHjkkUfYvHnzQfdJ3u6aa67h7bffzliM8e69914aGhrS9nmRa2jWKKkifU/lLb/N6OdvuPPClLe9/vrrY68feeQRTjzxRMaPH9/jPsnbPfjgg70LtBfuvfdevvzlL1NaWpqWz4t8UtAwFyLR9thjj3HPPfdgZpx88skcc8wxDBkyhMrKShYvXsyMGTMoKSnhtdde4+677+aFF16gsbGRs846i5///Oc888wznba74IILuOeee6iurmb27Nn88Ic/xN258MILueuuuwAYMmQIM2fO5MUXX6SkpIQ5c+YwduxYrrrqKoqLi1m5ciXbtm3jRz/6EdOnT6etrY2bb76Zl19+GTPj2muvxd3ZvHkz5557LuXl5cyfP/+w/x6RqztJblPQlYJIdK1cuZLbb7+defPmsWzZMn784x/H3rvsssuorq7m8ccfZ+nSpZSUlHDDDTewaNEiVqxYQWNjIy+++GKX23XYvHkzN998M/PmzWPp0qUsWrSI5557DoB9+/ZxxhlnsGzZMs4++2x+8YtfxPbbsGEDCxcu5Le//S3XX389TU1NzJo1i/Xr1/PWW2+xfPlyZsyYwY033sj48eOZP39+WhICRDApaJgLEekwb948LrvsMsrLywEoKyvrcfv58+dz+umnc9JJJzFv3jxWrlzZ4/aLFi1i6tSpjB49moKCAmbMmMErr7wCQFFREdOnTwfg4x//OBs2bIjtd8UVV5CXl0dVVRWTJk1i9erV/OEPf+D666+noKAgpVh7K3rVR21KCiJ9zaHU+aeTu6fcbbOpqYmvf/3rLF68mCOPPJLbbrvtoPcAeNJJaLzCwsLYsfPz82ltbY29lxyTmR1SrIdDVwpKCiKRNW3aNJ588knq6uoA2LFjR8L7Q4cOZe/evQCxBFBeXk59fT1PP/10l9vFO/3001m4cCEffvghbW1tzJ49m3POOeegcT311FO0t7fz3nvvsW7dOiZPnsynP/1pHnjggVjy6Ii1u2P3VvSuFJK7pOrGGZHIOuGEE/j+97/POeecQ35+PlOmTKGysjL2/lVXXcX1118fa0C+9tprOemkk6isrOS0007rdrsO48aN44477uDcc8/F3fnc5z7HxRdffNC4Jk+ezDnnnMO2bdt44IEHKC4u5pprruGdd97h5JNPprCwkGuvvZYbbriB6667jgsuuIBx48alpV3Berq86euqq6t98eLFh7TP3/3yz7zyTm1s+eGvnsa5k8ekN7CpU4PnBQvS+7kiA8yqVas4/vjjcx1Gn3LVVVcxffp0LrvssrR8Xld/YzNb4u7VXW0fuSuF4SWFjB46iLZ2p7WtnUH5katBExHpVuSSwk++OCXXIYiIdOuRRx7J6fF1miwiOdWfq7D7ut78bZUURCRniouLqaurU2LIgI75FIqLiw9pv8hVH4lI31FRUUFNTQ21tbUH31gOWcfMa4dCSUFEcqawsPCQZgWTzFP1kYiIxCgpiIhIjJKCiIjE9Os7ms2sFni/l7uXAx+mMZz+QN85GvSdo+FwvvPR7j66qzf6dVI4HGa2uLvbvAcqfedo0HeOhkx9Z1UfiYhIjJKCiIjERDkpzMp1ADmg7xwN+s7RkJHvHNk2BRER6dd+SUMAAAeOSURBVCzKVwoiIpJESUFERGIimRTM7LNmtsbM1prZLbmOJxPM7Egzm29mq8xspZnNDNeXmdnvzezd8HlkrmNNJzPLN7O3zOzFcHmimb0Rft/fmFlRrmNMJzMbYWZPm9nq8Lc+MwK/8bfCf9MrzGy2mRUPtN/ZzH5pZtvNbEXcui5/VwvcF5Zny83s1MM5duSSgpnlAz8DLgA+CnzRzD6a26gyohX4B3c/HjgD+Eb4PW8B5rp7FTA3XB5IZgKr4pbvAv4t/L47gatzElXm/Bh4yd2PA04h+O4D9jc2swnAjUC1u58I5AN/y8D7nR8BPpu0rrvf9QKgKnxcB9x/OAeOXFIAPgGsdfd17t4MPAEcfCbtfsbdt7j7m+HrvQSFxQSC7/pouNmjwCW5iTD9zKwCuBB4MFw24Dzg6XCTgfZ9hwFnAw8BuHuzu+9iAP/GoQKgxMwKgFJgCwPsd3b3V4AdSau7+10vBh7zwOvACDMb19tjRzEpTAA+iFuuCdcNWGZWCUwB3gDGuvsWCBIHMCZ3kaXdvcB3gfZweRSwy91bw+WB9ltPAmqBh8MqswfNbDAD+Dd2903APcBGgmSwG1jCwP6dO3T3u6a1TItiUrAu1g3YfrlmNgR4BrjJ3ffkOp5MMbPpwHZ3XxK/uotNB9JvXQCcCtzv7lOAfQygqqKuhPXoFwMTgfHAYILqk2QD6Xc+mLT+O49iUqgBjoxbrgA25yiWjDKzQoKE8Li7Pxuu3tZxaRk+b89VfGn2SeAiM9tAUCV4HsGVw4iwmgEG3m9dA9S4+xvh8tMESWKg/sYA5wPr3b3W3VuAZ4GzGNi/c4fufte0lmlRTAqLgKqwt0IRQSPV8zmOKe3C+vSHgFXu/qO4t54HrgxfXwnMyXZsmeDut7p7hbtXEvym89x9BjAfuCzcbMB8XwB33wp8YGaTw1XTgLcZoL9xaCNwhpmVhv/GO77zgP2d43T3uz4P/F3YC+kMYHdHNVNvRPKOZjP7HMFZZD7wS3e/PcchpZ2ZfQr4I/AXDtSxf4+gXeFJ4CiC/2CXu3tyg1a/ZmZTgW+7+3Qzm0Rw5VAGvAV82d335zK+dDKzjxE0rBcB64CvEpzsDdjf2Mz+GfhvBD3s3gKuIahDHzC/s5nNBqYSDI+9DfgB8Bxd/K5hcvwpQW+lBuCr7r6418eOYlIQEZGuRbH6SEREuqGkICIiMUoKIiISo6QgIiIxSgoiIhKjpCB9hpmNNrNXw9EvL4lbP8fMxvfis94Ih3/4q6T3bjKz0hQ+43spHmuDmZUfbH8z+1P4XGlmX4pbP7VjVNd0M7OLLBwJ2Mwu6c3gj2ZWn/7IpK9SUpC+5IsEA32dCXwHwMw+D7zp7od6h+Y0YLW7T3H3Pya9dxPBQGoHk1JSSHV/dz8rfFkJfKnT1hng7s+7+53h4iUEIwOLdEtJQfqSFqAEGAS0h8MW3ATc3d0OZna0mc0Nx5Gfa2ZHhTd0/SvwOTNbamYlcdvfSDBmznwzmx+u+6KZ/SW8QrkrXHcnwUicS83s8XDdc2a2JBzL/7qevkg3+3eccd8J/FX43reS9hscjqW/KLzKuThcf4KZ/TncZ7mZVXVxzM+a2ZtmtszM5obrrjKzn5rZWcBFwN3hZxwTPl4Kv9Mfzey4cJ+JZvZaGMO/9PQ9ZQBydz306BMPYDjwW2AxwZn+jcCVB9nnhY5tgK8Bz4WvrwJ+2s0+G4Dy8PV4grtDRxMMMDcPuCR8rz5pv7LwuQRYAYxK/ryk7ZP3rw+fpwIvxq2PLQM/JLgbF2AE8A7BoG8/AWaE64uAkqTPHk0wUubEpFhjfweCMfovi9tnLlAVvj6dYGgQCIdNCF9/I/l76DGwH7pSkD7D3Xe7+4XuXg28CUwHnjGzX1gwu9iZXex2JvDr8PWvgE8d4mFPAxZ4MMBaK/A4wRwFXbnRzJYBrxMMQNbpbD0NPg3cYmZLgQVAMcGwBq8B3zOzm4Gj3b0xab8zgFfcfT2AH2RYi3D03LOAp8Jj/RzoGIP/k8Ds8PWvDvsbSb9ScPBNRHLifwK3E7QzLCEo+OcA5x5kv0Mdt6WrYYc7bxSMp3Q+cKa7N5jZAoICO90M+Bt3X5O0fpWZvUEwidDLZnaNu89L2u9QvnsewRwEH+vmfY1/E1G6UpA+J6wvH+/uCwkahNsJCqmuCuE/EYyKCjADeDWFQ+wFhoav3wDOMbNyC6Zq/SKwMHyvxYLhxyGo2toZJoTjCM7MDyZ+/+6On+xl4JvhIGeY2ZTweRKwzt3vI6jeOTlpv9fC7zEx3L6sp+N6MLfGejO7PNzezOyUcLv/IvFvKhGipCB90e3AP4avZxPUi79OMONWshuBr5rZcuArBHM0H8ws4D/NbL4HQwzfSjD08jKCnk5z4rZbHjYUvwQUhMf5lzCeVI7TsX+85UBr2CD8raT3/gUoDPdbES5DMCroirCq5zjgsfid3L2WYH7eZ8Mqrt90Ec8TwHfCBuxjCAr8q8PtV3JgWtqZBHN6LyJIhhIhGiVVRERidKUgIiIxSgoiIhKjpCAiIjFKCiIiEqOkICIiMUoKIiISo6QgIiIx/x9VkA9HWyvy5AAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "newlines = citedRefsMeta_count.plot.line(x='titlepct', y='citationpct', linewidth=4)\n",
    "newlines.axhline(y=80, color='r')\n",
    "newlines.axvline(x=pctile, color='r')\n",
    "newlines.set_ylabel('% of total citations')\n",
    "newlines.set_xlabel('% of total titles cited')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Plot 80/20 rule for your institution"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Repeat the steps above to plot the 80/20 for your institution. Create a new dataframe for your institution. Then substitute a term for your institution in the place of \"ucb\" or Berkeley as needed."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 143,
   "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>Inst</th>\n",
       "      <th>citingDOI</th>\n",
       "      <th>CR</th>\n",
       "      <th>citedDOI</th>\n",
       "      <th>title</th>\n",
       "      <th>journal_book</th>\n",
       "      <th>date</th>\n",
       "      <th>issn1</th>\n",
       "      <th>issn1Type</th>\n",
       "      <th>issn2</th>\n",
       "      <th>issn2Type</th>\n",
       "      <th>isbn</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>24042</th>\n",
       "      <td>Berkeley</td>\n",
       "      <td>10.1061/(ASCE)GT.1943-5606.0001833</td>\n",
       "      <td>Abrahamson N., 2013, 201304 PEER U CAL, P143</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24043</th>\n",
       "      <td>Berkeley</td>\n",
       "      <td>10.1061/(ASCE)GT.1943-5606.0001833</td>\n",
       "      <td>Abrahamson N, 2016, EARTHQ SPECTRA, V32, P23, ...</td>\n",
       "      <td>10.1193/051712EQS188MR</td>\n",
       "      <td>BC Hydro Ground Motion Prediction Equations fo...</td>\n",
       "      <td>Earthquake Spectra</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>8755-2930</td>\n",
       "      <td>print</td>\n",
       "      <td>1944-8201</td>\n",
       "      <td>electronic</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24044</th>\n",
       "      <td>Berkeley</td>\n",
       "      <td>10.1061/(ASCE)GT.1943-5606.0001833</td>\n",
       "      <td>Ancheta T.D., 2013, 201303 PEER U CAL</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24045</th>\n",
       "      <td>Berkeley</td>\n",
       "      <td>10.1061/(ASCE)GT.1943-5606.0001833</td>\n",
       "      <td>Ashford SA, 2002, J GEOTECH GEOENVIRON, V128, ...</td>\n",
       "      <td>10.1061/(ASCE)1090-0241(2002)128:2(119)</td>\n",
       "      <td>Simplified Method for Evaluating Seismic Stabi...</td>\n",
       "      <td>Journal of Geotechnical and Geoenvironmental E...</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>1090-0241</td>\n",
       "      <td>print</td>\n",
       "      <td>1943-5606</td>\n",
       "      <td>electronic</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24046</th>\n",
       "      <td>Berkeley</td>\n",
       "      <td>10.1061/(ASCE)GT.1943-5606.0001833</td>\n",
       "      <td>Atkinson GM, 2003, B SEISMOL SOC AM, V93, P170...</td>\n",
       "      <td>10.1785/0120020156</td>\n",
       "      <td>Empirical Ground-Motion Relations for Subducti...</td>\n",
       "      <td>Bulletin of the Seismological Society of America</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>0037-1106</td>\n",
       "      <td>print</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40888</th>\n",
       "      <td>Berkeley</td>\n",
       "      <td>10.1016/j.marpetgeo.2014.07.024</td>\n",
       "      <td>WINTERS WJ, 1999, GEOLOGICAL SURVEY CA, V544, ...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40889</th>\n",
       "      <td>Berkeley</td>\n",
       "      <td>10.1016/j.marpetgeo.2014.07.024</td>\n",
       "      <td>WINTERS WJ, 2006, P ODP SCI RESULTS, V204, P1</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40890</th>\n",
       "      <td>Berkeley</td>\n",
       "      <td>10.1016/j.marpetgeo.2014.07.024</td>\n",
       "      <td>WINTERS WJ, 2000, P OCEAN DRILLING PRO, V164, ...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40891</th>\n",
       "      <td>Berkeley</td>\n",
       "      <td>10.1016/j.marpetgeo.2014.07.024</td>\n",
       "      <td>Xu WY, 1999, J GEOPHYS RES-SOL EA, V104, P5081...</td>\n",
       "      <td>10.1029/1998JB900092</td>\n",
       "      <td>Predicting the occurrence, distribution, and e...</td>\n",
       "      <td>Journal of Geophysical Research: Solid Earth</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>0148-0227</td>\n",
       "      <td>print</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40892</th>\n",
       "      <td>Berkeley</td>\n",
       "      <td>10.1016/j.marpetgeo.2014.07.024</td>\n",
       "      <td>Yun TS, 2010, ENERG FUEL, V24, P5972, DOI 10.1...</td>\n",
       "      <td>10.1021/ef100821t</td>\n",
       "      <td>Hydrate-Bearing Sediments from the Krishna−God...</td>\n",
       "      <td>Energy &amp; Fuels</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>0887-0624</td>\n",
       "      <td>print</td>\n",
       "      <td>1520-5029</td>\n",
       "      <td>electronic</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>16851 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           Inst                           citingDOI  \\\n",
       "24042  Berkeley  10.1061/(ASCE)GT.1943-5606.0001833   \n",
       "24043  Berkeley  10.1061/(ASCE)GT.1943-5606.0001833   \n",
       "24044  Berkeley  10.1061/(ASCE)GT.1943-5606.0001833   \n",
       "24045  Berkeley  10.1061/(ASCE)GT.1943-5606.0001833   \n",
       "24046  Berkeley  10.1061/(ASCE)GT.1943-5606.0001833   \n",
       "...         ...                                 ...   \n",
       "40888  Berkeley     10.1016/j.marpetgeo.2014.07.024   \n",
       "40889  Berkeley     10.1016/j.marpetgeo.2014.07.024   \n",
       "40890  Berkeley     10.1016/j.marpetgeo.2014.07.024   \n",
       "40891  Berkeley     10.1016/j.marpetgeo.2014.07.024   \n",
       "40892  Berkeley     10.1016/j.marpetgeo.2014.07.024   \n",
       "\n",
       "                                                      CR  \\\n",
       "24042       Abrahamson N., 2013, 201304 PEER U CAL, P143   \n",
       "24043  Abrahamson N, 2016, EARTHQ SPECTRA, V32, P23, ...   \n",
       "24044              Ancheta T.D., 2013, 201303 PEER U CAL   \n",
       "24045  Ashford SA, 2002, J GEOTECH GEOENVIRON, V128, ...   \n",
       "24046  Atkinson GM, 2003, B SEISMOL SOC AM, V93, P170...   \n",
       "...                                                  ...   \n",
       "40888  WINTERS WJ, 1999, GEOLOGICAL SURVEY CA, V544, ...   \n",
       "40889      WINTERS WJ, 2006, P ODP SCI RESULTS, V204, P1   \n",
       "40890  WINTERS WJ, 2000, P OCEAN DRILLING PRO, V164, ...   \n",
       "40891  Xu WY, 1999, J GEOPHYS RES-SOL EA, V104, P5081...   \n",
       "40892  Yun TS, 2010, ENERG FUEL, V24, P5972, DOI 10.1...   \n",
       "\n",
       "                                      citedDOI  \\\n",
       "24042                                      NaN   \n",
       "24043                   10.1193/051712EQS188MR   \n",
       "24044                                      NaN   \n",
       "24045  10.1061/(ASCE)1090-0241(2002)128:2(119)   \n",
       "24046                       10.1785/0120020156   \n",
       "...                                        ...   \n",
       "40888                                      NaN   \n",
       "40889                                      NaN   \n",
       "40890                                      NaN   \n",
       "40891                     10.1029/1998JB900092   \n",
       "40892                        10.1021/ef100821t   \n",
       "\n",
       "                                                   title  \\\n",
       "24042                                                NaN   \n",
       "24043  BC Hydro Ground Motion Prediction Equations fo...   \n",
       "24044                                                NaN   \n",
       "24045  Simplified Method for Evaluating Seismic Stabi...   \n",
       "24046  Empirical Ground-Motion Relations for Subducti...   \n",
       "...                                                  ...   \n",
       "40888                                                NaN   \n",
       "40889                                                NaN   \n",
       "40890                                                NaN   \n",
       "40891  Predicting the occurrence, distribution, and e...   \n",
       "40892  Hydrate-Bearing Sediments from the Krishna−God...   \n",
       "\n",
       "                                            journal_book    date      issn1  \\\n",
       "24042                                                NaN     NaN        NaN   \n",
       "24043                                 Earthquake Spectra  2015.0  8755-2930   \n",
       "24044                                                NaN     NaN        NaN   \n",
       "24045  Journal of Geotechnical and Geoenvironmental E...  2002.0  1090-0241   \n",
       "24046   Bulletin of the Seismological Society of America  2005.0  0037-1106   \n",
       "...                                                  ...     ...        ...   \n",
       "40888                                                NaN     NaN        NaN   \n",
       "40889                                                NaN     NaN        NaN   \n",
       "40890                                                NaN     NaN        NaN   \n",
       "40891       Journal of Geophysical Research: Solid Earth  2002.0  0148-0227   \n",
       "40892                                     Energy & Fuels  2010.0  0887-0624   \n",
       "\n",
       "      issn1Type      issn2   issn2Type isbn  \n",
       "24042       NaN        NaN         NaN  NaN  \n",
       "24043     print  1944-8201  electronic  NaN  \n",
       "24044       NaN        NaN         NaN  NaN  \n",
       "24045     print  1943-5606  electronic  NaN  \n",
       "24046     print        NaN         NaN  NaN  \n",
       "...         ...        ...         ...  ...  \n",
       "40888       NaN        NaN         NaN  NaN  \n",
       "40889       NaN        NaN         NaN  NaN  \n",
       "40890       NaN        NaN         NaN  NaN  \n",
       "40891     print        NaN         NaN  NaN  \n",
       "40892     print  1520-5029  electronic  NaN  \n",
       "\n",
       "[16851 rows x 12 columns]"
      ]
     },
     "execution_count": 143,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Example\n",
    "citedRefsMeta_ucb = citedRefsMeta.loc[citedRefsMeta['Inst'] == 'Berkeley']\n",
    "citedRefsMeta_ucb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 144,
   "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>journal_book</th>\n",
       "      <th>counts</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Journal of Geophysical Research</td>\n",
       "      <td>547</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Geophysical Research Letters</td>\n",
       "      <td>471</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Earth and Planetary Science Letters</td>\n",
       "      <td>339</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Science</td>\n",
       "      <td>324</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Nature</td>\n",
       "      <td>321</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1590</th>\n",
       "      <td>Mechanisms of Development</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1591</th>\n",
       "      <td>European Journal of Organic Chemistry</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1592</th>\n",
       "      <td>The Journal of Organic Chemistry</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1593</th>\n",
       "      <td>Antarctic Science</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1594</th>\n",
       "      <td>Permafrost and Periglacial Processes</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1595 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                               journal_book  counts\n",
       "0           Journal of Geophysical Research     547\n",
       "1              Geophysical Research Letters     471\n",
       "2       Earth and Planetary Science Letters     339\n",
       "3                                   Science     324\n",
       "4                                    Nature     321\n",
       "...                                     ...     ...\n",
       "1590              Mechanisms of Development       1\n",
       "1591  European Journal of Organic Chemistry       1\n",
       "1592       The Journal of Organic Chemistry       1\n",
       "1593                      Antarctic Science       1\n",
       "1594   Permafrost and Periglacial Processes       1\n",
       "\n",
       "[1595 rows x 2 columns]"
      ]
     },
     "execution_count": 144,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "citedRefsMeta_ucb_count = citedRefsMeta_ucb['journal_book'].value_counts().rename_axis('journal_book').reset_index(name='counts')\n",
    "citedRefsMeta_ucb_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 145,
   "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>journal_book</th>\n",
       "      <th>counts</th>\n",
       "      <th>cumsum</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Journal of Geophysical Research</td>\n",
       "      <td>547</td>\n",
       "      <td>547</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Geophysical Research Letters</td>\n",
       "      <td>471</td>\n",
       "      <td>1018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Earth and Planetary Science Letters</td>\n",
       "      <td>339</td>\n",
       "      <td>1357</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Science</td>\n",
       "      <td>324</td>\n",
       "      <td>1681</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Nature</td>\n",
       "      <td>321</td>\n",
       "      <td>2002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1590</th>\n",
       "      <td>Mechanisms of Development</td>\n",
       "      <td>1</td>\n",
       "      <td>12975</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1591</th>\n",
       "      <td>European Journal of Organic Chemistry</td>\n",
       "      <td>1</td>\n",
       "      <td>12976</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1592</th>\n",
       "      <td>The Journal of Organic Chemistry</td>\n",
       "      <td>1</td>\n",
       "      <td>12977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1593</th>\n",
       "      <td>Antarctic Science</td>\n",
       "      <td>1</td>\n",
       "      <td>12978</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1594</th>\n",
       "      <td>Permafrost and Periglacial Processes</td>\n",
       "      <td>1</td>\n",
       "      <td>12979</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1595 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                               journal_book  counts  cumsum\n",
       "0           Journal of Geophysical Research     547     547\n",
       "1              Geophysical Research Letters     471    1018\n",
       "2       Earth and Planetary Science Letters     339    1357\n",
       "3                                   Science     324    1681\n",
       "4                                    Nature     321    2002\n",
       "...                                     ...     ...     ...\n",
       "1590              Mechanisms of Development       1   12975\n",
       "1591  European Journal of Organic Chemistry       1   12976\n",
       "1592       The Journal of Organic Chemistry       1   12977\n",
       "1593                      Antarctic Science       1   12978\n",
       "1594   Permafrost and Periglacial Processes       1   12979\n",
       "\n",
       "[1595 rows x 3 columns]"
      ]
     },
     "execution_count": 145,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "citedRefsMeta_ucb_count['cumsum'] = citedRefsMeta_ucb_count['counts'].cumsum()\n",
    "citedRefsMeta_ucb_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 146,
   "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>journal_book</th>\n",
       "      <th>counts</th>\n",
       "      <th>cumsum</th>\n",
       "      <th>titlenum</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Journal of Geophysical Research</td>\n",
       "      <td>547</td>\n",
       "      <td>547</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Geophysical Research Letters</td>\n",
       "      <td>471</td>\n",
       "      <td>1018</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Earth and Planetary Science Letters</td>\n",
       "      <td>339</td>\n",
       "      <td>1357</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Science</td>\n",
       "      <td>324</td>\n",
       "      <td>1681</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Nature</td>\n",
       "      <td>321</td>\n",
       "      <td>2002</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1590</th>\n",
       "      <td>Mechanisms of Development</td>\n",
       "      <td>1</td>\n",
       "      <td>12975</td>\n",
       "      <td>1591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1591</th>\n",
       "      <td>European Journal of Organic Chemistry</td>\n",
       "      <td>1</td>\n",
       "      <td>12976</td>\n",
       "      <td>1592</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1592</th>\n",
       "      <td>The Journal of Organic Chemistry</td>\n",
       "      <td>1</td>\n",
       "      <td>12977</td>\n",
       "      <td>1593</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1593</th>\n",
       "      <td>Antarctic Science</td>\n",
       "      <td>1</td>\n",
       "      <td>12978</td>\n",
       "      <td>1594</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1594</th>\n",
       "      <td>Permafrost and Periglacial Processes</td>\n",
       "      <td>1</td>\n",
       "      <td>12979</td>\n",
       "      <td>1595</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1595 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                               journal_book  counts  cumsum  titlenum\n",
       "0           Journal of Geophysical Research     547     547         1\n",
       "1              Geophysical Research Letters     471    1018         2\n",
       "2       Earth and Planetary Science Letters     339    1357         3\n",
       "3                                   Science     324    1681         4\n",
       "4                                    Nature     321    2002         5\n",
       "...                                     ...     ...     ...       ...\n",
       "1590              Mechanisms of Development       1   12975      1591\n",
       "1591  European Journal of Organic Chemistry       1   12976      1592\n",
       "1592       The Journal of Organic Chemistry       1   12977      1593\n",
       "1593                      Antarctic Science       1   12978      1594\n",
       "1594   Permafrost and Periglacial Processes       1   12979      1595\n",
       "\n",
       "[1595 rows x 4 columns]"
      ]
     },
     "execution_count": 146,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "citedRefsMeta_ucb_count['titlenum'] = range(1, 1+len(citedRefsMeta_ucb_count))\n",
    "citedRefsMeta_ucb_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "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>journal_book</th>\n",
       "      <th>counts</th>\n",
       "      <th>cumsum</th>\n",
       "      <th>titlenum</th>\n",
       "      <th>titlepct</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Journal of Geophysical Research</td>\n",
       "      <td>547</td>\n",
       "      <td>547</td>\n",
       "      <td>1</td>\n",
       "      <td>0.062696</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Geophysical Research Letters</td>\n",
       "      <td>471</td>\n",
       "      <td>1018</td>\n",
       "      <td>2</td>\n",
       "      <td>0.125392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Earth and Planetary Science Letters</td>\n",
       "      <td>339</td>\n",
       "      <td>1357</td>\n",
       "      <td>3</td>\n",
       "      <td>0.188088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Science</td>\n",
       "      <td>324</td>\n",
       "      <td>1681</td>\n",
       "      <td>4</td>\n",
       "      <td>0.250784</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Nature</td>\n",
       "      <td>321</td>\n",
       "      <td>2002</td>\n",
       "      <td>5</td>\n",
       "      <td>0.313480</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>1590</th>\n",
       "      <td>Mechanisms of Development</td>\n",
       "      <td>1</td>\n",
       "      <td>12975</td>\n",
       "      <td>1591</td>\n",
       "      <td>99.749216</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1591</th>\n",
       "      <td>European Journal of Organic Chemistry</td>\n",
       "      <td>1</td>\n",
       "      <td>12976</td>\n",
       "      <td>1592</td>\n",
       "      <td>99.811912</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1592</th>\n",
       "      <td>The Journal of Organic Chemistry</td>\n",
       "      <td>1</td>\n",
       "      <td>12977</td>\n",
       "      <td>1593</td>\n",
       "      <td>99.874608</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1593</th>\n",
       "      <td>Antarctic Science</td>\n",
       "      <td>1</td>\n",
       "      <td>12978</td>\n",
       "      <td>1594</td>\n",
       "      <td>99.937304</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1594</th>\n",
       "      <td>Permafrost and Periglacial Processes</td>\n",
       "      <td>1</td>\n",
       "      <td>12979</td>\n",
       "      <td>1595</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1595 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                               journal_book  counts  cumsum  titlenum  \\\n",
       "0           Journal of Geophysical Research     547     547         1   \n",
       "1              Geophysical Research Letters     471    1018         2   \n",
       "2       Earth and Planetary Science Letters     339    1357         3   \n",
       "3                                   Science     324    1681         4   \n",
       "4                                    Nature     321    2002         5   \n",
       "...                                     ...     ...     ...       ...   \n",
       "1590              Mechanisms of Development       1   12975      1591   \n",
       "1591  European Journal of Organic Chemistry       1   12976      1592   \n",
       "1592       The Journal of Organic Chemistry       1   12977      1593   \n",
       "1593                      Antarctic Science       1   12978      1594   \n",
       "1594   Permafrost and Periglacial Processes       1   12979      1595   \n",
       "\n",
       "        titlepct  \n",
       "0       0.062696  \n",
       "1       0.125392  \n",
       "2       0.188088  \n",
       "3       0.250784  \n",
       "4       0.313480  \n",
       "...          ...  \n",
       "1590   99.749216  \n",
       "1591   99.811912  \n",
       "1592   99.874608  \n",
       "1593   99.937304  \n",
       "1594  100.000000  \n",
       "\n",
       "[1595 rows x 5 columns]"
      ]
     },
     "execution_count": 148,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#substitute your title number for \"1595\"\n",
    "citedRefsMeta_ucb_count['titlepct'] = 100*(citedRefsMeta_ucb_count.titlenum/1595)\n",
    "citedRefsMeta_ucb_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 150,
   "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>journal_book</th>\n",
       "      <th>counts</th>\n",
       "      <th>cumsum</th>\n",
       "      <th>titlenum</th>\n",
       "      <th>titlepct</th>\n",
       "      <th>citationpct</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Journal of Geophysical Research</td>\n",
       "      <td>547</td>\n",
       "      <td>547</td>\n",
       "      <td>1</td>\n",
       "      <td>0.062696</td>\n",
       "      <td>4.214500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Geophysical Research Letters</td>\n",
       "      <td>471</td>\n",
       "      <td>1018</td>\n",
       "      <td>2</td>\n",
       "      <td>0.125392</td>\n",
       "      <td>7.843439</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Earth and Planetary Science Letters</td>\n",
       "      <td>339</td>\n",
       "      <td>1357</td>\n",
       "      <td>3</td>\n",
       "      <td>0.188088</td>\n",
       "      <td>10.455351</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Science</td>\n",
       "      <td>324</td>\n",
       "      <td>1681</td>\n",
       "      <td>4</td>\n",
       "      <td>0.250784</td>\n",
       "      <td>12.951691</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Nature</td>\n",
       "      <td>321</td>\n",
       "      <td>2002</td>\n",
       "      <td>5</td>\n",
       "      <td>0.313480</td>\n",
       "      <td>15.424917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1590</th>\n",
       "      <td>Mechanisms of Development</td>\n",
       "      <td>1</td>\n",
       "      <td>12975</td>\n",
       "      <td>1591</td>\n",
       "      <td>99.749216</td>\n",
       "      <td>99.969181</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1591</th>\n",
       "      <td>European Journal of Organic Chemistry</td>\n",
       "      <td>1</td>\n",
       "      <td>12976</td>\n",
       "      <td>1592</td>\n",
       "      <td>99.811912</td>\n",
       "      <td>99.976886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1592</th>\n",
       "      <td>The Journal of Organic Chemistry</td>\n",
       "      <td>1</td>\n",
       "      <td>12977</td>\n",
       "      <td>1593</td>\n",
       "      <td>99.874608</td>\n",
       "      <td>99.984590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1593</th>\n",
       "      <td>Antarctic Science</td>\n",
       "      <td>1</td>\n",
       "      <td>12978</td>\n",
       "      <td>1594</td>\n",
       "      <td>99.937304</td>\n",
       "      <td>99.992295</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1594</th>\n",
       "      <td>Permafrost and Periglacial Processes</td>\n",
       "      <td>1</td>\n",
       "      <td>12979</td>\n",
       "      <td>1595</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1595 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                               journal_book  counts  cumsum  titlenum  \\\n",
       "0           Journal of Geophysical Research     547     547         1   \n",
       "1              Geophysical Research Letters     471    1018         2   \n",
       "2       Earth and Planetary Science Letters     339    1357         3   \n",
       "3                                   Science     324    1681         4   \n",
       "4                                    Nature     321    2002         5   \n",
       "...                                     ...     ...     ...       ...   \n",
       "1590              Mechanisms of Development       1   12975      1591   \n",
       "1591  European Journal of Organic Chemistry       1   12976      1592   \n",
       "1592       The Journal of Organic Chemistry       1   12977      1593   \n",
       "1593                      Antarctic Science       1   12978      1594   \n",
       "1594   Permafrost and Periglacial Processes       1   12979      1595   \n",
       "\n",
       "        titlepct  citationpct  \n",
       "0       0.062696     4.214500  \n",
       "1       0.125392     7.843439  \n",
       "2       0.188088    10.455351  \n",
       "3       0.250784    12.951691  \n",
       "4       0.313480    15.424917  \n",
       "...          ...          ...  \n",
       "1590   99.749216    99.969181  \n",
       "1591   99.811912    99.976886  \n",
       "1592   99.874608    99.984590  \n",
       "1593   99.937304    99.992295  \n",
       "1594  100.000000   100.000000  \n",
       "\n",
       "[1595 rows x 6 columns]"
      ]
     },
     "execution_count": 150,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#substitute your total citations for 12979\n",
    "\n",
    "citedRefsMeta_ucb_count['citationpct'] = 100*citedRefsMeta_ucb_count['cumsum']/(12979)\n",
    "citedRefsMeta_ucb_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 151,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "16.99059561128527"
      ]
     },
     "execution_count": 151,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ind=np.argmin(abs(80.-citedRefsMeta_ucb_count.citationpct))\n",
    "pctile_ucb = citedRefsMeta_ucb_count.titlepct[ind]\n",
    "pctile_ucb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 152,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYUAAAEGCAYAAACKB4k+AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAgAElEQVR4nO3deZwU1bn/8c/D7BvLzACyCANIcMUNRUyiuMREJWpyzSb608Tleo3R5Ca5anLvL/nlxkQTX4lmkxhNxFyDcbuixmgMi8ZI0EFAQVCQdQIyMAPCAMNsz++Pqmmme7YGpqd7ur/v12teXXWqaurpaThP1zlV55i7IyIiAtAv2QGIiEjqUFIQEZEIJQUREYlQUhARkQglBRERichOdgCHory83CsqKpIdRvK9807wOmFCcuMQkT5h0aJF29x9cEfb+nRSqKiooLKyMtlhJN/UqcHr/PnJjEJE+ggzW9/ZNjUfiYhIhJKCiIhEKCmIiEiEkoKIiEQoKYiISETCkoKZ/dbMqs1sWZuyUjN70cxWha+DwnIzs5+Z2Woze9PMTkpUXCIi0rlE3pL6IPAL4KE2ZbcCc9z9DjO7NVy/BTgfGB/+TAbuDV9FRDJKc4uzfU8Dtbsb2Fa3j9rdrcsN1O7e12a5gU+fNIIbph7Ro+dPWFJw95fNrCKm+GJgarg8E5hPkBQuBh7yYBzvf5jZQDMb5u6bExWfiEhvaK3ka+oaqNnddSVfu7uB7XsaiHdGg421e3o83t5+eG1oa0Xv7pvNbEhYPgLY2Ga/qrCsXVIws+uA6wBGjRqV2GhFRGJ0VMkHy0Elv3+5gZq6fezY2xh3JX+gauoaevx3psoTzdZBWYd/Rne/D7gPYNKkSZohSEQOSVNzC9v3NAaVeFipB8u9X8kfqJrdfT8pbGltFjKzYUB1WF4FHN5mv5HApl6OTUTSQFeVfE3YRt92OZUq+VYDCnIoK86lrCiX0qJcyorzIsulRbmUF+dRWpTL4JK8Hj93byeFp4ErgTvC19ltym80s0cIOpg/UH+CiEBMJV+3L+pbe2S5D1fy0cu5DCrMJScreU8LJCwpmNksgk7lcjOrAr5DkAweNbOrgQ3AZ8LdnwMuAFYDe4AvJiouEUmuuCr5Nu31qVjJDyzMCSrxolzKivIo7bTCT34lf6ASeffRFzrZdE4H+zrw5UTFIiKJ01rJ1+zeR21d+2aavlzJlxXlUhpW8mXFQUXf1yr5A5UqHc0ikiK6q+T3t9EH3+w/UCWfVpQURNJcU3MLteHDULV1DWzb3UBtF5X8jj2NyQ65ndZKvrwo6GAtLc6lvLXjtTgvWFYl3yOUFET6mK4q+W1hWbAcNteokpcDoKQgkmRtK/nIPfFhp2tNWMm3fotP5Uo+0lQTNs2063gtDrYPKswhW5V8ylJSEEmwD/Y0sqp6F6uq61i1pY5NO/aqkpeUpaQg0kNq6vYFFX91Hau37Iosb921L9mhMSjS8ZoX6WAtCyv42GVV8plNSUHkALg7W3eFlX+bin91dR21CRhyoDOq5CVRlBREOuDubP6gPlL5rw4r/1VbdrGzvqlHz2UGAwty2j/4pEpekkBJQTJaS4vzzx17w0p/F6u21PFudR3vVddRt69nKv/crH6MHVzEEUOKGT+khIryQgaX5EXa61XJSypRUpCM0NzibKzdEzb37GL1lv3NPnsbm3vkHHnZ/Rg3uJjxQ4sZP6SY8UNLGD+kmFGlhar0pc9QUpC00tjcwvqaPawOv/W3tvm/t7WOhqaWHjlHYW4WRwwpjnzzDxJAMSMHFZLVr6NR4EX6DiUF6ZP2NTWzbtueSJNPa/PP2m27aWzumTEXSvKyOaL1W/+Qksjy8AEF9FPlL2lKSUFSnruzurqOhWtrWbi2luWbPmB9zR6aW3qm8h9QkMOHhhZzRJtv/eOHlDC0fx5mqvwlsygpSMppaXFWvr+LhWtrWLimltfW1fbI7Z5lRbmRCn/80P3NP+XFuar8RUJKCpJ0Tc0tLN+0k9fW1rJwbQ2vra09pNs+h5TkRSr/oOIPEkBZcc/PUiWSbpQUpNc1NLXw1j938I81tby2tpZF67cf1O2fwwfkc0R4h09rs88Rg0sYUJiTgKhFMoOSgiRcfWMzSzbuYOGa4ErgjQ3bqW88sDuBivOymVQxiFPHlHJqRSkTDiuhJF+Vv0hPU1KQHtfS4iyp2sG8ldUsXFPLko07aGg+sCQwoCCHUypKOW1sKZPHlHHUsBLd6y/SC5QUpEc0tzivra3l+WWbeWH5Ft7fWX9Ax5cV5TJ5bHAVMHlsGROGlui2T5EkUFKQg9bY3MKr79Xw/LLN/GX5FmoO4A6hof3zmDymjMnhlcC4wUW6A0gkBSgpyAGpb2zmb6u28edlm/nr21vivkto5KCCIAmMKWXy2FJGlRYqCYikICUF6VZ9YzNzV1bz3Fubmbeymt0N3Y8VVJibxVlHDuGcI4cweWwZIwYW9EKkInKolBSkU2u37eYPC9fz+KIqtscxO1hJfjYfO2oonzj2MM740GDyc7J6IUoR6UlKChKlsbmFF9/ewsML1/P31TXd7l9alMt5RweJ4PRx5eRm6w4hkb5MSUEAqNq+h0de28gfKzd2O33kkJI8Pn7MYZx/7GGcOqZUt4qKpBElhQzW3OLMW1nNwwvXM//drXgX48sNKMjhUyeOYNrEYZw0apBuFxVJU0oKGaihqYUn36jiV/PfY0Ptni73PWnUQKZPHs2FE4epj0AkAygpZJD6xmYerdzIjPnvsemDzh8uK87L5lMnjuCyyaM4alj/XoxQRJJNSSED7Glo4g8LN/Drl9d02V9w7Ij+TJ88mouOH05Rnv5piGQi/c9PY7vqG3lowXoeeGVtp/MR5GQZl5wwgiumjGbiyIG9HKGIpBolhTS0r6mZ3y9Yz8/nruaDvR0/X5CX3Y8vnDqK684Yy3A9WCYiISWFNOLu/HnZ+9zx55WddiAX5GRxxZTRXPPRMQwpye/lCEUk1SUlKZjZ14BrAAfeAr4IDAMeAUqBN4Ar3P3Q52DMEHX7mrhqxgIq12/vcHtxXjZXnj6aqz8yltKi3F6OTkT6il5PCmY2ArgJONrd95rZo8DngQuAn7r7I2Y2A7gauLe34+tranc3UFtdx7a6fR0mhJK8bK756FiuOr1CM5KJSLeS1XyUDRSYWSNQCGwGzgYuC7fPBL6LkkKn3J3ZSzbxvWff5ld17e8oyupnTJ88ipvPGa+5iUUkbr2eFNz9n2Z2F7AB2Av8BVgE7HD31nGYq4AR3f6yd96BqVMTFGnq2tfUwtptuzlsTwO/Ao6uXgPAI3+4FYCBhbmMLiuk4NUs+GkSAxWRPicZzUeDgIuBMcAO4DHg/A527XDQBTO7DrgOYGJeZn0DdmDLB/Vs2L6Hlpb2f57C3GxGlxUyoEDNRCJycJLRfHQusNbdtwKY2ZPA6cBAM8sOrxZGAps6Otjd7wPuA5g0aZIzf36vBJ1s1Tvr+fpjS/nbqm3ttv1x1m2MHFTAUYsWkKPB6USkO11McJWMpLABOM3MCgmaj84BKoF5wKUEdyBdCcxOQmwp6S/L3+eWJ97scE6DU8eUMnHkAApyskAJQUQOUTL6FBaa2eMEt502AYsJvvn/CXjEzL4flj3Q27GlmoamFn7w3AoefHVdu20ledncdsFRfP6Uw+k3SwPViUjPSMrdR+7+HeA7McVrgFOTEE5Kqt5Zzw0Pv9Hhbaanjinlp587QVNcikiP0xPNKWjR+lqu/5832g1el93P+PfzPsS/njGOLM1nICIJoKSQYp5ZuomvP7aUhqaWqPIRAwv45fSTOOFwDVonIomjpJAi3J0ZL63hzudXttv20fHl3PP5EzU8hYgknJJCCmhpcb737NsddijfMHUcXz9vgpqLRKRXKCkkWXOL860n3+KPlRujynOyjB9+eiKXnjwySZGJSCZSUkiipuYWvv7YUmYviX5OryQ/m19ffjKnH1GepMhEJFMpKSRJQ1MLN81azPPL348qLy/O43+uOZUjD9PcyCLS+7p9BNbMisysX7j8ITO7yMw0uM4haGlxvvHY0nYJ4bD++fzxX09TQhCRpIlnXISXgfxwHoQ5BBPiPJjIoNLdj154h6eXRjcZjRxUwGPXT2Hc4OIkRSUiEl9SMHffA3wa+Lm7fwo4OrFhpa/fL1jHjJfeiyqrKCvkseuncHhpYXKCEhEJxZUUzGwKMJ1gfCJQX8RBefHtLXzn6eVRZeXFuTz0pckMG6AhK0Qk+eJJCjcDtwH/6+7LzWwswYimcgAWb9jOV2a9QdtpEApysvjtVacwqkxXCCKSGrr9xu/uLxP0K7SuryGYY1nitGnHXq6ZWUl94/6hK/oZ/HL6iUwcqWErRCR1dJsUzOxDwDeAirb7u/vZiQsrfexraubfHn6Dmt0NUeXfv+Q4zj5yaJKiEhHpWDx9A48BM4D7gebEhpN+vvfM2yzduCOq7MtnjeOyyaOSFJGISOfiSQpN7n5vwiNJQ49VbuThhRuiys45cghf/9iEJEUkItK1eDqanzGzG8xsmJmVtv4kPLI+bvmmD/jPp5ZFlY0uK+QnnzuBfhrcTkRSVDxXCleGr99sU+bA2J4PJz3sbWjmK7MWs6/NnAj5Of24d/rJDCjQw+AikrriuftoTG8Ekk5+8NwK1mzdHVV2+yXHcfRwDV8hIqktnruPcoB/A84Ii+YDv3b3xgTG1WfNXbmF3/9jfVTZZyeN5F80BLaI9AHxNB/dC+QAvwrXrwjLrklUUH3VzvpGbnniraiyirJCvvPJY5IUkYjIgYknKZzi7se3WZ9rZksTFVBfdveLq9i6a19kPauf8dPPnUBRnkYFEZG+IZ67j5rNbFzrSjjMhZ5XiLFi805mLlgXVfZvZ47jxFGDkhKPiMjBiOcr7DeBeWa2BjBgNMHw2RJqaXH+66llNLcZ2GjkoAK+fNYRSYxKROTAxXP30RwzGw9MIEgKK919XzeHZZRn3txE5frtUWXf/eQxFORmJSkiEZGD02lSMLOz3X2umX06ZtM4M8Pdn0xwbH1CfWMzP3r+naiyc48awrlHa1wjEel7urpSOBOYC3yyg20OKCkADy1Yxz937I2sZ/cz/vNCzUEkIn1Tp0nB3b8TLn7P3de23WZmeqAN2L67gZ/PXR1VdsWU0VSUFyUpIhGRQxPP3UdPdFD2eE8H0hf95m9r2FXfFFkvyc/mprPHJzEiEZFD01WfwpHAMcCAmH6F/kB+ogNLdTv2NDDz1XVRZTdMPYJBRbnJCUhEpAd01acwAZgGDCS6X2EXcG0ig+oLfvvKWnY37H9co6wolytPH53EiEREDl1XfQqzgdlmNsXdF/RiTClvV30jv/v7uqiya88YS2GunlwWkb4tnlpssZl9maApKdJs5O5fSlhUKe6xyip27dvflzCoMIcrTtNVgoj0ffF0NP8eOAz4OPASMJKgCemgmdlAM3vczFaa2QozmxJO3vOima0KX1NyfIjmFud3r0bdjMWVp1dofCMRSQvxJIUj3P2/gN3uPhO4EDjuEM97D/C8ux8JHA+sAG4F5rj7eGBOuJ5y/rpiCxtr9z+XkJvVj8t1lSAiaSKepNA6b8IOMzsWGABUHOwJzaw/wdwMDwC4e4O77wAuBmaGu80ELjnYcyTSb1+Jvkq4+IThlBfnJSkaEZGeFU9SuC9syvlP4GngbeDOQzjnWGAr8DszW2xm95tZETDU3TcDhK9DOjrYzK4zs0ozq9y6deshhHHgVmzeycK1tVFlX/ywnuMTkfQRT1KY4+7b3f1ldx/r7kOAvxzCObOBk4B73f1EYDcH0FTk7ve5+yR3nzR48OBDCOPAPfLahqj1KWPLNMWmiKSVZDzRXAVUufvCNr/rJGCLmQ0DCF+rD+EcPa6+sZn/XfzPqDL1JYhIuun1J5rd/X0z22hmE9z9HeAcgiapt4ErgTvC19kHe45EeO6tzexsM6RFaVEuH9NIqCKSZpL1RPNXgIfNLBdYQzBpTz/gUTO7GtgAfOYQz9GjHnltY9T6v5w0gtzseC60RET6jqQ80ezuS4BJHWw6pyfP01NWV9fx2rroDubPnTIqSdGIiCROV81H/+HuPwIuM7MvxG5395sSGlkKeeKNqqj1UytKOWJIcZKiERFJnK6aj1aEr5W9EUiqcneeWbopquyzpxyepGhERBKrq+ajZ8LXmZ3tkwkWb9xB1fb9TzDnZffj48eog1lE0lO3PaXhOEQD26wPMrMXEhtW6oi9Sjj7yCGU5OckKRoRkcSK5/aZweEwFAC4+3Y6edo43TS3OM++uTmq7KLjhycpGhGRxIsnKTSbWeRWGzMbDXjiQkodletq2bprX2S9KDeLs47MiHwoIhkqnvGevw28YmYvhetnANclLqTU8eLbW6LWzz16KPk5WUmKRkQk8bpNCu7+vJmdBJwGGPA1d9+W8MiSzN15cUV0Ujjv6MOSFI2ISO+Ia2aYMAk8m+BYUsqq6jrW1+yJrOdm9ePMCb07AJ+ISG/TOA2diG06mjKujGLNriYiaU5JoROxSUGD34lIJuhqmIvSrg5099qutvdl1TvrWbJxR1SZkoKIZIKu2kMWEdx6ah1sc4IZ1NLSnJXRUzkcP3IAQ/sf9GjhIiJ9RlfDXGTsPJPz34lOCucepasEEckMcfWchnM0j6fN5Dru/nKigkqmpuYWXl1dE1WmB9ZEJFN0mxTM7BrgZmAksITgeYUFwNmJDS05lmzcwa59+2dYKyvK5ehhmodZRDJDPHcf3QycAqx397OAE4GtCY0qiV5eFf1c3kfGl9OvX0fdKiIi6SeepFDv7vUAZpbn7isJpupMSy+/G53vzhivB9ZEJHPE06dQFQ6d/RTwopltBzZ1c0yftLO+kTerom9F/ej48iRFIyLS++IZ++hT4eJ3zWweMAD4c0KjSpIlG3bQ0mb81/FDihmiW1FFJIPEM8nO71uX3f0ld38a+G1Co0qSReu3R61PqhiUpEhERJIjnj6FY9qumFkWcHJiwkmuNzZEJ4WTR3f5ULeISNrpNCmY2W1mtguYaGY7zWxXuF4NzO61CHtJc4uzeEN0f8LJo3WlICKZpdOk4O4/dPcS4Mfu3t/dS8KfMne/rRdj7BWrq+uoa/N8QmlRLhVlhUmMSESk98XT0XybmV1EMOMawHx3T7u5FVa+vzNqfeLIAZjp+QQRySzxdDT/kOABtrfDn5vDsrTy7pZdUesThpYkKRIRkeSJ5zmFC4ET3L0FwMxmAouBtGpCendLXdT6h5QURCQDxTvJzsA2ywMSEUiyxV4pKCmISCaK50rhh8Di8ME1I+hb+FZCo+plexua2VC7fz5mMzhiSHESIxIRSY54Oppnmdl8gkHxDLjF3d9PdGC9aXV1Hd7mSeZRpYUU5GYlLyARkSSJp6N5jrtvdven3X22u79vZnN6I7jeEtt0NH6Imo5EJDN1NUdzPlAIlIeT7LTen9kfGN4LsfWaVdWxncxqOhKRzNRV89G/Al8lSACL2J8UdgK/PNQTh8NlVAL/dPdpZjYGeAQoBd4ArnD3hkM9TzzWbdsdtT5usJKCiGSmrp5oviecp/kb7j7W3ceEP8e7+y964Nw3AyvarN8J/NTdxwPbgat74BxxWVcTnRQqyot669QiIiml2z4Fd/95T5/UzEYSPP9wf7huBNN7Ph7uMhO4pKfP2xF3Z33NnqgyDW8hIpkq3ucUetrdwH8ALeF6GbDD3VsHH6oCRnR0oJldZ2aVZla5deuhzwq6ddc+9jY2R9ZL8rIpLco95N8rItIXdTVK6ofD17yePKGZTQOq3X1R2+IOdvUOynD3+9x9krtPGjz40KfKXBdzlTC6vFBjHolIxurqSuFn4euCHj7nh4GLzGwdQcfy2QRXDgPNrLXjeyS9NOVnbH/C6DL1J4hI5urq7qNGM/sdMMLMfha70d1vOpgThsNu3wZgZlMJOrKnm9ljwKUEieJKemnOhvWxnczqTxCRDNZVUpgGnEvwTX5RF/v1lFuAR8zs+wQD7j3QC+ds33ykKwURyWCdJgV330ZQSa9w96WJOLm7zwfmh8trgFMTcZ6utL9SUFIQkcwVz91HNWb2v2ZWbWZbzOyJ8JbStFC1fW/U+qhSNR+JSOaKJyn8Dnia4MnmEcAzYVmft7ehmR17GiPr2f2MwSU9erOViEifEk9SGOLuv3P3pvDnQeDQ7wVNAe/vrI9aH9o/n6x+uh1VRDJXPElhq5ldbmZZ4c/lQE2iA+sNmz+Ibjo6bEB+kiIREUkN8SSFLwGfBd4HNhPcNvqlRAbVW97/IPpKQUlBRDJdPJPsbAAu6oVYet3mmKQwrL+SgohktmSNfZQS1HwkIhIto5NCbPPRsAEFSYpERCQ1ZHRSaNd8NFBXCiKS2eJOCmZ2mpnNNbO/m1mvzHWQaDV10RO7DS7WMwoiktm6mqP5MHd/v03RvxN0OBvwKvBUgmNLuO17opPCIM2jICIZrqu7j2aY2SLgx+5eD+wALiOYGGdnbwSXSHsbmtnX1BJZz83qR1FuVhIjEhFJvq7maL4EWAI8a2ZXAF8lSAiF9NJUmYlUG3OVMLAwR5PriEjG67JPwd2fAT4ODASeBN5x95+5+6HPg5lk23fHNB0VqulIRKSr6TgvMrNXgLnAMuDzwKfMbJaZjeutABOl7UB4EFwpiIhkuq76FL4PTAEKgOfc/VTg381sPHA7QZLos9p1MutKQUSky6TwAUHFXwBUtxa6+yr6eEIA2NHuziNdKYiIdNWn8CmCTuUmgruO0sr2ds1HulIQEeluOs6f92Isvap985GuFEREMnaYi/YdzbpSEBHJ2KSgjmYRkfYyOClEXymo+UhEJIOTwq690UlhQIGSgohIxiaFnfVNUev9lRRERDI5KURfKZTkdzszqYhI2svIpLCvqZmGNiOkZvUzCnI0QqqISEYmhV0xTUcl+dkaIVVEBCUFAPrnqz9BRAQyNCns3Kv+BBGRjmRkUuio+UhERDI2KcReKaj5SEQEMjUp7Iu5UsjTlYKICCQhKZjZ4WY2z8xWmNlyM7s5LC81sxfNbFX4OihRMdQ3NketF+bpdlQREUjOlUIT8HV3Pwo4DfiymR0N3ArMcffxwJxwPSH2NEQnBT2jICIS6PWk4O6b3f2NcHkXsAIYAVwMzAx3mwlckqgY9sYmhVw1H4mIQJL7FMysAjgRWAgMdffNECQOYEgnx1xnZpVmVrl169aDOm9s85GuFEREAklLCmZWDDwBfNXdd8Z7nLvf5+6T3H3S4MGDD+rc7ZuPMrK/XUSknaTUhmaWQ5AQHnb3J8PiLWY2LNw+DKhO1Pn3xnY0q/lIRARIzt1HBjwArHD3n7TZ9DRwZbh8JTA7UTHEJoX8XDUfiYgAJOMr8oeBK4C3zGxJWPYt4A7gUTO7GtgAfCZRAbTraFafgogIkISk4O6vAJ0NSXpOb8QQmxQKdaUgIgJk6BPN7ZqPdKUgIgJkalJQ85GISIcyMynEPqeg5iMREUBJAVCfgohIq8xMCg3qUxAR6UjGJQV3b998pKQgIgJkYFJobHaaWzyynt3PyM3OuD+DiEiHMq421J1HIiKdy7ykoCEuREQ6lfFJQXceiYjsl3FJYU9D9PzMaj4SEdkv45JC7AQ7uh1VRGS/jEsKextaotbVfCQisl/GJQU1H4mIdC7jphyrb4q+UlDzkUjyNDY2UlVVRX19fbJDSUv5+fmMHDmSnJycuI/JuKTQEJMU8vTgmkjSVFVVUVJSQkVFBcGkjNJT3J2amhqqqqoYM2ZM3MdlXI24rym6o1lPM4skT319PWVlZUoICWBmlJWVHfBVWMbViPsadaUgkkqUEBLnYP62GVcjNjTHJAX1KYiIRGRcUoi9UsjNyrg/gYh0YcaMGTz00EMAPPjgg2zatKnbY2L3u+aaa3j77bcTFmNbd999N3v27Omx35d5Hc3N0X0Kaj4SSb6KW/+U0N+/7o4L4973+uuvjyw/+OCDHHvssQwfPrzLY2L3u//++w8u0INw9913c/nll1NYWNgjvy/jkkK7KwUlBZGM9tBDD3HXXXdhZkycOJFx48ZRXFxMRUUFlZWVTJ8+nYKCAhYsWMCPf/xjnnnmGfbu3cvpp5/Or3/9a5544ol2+51//vncddddTJo0iVmzZvGDH/wAd+fCCy/kzjvvBKC4uJibb76ZZ599loKCAmbPns3QoUO56qqryM/PZ/ny5WzZsoWf/OQnTJs2jebmZm655RZeeOEFzIxrr70Wd2fTpk2cddZZlJeXM2/evEP+e2RcjdiuT0FJQSRjLV++nNtvv525c+eydOlS7rnnnsi2Sy+9lEmTJvHwww+zZMkSCgoKuPHGG3n99ddZtmwZe/fu5dlnn+1wv1abNm3illtuYe7cuSxZsoTXX3+dp556CoDdu3dz2mmnsXTpUs444wx+85vfRI5bt24dL730En/605+4/vrrqa+v57777mPt2rUsXryYN998k+nTp3PTTTcxfPhw5s2b1yMJATIwKbS7+0gdzSIZa+7cuVx66aWUl5cDUFpa2uX+8+bNY/LkyRx33HHMnTuX5cuXd7n/66+/ztSpUxk8eDDZ2dlMnz6dl19+GYDc3FymTZsGwMknn8y6desix332s5+lX79+jB8/nrFjx7Jy5Ur++te/cv3115OdnR1XrAcr85qPYp9TUEezSNIdSJt/T3L3uG/brK+v54YbbqCyspLDDz+c7373u90+A+DunW7LycmJnDsrK4umpv1D8MTGZGYHFOuhyLgasf0tqRn3JxCR0DnnnMOjjz5KTU0NALW1tVHbS0pK2LVrF0AkAZSXl1NXV8fjjz/e4X5tTZ48mZdeeolt27bR3NzMrFmzOPPMM7uN67HHHqOlpYX33nuPNWvWMGHCBM477zxmzJgRSR6tsXZ27oOVeVcKuiVVRELHHHMM3/72tznzzDPJysrixBNPpKKiIrL9qquu4vrrr490IF977bUcd9xxVFRUcMopp3S6X6thw4bxwx/+kLPOOgt354ILLuDiiy/uNq4JEyZw5plnsmXLFmbMmEF+fj7XXHMN7777LhMnTj/DMcAAAAlWSURBVCQnJ4drr72WG2+8keuuu47zzz+fYcOG9Ui/gnV1eZPqJk2a5JWVlQd0zBUPLORvq7ZF1md+6VTO/NDgng6td02dGrzOn5/MKEQO2IoVKzjqqKOSHUZKueqqq5g2bRqXXnppj/y+jv7GZrbI3Sd1tH/GXSkMKMjhsP757GtqZl9TC/m6+0hEJCLjksIvLjsp2SGIiHTqwQcfTOr59TVZRJKqLzdhp7qD+dsqKYhI0uTn51NTU6PEkACt8ynk5+cf0HEp1XxkZp8A7gGygPvd/Y4khyQiCTRy5EiqqqrYunVrskNJS60zrx2IlEkKZpYF/BL4GFAFvG5mT7t77ww1KCK9Licn54BmBZPES6Xmo1OB1e6+xt0bgEeA7m/oFRGRHpNKSWEEsLHNelVYJiIivSSVkkJHg3q0630ys+vMrNLMKtUOKSLSs1KmT4HgyuDwNusjgXZTHrn7fcB9AGa21czWH+T5yoFt3e7Vl3Q/WFb6vefu6T1nBr3nAzO6sw0pM8yFmWUD7wLnAP8EXgcuc/eux6Y9+PNVdvaYd7rSe84Mes+ZIVHvOWWuFNy9ycxuBF4guCX1t4lKCCIi0rGUSQoA7v4c8Fyy4xARyVSp1NHc2+5LdgBJoPecGfSeM0NC3nPK9CmIiEjyZfKVgoiIxFBSEBGRiIxMCmb2CTN7x8xWm9mtyY6np5nZ4WY2z8xWmNlyM7s5LC81sxfNbFX4OijZsfY0M8sys8Vm9my4PsbMFobv+Y9mlpvsGHuSmQ00s8fNbGX4eU9J98/ZzL4W/rteZmazzCw/3T5nM/utmVWb2bI2ZR1+rhb4WVifvWlmhzRpTMYlhTYD750PHA18wcyOTm5UPa4J+Lq7HwWcBnw5fI+3AnPcfTwwJ1xPNzcDK9qs3wn8NHzP24GrkxJV4twDPO/uRwLHE7z3tP2czWwEcBMwyd2PJbh9/fOk3+f8IPCJmLLOPtfzgfHhz3XAvYdy4oxLCmTAwHvuvtnd3wiXdxFUFCMI3ufMcLeZwCXJiTAxzGwkcCFwf7huwNnA4+EuafWezaw/cAbwAIC7N7j7DtL8cya4lb4gfOC1ENhMmn3O7v4yUBtT3NnnejHwkAf+AQw0s2EHe+5MTAoZNfCemVUAJwILgaHuvhmCxAEMSV5kCXE38B9AS7heBuxw96ZwPd0+67HAVuB3YZPZ/WZWRBp/zu7+T+AuYANBMvgAWER6f86tOvtce7ROy8SkENfAe+nAzIqBJ4CvuvvOZMeTSGY2Dah290VtizvYNZ0+62zgJOBedz8R2E0aNRV1JGxHvxgYAwwHigiaT2Kl0+fcnR79d56JSSGugff6OjPLIUgID7v7k2HxltbLyvC1OlnxJcCHgYvMbB1Bk+DZBFcOA8NmBki/z7oKqHL3heH64wRJIp0/53OBte6+1d0bgSeB00nvz7lVZ59rj9ZpmZgUXgfGh3cr5BJ0Uj2d5Jh6VNiW/gCwwt1/0mbT08CV4fKVwOzeji1R3P02dx/p7hUEn+lcd58OzAMuDXdLt/f8PrDRzCaERecAb5PGnzNBs9FpZlYY/jtvfc9p+zm30dnn+jTwf8K7kE4DPmhtZjoYGflEs5ldQPAtsnXgvduTHFKPMrOPAH8D3mJ/+/q3CPoVHgVGEfzn+oy7x3Zm9XlmNhX4hrtPM7OxBFcOpcBi4HJ335fM+HqSmZ1A0LGeC6wBvkjwZS9tP2cz+3/A5wjuslsMXEPQhp42n7OZzQKmEgyPvQX4DvAUHXyuYXL8BcHdSnuAL7p75UGfOxOTgoiIdCwTm49ERKQTSgoiIhKhpCAiIhFKCiIiEqGkICIiEUoKkjLMbLCZvRKOfnlJm/LZZjb8IH7XwnD4h4/GbPuqmRXG8Tu+Fee51plZeXfHm9mr4WuFmV3Wpnxq66iuPc3MLrJwJGAzu+RgBn80s7qej0xSlZKCpJIvEAz0NQX4JoCZfRJ4w90P9AnNc4CV7n6iu/8tZttXCQZS605cSSHe49399HCxAris3d4J4O5Pu/sd4eolBCMDi3RKSUFSSSNQAOQBLeGwBV8FftzZAWY22szmhOPIzzGzUeEDXT8CLjCzJWZW0Gb/mwjGzJlnZvPCsi+Y2VvhFcqdYdkdBCNxLjGzh8Oyp8xsUTiW/3VdvZFOjm/9xn0H8NFw29dijisKx9J/PbzKuTgsP8bMXguPedPMxndwzk+Y2RtmttTM5oRlV5nZL8zsdOAi4Mfh7xgX/jwfvqe/mdmR4TFjzGxBGMN/d/U+JQ25u370kxI/wADgT0AlwTf9m4AruznmmdZ9gC8BT4XLVwG/6OSYdUB5uDyc4OnQwQQDzM0FLgm31cUcVxq+FgDLgLLY3xezf+zxdeHrVODZNuWRdeAHBE/jAgwE3iUY9O3nwPSwPBcoiPndgwlGyhwTE2vk70AwRv+lbY6ZA4wPlycTDA0C4bAJ4fKXY9+HftL7R1cKkjLc/QN3v9DdJwFvANOAJ8zsNxbMLjalg8OmAH8Il38PfOQAT3sKMN+DAdaagIcJ5ijoyE1mthT4B8EAZO2+rfeA84BbzWwJMB/IJxjWYAHwLTO7BRjt7ntjjjsNeNnd1wJ4N8NahCPong48Fp7r10DrGPwfBmaFy78/5HckfUp297uIJMX/BW4n6GdYRFDxzwbO6ua4Ax23paNhh9vvFIyndC4wxd33mNl8ggq7pxnwL+7+Tkz5CjNbSDCJ0Atmdo27z4057kDeez+COQhO6GS7xr/JULpSkJQTtpcPd/eXCDqEWwgqqY4q4VcJRkUFmA68EscpdgEl4fJC4EwzK7dgqtYvAC+F2xotGIIcgqat7WFCOJLgm3l32h7f2fljvQB8JRzkDDM7MXwdC6xx958RNO9MjDluQfg+xoT7l3Z1Xg/m11hrZp8J9zczOz7c7+9E/00lgygpSCq6HfjPcHkWQbv4Pwhm3Ip1E/BFM3sTuIJgjubu3Af82czmeTDE8G0EQy8vJbjTaXab/d4MO4qfB7LD8/x3GE8852k9vq03gaawQ/hrMdv+G8gJj1sWrkMwKuiysKnnSOChtge5+1aC+XmfDJu4/thBPI8A3ww7sMcRVPhXh/svZ/+0tDcTzOv9OkEylAyiUVJFRCRCVwoiIhKhpCAiIhFKCiIiEqGkICIiEUoKIiISoaQgIiIRSgoiIhLx/wHDpLAkAO65NQAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "ucblines = citedRefsMeta_ucb_count.plot.line(x='titlepct', y='citationpct', linewidth=4)\n",
    "ucblines.axhline(y=80, color='r')\n",
    "ucblines.axvline(x=pctile_ucb, color='r')\n",
    "ucblines.set_ylabel('% of total citations')\n",
    "ucblines.set_xlabel('% of total titles cited')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Plot your institution vs the entire group:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 154,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.lines.Line2D at 0x125e4ead0>"
      ]
     },
     "execution_count": 154,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXcAAAEGCAYAAACevtWaAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAgAElEQVR4nO3deXgc1Z3u8e9P+y5b8m7ZlvBC7LDYxmAMhM3sITjrDAlPIECGzJBcyExyc2FyMzBzMxkyyU0CN4SECQSy2QOECUwIWwCzJXjDLDa2kfEqb9psydosqfvcP6q0dGuxpO5Wq7vfz/Po6arTVV2n3Pbro1OnTplzDhERSS5p8a6AiIhEn8JdRCQJKdxFRJKQwl1EJAkp3EVEklBGvCsAMGHCBFdeXh7vaoiIJJQNGzbUOucm9vfemAj38vJy1q9fH+9qiIgkFDPbPdB76pYREUlCCncRkSSkcBcRSUIKdxGRJKRwFxFJQscNdzN70MyqzWxTr7ISM3vezCr91/F+uZnZPWa23czeMbPFsay8iIj0byhDIR8Cfgz8slfZbcALzrm7zOw2f/1/AZcDc/2fpcB9/quISPIIBqGjpeenve9ysL2ZlqajtLYcpa3lKO2tTXS2NdPZ1oxrb4aOFtI6W0nvbOXIzItZ+oW7olrF44a7c+4VMysPK14BnO8vPwysxgv3FcAvnTeP8BtmNs7MpjrnDkSrwiIixxUM+GHbCn6Qhi73H8iDLbv2FlxHC7Q3kxY4dtwqpAEF/s/xbGiYE+kZ9zHSm5gmdwW2c+6AmU3yy6cDe3ttV+WX9Ql3M7sJuAlg5syZI6yGiCSkYMAP2lboaPZD1F8eMJD7C+d+9m9vgSGE73CZ/xMT7S1R/8ho36Ha37n3+zQQ59z9wP0AS5Ys0RNDRMaSQGevEO0K4YGWuwK5ZYjh3BqT8E1k1jF2wv1QV3eLmU0Fqv3yKmBGr+3KgP2RVFBE+hHoGEbXwgDh3L1dP+EcaI/3GY55LS6bVrJoJdtf9n9cFi1k00oOgfQcyMzDsvJJz84jI6eA7LxCsnPzyc0voqCgkPzCIspLp0a9fiMN9yeB64C7/NcnepV/xcxW4V1IbVB/u6SkYBDaj/aEaQR9vSHLXevBjnif4ZjX3BW4fgi3kE2ry+m17L3fQjZtZNHismkhp9dyNm1+cHctZ2Tnk1dQSEF+AeMLcigtyKY0P4uS/Kzu5Sn5WZQWZDE+L4vM9PiNNj9uuJvZSryLpxPMrAq4Ay/UHzGzG4E9wGf8zf8IXAFsB1qA62NQZ5HR19kOrfXQXAsttdBSB811vZb9197LLhDvWo9ZQWd9QnawFnDPsre9t5xFq8vptZzdvU0bWQylh7w4N5PSgqyQgJ4aFtYlYySsh2soo2U+O8Bby/vZ1gFfjrRSIjHlHLQ3DRDQ/QV3HRxriHetR5XDCGTk0pGWyzHLps1yaHXZNLssjgayaAxk0hDI7AljN3gLOLQFncMxMonF5cni3EymhYV1/8uJF9bDNSam/BWJSDAArYd7tZ4HalnXQovf+k70C3qWBpn5kJUHmbl9lzNzCWbm+aGcRXMwi6PBbBoDGRzpyKS+I5P69nRq2jOobjUOtaZzqC2dFuf1IccqfIerv5Z1qob1cCncZWwKdEDjfmjY6732DuhmP6S7llsPM8CgrPjKKoCsfMjM819zB1n2X7PyBljOpzM9xw/mDGpbHHUtHdQ3t1PXdIy65nZ/uZ262mPUN7dzpLUDN8b+WMblZXphnJ9FaX42JQVdy1mU+GFdWuAFtsI6Mgp3iY9jTdBQ5YX3kT3ea0MVHNnrLR89AC4Y71r2sDTILYG8Usif4L12L/vr+aU9y3mlkJkz6Ed2BoIc7i+g68PCuvkI9c3VCmsZFoW7RJ9zXou6wQ/qrsBuqOoJ8tbD8a1jRo4fxCUDB3Tv8txxkJY+6Ed2hXVd8zHqa5qoa66nrslrRdf5Qe0te+HdoLCWGFK4y8i0NUJdJdRu79Xy7gryKuhsHd365BSHhfJxWtZZ+WDD61NuaO1ge/VRKg81UVndxL7DrQprGbMU7jIw57z+7tr3w34qvW6TWMufBONmQHGZtzxgcJdAembUDnu4uZ3K6iYqu4Pce60+Gv+LsF1hPSE/m5L8LEoKspjgX1QsKcj2lhXWgsJdujTVwIG34cBbULOtJ8Q7mmNzvLQMKJoO42ZC8YyeEC+e4ZUVTT9un3UknHPUNrVTWX2U7dVN3SG+vbqJ2qbRuztTYS2xonBPRUcPekG+/y0vzA+8DY37onuMrMKwwJ7hvXYtF0w+bh92NDjnONR4rFcrvMnrWqlu4khL9O/yVFjLWKFwT3bNdVC1FvZv7An0poORf25aBpScABPmwfjynhZ4cZkX3jnjht2nHQnnHPsb2nj/0FG2d3WlVDex/VATR491RuUYmelGxYR85k4qZM6kAk6YmM/EguzusC7JyyJDYS1jhMI9mTgHh3fCnjdgz19gzxqo3RbZZ2YXeQE+YR5MmNuzXFIR1X7uoQoGHVWHW7vDu/KQ1xLfXt1Ec3t0bvfPykhj9sQC5k7yfyYXMGdSIbNK89TSloShcE90h3fDBy/Cjpdg91+gufr4+/QnPQsmLYCpp8KUk2HiiV6IF0we1RZ4l85AkD31LX43ShOVh7ww/6CmibaO6Ix/z8lMY86kgu6W+NxJBcybXMiMkjzS0+J/d6ZIJBTuiaatEXa96gX6By9C/Y7hf0Z6Nkw5yQvyqQth2kKYOB8ysqJf3+No7wyyu665uxXedVFzR00z7YHohHh+VjpzJheGtMTnTipk+rhc0hTikqQU7omg7gN4/xnY9rTX3RIcRh+ypcHkk2DGGTBtkRfmE0+MS5eKc44dtc2s3VnPmh11bN7fyM7aZjqD0RkcXpiTwTw/xOdMKmCuvzy1OAeLw28fIvGkcB+rjuyFdx/1fqrfG/p+mXlQtgRmLoOZZ8L0JZBTFLt6DiIYdFRWN7FmZx1rdtazdmc9NVEYKz4+L7M7uOf2CvGJhdkKcRGfwn0saT0Mm3/vBfru14e2T1omzFgKsy+AEy6AqafEpVUOEAg6thxoZI3fMl+3q57DEQw3nFCQ3asbxbuoOXdyARMKsqNYa5HkpHCPt2DA6255eyVUPje0x5uVzoU5y2H2hTDrbMgeyvPVo68jEGTTvgavm2VnPet21XO0bfjDDqcU5fgjUry+8LmTC5gzsYDx+aN/DUAkWSjc46X1MLz5K1j7H9CwZ/BtLR3Kz4Z5l8O8S6F09ujUMcyxzgDvVDWwZofXzbJh92Fahjn8MC8rndNmjWdpRQmnl5cwf1oRRTnx+U1DJJkp3Edbzfuw5j54e5X3PMzBlJ0OJ/8VfPgTUDBxdOrXi3OOd/c18MKWatbsrGPjniMc6xzeCJbC7AxOryhhaUUJZ1SUcNL0Yo0VFxkFCvfRUvcBvPxdrz99sHnKS2bDKX8FJ38mLi30YNDx5p7DPL3pIM9sOsi+I8Ob3XFcXiZnlJew9IRSllaUMH9qkcaMi8SBwj3WDu+GV/4d3lo58AOTM3K8MD/tepi+eNRvGuoMBFm7s56nNx3k2c0HhzX74YSCbJaeUMKZFSWcUVHK3EkFGjsuMgYo3GOlrQFe/ndY8zMIDjBipHAanPFFWPwFb67xUdTeGeT1D2p55t2DPL/lEPXNQ5sJcWpxDksrelrmFRPyNfxQZAxSuEdbMAhv/Rpe+Bdorul/m4nz4dyvw4IVozpssb0zyOpt1Ty96SB/2nJoSCNbcjLTOG/eRJbPn8yyE0opG5+rMBdJAAr3aKr7AJ74sncXaX9K58D5t3sXSEdhutsue+tbWLl2D4+s3zukucrzs9K5cP5kLj9pCuefOJG8LP01EUk0+lcbDcEgrL0f/nRn/4+XKyqDC7/pjXxJH50/8s5AkJe21fCbNbt5+f2a4z7+rSgng4sXTOHyk6ZwztwJ5GSO3n8+IhJ9CvdINeyDx2+C3a/1fS8jF875Kpx1C2TljUp1Dja08Z/r9rJq3R4ONLQNum1pfhaXfNgL9GWzSzVEUSSJKNwjsWM1PHYDtNT1fW/uJfDRH3gProixYNDx6vZafvPGbl7YWk1gkIm4CrIzWLFwGleeMo0zKko0TFEkSSncR8I5eP1ueOGf+45Zzy6Cy+6ChZ+L+ZDGzkCQ/35nPz9+cTsf1Az+rNOTpxdzzdKZfOzUaeRn62sXSXb6Vz5cgQ74w9/Dxl/1fe+EC2DFvVA8PaZVaO8M8vibVfxk9QfsqR/4LtfczHRWLJzG55bO5JSycTGtk4iMLQr34WhrgEeu8556FMLggn+Ej3wd0mLXb93WEeDR9Xv56cs7Br1z9MTJhVxz5kw+vmi65m0RSVEK96FqqYdfXgUH3w0tzymGTz8Icy6K3aHbO/ntmj3c/8qOAe8eTU8zrjxlKp8/cxanzRqvsegiKU7hPhTNtfDwVVC9ObR83Ey45jHvyUYx0BkIsnLdXn70/PvUDXAHaWa68anFZfzd+bOZVZofk3qISOJRuB9PU7UX7DVbQsunnwafXQUFk6J+SOccq7fV8K9/3ML26qZ+t8nKSOPq02fwpfNmM31cbtTrICKJLaJwN7O/B74IOOBd4HpgKrAKKAHeBD7vnBvaxCVjTVsj/PqTfYO94lwv2LOi31LecqCRf31qC69tr+33/dzMdK5ZOpObzj2BSUU5UT++iCSHEYe7mU0HbgEWOOdazewR4GrgCuCHzrlVZvZT4EbgvqjUdjQFOuCRa/v2sc++EK7+LWRGt7Xc2NbBd5/eym/X7un3btLczHSuP7ucG8+poFSPmROR44i0WyYDyDWzDiAPOABcCHzOf/9h4E4SLdydg//+at9RMbOX+8Ee3Rbzs5sP8q3fb+r3YqkZfHpxGV+/9EQmq6UuIkM04nB3zu0zs+8De4BW4DlgA3DEOdc13WAVcPxB39u2wfnnj7Qq0dd4AOo/CC3LLoApNfDAZVE7THsgyK7aZoqb27mnn/eLcjOZVZpH/l8y4N6oHVZEUkAk3TLjgRVABXAEeBS4vJ9N+70X3sxuAm4COCV7DHUzHGuEwztCyzJyYNKHvWeZRoEDao4eY3ddc79TBeRkpjOrNI9xeVloQKOIjEQk3TIXATudczUAZvY4cBYwzswy/NZ7GbC/v52dc/cD9wMsWbLEsXp1BFWJktYjcN9Z0Nhrkq+sQvibF2HivKgc4nBzO7c9/g7Pbj7U572MNONvz5vNVy6co1kZReT4BrmfJZJw3wOcaWZ5eN0yy4H1wEvAp/FGzFwHPBHBMUbXM7dD477Qsk/cF7Vgf62ylq89+haHGvv2rZ9aVsxdnzqF+VOLonIsEUltkfS5rzGzx/CGO3YCG/Fa4k8Bq8zs237ZA9GoaMxtfQre/m1o2bKvwPyPRfzRgaDjh8+/z49f2t7nvdzMdL52yTyuP7tCMzSKSNRENFrGOXcHcEdY8Q7gjEg+d9S1NcIf/iG0bOJ8WP5PEX/04eZ2blm1kVcr+45bP7WsmB9dvYiKCbqzVESiS3eoAqz+N2g62LOelgGf+ClkRHahd/P+Bm765YY+k3yZwc3nz+arF83TAzJEJCYU7gc3wZqfhpadfStMWxjRx760tZov//ZNWtoDIeUTCrL5f59dxLLZpRF9vojIYBTuf7oz9IEbxTO9qXsj8Os3dvNPT2wifJTjklnjufeaxboZSURiLrXDffefYfvzoWWX3zXi55065104vefFvhdOr102i//90QVkZagbRkRiL3XD3Tn40z+Hls1cBideMcKPc3znj1v4j1d3hpSnGfzTlQv4wtkVI62piMiwpW64v/8s7H0jtGz5HSN67mkw6Ljjyc386o3dIeW5menc89lFXLxgciQ1FREZttQMd+fgxW+Hls29BGYtG/ZHBYKO2373Do9uqAopL8rJ4KEbzmDxzPGR1FREZERSM9wrn4dDYVP5XvitYX+Mc447n9zcJ9hL8rP45Q1ncNL04khqKSIyYqkZ7q/9MHR9wQqYesqwP+Znr+zo0xUzsTCb33xxKfMmF0ZSQxGRiKReuO/bAHv+HFp2zj/0v+0gnnhrH3c9vTWkbEpRDitvOlN3nIpI3KXeuLx1D4aun3DBsG9Y+ssHdXz90bdDygpzMnj4hjMU7CIyJqRWuLcehk2/Cy1b+rfD+oj3Dx3lpl+tpyPQc4dSZrrxs8+fxolT1BUjImNDaoX726ugs9c8L8UzYO7FQ969vrmd63+xjqNtnSHl3//MqZw1e0K0aikiErHUCXfnYMNDoWWnXQdpQ3soRiDouGXlxj6TgH3jshNZsfD4TxIUERlNqRPuB96Gml4XQNMyYNG1Q979B89v47XtodP2XrN0Jn933uxo1VBEJGpSJ9zffTR0fc5FUDi0O0ef23yQe18KfWD2GeUl3HnVh7ER3NEqIhJrqRHuwUDfC6knf2ZIu+6qbeZrj4SOjJlUmM2Pr1mkudhFZMxKjXTa/TocPdCznpk/pAnCOgJBbl21kaPHei6gZqQZ916zmEmFmrZXRMau1Aj3bU+Hrs+/ckjT+t7zQiVvVzWElP3jFfM5vbwkmrUTEYm65A935/oJ9+M/9HrdrnruDXug9SULJnP92eVRrJyISGwkf7jXVsLhXnOsp2fBCecPuktbR4D/+ejbIU9SmlSYzV2fOkUXUEUkISR/uL8f1movPweyB7+T9P5XdrCrriWk7PufOZWS/Kxo105EJCZSINyfDV2fd/mgm++tb+nTHXPN0pmcO29itGsmIhIzyR3ux5pg75rQsnmXDLrLnU9u5lhnzwOzS/Oz+MalH4pF7UREYia5w33vGxDsNQ9MyWwYXz7g5i+/X8MLW6tDym67/EMU52XGqIIiIrGR3OG+89XQ9YqPDLhpIOj4tz9uCSlbMms8n1pcFouaiYjEVHKH+67XQtfLBw73322oYuvBoyFld3zsw6SlaXSMiCSe5A33Y02wf2NoWfk5/W7a2h7g/z6/LaTsE4umc3KZnoEqIokpecN9/0ZwgZ710jlQOKXfTX/9xm4ONR7rXs/KSONrl8yLdQ1FRGImecN93/rQ9bLT+92stT3Az17ZEVJ2/VnllI0//vQEIiJjVfKGe1VYuE8/rd/NVq7dQ21TT6s9LyudL2mOdhFJcMkZ7s71DfeyJX02a+8M8rNXQudp//yyWboTVUQSXnKGe+M+aDrYs56RA5NP6rPZU+/uD+lrz81M528+csJo1FBEJKYiCnczG2dmj5nZVjPbYmbLzKzEzJ43s0r/dXy0Kjtk4a32qQshPfRGJOccD7y2M6Tsr0+fwYSC7FjXTkQk5iJtud8NPOOc+xBwKrAFuA14wTk3F3jBXx9dfS6m9u2SWbfrMJv2NXavm8EXziqPccVEREbHiMPdzIqAc4EHAJxz7c65I8AK4GF/s4eBj0dayWEbwsXUB8Na7cs/NJnyCfmxrJWIyKiJpOV+AlAD/MLMNprZz80sH5jsnDsA4L9O6m9nM7vJzNab2fqampoIqhEmGISD74aWhYX7viOtPPfewZCyG8+piF4dRETiLJJwzwAWA/c55xYBzQyjC8Y5d79zbolzbsnEiVGcTvfILmhv6lnPKYZxM0M2eWTd3pAHccyfWsSZJ+jReSKSPCIJ9yqgyjnXNafuY3hhf8jMpgL4r9UD7B8bhzaHrk8+2etQ9wWCjkfX7w3Z5JqlM/WEJRFJKiMOd+fcQWCvmZ3oFy0H3gOeBK7zy64DnoiohsN1cFPo+uQPh6y+UlnD/oa27vXczHRWLJw2GjUTERk1GRHu/z+A35hZFrADuB7vP4xHzOxGYA/wmQiPMTyHwsJ9Suj49lVr94Ssf/SUqRTmaL52EUkuEYW7c+4toO84Q68VHx/h4d7r5qXqo228sCW0l+izZ8wYjVqJiIyq5LpDta0RDu/qWbc0mDS/e/WJjfvp7HUlde6kAhbPHP17rEREYi25wr36vdD10rmQmdu9+uTb+0Pe/qslM3QhVUSSUnKFe03oAzeYvKB7cWdtM+/ua+heN4OrdCFVRJJUcoV7fegMj5TO7V78Q1irfWlFCZOLckajViIioy65wr0uPNy9edmdc326ZD52qlrtIpK8kivc60OfqESJF+7bq5uorO65azUjzbj8pKmjWTMRkVGVPOEeDPYNd7/l/tx7h0KKz5ozQQ/kEJGkljzh3rgPOnvuPCVnHOR588U8HxbulyyYPJo1ExEZdckT7n0upnqt9urGNt7aeyTkrYsV7iKS5JIn3I+ETivAeG8K3z+F3ZF6almxRsmISNJLnnBvqApdH+dNK/B82LztF81Xq11Ekl8Shfu+0PWi6TQf6+T1D+pCii/+sMJdRJJf8oR7Y1jLvXgGr1bW0N4Z7C6aUZLLiZMLR7liIiKjL3nCPbxbpng6q7eFPr7vovmTNZeMiKSE5Ah35/p0y7ii6bxaWRtSdsGJ/T7OVUQk6SRHuLcehs7WnvXMfD44msm+Iz1l2RlpnFGh56SKSGpIjnBvCH0mKsXTeXV7aKv9jIoScjLTR7FSIiLxkyThHjZSpriMV94P7W8/b97EUayQiEh8JUe4N4aGe7BwOmt21oeUfWSuwl1EUkdyhHvYSJmatAm0tAe61ycUZDFvcsFo10pEJG6SI9ybQqcY2N4aGuSnzRqvIZAiklKSI9xbQi+ebm7IDllfMkujZEQktSRHuDeHXjzdUBs6KmbxrPGjWRsRkbhLknAPnT9m69GelntWehonTS8a7RqJiMRVcoR7WLdMvesJ8/lTC8nO0Ph2EUktiR/u7c3Q0dK9GrAMjpLbvT5PE4WJSApK/HBvDm21N6WPA3pGxpw4ReEuIqkn8cM9rEumjtD+9blquYtICkr8cA+7mHqgI3SMu25eEpFUlPjh3hIa7rXBnjAvzMlgip6XKiIpKPHD/djRkNVGl9e9PG9yoe5MFZGUlATh3hiy2hQyUkZdMiKSmiIOdzNLN7ONZvYHf73CzNaYWaWZ/aeZZUVezUGEhftR1xPusycq3EUkNUWj5X4rsKXX+neBHzrn5gKHgRujcIyBhXXLHKWnW6a8ND+mhxYRGasiCnczKwM+CvzcXzfgQuAxf5OHgY9HcozjCgv3pl4t9/IJeeFbi4ikhEhb7j8CvgEE/fVS4IhzrtNfrwKm97ejmd1kZuvNbH1NTU1/mwxNW/997mZQNl7hLiKpacThbmZXAtXOuQ29i/vZ1PW3v3PufufcEufckokTI3hK0gDdMtOKc/XMVBFJWRkR7Hs2cJWZXQHkAEV4LflxZpbht97LgP2RV3MQ4eHud8vMKlWrXURS14hb7s65251zZc65cuBq4EXn3DXAS8Cn/c2uA56IuJaDOdYQstrVcp+li6kiksJiMc79fwH/YGbb8frgH4jBMXoMcEG1XC13EUlhkXTLdHPOrQZW+8s7gDOi8blDOHDfcKerW0YtdxFJXYl9h2pHKwQ7u1ePuUzayQRgZola7iKSuhI73PuMlOkZ4z59XG741iIiKSPBwz1sjLvf356bmU5RblR6nEREElJShXtXy31qcY5mgxSRlJbg4d4Ustrsh/uUYs3hLiKpLbHDvaM1ZLXFZQMKdxGRBA/3lpDVVrzZhacq3EUkxSVZuHuhPqVYI2VEJLUleLiHdsu0Oq/lPk0tdxFJcQke7uEtd6/PfWJhdjxqIyIyZiR4uIe13P0+9/F5sX2yn4jIWJfg4R7acm/zR8uMz1e4i0hqS/BwDxsKSTaZ6UZ+lh7SISKpLbHDvb3vUMhxeVm6O1VEUl5ih3s/3TLj8zLjVBkRkbEjwcO97wXVcbqYKiKS6OHedyikWu4iIgkf7n3nltEwSBGRJAv3Y+qWEREBEj3cA+0hq8fIULeMiAgJH+7HQlY7yFC3jIgICR/uHSGr7S6TcWq5i4gkeriHdst0kEFxrsJdRCSpwr2ddIoU7iIiiR7uod0yHWRQmJMRp8qIiIwdiR3unX0vqBbmqOUuIpK44R4MgAv0rDqjk3QKstVyFxFJ3HDvr0smO5P0NM0IKSKSwOEefjFV/e0iIl0SONzDW+7p6m8XEfElcLj3dzFVLXcREUjocA/rlnGZFCjcRUSACMLdzGaY2UtmtsXMNpvZrX55iZk9b2aV/uv46FW3l/CpB8ggP0vhLiICkbXcO4GvOefmA2cCXzazBcBtwAvOubnAC/569PUz9UBOph6MLSICEYS7c+6Ac+5Nf/kosAWYDqwAHvY3exj4eKSV7FefG5jSyctSuIuIQJT63M2sHFgErAEmO+cOgPcfADBpgH1uMrP1Zra+pqZm+AftZ5x7rsJdRASIQribWQHwO+CrzrnGoe7nnLvfObfEObdk4sSJwz+wumVERAYUUbibWSZesP/GOfe4X3zIzKb6708FqiOr4gDCn8LkMtUtIyLii2S0jAEPAFuccz/o9daTwHX+8nXAEyOv3iD665ZRy11EBIBIxg6eDXweeNfM3vLL/hG4C3jEzG4E9gCfiayKA+jnJiaFu4iIZ8Th7px7DRholq7lI/3cIetn+gFdUBUZuzo6OqiqqqKtrS3eVUk4OTk5lJWVkZk59ClWEveun34mDitWy11kzKqqqqKwsJDy8nK8Xl0ZCuccdXV1VFVVUVFRMeT9Enf6gWBnyGrAqeUuMpa1tbVRWlqqYB8mM6O0tHTYv/EkTbh3kqahkCJjnIJ9ZEby55bA4R4IWQ3oDlURkW5JFO5pGi0jIoNKT09n4cKFnHrqqSxevJg///nPw/6MgoKCmG4fLYl7QTW8z12jZUQSQvltT8X083fd9dEB38vNzeWtt7yR288++yy33347L7/88pA+1zmHcy4qdRwNidtyd6Et907SFO4iMmSNjY2MH98zI/n3vvc9Tj/9dE455RTuuOMOAHbt2sX8+fO5+eabWbx4MXv37u3evra2lmXLlvHUU08NuH+4/rb51re+xd133929zTe/+U3uueeeiM8vYVvuLtAZMsg+qG4ZETmO1tZWFi5cSFtbGwcOHODFF18E4LnnnqOyspK1a9finOOqq67ilVdeYebMmWzbto1f/OIX/OQnP+n+nEOHDnHVVVfx7W9/m4svvnjA/ViDZnMAAAp8SURBVM8999zufQba5sYbb+STn/wkt956K8FgkFWrVrF27dqIzzVhwz0Q6AipfNDSyUxP3F9ERCT2enfL/OUvf+Haa69l06ZNPPfcczz33HMsWrQIgKamJiorK5k5cyazZs3izDPP7P6Mjo4Oli9fzr333st5550HMOD+4eE+0DalpaVs3LiRQ4cOsWjRIkpLSyM+14QN986OzpDKW3rCnopIShmsT3w0LVu2jNraWmpqanDOcfvtt/OlL30pZJtdu3aRn58fUpaRkcFpp53Gs88+2x3uA+3f22DbfPGLX+Shhx7i4MGD3HDDDVE4uwTuc+/oDJ1+IC1t6Lfliohs3bqVQCBAaWkpl156KQ8++CBNTU0A7Nu3j+rq/ie0NTMefPBBtm7dyl133QUwpP0H2+YTn/gEzzzzDOvWrePSSy+NyvklbHM3EB7u6epvF5HBdfW5g9eSfvjhh0lPT+eSSy5hy5YtLFu2DPCGL/76178mfYBcSU9PZ9WqVXzsYx+jqKiIm2++ud/9J03qeVbRQMeYNGkSWVlZXHDBBYwbN27AYw6XjYWhPUuWLHHr168f1j61j3+DCe/8rHv95znX88XbfhTtqolIlGzZsoX58+fHuxpjUjAYZPHixTz66KPMnTu33236+/Mzsw3OuSX9bZ+w3TJ9Wu4ZCftLiIiksPfee485c+awfPnyAYN9JBI2EfuEe1rCnoqIpLAFCxawY8eOqH9uwrbcg2HTD6jlLiLSI3HDPazlbmq5i4h0S9hwd2Fzy6RpnLuISLfEDfdAaLdMurplRES6JW64h7XcLV03MYnI8f3Xf/0XZsbWrVsB7y7Uk046CYDVq1dz5ZVXxrN6UZOwzV0XCA33aA38F5EYu7M4xp/fMOjbK1eu5JxzzmHVqlXceeedsa1LHCVNyz1NLXcROY6mpiZef/11HnjgAVatWhXv6sRUAod7eJ+7wl1EBvf73/+eyy67jHnz5lFSUsKbb74Z7yrFTMKGe/iTmDI0WkZEjmPlypVcffXVAFx99dWsXLkyzjWKncRNxLBw12gZkQRxnD7xWKmrq+PFF19k06ZNmBmBQAAz4+abb45LfWItYVvuLZZPrSviiMun0eWSnpkd7yqJyBj22GOPce2117J792527drF3r17qaiooKqqKt5Vi4mEbe7+suxOHjvU86V8d/LJcayNiIx1K1eu5Lbbbgsp+9SnPsV3vvOdONUothI23Ns7gyHr2RkaCikiA1u9enWfsltuuYVbbrmle/3888/n/PPPH71KxVDChntRbgZTinI41hmgvTNITmbC9jCJiERdwob7tz9+Mt/+eLxrISIyNqm5KyKjZiw8+S0RjeTPTeEuIqMiJyeHuro6BfwwOeeoq6sjJydnWPvFpFvGzC4D7gbSgZ875+6KxXFEJHGUlZVRVVVFTU1NvKuScHJycigrKxvWPlEPdzNLB+4FLgaqgHVm9qRz7r1oH0tEEkdmZiYVFRXxrkbKiEW3zBnAdufcDudcO7AKWBGD44iIyABiEe7Tgb291qv8MhERGSWxCHfrp6zPFRQzu8nM1pvZevXBiYhEVywuqFYBM3qtlwH7wzdyzt0P3A9gZjVmtnuEx5sA1I5w30Slc04NOufUEMk5zxroDYv2sCQzywDeB5YD+4B1wOecc5ujeqCe4613zi2JxWePVTrn1KBzTg2xOueot9ydc51m9hXgWbyhkA/GKthFRKR/MRnn7pz7I/DHWHy2iIgcXzLcoXp/vCsQBzrn1KBzTg0xOeeo97mLiEj8JUPLXUREwijcRUSSUEKHu5ldZmbbzGy7md12/D0Sj5nNMLOXzGyLmW02s1v98hIze97MKv3X8fGuazSZWbqZbTSzP/jrFWa2xj/f/zSzrHjXMZrMbJyZPWZmW/3velkKfMd/7/+d3mRmK80sJ9m+ZzN70MyqzWxTr7J+v1fz3OPn2TtmtjiSYydsuPeaoOxyYAHwWTNbEN9axUQn8DXn3HzgTODL/nneBrzgnJsLvOCvJ5NbgS291r8L/NA/38PAjXGpVezcDTzjnPsQcCreuSftd2xm04FbgCXOuZPwhk1fTfJ9zw8Bl4WVDfS9Xg7M9X9uAu6L5MAJG+6kyARlzrkDzrk3/eWjeP/op+Od68P+Zg8DSfNcKjMrAz4K/NxfN+BC4DF/k2Q73yLgXOABAOdcu3PuCEn8HfsygFz/xsc84ABJ9j07514B6sOKB/peVwC/dJ43gHFmNnWkx07kcE+5CcrMrBxYBKwBJjvnDoD3HwAwKX41i7ofAd8Aup6CXgoccc51+uvJ9l2fANQAv/C7on5uZvkk8XfsnNsHfB/YgxfqDcAGkvt77jLQ9xrVTEvkcB/SBGXJwswKgN8BX3XONca7PrFiZlcC1c65Db2L+9k0mb7rDGAxcJ9zbhHQTBJ1wfTH72deAVQA04B8vG6JcMn0PR9PVP+eJ3K4D2mCsmRgZpl4wf4b59zjfvGhrl/Z/NfqeNUvys4GrjKzXXhdbRfiteTH+b++Q/J911VAlXNujb/+GF7YJ+t3DHARsNM5V+Oc6wAeB84iub/nLgN9r1HNtEQO93XAXP/qehbexZgn41ynqPP7mx8AtjjnftDrrSeB6/zl64AnRrtuseCcu905V+acK8f7Tl90zl0DvAR82t8sac4XwDl3ENhrZif6RcuB90jS79i3BzjTzPL8v+Nd55y033MvA32vTwLX+qNmzgQaurpvRsQ5l7A/wBV4M1B+AHwz3vWJ0Tmeg/er2TvAW/7PFXj90C8Alf5rSbzrGoNzPx/4g798ArAW2A48CmTHu35RPteFwHr/e/49MD7Zv2Pgn4GtwCbgV0B2sn3PwEq8awodeC3zGwf6XvG6Ze718+xdvJFEIz62ph8QEUlCidwtIyIiA1C4i4gkIYW7iEgSUriLiCQhhbuISBJSuEvS8mdavNlfnmZmj/nLC83sil7bfcHMfhzlY3/BzKZF8zNFhkPhLslsHHAzgHNuv3Ou6+aYhXj3CsTSF/BuqxeJi5g8IFtkjLgLmG1mb+HdMDIf77b+f8GbjfAc4N9672BmE4GfAjP9oq865143szuB2XgTOc0A/t059x/+Pt8APo830dnTeDcjLQF+Y2atwDLnXGssT1QknMJdktltwEnOuYX+jJp/cM61m9k/4d399xXwulB67XM33nzir5nZTOBZvP8UAE7Bm1M/H9hoZk/hzb3+cWCpc67FzEqcc/Vm9hXg68659bE/TZG+FO4ioS4CFnjTnQBQZGaF/vITfgu81cxewnumwEeAXzjnWgCcc+Fzd4vEhcJdJFQa/XSj+GEfPleHw5sPRHN4yJijC6qSzI4ChcMoB3gO+ErXipkt7PXeCv85n6V4k5qt87e/wczy/O1LhnAMkZhTuEvScs7VAa/7Dyf+Xq+3XsLrennLzP46bLdbgCX+A4rfA/6213trgaeAN4D/44/AeQZvqtb1/oXbr/vbPgT81D9GbtRPTuQ4NCukyBD4o2WanHPfj3ddRIZCLXcRkSSklruISBJSy11EJAkp3EVEkpDCXUQkCSncRUSSkMJdRCQJ/X87fA5puBFWOQAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "ax = citedRefsMeta_ucb_count.plot(x='titlepct', y='citationpct', linewidth=4, label = 'Berkeley')\n",
    "citedRefsMeta_count.plot(ax=ax, x='titlepct', y='citationpct', linewidth=4, label = 'All').axhline(y=80, color='r')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Notes and some references:"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "*Note: on splitting & stacking method*  \n",
    "For each row, take column 'CR', split it at ; and append new row, keeping DOI and Institution\n",
    "https://stackoverflow.com/questions/12680754/split-explode-pandas-dataframe-string-entry-to-separate-rows\n",
    "https://gist.github.com/jlln/338b4b0b55bd6984f883"
   ]
  },
  {
   "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.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}