Etat-art-nettoyage.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Récupération des données : \n",
    "\n",
    "- https://github.com/jerrytigerxu/Beatles-NLP\n",
    "- Transformation du xlsx en csv."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### État de l'art : \n",
    "\n",
    "- Référence : Compton, Todd (2017). *Who Wrote the Beatle Songs?  A History of Lennon-McCartney* :\n",
    "\n",
    "Comme le remarque Todd Compton, la plupart des chansons des Beatles ont été signées par les deux principaux chanteurs du groupe : John Lennon et Paul McCartney. Ce n'est pas un mystère cependant que ces chansons, pour une partie, n'ont été écrites que par un seul des deux. </br>\n",
    "La question de l'attribution des textes a été rendue encore plus compliquée du fait des Beatles eux-mêmes, qui ont cultivé la mésinformation par rapport à ces questions. De même, ce point aveugle tient sûrement aussi du fait que l'apport majeur des Beatles et la rupture qu'ils constituent dans la culture populaire ne tient pas forcément à leurs textes. </br>\n",
    "Certaines chansons relèvent d'une véritable collaboration, écrites pendant des sessions de trois heures, \"*eyeball to eyeball*\" dit John Lennon. </br>\n",
    "D'autres ont été écrites séparément par John Lennon ou Paul McCartney et l'un aidait l'autre à terminer d'écrire la chanson. Selon T. Compton, il s'agit de la forme la plus commune de leur collaboration. </br>\n",
    "Dans d'autres cas, des textes étaient écrits séparément par les deux chanteurs, puis rassemblés ensuite pour construire une chanson unique (ex : *Baby You're a Rich Man*\"). </br>\n",
    "\n",
    "Lorsque l'on se penche sur les interviews donnés par les deux chanteurs, on se rend compte que ceux-ci se sont souvent contredits sur ces questions, l'un vis-à-vis de l'autre, mais aussi au sein de leur propre discours personnel. Pour ne prendre qu'un exemple parmi les nombreux développés par T. Compton, la chanson *Eleanor Rigby*, attribuée en grande partie à McCartney mais dont Lennon affirme dans un interview de 1970 avoir écrit près de 70% de la chanson, propos contredits par un des amis de McCartney, Pete Shotton, présent lors de la session, qui affirme que Lennon n'a pratiquement rien fait sur cette chanson. Lennon lui-même, dans un interview de 1981, explique qu'il a aidé à écrire une demie ligne de *Eleanor Rigby*, se contredisant avec ses propos tenus dix ans plus tôt. De même, dans un autre interview, répondant à la question de savoir quelles chansons étaient les plus marquantes dans sa collaboration avec McCartney au niveau de l'écriture, Lennon cite *Eleanor Rigby*. Pour une demie ligne ? C'est peu probable...\n",
    "\n",
    "Une vision diachronique sur les différentes périodes des Beatles peut s'avérer nécessaire pour tâcher de mieux comprendre cette collaboration.\n",
    "\n",
    "- Première période : \"__the Beatles era__\" : Brian Epstein, l'agent des Beatles, leur conseilla rapidement d'affirmer que toutes leurs chansons résultaient d'une écriture collaborative. En 1964, McCartney affirme : \"*Sometimes maybe he'll write a whole song himself, or I will, but we always say that we've both written it*\" ; et en 1966, d'affirmer : \"*We both work on all our songs*\". Au fil du temps cependant, et après la mort d'Epstein en 1967, cette position de revendication d'une écriture résolument collaborative se dissipa progressivement, à mesure qu'ils arrivaient aux albums de maturité, comme *Revolver and Sgt. Pepper*.\n",
    "- Deuxième période : \"__after the breakup__\" : très peu de temps après la rupture en 1970-1971, Lennon donna des interviews qui remirent en question l'attribution des chansons attribuées au couple Lennon-McCartney. Cependant, ces propos semblent davantage relever du ressentiment de Lennon vis-à-vis de McCartney à cette époque et de leurs désaccords. Compton écrit : \"*During this period, John and Paul were publicly and heatedly disagreeing about many things, and attacked each other in interviews, at the same time that they were discussing autorship of songs. Naturally, bias would be present during a time of such heated emotional conflict*\" (p. 6).\n",
    "- Troisième période : \"__1980's to the present__\" : cette troisième période se caractérise par une forme de retour sur les propos tenus pendant la deuxième période. Dans sa biographie *Paul McCartney : Many Years From Now*, McCartney affirme n'être en désaccord avec Lennon sur l'attribution de seulement deux chansons. En vérité, ces désaccords sont bien plus nombreux, mais l'on remarque que ces interviews ont eu tendance à reprendre la première posture de l'écriture purement collaborative.\n",
    "\n",
    "On note donc que l'histoire de l'écriture collaborative entre les deux auteurs se doublent des histoires et destins personnelles de ceux-ci, de  problématiques tenant à leur relation amicale, des tensions qui ont pu naître entre eux, mais aussi de l'image commerciale qui a été entretenue par leur agent, préférant mettre en avant la création collective plutôt que l'écriture individuelle au sein du groupe. </br>\n",
    "Si Todd Compton mène une étude en confrontant les sources, les différents interviews et propos des deux chanteurs, il convient pour nous de nous demander si une analyse à partir des textes et du style de ces chansons à l'attribution douteuse ne nous permettrait pas, pour certaines chansons tout du moins, de démêler le style propre de chacun des deux chanteurs.\n",
    "\n",
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Nettoyage des données : \n",
    "\n",
    "---"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Librairie pandas (manipulation de données csv, dataframe, etc.)\n",
    "import pandas as pd\n",
    "\n",
    "# Import et lecture du corpus :\n",
    "corpus = pd.read_csv('data/beatles_data.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(218, 6)\n"
     ]
    }
   ],
   "source": [
    "# Print dataframe shape\n",
    "print(corpus.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Song' 'Album Debut' 'Songwriter(s)' 'Lead Vocal(s)' 'Year' 'Lyrics']\n"
     ]
    }
   ],
   "source": [
    "#Print column values\n",
    "print(corpus.columns.values)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>Song</th>\n",
       "      <th>Album Debut</th>\n",
       "      <th>Songwriter(s)</th>\n",
       "      <th>Lead Vocal(s)</th>\n",
       "      <th>Year</th>\n",
       "      <th>Lyrics</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>\"12-Bar Original\"</td>\n",
       "      <td>Anthology 2</td>\n",
       "      <td>John Lennon\\n Paul McCartney\\n George Harrison...</td>\n",
       "      <td>Instrumental</td>\n",
       "      <td>1965</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>\"Across the Universe\"</td>\n",
       "      <td>Let It Be</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1968</td>\n",
       "      <td>Words are flowing out like endless rain into a...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>\"All I've Got to Do\"</td>\n",
       "      <td>UK: With the Beatles\\n US: Meet the Beatles!</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1963</td>\n",
       "      <td>Whenever I want you around yeh \\nAll I gotta d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>\"All My Loving\"</td>\n",
       "      <td>UK: With the Beatles\\n US: Meet the Beatles!</td>\n",
       "      <td>McCartney</td>\n",
       "      <td>McCartney</td>\n",
       "      <td>1963</td>\n",
       "      <td>Close your eyes and I'll kiss you\\nTomorrow I'...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>\"All Things Must Pass\"</td>\n",
       "      <td>Anthology 3</td>\n",
       "      <td>Harrison</td>\n",
       "      <td>Harrison</td>\n",
       "      <td>1969</td>\n",
       "      <td>Sunrise doesn't last all morning, \\nA cloudbur...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Song                                   Album Debut  \\\n",
       "0       \"12-Bar Original\"                                   Anthology 2   \n",
       "1   \"Across the Universe\"                                     Let It Be   \n",
       "2    \"All I've Got to Do\"  UK: With the Beatles\\n US: Meet the Beatles!   \n",
       "3         \"All My Loving\"  UK: With the Beatles\\n US: Meet the Beatles!   \n",
       "4  \"All Things Must Pass\"                                   Anthology 3   \n",
       "\n",
       "                                       Songwriter(s) Lead Vocal(s)  Year  \\\n",
       "0  John Lennon\\n Paul McCartney\\n George Harrison...  Instrumental  1965   \n",
       "1                                             Lennon        Lennon  1968   \n",
       "2                                             Lennon        Lennon  1963   \n",
       "3                                          McCartney     McCartney  1963   \n",
       "4                                           Harrison      Harrison  1969   \n",
       "\n",
       "                                              Lyrics  \n",
       "0                                                NaN  \n",
       "1  Words are flowing out like endless rain into a...  \n",
       "2  Whenever I want you around yeh \\nAll I gotta d...  \n",
       "3  Close your eyes and I'll kiss you\\nTomorrow I'...  \n",
       "4  Sunrise doesn't last all morning, \\nA cloudbur...  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Coup d'oeil sur les données, les variables, etc. :\n",
    "corpus.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Analyse et nettoyage des données :\n",
    "---"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "McCartney                                                                               60\n",
       "Lennon                                                                                  60\n",
       "Harrison                                                                                26\n",
       "McCartney\\n (with Lennon)                                                               23\n",
       "Lennon\\n McCartney                                                                      19\n",
       "Lennon\\n (with McCartney)                                                               16\n",
       "Lennon\\n McCartney\\n Harrison\\n Starr                                                    4\n",
       "McCartney and Harrison                                                                   1\n",
       "McCartney (\"Step Inside Love”)\\n Lennon–McCartney\\n Harrison–Starr (\"Los Paranoias”)     1\n",
       "McCartney\\n Starr                                                                        1\n",
       "Lennon\\n and McCartney                                                                   1\n",
       "Lennon and Harrison                                                                      1\n",
       "John Lennon\\n Paul McCartney\\n George Harrison\\n Ringo Starr                             1\n",
       "McCartney (with Lennon)                                                                  1\n",
       "Starr                                                                                    1\n",
       "Lennon\\n McCartney\\n Starkey[d]                                                          1\n",
       "Lennon, McCartney, Harrison, Starr                                                       1\n",
       "Name: Songwriter(s), dtype: int64"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Analyse des observation à homogénéiser : \n",
    "\n",
    "## Dénombrement songwriters :\n",
    "\n",
    "corpus['Songwriter(s)'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:>"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAhMAAAD4CAYAAABWv2RMAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAABQHklEQVR4nO2dd7hdVbW+34+EHkCpl2qUFmkJEJCqCe1aUFCRIoIBBUVpeoGfCirlqiCItEsJEYKC0kEEpAgEQicdEjoJgigQCIFACCXf748xN2dl5/SWnGS8z3Oe7DXXXHPNtfaGNdaYY4xPtkmSJEmSJGkvi8zrCSRJkiRJ0rNJYyJJkiRJkg6RxkSSJEmSJB0ijYkkSZIkSTpEGhNJkiRJknSI3vN6AkkyL1hxxRXdt2/feT2NJEmSHsXo0aOn2l6pvj2NiWShpG/fvowaNWpeTyNJkqRHIen5xtpzmSNJkiRJkg6RxkSSJEmSJB2iRWNC0ozumEhHkdRXkiX9b6VtRUnvSzqnhWP/S9Llkp6VNFrSzZLWa+P5f9beubcHSUPqr0vSCEkDOzjuiZJ26tjsWn2uAyU9KmmCpMck7Vbah0harSvP/ei/ptP3JzfN8ZckSZK0jwXNMzEZ+FJl+xvAxOYOkCTgOmCE7bVtbw78FFilNSdUsAjQrcZEZyCpV/227V/Y/kc3nHsN4FhgO9ubAFsBE8ruIUCbjAlJvZvbTpIkSbqOdhkTktaWdEt5ix8pqV9pHy7pLEn3S3pO0h6lfVB5a75a0hOSLisPcSTtKGlseUO9SNLipX2KpBMkjSn7+rViau8Aj1fezvcCrqzMexVJ10kaX/62AQYD79s+v9bP9njbIyX1kXRHZQ61N+e+kp6U9EfgMeAPwJKSxpVr6yvpcUkXSpoo6TZJSzZ17yQtI2mypEVLn2Wr2+38js6TNKqc/4RK+xRJp0gaA3yjke3hle/tZEmTiufgtMq131na7pC0VmkfLum9+u++GVYG3gJmlHs+w/bkctxA4LJyP5eU9AtJjxTvxdDKb2eEpDMkjQKOqN9u771LkiRJ2kZ7PRNDgcPKW/xRwLmVfasC2wG7AidX2jcFjgQ2AD4FbCtpCWA4sJftjYnskkMqx0y1vRlwXjlPa7gc2FvSmsCHwEuVfWcBd9vuD2xGeC02AkY3Mda7wFfLHAYDv6s9yIB1gXNtb2j7AGCm7QG2963s/z/bGwJvAF8v7XPdO9tvASNo8KrsDVxr+/0WrnWv8sAdJ2kc8RCucaztgcAmwOckbVLZ95rtzWxf3sQ2klYAvgpsWDwHteWjs4FLSttlxD2tsQiNf/eNMR54GZgs6WJJXwawfTUwCti33M+ZwDm2t7C9EbBkGb/GYrYH2v5dE9sfIengYmCN+vCd6S1ML0mSJGktbXYFS+oDbANc1fBcZfFKl+ttzwYmSaouFTxs+8UyxjigL/FmOtn2U6XPJcAPgTPK9rXl39HA11o5xVuAk4gH1RV1+3YA9gew/SEwvXINjSHg15I+C8wGVqdh+eN52w82c+xk2+Mq8+/bwr0bBhwDXA8cABzU3MQKV9g+9KPJSiMq+/aUdDDxHa9KGHG1ZYT6+1K/DTCdMKb+IOlG4MbSvjUN38WfgN9Wjvmg/ruXtDbwf8BKhOfoINtPEN6cJ8vcdgM+L+kCwqgaAJwiaXXi3l0r6ZgyxhrAzpJuJr6fKyRNIX47mwNrSepXzjEHtocSxhyLr7puyuUmSZJ0Eu3xTCwCvFHeGmt/n67sn1X5rCbaP6R1hkztmNb2x/Z7xAPof4CrW3HIROIh1Bj7Eg+wzW0PIAyUJcq+t1sYt7HrbfLe2b6PMDgGAb1sP9aKuTeKpE8SXo8diwfhpsq8G5v7XNdi+wNgS+Ie7koYaS1RfUDXvvuWvFgDCG/GBzR4b/oAvyMMoLWBC4nvYlHgAuB84n6uXpn7VOJ7v5LWe7GSJEmSTqDNxoTtNwnX9DfgowDE/u08/5PEA3Sdsr0fcHdzB0jassQqNMfvgP9n+/W69jsoyyiSeklaDrgTWLy8xdfOsYmk7YHlgFdsvy9pMPCJZs75fksxDq24d38E/gxcXJnLoZIOpW0sSzxkpxcPwRfaeHzNA7Wc7ZuBHwG1ed5PLMNAPOBHtjDGNsCjxRt1AWFAQCxXjLM92/YkwmirFUOZRiwbzSaMvV7A8mX/4NLnEuL7qVHzYj1OeL2aZePVl2PKyV+a4y9JkiRpH60xJpaS9GLl78fEQ+Q7ksYT/7PfrT0nt/0u4dK/StKjxFLC+c0fxVrAzBbGnWj7kkZ2HQEMLucaDWxg20RswE6K1NCJwG+A/xAxAQNL//2BuVznFYYCEyRd1sL8m7t3lwEfB/5SaesHvNbCmHNgezwwtsz3z8B9bTm+sAxwo6QJwL3Aj0v7YcABpX0/mg90XIRYLnm+ES/WIkRsyxPF0OhdGet54PzS/h5hYF4DbAw80sS5ap6g2WRl1yRJkm5F8SztOUg6FfiT7Qktdu5hlEyG3WzvV2m7EfhaWb6Zr5E0w3afurbHgQdsH1iCVzexPV7ScODGEnD50bFlmeco27uW9nOIgMzLgaeAHWw/U44fa/vMEjMx0PZURSbPabYHNTfXgQMHOstpJ0mStA1Jo0tw/xz0uDc420fP6zl0BZLOJpYjvlhtrz1UewhLSXqxsn06cT3nFU/MooRRML6tA9t+V1LNi9Wb8FC05MVKkiRJuoEe55lIks4gPRNJkiRtpynPxIJWATNJkiRJkm6mxy1zJElnUNPmqJIZHUmSJO0jPRMJ8FGZ7ZF1beMkNVvvQtKiirLbTyvKjj8gqU2pqOoGYa8kSZKk60hjIqmyTClDjqRPt9S5cBJRO2KjUnZ8dyKttFUoxMaG0EZhryRJkmT+IY2JpMqVhDgawD5U6l2UIl+nKcS2Jkg6TNJSRNnvw2zPArD9su0ryzGtERvbh7mFvRoVeZO0tEIM7mGFOFxNeO0eSQMq49/bgUJqSZIkSRtJYyKpcg0NuhtfBv5W2XcwUVlyQEXkax3gn6WyZ2O0RmzsUuYW9oLGRd6OBe60vSVRCfNUSUsTOh9DACStByxRCnfNgVLoK0mSpEtIYyKp8howTdLeRFnqdyr7dgIuKJodNFKqvDH2LN6HscCGhNZGjcbExapURd76ls+7AD8plTFHEHojawFXAbuWcuYHEkq0c2F7aFEUHdhrqeUa65IkSZK0g8zmSOq5glD5HNKKvs8QKp3L1nsn1CA2toXtaaViZXNiY/U0JvIm4Ou2n6zvLOl2ojT5njQt3JYkSZJ0AWlMJPVcRwRU3sqcQZG3A9+TdJftDyQtb/t1SX8AzpT0PdvvSVoJGESUvq4XGxvRxDnfonVBm7cCh0k6zLYlbWp7bNk3jFiWGWl7WksDbbz6cozKVNAkSZJOIZc5kjmw/ZbtUxrRAhkG/JMQMxsPfLO0Hwe8CkwqaaQ3Am+2UWxsOEXYS9KSzfQ7iSjJPaEIsp1Umfdo4E0qiqtJkiRJ95DltJMFglKnYgTQr0iXN0uW006SJGk7WU47WWCRtD/wEJE90qIhkSRJknQuGTOR9Hhs/xH447yeR5IkycJKeiaSJEmSJOkQaUwkcyDpwFJ1ckKpdlmrMtku/QxJwyXt0cz+Y0uFzAklAPMzko4s1TVrfQZJmi7p5pbOIekySa83d05oEPqq/iVJkiTtI5c5ko+QtAZRZXIz29Ml9QFWKruHAI8BL7VhvGZ/X5K2BnYt55slaUVgMaLWxaXMWTRrpO1dmxluEQDb+5aaFmkoJ0mSdBP5P9ykyspEzYcZALZn2J5c3vLr9TN+IemR4r0YKkkAkkZIOkPSKOCI6uCSTipehF6SjibiHDYEfla6HA6cTdS3uKtodBwB/AjYrqbxoeAcSe9LmgJ8Fdi6pvlBlALfukvvVJIkSfIRaUwkVcYDLwOTJV0s6csAtq9mbv2Mc2xvYXsjYEnCw1BjsVK2+ne1BkmnEl6OA4AdgXWBTYHngP+RdB0wEfgk4f3Ygah+eSlR4+JeisYHcCSwPvCvst801LF4jSheNVddi9TmSJIk6RrSmEg+wvaHwOeBPYgKlr+XdHwT3QdLekjSo8SDf8PKvnrdjZ8Dy9n+vqOwyS7l796yfzrQCziTWOZYjBDyGmv7tfJ5exo0PnamQdH0QuDOZs5dvb7U5kiSJOkC0phI5sDBw7Z/A+wNfL2+j6QlgHOBPWxvTDzQm9PdeATYXNLytSGA3xQvxwDbq9v+CnAoocnRh5Amv6hofOwFPFjUSm9izlif+nO1pPmRJEmSdDJpTCQfIWk1SZtVmgYAz5fPVf2MmuEwtQRpNps5AdwCnAzcJGkZQmPjQEmbSlpX0uqSVi7newhYnBDruhVYFpgJvF/R+HiSMDAAViE8F0mSJMk8IrM5kiqLAqeVFNB3Cc2N75d9wwn9jJlEcOOFRHbHfwjPQ7PYvqoYEjcAXyT0Oq4kgi1F6H5MAg4mYiM+DfzD9mBJzxDiYTWNj9HlmB0IhdMH2nqhKfSVJEnSeaQ2RzJfIWkRYAzwDdtPl7ZBwFEtpIZWxxgO3FgCRxsltTmSJEnaTmpzJEia0cy+QZJu7MDYHTq+jLEB8AxwR82QKLwHbNRU0aq6MS4jMj7e7chckiRJktaTyxzJfIPtScCnGmm/H+jbyjH27eRpJUmSJC2QnomFjFLw6dRSbOpRSXtVdveRdLWkJ0pZ6lohqimlWNSYcky/NpxvF0kPlGOvKgGbTY4p6XhJF5XiV89JOrwy1o/LvB+TdGRp6yvpcUkXlqJWt0lasjPuVZIkSdI60phY+PgakTXRH9gJOFXSqmXfpkRBqA0ID8G2leOm2t4MOA84qjUnKuWxjwN2KseOAn7cijH7Af8NbAn8UtKikjYnCl59BtgKOEjSpqX/usD/2d4QeING0lmTJEmSrmOhMSYkWdKlle3ekl5taZ1fUh9JF0h6VtLo8sb8mTaeew7hqq5C0u6SftFCt+2Igk9fIh7OdxP1HT4BPGz7RaII1L+Yc2nh2vLvaKBv8Qg81sK5tiIMk/skjQO+Xc7T6JiV9ptsz7I9FXiFSP/cDrjO9tu2Z5Rjty/9J9seJ+lQIsujOlajpNBXkiRJ57EwxUy8TQTxLVnKQe9MPDBbYhgwGVjX9uxSRGmD1p5UUi/ibb9euKorOAb4Sms62r4BuEHSn4iH/ntEwagaHzLn72NWE+3NIeB22/s0sb+pMZubR3PjXAT8lCjLnSRJknQTC5MxAXAz8UZ+NVFh8S+Ut9uyln82IWhl4ARgHOFW39f2bADbkwnjAknXA2sSRZzOtD20tM8ALiCWEa6hQbhqaqmbMIMoHb0rUZBpN9svS1oJOB9Yq8z3SKKGwpPANrZfLamTTwFb2361dmGS1gNm2Z5aDJhniKWK5Qi9ilphp12AgZJMLGPsTBSJ2gBYStLapd86wC8k/azsbxVlOeJ0oorldGA9SesQRtmYck+WqI0paQiwP7CJpKcJT8R1Zd8+ZR63lvuwmaSTS593gGmEd6VX+W7ekfQ6sHpr55skSZJ0nIVmmaNwObB3KQe9CVFtscbPgem2Ny5lm+8kdCDGFc2KxjjQ9uaEAXK4pBVK+9LAQ7b72z6REK4abHtwZf+DtvsD9wAHlfYzgd/b3oJY9x9WjJhLgVqWwk7A+KohUdiWeFjXNDaeJAyE7Ur754g3+KWAB4GTCLXNI4C/EkbMSNvPlvEWAU4kDJqPNXH99ewI3E/EMKxC3MNHCaNtILAfEUNRP+Z6hDdhY+KeL1cKZ51CGG5fJAysUcDDxP37q+31ie9w+cpYL9JgjM2BUugrSZKkS1iojAnbE4j19H0IL0WVnYhqirW+01ox5OGSxhMP5zWJhyiEa/6aZo57D6jFalTjBXYCzinxBTcAyxaPyUXE2zvAgcDFjYy5KlGxssZI4LPl7zdEQOPLwCO2jyYe6n+xXRPGmlhXFOpQ28PL/P5V4hewPcr2oPqT2x4BbEEYLK8AU4mS172KcTQK2L0sr8wxJvB329vbfpfwQNxaxhph+9PFwLkMeKOolL5HVMoEuItQCa1xLVGZcy5S6CtJkqRrWNiWOSAe0qcR5ZlXaL4rE4H+knrVeydKVcadiOWGdySNoEGz4t1mvBkA77uh9Gg1JmARYKvyUK0yQ9LLknYgMhwaq6Uwk1jSqHEPcAixxPJPYDOifPXoZuZVpb0xEhNtb93GMdsaI9HU/YP4Dma2brpJkiRJZ7BQeSYKFwEn2H60rv124Ie1DUkfL2/Eo4ATKjUX+kr6EvHgnlYMiX5EEGNTVEWymuM24LDKHAZU9g0jljuuasJQeZyIL6jxMLANMNv2OcAlxDLEPR2YX0s8CawkaWuAktK5YQvHNMXDwOckrVhiQPYhMk9aYj2a8ExU2Xj15Zhy8pfm+EuSJEnax0JnTNh+0fZZjez6X+DjpSDSeBoCFr9LrP8/U1IhhxNu/FuA3pIeJxQxH2zmtEOBWyTd1cL0DieCIydImkSDyBaER6UPjS9xQBgJm9aMHtuzgBcq8xpJGAz1RhRELMnRksZWAjBbw/qSXqz9AbsRCqKnlHs4jjBo2oztfwM/IZYxxgOjbf+1FYduSxiGSZIkSTeRQl89BEkvEd6QZwmlzv1t/6euz5nA32z/o5lxpgADK/EK1fYXbG9faRsH9C5xCk2NtygRzPl1wsMxCzjR9t/bcG1DgNtsv9TaY5oYZ1Pgx7b3a6lvCn0lSZK0HaXQV89F0k+AlYE9S6bJKOBnjXT9NZGt0V6WkbRmOeenW3nMSUTw50almuXutGHJpCxhDCFiOzrKikRWTpIkSdKNpDHRA7B9MpHyWEtlvQdYR9KWCt2LsZLuBz5m+wZJQySdUzte0o0lYLQlriQyMKChDkdtjF6STivLQBMkHVaqeh4EHFaWVbD9su0ryzHnlVTMiZJOqIw1RdIpksaU8wwELpM0TtKSalq3Y2mFbsfD5Zp3K+33SBpg+3bbUyTdK6l/W+9zkiRJ0j7SmOiZ7ErEPjwBbG97U+AXhGeiI1xDaHcAfJk5Uy4PJlJYBxTvyGVEwOc/bb/ZxHjHFnfYJkQw5SaVfa/Z3sz2pYSnZV/bA0p1Umhct+NY4E7bWxIxLadKWhr4A+HdqBXvWsL2+HbdgSRJkqTNpDHRs7irxDEsS9SOWA64qgSG/p4o+NQRXgOmSdqbyA6plv/eCbjA9gcAtl9vxXh7Fu/D2DK3ahnyKxo/5CMa0+3YBfhJuQcjiDTQtYCrgF1L/MaBRJBskiRJ0k0sjHUmejKDq4GTks4A7rL9VUl9iQcswAfMaSguQeu5gijeNaQVfZ8B1pK0bL13QqFhchSwhe1pkobXzePtFsZurCaFgK/bfrK+s6TbiWySPYHNW5p4TeirSqaHJkmStI/0TPRslqNBrGxIpX0KMEDSIiWgcss2jHkd8FuiCmWV24HvSeoNIGl52+8QSwxnSlqstK8k6RuE9+RtYLqkVYAvNHPO1ta5uBU4rFLzY9PKvmHAWUSFz9ZUL02SJEk6iTQmeja/BX4jaSxzepnuIzQtJhEP2DGtHdD2W7ZPsf1e3a5hRCXNCaWGxDdL+3FEGe9JZbnlRuDNErMwlojr+HOZU1MMB86vBWA20+8kYNEyh4lluzbv0cCbNF2HI0mSJOkiss5EskBQhMFGAP1qCq+N9DmYounRa9mVNl/jkDntjlzmSJIkaZ6sM5EssEjan0ibPbYpQwJS6CtJkqSryADMpMdj+4/AH+f1PJIkSRZW0piYTynS46cS6ZDTAQPn275wnk6Mj8pfD7R9aKVtBHCU7XbXqJZ0InBPc+XAO4uNV1+OUbmskSRJ0imkMTH/Mgx4DljX9mxJKxE1FDpEyYRQc8sB3YHqZN3L9i/m5ZySJEmS9pExE/MhRblzS+C42kPf9qu2T6n0OVrSI6W0dbVU9Y9LyevHJB1Z2vpKelLSHwl57jUl/by03SvpL5KOqp1b0i2SRksaWStl3cb5t6aM9jca2R4uaY/S92RJk8r1nVa5jjtL2x2S1irtwyWdJel+Sc/VxkiSJEm6h/RMzJ9sCIxvJithF2BdwuAQcIOkzxJ1HQ4APlPaH5J0NzCt9P+27QclbUGofPYnUi3HEJUmIeTSv2/7aUmfAc4FdmhkGntJ2q6yvU7l87G2X1eIeN0haRPbE8q+10qZbCSdXLf9+fLvCsBXicwMS/pYOfZs4BLbl0g6kEh73b3sWxXYDuhHyLVf3di9S5IkSTqfNCZ6AJKOBb4BrGx7NSKOYheijgNAH8JY6ANcZ/vtcty1wPbEw/V52w+W/tsCf7X9LvCupL+V/n2AbYgS3bXTL97EtK5oJGaixp4lDbM38ZDfAKgZE/VltBsrqz0deBf4g6QbidoVAFvToB3yJ6LORo3ri/E1qRTJSpIkSbqJNCbmTyYB/SUtYnu27V8Bv5I0o+wX8BvbF1QPknREM2O2VL4aYtnrDdsD2jPpMoe2ltGea162P5C0JbAjsAdwKI17R6rMqnxWk72SJEmSTidjJuZDbD9DKGn+b1kqQNISNDwkbwUOLJ4EJK0uaWVgJLC7pKUUappfLW313Ad8WdISZYxdy3nfBCaXctgoaKuUd1vKaDdKmdNytm8GfkQsxwDcD+xdPu9L49eWJEmSdDPpmeggkmbY7tMFQ3+XSA19RtJrwEzgGADbt0n6NPBAWY6YAXzL9pjiCXi4jDHM9liFCNhH2H5E0g3E0sPLhJz59LJ7X+A8SccR2h+zgPXr5tYP+BLhMai27WD7t6W89xPACzRfRrue9QmdjvuAv1YMqB+X/YcBF0s6mijhfUAbxp6DFPpKkiTpPLKcdgfpQmOiS5HUx/YMSUsB9wAH2x5T12cQUTti15baixFzo+1WBT5K6l2TM29su6tZfNV1veq3z5ijLY2JJEmS5sly2t1IU+mVTaUwShokaYSkqyU9Ieky6SNlzB0ljZX0qKSLJC1e2qdIOkHSmLJvrhTOkko5svQZI2mb2vmAZyW9QWR69KYEc0r6fJnDGBqCHdt6/b9QpK0+Jmlo5VpGSDpD0ijgiEa2j1dDiurhakgNvby0LS/p+tL2oKRNSvvx5d6MKPf18PbMO0mSJGkfaUx0DUOBw2xvTgQjnlvZV0th3BU4udK+KXAkkfnwKWDb4uYfDuxle2PioX9I5ZipJa3yvHKeel4Bdi599iJSKWssAWwELEksodTOdyHwZWBz4L+aucbtFSqf4ySNA75S2XeO7S1s18avejYWK/oYv2tiu8ZPgE1tbwJ8v7SdAIwtbT9jzhLa/YD/JtJlfylp0foJSzpYUf9i1IfvTK/fnSRJkrSTNCY6mbr0ynHABYQBUeP6kqExCaimMD5s+8WS3jgO6EvEEEy2/VTpcwnw2cox15Z/R5f+9SwKXCjpUeAqwlBp7nz9yvmedqx/XdrMpY60PaD2R6Sf1hgs6aFy3h2Iuhk1WpMaChHPcZmkbwG15Y/tiJRQbN8JrCBp2bLvJtuzbE8ljKi50kNT6CtJkqRryADMzqel9MqmUhir7R/Suu+mdkxT/X9EBFj2L/N6t/5YSVOAZQjvwctlrBqnAM+2Yh4fUbwb5xLaHS9IOp6mU0MXAX4i6RziXiwLnK8oUvU3IkX2y8CxkjZu4dTtuX9JkiRJJ5D/w+1kbL8pabKkb9i+qsQLbGJ7fDuGexLoK2mdki66H3B3G45fDnixaHt8G+jVRL/rgHuJKpZHSlrb9rOEx2KZNs65ZjhMLV6aPWi6GuUawAO2vwAg6WzCEPg4cLjt9SXdS6SD9iFSQfcFTipxH1PL/aYcv0i1amj9dpUU+kqSJOk80pjoOEtJerGyfTpzplcuClwOtNmYsP2upAOIJZPewCPA+W0Y4lzgGkn7A7fQcuGqe4nKmjdJeoeIqbitPLiPB6aWthdo8Gx8kbjmFYFvlfNcSHgVliU8Dt9VVOOsZzFiSaLGa4QxcTKwjqSZRNrr2cA15Rx9JX0H+A/wU0lPEh6XVYBHJA0FVgZuA3YGnm/hmpMkSZIOkqmhCzllmWOg7amSzgAm2R5a9s2w3acYE38lYh9eIupAHE0U1noa+KztyZLeB261vWvxMky1fYKkHYDT65d+JA0gHvrPAncQuhtPK+pi3FgCOCmG1FLFC7Ei8CBRPvwThLLqNkVzpG91u7nrHjhwoEeNardaepIkyUKJMjU0aYa7JP2LqFb5lyb6NBWw+ZztyaVPtU7EdsCfFAqoxwAblJTYj9JkCUn154BPAgMJz8L+hCdnzVqaLOHd+LWk54B/EtkufyY8G88DlyvUSW8sc3ijY7cjSZIkaQtpTCQAg4m3/HFE+mVjtDfAcShRufJl4FjmTpPdhsj4WIfIHtmKyDr5Nw1psscTyxiLAgMIg2IxYlmltnQzlQginUrjabJJkiRJF5HGRAKEuBZR52J/Scu38rAngU+poVx31cAYSZS73gb4O7AC8HvmTJOdRGhw1NJkNyCMjjHAkhUvyFqEx2EysDph+FxD1JSoUYvJmEnjabJJkiRJF5EBmMlH2P63pL8APwROakX/mZJ+ANwiqeYhqFWDOp4oKtWb8BZ8zfaEuiGWB+4uGS9LETEYdwNbAPdJegx4D7gIOIjwXuxP6H7UM4vwXJhW/K5TmyNJkqTzSM/EQo7tvqXQU237MNsnlc99yr8jqjoctg+1Pbxs3mW7HxHzAGEQYPv1cswjwO9sT1BQVSG92/YmpbrnTNvHVM7xzRKAeT+R0fEZItvjV7Y/TWSd/L0WpFmOmUKDqmiSJEnSTaQxkXSUg0qlz4mER+AoSS+Wvx8TabLfkTS+9NmtPSex/S6xbHJVqaw5m7alySZJkiRdRKaGJgsNkg4GDgbotexKm69xyMVz7M9ljiRJkubJ1NBkoSe1OZIkSbqGNCaSJEmSJOkQaUwkSZIkSdIhMjV0IaNaPruR9hdsb19pGwf0rmZMNDLeokQa6deBt4gUzRNt/70NcxoC3Gb7pVZfSAdJoa8kSZLOIz0TSY1PABtKWhNA0kaEqNdaLRx3MvBV4rdkIsti09aeVFIv4DiipHaSJEnSA0ljooch6TxJoyRNLHoUtfYpkk6QNEbSoxUNjBUk3Vb6DyN0LhrDhPrmvmX7p1QUPSX1knSapMckTZB0mKSlgEMJTYx1bW9OlLge34q5niJpDPBNomT2JZLGSVqymWtZWtJFkh6WNFbSbqX9niIaVhv/3rp6FkmSJEkXksZEz+PYkpazCfA5SZtU9k21vRlwHg36FL8E7rW9IXAdzXsabiBqOcDcol+HAXsQRgfAm8Cg8vmYUvoa25Nt10pLrkWD8bJ3Za5rAVsDvZjTIzHN9syyf6uyvw/huQD4FeEtUZnH2ZL6AOsBhwBIWp8ooNVtSyZJkiQLO2lM9Dz2LG/0YwlJ8A0q+2r6FKNp0Kf4LCGgRXnIT2tm7D8Dy0raj3hgP1LZdwgwxvbGtjchDI+1icqVHzYx3h1lnNmlb01LQ8DltvvbPpEomf0924Mr+/9suz9wL2FYAOwHrEiUzV6c0PlYExgGfK3Eb5wAPGH71WauM0mSJOlE0pjoQUj6JOFx2LE80G8Clqh0qSl7tkXVs8okYqnjPOD2un0rEwYEALanEcqeS0patom5Hkeoe84uf5+odLm6hbnUvBuTgKXL52VpuMb3iWWYF4ALSttuhHLob1oYO0mSJOlEMpujZ7EsIbk9XdIqxFLEiBaOuYeIS/hfSV8APt5C/8uAHxEP5PUr7W8SSxWX2v6gKIuOJVQ6z5J0sO33JK1ELH8sSxgSnyGWKl4gPArQEKhZY3bpQ2V/jQ9pWCp5v1zvD2xb0qa2ZwAzJD1FQ3ntlgyVFPpKkiTpRNIz0YOwPZ54gD9BLEnc14rDTgA+K2ki8DXgny30Px/4qe2xde2XE96JCUVn4zu2nwX+QcQsTCoqn7cB/Qil0GllvtcT8Q9N8Srw+1oAZjP9/kZkikwo13NmZd/pwHLAzc0suyRJkiRdQLcaE5Is6dLKdm9Jr0q6sYXj+ki6QNKzkkZLGiHpM20895El+6BLkbS7pF+Uz8dLGiJpuKRBpW3XkokwXtIkSd+rHLdB0yMHtofYXs/2jra/VlPvrFP/nErEFmD7Ndu72N7Q9kG2P1FfY6LwTmk/mFhaAPgP4dmA8AisRINH4dny74GEgFfNezAduAV4HPgY4Vl4GRhZ2qvnqnEa4XWoBWBW9z9XOe6HwPOE52JlYKlyj48n4jt6ATc3efOSJEmSLqG7lzneBjaStGR5aOwM/KsVxw0DJhPph7PLenyLD94apZbBkUQg4jttnnXbOAb4ShPzWBQYCmxp+0VJi9MQKLk7kWI5qbFju5qK3PgvKm0jaFhGmQmMr0qRlz5vAgfVjyepL/B8YwWvaueqbJ8NnN3YfttXU5YtioGxVxl/GHANUSzrDeBhwsD5JjC8sWusE/pqrEuSJEnSDubFMsfNQG1xeh8q6YfFA3FxqS0wQdLXJa1NrLsf11j6oaTri7diYnlY1MaaIel3xSV/LLAacJekuyr7f1U8BA+WGAQkrSTpGkmPlL9tJS0i6ekSD0DZfqa2XTnnesCsylv1DOIhPJ3IWFiGMOBeK9cxy/aTkrYhDJBTi6t/7fJ3S7m2kZVaC8MlnV/qNzwlaY6Hez3FM3JtGetpSb8t7b3KWI+V+/2jyvh7lM+fl/REyR75WmXMRus9tAZJO5ZjHi1jLF7Oc1Wlz6Cat0rSLpIeUNScuEqRCgrwAeGx+IDwxMwi0lpXkPRfjZ07hb6SJEm6hnlhTFxOBPItQdRKeKiy7+fA9Er64Z1E+uO4ZtbBDyzFkgYCh0taobQvDTxUST98CRhcST9cGniwpB/eQ8Pb9ZnA721vQbz1DitGzKU0FHTaiXhLr08/3BYYU9uwfZrtK2wfYft+268TGRHPS/qLpH0lLWL7/tJ+tO0BJRZhKHBYubajgHMr5+lLpFl+CTi/3MvmGEC80W8M7KWocjkAWN32RrY3BubQ4y5jXgh8GdgcqD6gjwXutL0lMJgwgpamBcqYw4G9yjl7Eymn/wA+UxljL+BySSsSGSE7lfoZo4AfA9j+voPv2z65LN/cS9z/bVuaS5IkSdJ5dHs2h+0JxQW+D3Ovb+8E7F3pO01qqmDjRxwu6avl85rAusSb/4eEG7wp3iOWFSDqMuxcmcMGlfMuW96GLwL+CpxBxAnM8fAtrEoEEzaJ7e9K2ric56hy3iHVPuV82wBXVeaxeKXLlcXAeVrSc0TA47hmTnuH7ell7ElEiuZE4FOSzibSMG+rO6YfMNn20+W4SylLBMAuwFck1QpjLUEUmnq8uWsnskMm236qbF8C/ND2GZJuAb4s6WrCSDoG+ByxnHVfuQ+LAQ+0cI5XCC9Us6Q2R5IkSecxr1JDbyCC7gYBKzTflYlAf0m96r0TiqDGnYCtbb8jaQQNdRfebSGq/33btRTEal2GRYCtbL9b13+GpJcl7UB4BfZlbmYSGQXNYvtR4FFJfyJiQYbUdVkEeMP2gKaGaGG7nlmVzx8S4l3TFCWn/xv4PrAnYSS1BgFft/1kK/s3xeeBHSVNIJaANgZeJwyCZcp5bre9TxvGXIL4HpIkSZJuYl6lhl4EnFAeqlVuJyL2AZD08eLyHwWcoPJ6KqmvpC8RD+5pxZDoR0OlxMZ4i3hAtcRtROno2hwGVPYNI5Y7rmrCUHkcWKepgUtMyKBK0wAiO2GO+ZWgxsmSvlGOk+bUmvhGidtYm9C1aPNDvSwhLGL7GmIpYbO6Lk8Afcs5IDxJNW4FDqt8H60V9nqyjLmOpDWA7wG/Lkta/QnP0kHAkoR34UFgW0nrlPMsXeJSGruemjG4HvBYZTtJkiTpYuaJMWH7RdtnNbLrf4GPl6DA8cR6PMB3gVWAZxS1DIYTb6+3AL0lPU6oVz7YzGmHAreoBGA2w+HAQEUA6CTirb3GDURxpcaWOCBiLzatPWQbQcAxkp5UyHufQINX4nLg6BKcuDbh+fhOuQ8TieqONf5JZC/8Hfh+I16U1rA6MKLM41JC2OsjypgHAzeVAMxXKrtPIgpQ1eo9nNTEOdaX9GLtj4i/OAC4CriLSAc9q5zvTaIexa7EMsxlhHF5MHC3pHeI5auzK0bMCElnSBoFHCHpbiJe4hzgiHbckyRJkqQdqMHTn7SEpIFEcOb2zfQ5E/ib7X900RyGAzeWlMkeiyJd92bg04SGx7W2/1b2jQCOsj2qbC9fglcpS0NX2v5b6TfJ9g/KvseI5a2BLZ1/4MCBHjVqVOdfWJIkyQKMpNGN/T82K2C2Ekk/IQI6f9pC118DXV4cq6dTlok+TyiRPkVUwDy+ie6DJT0k6VFgByLDp8YVlc8iVFKTJEmSbiTXlVuJ7ZOJpZSW+r1MRRCrC+YxpKvG7m5KAOzDwMOSbieWj46v9inppOcCA22/UAyOairs25XPrxLVNpMkSZJuJI2JZJ4gaTXgv2zX6nIMoJFgVBoMh6klZXYPWiHk1RIp9JUkSdJ55DJHFyNpSsmcmG8pFSct6buVtgGl7agWjl1P0s2K6ppjJF2pUk20BRYFTlNU8XyBKFRVC5ocThTjGkektV4IPEZkkTzS5gtMkiRJupT0TCQ1HiNqTQwr2/sA45s7oCxB3AT8uBI8OYgQBGt2ucH285J2AdYgAkp3ruy7hjkLjh1X/urHGNTcdpIkSdI9pGdiHqBG9D9K+/EKvYoRkp6TdHhp7yvpcUkXKjRIblOR6i4ehAdLKut1kj5e2kdIOkWhn/GUpCYzUArPA0tIWqWkXn6eSD2tzXkdSf9QaJmMKemr3wQeqBkSEOJgth8rcx5Z+o5R6I/UvCAjJd1AiJqdDKyt0CQ5tewfIelqhS7IZZVU0M0l3a3QK7lV0qoKDZMxlXmuW92uu+8HKzRNRn34zvQ2fWdJkiRJ06QxMW+YS/+jsq8fUZVyS+CXCqVRiDLh/2d7Q0Il8+ul/Y/A/yuFnx5lzmyG3kU/40hal+VwNfANopT3GOasnHlZOX//sv/fwEZEKfLGeAXYuWhq7EWpJ1HYDDjC9nrAT4BniybJ0WX/pmXOGxBFubYt9+FsYI+iV3IR8KtS1Gy6GoqLHUATdUBS6CtJkqRryGWOeUNT+h8AN9meBcyS9ApRrAtC02Jc+TyaqCS5HPAx23eX9kuIglA1rq32b8W8riRSLfsRaq41b8IyhCjYdfBRQSvUvG7KosA55SH/IVGZssbDtic3c+zDtl8s5xhX5v4GYbzcXs7bizBoIIyxAyT9mDBctmzFtSZJkiSdRBoT84ZG9T/KQ3IuHY3yub59yVacp3bMR+NIuph486/xvdoH2/+R9D4hPnYExZhohomEGFdj/IiIm+hPXG/1Wt9u9Ii5512du4CJtrdupP81hOflTmC07ddaGD+FvpIkSTqRXOaYNzSn/9FqihLotEo8xH7A3c0cgu0DypJC7e+hui6/IJZNPqwc8xbwoqTdy3wXl7QU8GdgG4VOSu1aPitpI0I35d9F3XQ/wpPQGK3VTHkSWEnS1uU8i0rasMzvXSLT4zyaLnWeJEmSdBFpTHQPE9SgUXE6zet/tJVvA6cqlDcHACd2ZKK277d9fSO79iPk3icA9xM1ImYSWhqHldTQScAPiOJR5wLfVmiL9KMJb0TxItyn0GM5tZl5vUfUmDiljDmOOT0nlwGzmVtKPUmSJOliUpsj6TQkzbDdp+WeXXLuo4DlbP+8Nf1TmyNJkqTtqAltjoyZSHo8kq4D1iZ0O5IkSZJuJpc5ki6l1IG4pdSGGCmpX2kfLuksSfeXmhp7lPbm6kzsqJBof7TU41i8nGZT4DrgtrKv3zy52CRJkoWUNCaSrmYocFipDXEUEUtRY1VgOyLuoiqi1lidiSWIMtt72d6Y8KodUjlmaqlpcV45T5IkSdJNdKkxoTpdivLWeWMHx1xNUoeFnspYlnRpZbu3pFcl3ShpK4Xs9ThF9cnjS59B5Q35AknPljfuEZI+08ZzH1kyImrbq9buTTnHcElDKuc9Xi3oZLTx/CMkPamoaHmfpPUb6TNE0jmtaZc0grrfU6mdsQ1wVakXcQFhQNS4HjgYGAisIulEYHNKnYmSCTKOqDOxPlFr46ly7CXA78vnTwDXSlqJCBTt29L114S+qn9JkiRJ+5ivYyYk9bb9Qd32S0RUf2fwNrCRpCVLZsLOwL/KvkuAPW2Pl9SLeJgBDAJ2A24B1rU9W9Inibfo1l7HYsSb96XAO6X5x4SgVXeyr+1Rkg4GTgW+0tIBktrym1kEeMP2gMaGAmbZvqyMe67tXyi0PQZX+lVrbVRZkUiLXQN4r4w1VdKrhN5HkiRJ0k3MM2NC0pZEWeklgJnAAbaflDQE+BrQB+hViixVt79NCENtVOoMXAwsRjy4vm776VIJ8cByqmG2z5DUl9CauJd4W64ZDTcDXyJKSe9DVH7cHliZKNN8MfHmbEnnAj8EPk48DG+W9DFChGoxST8C3i/Hrgk8RzwM/ynp68AzxFv0s8BqwF2SptoeDPwP8GF5O+9FpF/OLOe9BtgKmC3pAeABou7CNsAxwBeIcts/tD1M0qpEJcv/Ih6sLwJT6+7xhsBZ5W3+bmCdco9uA9Yq8/4H8EJ5wJ8ETCPSPH8NfFHS6PL9nVn5XmeUuX26NE2T9A1C7fPxck29CV2OL0g6kvAk9JZ0X/m8jKQniVTPlYBty3e8nqQ3gSnl/t1OGHmzgV8r6lusRy7fJUmSdCvd8T/du8pSwTjm1KB4Atje9qZEoaRfV/ZtRmgwfK6J7RrfB84sb74DicJKmxP6DJ8hHsAHSapVfKzXt+gNXA7sXdbkNwFqRZx+X5sjcA5RovkK4gH7eCn4NJIwTrYq13E58FyJDxhKVH/c0/Y+RHnpJYAVi47GS8Bg24OLZ0PAfUX74mbgn7avIB6Wvye8FpcQxtFswqtxClFb4ijiwfqLYkh8kyjiNBD4GLF0UH+P+wA/BTYmdD6eIX4PSxCG0BbAjnXfSU1PA2BZwuj5gDAmBpZjlyYMgtfLvZxNVNMcX+7BI4RXZrUyzkzgjDLOP8t9e4DwPJxb7unKwC7AqPK9iTBMlrR9B2H4rELEXxxbrnkulEJfSZIkXUJ3eCYG254KH8lT19b9lwMukbQuYOJBU+N22683s13jAeDY4uq+tngltgOus/12Oee1hEFwA3PrW+xme0J5I9+HeIgDYPvE8kZ9FfFw3sf2IM2tR7EGcEV5iC9GeE/GEw83EQ/mf5Vr/GNZTqln1bK/Fk8ymlhygaLjQXgZPizX1IcQuhpFGARDgPMJXYotiAf2RcAKhLGxMnPf42nEg3smsUwwnDC+3ifKUn9YrqdGvZ7Gc0Atm+I9wttyMHAf8UA/mAieXBE4mjDIXiztLwG/BWYQ0ufY7iPp78DehGHRh/AC/azMYzihzbGO7ZcVwl81bY6rid/IbEkXlXsxF7aHlmtm8VXXzQIrSZIkncS8dAefBNxleyPgy8RbbY36aolNVU/8M7HOP5NYcmipzkC95oMkrQmsTrz5f414yNV4j1j22BHoL2kFQg1ztRJHAaFkeU7JMDiPcMtvTTzQ/lW5rg+Ih2djzIzL+aiCWDVOYBHiIX8+oTS6uu0Ztl8g4i36EV6Tj+TCbd8DfJbwzqxXrqn+HpuImRhAGB+vE/fyXcKjMpA5S2BXv4N+hBG1dfGkjKXht/QBYTDuSCzdVO9B/TgQxkuN7QjPy8aEIfECkemxDrGU1At4qHwP9dS+2yXKtSVJkiTdxLwMwFyOhriFIe0ZQNKniGWFsyStRSxT3AMMl3Qy4Rn4KhHh3yi2X5C0BfC1Ms4g4CiF3sTtxEPtAopXgHDF/wc4QdLPy3XMLv13Bd63/Y4ii2WtZqZf06SYCjxV5toYc+l4VLwrVxGluc8ClicMiKMlfYLwArxCxCZsRngJWuJNwkvyceK+NWVsLkkEPL6jqOmwFbEkRLmOt4HpxL1ZvbTfTxhZAPsCI5lTcAzCczKtxKF8i4iN+BEwxfZDkv5BeCfWJDwuIxuZ23rE0kqzpNBXkiRJ5zEvjYnfEsscxwHtzcvbE9hPoXT5H+DXtl+XNBx4uPQZZntsWcpolCJ3fVZd835ErMEKhLLmvwmFzL8RMRmHlH8/IB7qUwjvwKaSHiceqv9sZu5DgVskvVTiJmZLWsf2M3X9Dgf+j8giWRGYKemNsu+TRDzC7kQQ5jFF+fPbxNLCosSDdzJR1KklTi3jvAS8Vq6tMR4Fdi/X+STwIA1xCrMJT8UThJfjldJ+WGm7m/iuDiAMvypjgd+UvqsRxuHmwLOSHiWWOxYF/kjofxzQyNwG02D4JUmSJN1AanPMJ0j6KrC57ePacMxAYulj+xY7tzzWFOCF6lglaLZ3WYpq6rhFiSWrrxPellnAibb/3tQxjYwxBLitpP12CEn3ELEw05rrl9ocSZIkbUdNaHNkCt18gu3rCO9Gq5D0E+AaIgCzs1imxJAg6dMtdS6cRCyNbFQqUO5O6yTFKefpRSxzrdZC19aMtRJwekuGRJIkSdK5pDExH2F7WMu9Pup7su1P2L63E6dwJZERAg01N4B46Es6TSEVPkHSYYoKngcR5bJnlXm9bPvKcsx5JRVzoqQTKmNNkXSKpDHlPAOBy0oK8ZJl/wmSxqiitSFpaYUmx8MKjY7dSvs9JZbkVdvXS7pXUv9OvC9JkiRJM6QxkVS5hshogcj++Ftl38FE/YgBpU7GZUSWxT9tv9nEeMcWd9gmwOckbVLZ95rtzWxfSqS47ltqd9RSZxvT2jgWuNP2lkRsxKmSlgb+QAnilbQesITt8e26A0mSJEmbma/LaSfdzmtENsXeRFGodyr7dgLOr5UFL4GuLZWt3lNRqrs3sRSyATCh7LuihWOvLf+OpsHA2QX4iho0SpYgMmauAn4u6Wii8unwFsb+SJujM5mS2SFJkiykpDGR1HMFkT0ypBV9nwHWkrRsvXeiVPU8CtjC9rSSYdNcvYl6anUjqjU3RJRMf7K+s6TbCc2UPYkMkCRJkqSbyGWOpJ7riLTdW+vabwe+pyL0JWl52+8QSwxnKsTLkLRSqRy6LKXehKRViJTTpqjV3GiJW4HDVMqQVsqkQ5RqPwt4JAMwkyRJupc0JpI5sP2W7VNsv1e3axhRN2NCKRf+zdJ+HFHzYZKkx4iS4G+WmIVavYk/E2W2m2I4cH4tALOZficRdSYmSJpYtmvzHk0U3bq4dVeaJEmSdBZZZyJZIJC0GjAC6FeE0BrrczARSEqvZVfafI1DOtfuyJiJJEkWdLLORLLAIml/QqH02KYMCQihL9sDbQ/stdRy3TfBJEmSBZwMwEx6PLb/SJTYTpIkSeYBaUwkbaaU3h5YLy1ve9cOjLkacJbtPTpjji2RQl9JkiSdRy5zJJ2GpKYk1uv79a7ftv1SdxkSSZIkSeeSxkTSqUjaUtIDpdz1/ZLWL+1DJN0g6U7gjka2+5ZsECRtWEpmjyulu9ct7T8u5bwfk3Rkaesr6XFJF5ay3be1kBGSJEmSdDK5zJG0l7sk1aS++xApoJR/t7f9gaSdiBoUAP2IKpiftf2QpHuB/kSlzRUpdSjKksmlwL+IIldjgRclbQ4cStSk6A38UtL9hMR5P0LafBawZel3apddeZIkSTIH6ZlI2svgoqUxAPhupX054KriZfg9sD1wGHA8cBvwm0rfqcBWwK7A/6u0Lw98jKg/0Y+oaDkIWAH4hu0NgRcqx3wATCxaHnfRIFaWJEmSdAPpmUg6m5OAu2x/VdIGwGOEdsbywJKEAVHj6ZLKOUnSikAt5uI+4PvAl4BPAl8EegFv2H6q9BlPCIgBmAYtjxcIj0eSJEnSTaQxkXQ2yxFLFAD7AbNtD5A0hMgAObTS98PKZ1U+9wKes32WpAMItdK/Aj8ssucCtgOeqxxT0/KYTSs8bl0h9LWwk0W7kmThJZc5ks7mt8BvJI0ljIUPilYHAJJa4zVYFXhM0jjCo3EfYUy8D4wjClS9CtzQqTNPkiRJ2kV6JpI2Y7tv3fYIYISk2cSSBsBSwOvAp4HzCANhUSJgcjyhOHrjnMN4oxKA+WytZoWkc4C3bb8raQ/gNOJ3+xghiT5L0kuVcS4FBnTWtSZJkiQtk9ocyUJDV2tzLOzkMkeSLPikNkey0JPaHEmSJF1DGhNJkiRJknSINCaSeYakAyU9WqpcPiZpt9I+pGh1JEmSJD2ADMCcT1CUibwD2N32m63ofzPwzbL5TdvnlvZBtEJ0S9JwYE9gFdtvlbYzgCOAlWoiXk0cuz9wDFHf4QPgMtuntTTnyvGDiBTSY4HNbE+X1AdYqXQZQgRYvtTY8U2M2Rv4OPAn258veh8fNNU/hb6SJEk6j/RMzD98ERjfGkMCwPYXbb9BVIr8QTvP+QxQ8wYsAuxAQ42IRpH0BeBIYBfbGxMVLKeXfS0KfZWH/qDy9xalUJXtGbYnl4yNgcBlRZtjSUm/kPRI8V4MLYYXkkZIOkPSKMIIugpYU9LjZTtJkiTpBtIzMf+wLzAUQNLRwKxStOn3QH/bO0jaAfiO7X1rMuDAycDapSbD7cBNQB9JVwMbAaOBb7nxtJ3LidLTlxIP9/soGhllHvsDRxEeiAm29wN+Sng+XgKwPQu4sBzSW9IjwGKEobKf7XeKF+RdYFPCWNmGqEGxDPCSpDcJTY8VgP8Cnge+bXtUuRe7E7/Va4BPAX+W9FA552LArYSHhHLsFNu/a81NT5IkSTpOeibmH7YlHvwAIwlNCwiDoY+kRUvbPXXH/YSoyzDA9tGlbVPCe7AB8fDdtolzPgWsJOnjwD6EcQGEcidwHLCD7f40vOnXDJTG+MD2FqX/48B3JK0N7AzsDbwH/Aw4n1jCGA68DKwF7EQYQycQehynSPonkcr5K2AmYdjsDexY5ibgSmLJZXVCw2PDMlaSJEnSTaQxMf+wfC12gXhYby5pWaJM9AOEUbE9YWi0xMO2Xyy6F+OIctRNcS3xgP5M3dg7AFfVYidsv96K8y4iaaSkRwlPy4aEt+VBwhg5Cji30n9VosDUzcDbwNcIz8IiwO8IQ2FN4ArCi7EYYUydSxgmnwQ2Lp9fIO7bFYRxkiRJknQTaUzMP3xQ4haw/T4wmQhEvJ94yA8G1iHe+FtiVuXzhzS/nHUFIc51ezE+WmIi4QFojCWAQ0ssxQmENPk2xNyPBy4gDAiIapjjyjmnA8sShgTEsspMwvMwijA0hhBltFcpff5ABGx+mYi7qAl9PduKa0iSJEk6kYyZmH94kliSeKZsjyTe5A8EHgVOB0Y3EvvwFvHW3i5sPy/pWOAfdbvuBK6TdLrt1yQtX7wTvwFOlfQl2/+RtBiwv+1hxMP/32VJZl+idPYbREzDjbavBpD0P4Qxsbek/YCVCXGvIwhPhImlkN7A0sC9RLzEx2gowX0vEb+xAWF41AyolYF3WrruFPqa/8gKmknSc0nPxPzDTUQQZI2RxFv8A7ZfJgIY51risP0acF/JdDi1PSe2fYHtZ+vaJhKxCndLGk8YM9i+GTgH+IekicAYwqsA8UB/iAjkfIIQ5poMfAIi/bUIff2tXFsf4CBCsOu9yhxse33baxNxHZsQ3ovFgAttH0/EeDxEBI/WDhpEBHG+1p77kCRJkrSP1OaYT5C0KvBH2zvP67m0lyL0Va0NcTpwHXMKfV1u+8SS4VH1Vsyw3ae+TkYR+hple7ikHWkQ+nqEWG7ZgwjcHGh7qqQxwDu2t2turouvuq5X/fYZnXPhSaeQnokkmf9pSpsjlznmE2z/W9KFkpZtba2J+Q3bTXm6Pt9I3yF1233KvyOAEZX2Qyuf7wA2lbQBsdxxne2nKQGmklYCTrR9fWOTqBP6atU1JUmSJC2TxsR8hO0r5/UcegK2JxHxJfXtrwLXN3PcUEotj8VXXTddckmSJJ1ExkwkSZIkSdIh0jORLJSkNkeSJEnnkZ6JBABJUySNrGsbJ+mxFo5bVNLJkp6WNEbSA0W/oy3nTpXQJEmSHkwaE0mNTwAbSloTQNJGROnslqpJngx8lfgtGZhNlPNuFZJ6EaWxP9mOOSdJkiTzAWlMJDVM1LLYt2z/lCg6BcRDX9JppZ7FBEmHSVoKOJTIrFjX9ubAt4Dx5ZjzJI2SNFHSCZWxpkg6paRxfpMIprykohI6RdIJxdPxqKR+5bilJV0k6WFJYyXVFE/vkTSgMv69pZ5FkiRJ0g2kMZFUuQE4oHz+AvCXyr7DiJoOtSyIN2kosnVMrRS37cm2a6Ul1yKqYkJUu9yk0r41UfWy6pGYZntm2b9V2d+H8FxAFNHaqIxp4GxJfYD1gEMAJK1P6JhU610kSZIkXUgaE0mVPwPLlhLXIgpD1TgEGGN7Y9ubEIbH2sBM2x82Md4dZZzZpe+WpV1E8ar+tk8khLq+Z3twZf+fi/rovYRhAbAfsCJR/GpxohDWmsAw4GuljPcJwBMlTTRJkiTpBtKYSKpMIpY6ziOqSlZZmTAgALA9Dfg3sGRRN50DSZ8kPAqLEcbEbEpZ7cLVLcyl5t2YROhzQJTtrmlwvE8sw7xACIgB7AbsSuiHJEmSJN1EpoYm9VwG/Ih4IK9faX+TWKq41PYHkpYHxhIiW2dJOtj2e6UK5SDiwb8YIW3eh3joL1rGqgVq1phd+lDZX+NDGpZK3ieqY/7AtiVtansGMEPSU4Q4GLRsqKTQ10JCluhOku4hPRNJPecDP7U9tq79csI7MaEIf32nCHP9g4hZmFTSSG8D+gFTgWmEwXE9Ef/QFK8Cv68FYDbT729EpsiEIjJ2ZmXf6cBywM3NLLskSZIkXUAaE0mNd2xPtf2i7bNK23+Ae8rnkwgp9JpHoabweSAwkQbvwXTglvL3GOFZeJlQPL2leq7KuU8jvA61AMzq/ucqx/0QeJ7wXIhYAqnxCPF7/mXbLz1JkiTpCKkamvR4JO0P/JYwRj7dTL+q0NfmaxxycTfNMJlX5DJHknQuTamGpmciWRBYjQjMPKi5TraH2h5oe2CvpZbrnpklSZIsBKQxkfR4bJ9s+xO2753Xc0mSJFkYyWyOZKEkhb6SJEk6j/RMLEAouLOxug9N9L9Z0sfK3w8q7YMk3diK44dL2qMjc+5MJC1WSmunkZwkSdKNpDGxYPFFYLztN1vT2fYXbb8BfAz4QfO9539sv0dU3dxrXs8lSZJkYSKNiQWLfYG/Akg6WtLh5fPvJd1ZPu8g6bLyeYqkFQnlz7VLnYdTy1h9JF0t6QlJl0nS3KebmyIIdqqkR4og2PdK+yBJIxobsxlhr+UlXV/GebCm7SHp+CL4NULSc7XrLFxPg1hZkiRJ0g2kMbFgsS0wunweCWxfPg8kjINFS9s9dcf9BHjW9gDbR5e2TYEjgQ0IVc9tWzmH7wDTbW8BbAEcVEprtzTmVNubEaW8jyptJwBjixbIz4A/Vvr3A/6b0Pv4Zbk2iNoWW7RyrkmSJEknkMbEgsXytt8qn0cDm5f4iVnAA4RRsT1haLTEw6WA1WxgHNC3lXPYBdhf0jjgIWAFYN1WjHltZd619u2APwHYvhNYoRIPcpPtWaW41SvAKqXfh8B7kpZp5XyTJEmSDpKBagsWH0haxPZs2+9LmgwMAe4HJgCDgXWAx1sx1qzK5w9p/W9FwGG2b52jURrUwpizmmhvz/wWJwTLkiRJkm4gjYkFiyeJ5YNnyvZIYsngQKIU9unAaM9d9vQtoNVv8pJm2O5T2R4CDLR9KHArcIikO4tBsx7wr1YM21/Sbsy5lDGSiH84qRgjU22/2Vz4hqQVSr/3mztZCn0lrSEraCZJ60hjYsHiJkKxs2pMHAs8YPttSe/SyBKH7dck3VeEuv5Og/x3a7iA8EYsJmlzIg6iLzCmBFi+CuxePaCJ1M3xtu+QVC3TejxwkaQJwDvAt1sxn8FtnH+SJEnSQdKYWLAYRrzZDwOwfQcNst/YXq/a2Xbfyudv1o01orLv0MZOZnsIzOmZkPRlYEfgA+A1YF/b04tnYZqk+4B/El6UHSUdRMRzbCTpKNu7SvplibmAEPXaFpgB/FbSF0rb/5ZzDyIUSk+TtBGwFLBTczcpSZIk6VzSmFiAsP1vSRdKWra1tSbayZKVhz3A8sAN5fO9wFa2Lem7wDHA/5R9GwDb2Z4p6fi67UGV8Y4Cfmj7Pkl9iPiHrwEDgP7AisAjkmpZKZsCGxJekMcIqfSn6iddJ/TV3mtPkiRJ6khjYgHD9pXdcJqZtgfUNmqeibK5BnCFpFWBxYDJleNuKBLjTW3XuA84vdTDuNb2i5K2A/5SsjVelnQ3kQL6JiVLpMzlH8Qyy1w6HbaHAkMBFl913ZTLTZIk6SQyNTTpbM4GzrG9MfA9YInKvrfr+tZvAyHcBXwXWBK4r1bEqhnam3mSJEmSdAL5P92ks1mOhuyN1gRMzoWktW0/CjwqaQuiQNVI4HuSLiGWVT4LHF32tZkU+kqSJOk80phIOpvjgaskTQPuBD7ZfPdGOVLSYGA2MJHIMHkP2BoYTwRgHmP7P63wWiRJkiRdjOYuOZAkCz4DBw70qFGj5vU0kiRJehSSRtseWN+eMRNJkiRJknSINCaSJEmSJOkQaUwkSZIkSdIhMgAz6TTqNTvmZ1KbI0mShZGu0ptJz0SSJEmSJB0ijYmkS5G0tqRbJI2WNLKWyilpuKSzJN0v6TlJe5T2QZJGSLpa0hOSLiuCYUjaUdJYSY9KukjS4qV9iqQTJI0p+zJdNEmSpBtJYyLpaoYCh9nenNDcOLeyb1VgO2BX4ORK+6bAkYR2x6eAbSUtAQwH9irVNXsDh1SOmWp7M+C8cp4kSZKkm0hjIukyikjXNkQRq3GEXPmqlS7X255texKwSqX9Ydsv2p4NjCO0NtYHJtuuCXhdQlTBrHFt+Xd06d/YfA6WNErSqA/fmd6RS0uSJEkqZABm0pUsArxRFQWro6qpoSbaW6u1UTumyf4p9JUkSdI1pGci6TKKDPpkSd8AUNC/ncM9CfSVtE7Z3g+4uxOmmSRJknSQ9EwknclSkl6sbJ8O7AucJ+k4YFHgckJfo03YflfSAcSSSW/gEeD89k40hb6SJEk6j9TmSBZKUpsjSZKk7aQ2R5IkSZIkXUIaE0mSJEmSdIg0JpIkSZIk6RBpTCRJkiRJ0iEymyMBQJKBy2x/q2z3Bv4NPGR712aO6wP8DtgJeAN4C/h/th9qw7mPBIbafqfdF9BGUugrSZKFkRT6Srqat4GNJC1ZtncG/tWK44YBrwPrlpLZBwArtvakknoRpbOXatNskyRJkvmGNCaSKjcDNbN1H+AvtR2S+ki6uAhpTZD0dUlrA58Bjiulr7E92fZN5Zjri8DXREkHV8aaIel3ksYDxwKrAXdJuquy/1eSxkt6UNIqpX0lSddIeqT8bStpEUlPS1qp9FlE0jO17SRJkqTrSWMiqXI5sHcR1doEqC5V/ByYbntj25sAdwIbAuNsf9jEeAcWb8VA4HBJK5T2pYnlk/62TwReAgbbHlzZ/6Dt/sA9wEGl/Uzg97a3AL4ODCtGzKVEcSyI5Zbxtl+tn0xqcyRJknQNGTORfITtCZL6El6Jm+t27wTsXek7rSiDN8fhkr5aPq8JrAu8RuhnXNPMce8BN5bPo4kll9ocNqicd9kSs3ER8FfgDOBA4OLGBk1tjiRJkq4hjYmknhuA04BBwArNd2Ui0F9Sr3rvhKRBxMN/a9vvSBoBLFF2v9uMNwPgfTeUZq0Kdy0CbGX73br+MyS9LGkHYEsavBRJkiRJN5DLHEk9FwEn2H60rv124Ie1DUkft/0sMAo4QcVdIKmvpC8BywHTiiHRD9iqmXO+BSzTirndBhxWmcOAyr5hxHLHVS0YKkmSJEknk56JZA5svwic1ciu/wX+T9JjhLfgBOBa4LtEaugzkmYCU4GjgQnA9yU9Tih+PtjMaYcCt0h6qRI30RiHlzlMIH679wDfL/tuIJY3Gl3iqCeFvpIkSTqPFPpKFggkDSSCM7dvTf8U+kqSJGk7TQl9pWci6fFI+glwCBkrkSRJMk9Iz0SyUCLpLWL5ZUFiRWKZaUEir6lnkNfUc+jodX3C9lx1fNIzkSysPNmYq64nI2lUXtP8T15Tz2BBvCbouuvKbI4kSZIkSTpEGhNJkiRJknSINCaShZWh83oCXUBeU88gr6lnsCBeE3TRdWUAZpIkSZIkHSI9E0mSJEmSdIg0JpIkSZIk6RBpTCQLFZI+L+lJSc+UYlc9EkkXSXqllDevtS0v6XZJT5d/Pz4v59gWJK0p6S5JkyRNlHREae+x1wQgaQlJD0saX67rhNL+SUkPld/hFZIWm9dzbQuSekkaK+nGst2jrwdA0hRJj0oaJ2lUaevpv7+PSbpa0hOSHpe0dVddUxoTyUKDpF7A/wFfADYA9pG0wbydVbsZDny+ru0nwB221wXuKNs9hQ+A/7G9ASEK98Py3fTkawKYBexguz8wAPi8pK2AU4jy7+sA04DvzLsptosjgMcr2z39emoMtj2gUoehp//+zgRusd0P6E98Z11yTWlMJAsTWwLP2H7O9nvA5cBu83hO7cL2PcDrdc27AZeUz5cAu3fnnDqC7X/bHlM+v0X8T291evA1ATiYUTYXLX8GdgCuLu096rokrQF8iVDqpSgG99jraYEe+/uTtBzwWeAPALbfs/0GXXRNaUwkCxOrAy9Utl8sbQsKq9j+d/n8H2CVeTmZ9iKpL7Ap8BALwDWVJYFxwCvA7cCzwBu2Pyhdetrv8AzgGGB22V6Bnn09NQzcJmm0pINLW0/+/X0SeBW4uCxJDZO0NF10TWlMJMkCiCPnu8flfUvqA1wDHGn7zeq+nnpNtj+0PQBYg/CO9Zu3M2o/knYFXrE9el7PpQvYzvZmxDLoDyV9trqzB/7+egObAefZ3hR4m7oljc68pjQmkoWJfwFrVrbXKG0LCi9LWhWg/PvKPJ5Pm5C0KGFIXGb72tLco6+pSnEx3wVsDXxMUk0bqSf9DrcFviJpCrFMuAOxLt9Tr+cjbP+r/PsKcB1h+PXk39+LwIu2HyrbVxPGRZdcUxoTycLEI8C6JfJ8MWBv4IZ5PKfO5Abg2+Xzt4G/zsO5tImy7v4H4HHbp1d29dhrApC0kqSPlc9LAjsT8SB3AXuUbj3mumz/1PYatvsS//3caXtfeuj11JC0tKRlap+BXYDH6MG/P9v/AV6QtH5p2hGYRBddU1bATBYqJH2RWPPtBVxk+1fzdkbtQ9JfgEGEnPDLwC+B64ErgbWA54E9bdcHac6XSNoOGAk8SsNa/M+IuIkeeU0AkjYhgtx6ES9vV9o+UdKniDf75YGxwLdsz5p3M207kgYBR9netadfT5n/dWWzN/Bn27+StAI9+/c3gAiUXQx4DjiA8jukk68pjYkkSZIkSTpELnMkSZIkSdIh0phIkiRJkqRDpDGRJEmSJEmHSGMiSZIkSZIOkcZEkiRJkiQdIo2JJEmSJEk6RBoTSZIkSZJ0iP8PpxBisbGt+e8AAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Visualisation sommaire / moche :\n",
    "\n",
    "corpus['Songwriter(s)'].value_counts().plot(kind='barh')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---\n",
    "\n",
    "**Plusieurs remarques à faire ici** :\n",
    "\n",
    "    - On remarque évidemment l'absence d'homogénéisation des différentes observations \n",
    "    (==> nettoyage nécessaire des données).\n",
    "    - Également les retours chariot qui peuvent poser pb.\n",
    "\n",
    "**À modifier** :\n",
    "\n",
    "    - McCartney\\n (with Lennon)\n",
    "    - Lennon\\n McCartney\n",
    "    - Lennon\\n (with McCartney)\n",
    "    - McCartney (with Lennon)\n",
    "    - Lennon\\n and McCartney\n",
    "\n",
    "==> 'Lennon-McCartney'\n",
    "\n",
    "---"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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>Song</th>\n",
       "      <th>Album Debut</th>\n",
       "      <th>Songwriter(s)</th>\n",
       "      <th>Lead Vocal(s)</th>\n",
       "      <th>Year</th>\n",
       "      <th>Lyrics</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>\"12-Bar Original\"</td>\n",
       "      <td>Anthology 2</td>\n",
       "      <td>John Lennon Paul McCartney George Harrison Rin...</td>\n",
       "      <td>Instrumental</td>\n",
       "      <td>1965</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>\"Across the Universe\"</td>\n",
       "      <td>Let It Be</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1968</td>\n",
       "      <td>Words are flowing out like endless rain into a...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>\"All I've Got to Do\"</td>\n",
       "      <td>UK: With the Beatles\\n US: Meet the Beatles!</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1963</td>\n",
       "      <td>Whenever I want you around yeh \\nAll I gotta d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>\"All My Loving\"</td>\n",
       "      <td>UK: With the Beatles\\n US: Meet the Beatles!</td>\n",
       "      <td>McCartney</td>\n",
       "      <td>McCartney</td>\n",
       "      <td>1963</td>\n",
       "      <td>Close your eyes and I'll kiss you\\nTomorrow I'...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>\"All Things Must Pass\"</td>\n",
       "      <td>Anthology 3</td>\n",
       "      <td>Harrison</td>\n",
       "      <td>Harrison</td>\n",
       "      <td>1969</td>\n",
       "      <td>Sunrise doesn't last all morning, \\nA cloudbur...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>\"All Together Now\"</td>\n",
       "      <td>Yellow Submarine</td>\n",
       "      <td>Lennon-McCartney</td>\n",
       "      <td>McCartney</td>\n",
       "      <td>1967</td>\n",
       "      <td>One two three four\\nCan I have a little more\\n...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>\"All You Need Is Love\"</td>\n",
       "      <td>Magical Mystery Tour</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1967</td>\n",
       "      <td>Love, love, love\\nLove, love, love\\nLove, love...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>\"And I Love Her\"</td>\n",
       "      <td>UK: A Hard Day's Night\\n US: Something New</td>\n",
       "      <td>Lennon-McCartney</td>\n",
       "      <td>McCartney</td>\n",
       "      <td>1964</td>\n",
       "      <td>I give her all my love\\nThat's all I do\\nAnd i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>\"And Your Bird Can Sing\"</td>\n",
       "      <td>UK: Revolver\\n US: Yesterday and Today</td>\n",
       "      <td>Lennon-McCartney</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1966</td>\n",
       "      <td>You tell me that you've got everything you wan...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>\"Another Girl\"</td>\n",
       "      <td>Help!</td>\n",
       "      <td>McCartney</td>\n",
       "      <td>McCartney</td>\n",
       "      <td>1965</td>\n",
       "      <td>For I have got another girl, another girl\\nYou...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>\"Any Time at All\"</td>\n",
       "      <td>UK: A Hard Day's Night\\n US: Something New</td>\n",
       "      <td>Lennon-McCartney</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1964</td>\n",
       "      <td>Any time at all, any time at all, any time at ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>\"Ask Me Why\"</td>\n",
       "      <td>UK: Please Please Me\\n US: The Early Beatles</td>\n",
       "      <td>Lennon-McCartney</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1963</td>\n",
       "      <td>I love you, 'cause you tell me things I want t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>\"Baby, You're a Rich Man\"</td>\n",
       "      <td>Magical Mystery Tour</td>\n",
       "      <td>Lennon-McCartney</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1967</td>\n",
       "      <td>How does it feel to be\\nOne of the beautiful p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>\"Baby's in Black\"</td>\n",
       "      <td>UK: Beatles for Sale\\n US: Beatles '65</td>\n",
       "      <td>Lennon-McCartney</td>\n",
       "      <td>Lennon\\n McCartney</td>\n",
       "      <td>1964</td>\n",
       "      <td>Oh dear, what can I do?\\nBaby's in black and I...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>\"Back in the U.S.S.R.</td>\n",
       "      <td>The Beatles</td>\n",
       "      <td>McCartney</td>\n",
       "      <td>McCartney</td>\n",
       "      <td>1968</td>\n",
       "      <td>Flew in from Miami Beach BOAC\\nDidn't get to b...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Song                                   Album Debut  \\\n",
       "0           \"12-Bar Original\"                                   Anthology 2   \n",
       "1       \"Across the Universe\"                                     Let It Be   \n",
       "2        \"All I've Got to Do\"  UK: With the Beatles\\n US: Meet the Beatles!   \n",
       "3             \"All My Loving\"  UK: With the Beatles\\n US: Meet the Beatles!   \n",
       "4      \"All Things Must Pass\"                                   Anthology 3   \n",
       "5          \"All Together Now\"                              Yellow Submarine   \n",
       "6      \"All You Need Is Love\"                          Magical Mystery Tour   \n",
       "7            \"And I Love Her\"    UK: A Hard Day's Night\\n US: Something New   \n",
       "8    \"And Your Bird Can Sing\"        UK: Revolver\\n US: Yesterday and Today   \n",
       "9              \"Another Girl\"                                         Help!   \n",
       "10          \"Any Time at All\"    UK: A Hard Day's Night\\n US: Something New   \n",
       "11               \"Ask Me Why\"  UK: Please Please Me\\n US: The Early Beatles   \n",
       "12  \"Baby, You're a Rich Man\"                          Magical Mystery Tour   \n",
       "13          \"Baby's in Black\"        UK: Beatles for Sale\\n US: Beatles '65   \n",
       "14      \"Back in the U.S.S.R.                                   The Beatles   \n",
       "\n",
       "                                        Songwriter(s)       Lead Vocal(s)  \\\n",
       "0   John Lennon Paul McCartney George Harrison Rin...        Instrumental   \n",
       "1                                              Lennon              Lennon   \n",
       "2                                              Lennon              Lennon   \n",
       "3                                           McCartney           McCartney   \n",
       "4                                            Harrison            Harrison   \n",
       "5                                    Lennon-McCartney           McCartney   \n",
       "6                                              Lennon              Lennon   \n",
       "7                                    Lennon-McCartney           McCartney   \n",
       "8                                    Lennon-McCartney              Lennon   \n",
       "9                                           McCartney           McCartney   \n",
       "10                                   Lennon-McCartney              Lennon   \n",
       "11                                   Lennon-McCartney              Lennon   \n",
       "12                                   Lennon-McCartney              Lennon   \n",
       "13                                   Lennon-McCartney  Lennon\\n McCartney   \n",
       "14                                          McCartney           McCartney   \n",
       "\n",
       "    Year                                             Lyrics  \n",
       "0   1965                                                NaN  \n",
       "1   1968  Words are flowing out like endless rain into a...  \n",
       "2   1963  Whenever I want you around yeh \\nAll I gotta d...  \n",
       "3   1963  Close your eyes and I'll kiss you\\nTomorrow I'...  \n",
       "4   1969  Sunrise doesn't last all morning, \\nA cloudbur...  \n",
       "5   1967  One two three four\\nCan I have a little more\\n...  \n",
       "6   1967  Love, love, love\\nLove, love, love\\nLove, love...  \n",
       "7   1964  I give her all my love\\nThat's all I do\\nAnd i...  \n",
       "8   1966  You tell me that you've got everything you wan...  \n",
       "9   1965  For I have got another girl, another girl\\nYou...  \n",
       "10  1964  Any time at all, any time at all, any time at ...  \n",
       "11  1963  I love you, 'cause you tell me things I want t...  \n",
       "12  1967  How does it feel to be\\nOne of the beautiful p...  \n",
       "13  1964  Oh dear, what can I do?\\nBaby's in black and I...  \n",
       "14  1968  Flew in from Miami Beach BOAC\\nDidn't get to b...  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## Regex de nettoyage :\n",
    "\n",
    "corpus_clean = corpus\n",
    "\n",
    "## Sélection de la colonne, retrait retour chariot et homogénéisation des obs\n",
    "\n",
    "corpus_clean['Songwriter(s)'] = corpus_clean['Songwriter(s)'].replace('\\n','', \n",
    "                                                                      regex=True) # retour chariot\n",
    "\n",
    "corpus_clean['Songwriter(s)'] = corpus_clean['Songwriter(s)'].replace('McCartney (with Lennon)',\n",
    "                                                                      'Lennon-McCartney', regex=False) # Regex = False parenthèse\n",
    "\n",
    "corpus_clean['Songwriter(s)'] = corpus_clean['Songwriter(s)'].replace('Lennon McCartney',\n",
    "                                                                      'Lennon-McCartney', regex=False)\n",
    "\n",
    "corpus_clean['Songwriter(s)'] = corpus_clean['Songwriter(s)'].replace('Lennon (with McCartney)',\n",
    "                                                                      'Lennon-McCartney', regex=False)\n",
    "\n",
    "corpus_clean['Songwriter(s)'] = corpus_clean['Songwriter(s)'].replace('McCartney (with Lennon)',\n",
    "                                                                      'Lennon-McCartney', regex=False)\n",
    "\n",
    "corpus_clean['Songwriter(s)'] = corpus_clean['Songwriter(s)'].replace('Lennon and McCartney',\n",
    "                                                                      'Lennon-McCartney', regex=False)\n",
    "\n",
    "# Aperçu du résultat :\n",
    "\n",
    "corpus_clean[0:15]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "McCartney                                                                           60\n",
       "Lennon                                                                              60\n",
       "Lennon-McCartney                                                                    60\n",
       "Harrison                                                                            26\n",
       "Lennon McCartney Harrison Starr                                                      4\n",
       "John Lennon Paul McCartney George Harrison Ringo Starr                               1\n",
       "Lennon and Harrison                                                                  1\n",
       "McCartney and Harrison                                                               1\n",
       "McCartney (\"Step Inside Love”) Lennon–McCartney Harrison–Starr (\"Los Paranoias”)     1\n",
       "Starr                                                                                1\n",
       "Lennon McCartney Starkey[d]                                                          1\n",
       "Lennon, McCartney, Harrison, Starr                                                   1\n",
       "McCartney Starr                                                                      1\n",
       "Name: Songwriter(s), dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# On compte à nouveau :\n",
    "\n",
    "corpus_clean['Songwriter(s)'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:>"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAwYAAAD4CAYAAABWtvEgAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAABG2UlEQVR4nO3debxd873/8dc7A0EIxXVDtaeI5mdKxDEPjamX0quK4qpWVHP115p6tc0tVfGr3rSqFKVCiVaKGqu4QRGN2cl4kpgl2tCaSoiI4eTz++P73bKys/c++0w5Pcn7+XicR/b6rrW+3893rbV31ndYeysiMDMzMzOzlVuv7g7AzMzMzMy6nxsGZmZmZmbmhoGZmZmZmblhYGZmZmZmuGFgZmZmZmZAn+4OwMzMrD3WW2+9aGho6O4wzMx6lMmTJ78WEetXWueGgZmZ9UgNDQ00NTV1dxhmZj2KpBeqrfNUIjMzMzMzc8PAzMzMzMzcMDAzMzMzM/yMgZmZ9VDNL86nYdTty6TPHXNAN0RjZtbzecTAzKwLSQpJVxeW+0h6VdJtrezXX9Klkp6TNFnSREk7trHskyWt3t7Y6yxjA0m3SZouabakO3J6g6T/6Mqyzcysc7lhYGbWtd4BtpK0Wl7eF3ixjv0uB/4BDIqI7YARwHr1FiqpN3Ay0KUNA+As4O6IGBIRWwCjcnoD0KaGgaQ+tZbNzKxruWFgZtb17gBK81uOBK4prcgjA1dKapY0Q9IhkjYFdgROj4jFABExJyJuz/vckkcRZkkaWchrgaRzJU0HTgM2BO6TdF9h/dm5d/8RSRvk9PUl3Sjp8fy3q6Rekp6RtH7eppekZ0vLBQOBeaWFiJiRX44Bdpc0TdIpeQRhkqQp+W+XnO/wnH4rMLt8ueOH3szM6uWGgZlZ17sWOEJSP2Ab4NHCuh8A8yNi64jYBrgX2BKYFhEtVfI7No8iNAInSlo3p68BPJp7788CXgL2jIg9C+sfiYghwJ+Br+f0XwDnRcT2wCHA5blBcjVwVN5mH2B6RLxaFssvgV9Luk/SaZI2zOmjgEkRMTQizgNeAfaNiGHA4cAFhTyGASdFxOZVlj8iaaSkJklNLQvnVzk8ZmbWHh6mNTPrYhExQ1IDabTgjrLV+wBHFLZ9Q1JrWZ4o6eD8emNgEPA60ALcWGO/94HSsw2TSdOaSjFsUSh3LUn9gSuAPwDnA8cCV1ao252SNgH2A/YHpkraqkLZfYGLJA3NcRZv+h+LiDk1lovljQXGAqw6cFDUqKuZmbWRGwZmZsvHrcDPgOHAurU3ZRYwRFLv8lEDScNJN/I7R8RCSROBfnn1ohqjDAAfRETpZrqFJf8H9AJ2iohFZdsvkPSypL2AHVgyerCUiPgH8Dvgd/mh6j1IDZWiU4CXgSG5vGJZ75RtW75sZmbLgacSmZktH1cAoyOiuSz9buCbpQVJ60TEc0ATMFq5Gz/P0T8AGAC8kRsFg4GdapT5NrBmHbHdBZxQiGFoYd3lpClF11dqdEjaq/TNR5LWBDYF/lKh7AHA3/IUpaOB3nXEZWZmy5FHDMzMloOImMfS8+pLfgT8UtJMUi/+aOAm4DjgXOBZSe8CrwHfAWYAx0t6AngKeKRGsWOBCZJeKjxnUMmJOYYZpP8X/gwcn9fdSppCtMw0omw70hShD0mdTZdHxOOS+gIt+UHoccDFwI2SvgJMoBNGBbbeaABN/s0CM7NOoyWjymZmZkuT1Eh6MHn37o6lXGNjYzQ1NXV3GGZmPYqkyRHRWGmdRwzMzKwiSaOAb1Dl2QIzM1ux+BkDMzOrKCLGRMQnI+KB7o7FzMy6nhsGZmZmZmbmhoGZmZmZmblhYGZmZmZmuGFgZmZmZmb4W4nMzKyHan5xPg2jbl8mfa5/28DMrF08YmC2kpC0oLtjqEf+hd+Q9KNC2nqSPpB0USv7/qukayU9J2mypDskbd7G8r/f3tjbQ9Ix5fWSNDH/fkBH8j1L0j4di67uso6V1CxphqSZkg7K6cdI2nB5xGBmZh3nhoGZ/TOaAxS7fQ8DZtXaQZKAm4GJEbFpRGwH/DewQT0FKukFLNeGQWeQ1Lt8OSLOiIg/LYeyPw6cBuwWEdsAO5F+nRngGKBNDQNJfWotm5lZ13HDwGwlJmlTSRNy7/okSYNz+jhJF0h6SNLzkg7N6cNzb/YNkp6UND7fkCNpb0lTc8/xFZJWzelzJY2WNCWvG1xHaAuBJwq95ocDvy/EvYGkmyVNz3+7AHsCH0TEr0rbRcT0iJgkqb+kewoxlHq0GyQ9Jek3wEzg18BqkqblujVIekLSZZJmSbpL0mrVjp2kNSXNkdQ3b7NWcbmd5+gSSU25/NGF9LmSfiJpCnBYheVxhfM2RtLs3KP/s0Ld781p90j6RE6veO5r+BfgbWBBPuYLImJO3q8RGJ+P52qSzpD0eB5VGFu4diZKOl9SE3BS+XJ7j52ZmbWNGwZmK7exwAm5d/1U4OLCuoHAbsCBwJhC+rbAycAWwCbArpL6AeOAwyNia9LzS98o7PNaRAwDLsnl1ONa4AhJGwMtwEuFdRcA90fEEGAYaTRhK2BylbwWAQfnGPYEzi3dlAKDgIsjYsuIGAG8GxFDI+KowvpfRsSWwJvAITl9mWMXEW8DE1ky2nEEcFNEfNBKXQ/PN8/TJE0j3VCXnJZ/un4b4DOStimsez0ihkXEtVWWkbQucDCwZe7RL03RuhC4KqeNJx3TkmrnvpLpwMvAHElXSvo8QETcADQBR+Xj+S5wUURsHxFbAavl/EtWiYjGiDi3ynKpPiNzQ6mpZeH8VkIzM7O2cMPAbCUlqT+wC3B9vhm9lHRDWHJLRCyOiNksPR3nsYiYFxGLgWlAA/BpYE5EPJ23uQrYo7DPTfnfyXn7ekwA9iXdXF9Xtm4vUiODiGiJiNbuEAX8WNIM4E/ARoU6vRARj9TYd05ETCvG38qxuxwYkV+PAK5sJTaA6/LN89CIGEq6oS75Uh4FmApsSWqQfbRfeT4V8p5Pahj9WtIXSaMxADsDv8uvf0tqCJRUO/fLiIgWYD/gUOBp4DxJZ1bZfE9Jj0pqJp3DLdtYFyJibG4wNPZefUCt0MzMrI08d9Ns5dULeDPfiFbyXuG1qqS3UN/nSGmfercnIt6XNBn4L9LN8L+3ssss0s1pJUcB6wPbRcQHkuYC/fK6d1rJt7y+q1Hj2EXEg3maznCgd0TMbCX/qiR9ijQasX1EvCFpXCHuSrEvU5eI+FDSDsDepOPzLdJNeS3Vzn1FERHAY8Bjku4mNYbOLKtLP9KIVGNE/DU3HtpUFzMz61oeMTBbSUXEW6TpH4fBRw/fDmlndk+RetI3y8tHA/fX2kHSDnlufy3nAt+LiH+Upd9DnqokqbekAcC9wKqSRhbK2EbS7sAA4JXcKNgT+GSNMj9o7ZmAOo7db0i98R+NFkj6lqRvtVLfcmuRbpDnS9oA2L+N+5dGhgZExB3AKUApzodIozGQGk6T6sjryQppG0oaVkgaCryQX78NrJlflxoBr+WYWnt2wczMljM3DMxWHqtLmlf4+zbphvBrkqaTetwPak/GEbGING3m+jxNZDHwq9p78Qng3VbynRURV1VYdRJpWkozaXrPFrnX+mBgH6WvK50F/A/wd9Ic+sa8/VeAZW5wC8YCMySNbyX+WsduPLAOcE0hbTDweit5LiUippOmED1Jamg82Jb9szWB2/I0qgeAb+f0E4AROf1oWnnIV9J6VB496Av8TOlh9GmkB8VLeY0DfpXT3wMuIz3kfSfweDvqYmZmXUjp/1Izs+VL0jnAbyNiRqsb9zD5G3kOioijC2m3AV+MiPe7L7L2k3QgsElEXNDqxstJY2NjNDU1tb6hmZl9RNLk/KUWy/AzBmbWLSLiO90dQ1eQdCFpys/niukRcWDlPXqGiLitu2MwM7Ou5YaBmVkniogTujsGMzOz9vAzBmZmZmZm5oaBmZmZmZm5YWBmZmZmZrhhYGZmZmZmuGFgZmZmZmb4W4nMzKyHan5xPg2jbl8mfe6YA7ohGjOzns8jBmbW6SQt6O4YqpE0XFJIOq6QNjSnndrKvptLukPSM5KmSPq9pA3aUPbakv5vR+Kvs5ydJD0qaZqkJySdmdOHS9qlHfkdI+miToirJce0Ya0yJJ0i6S+dUaaZmdXPDQMzWxnNBL5UWD4SmF5rB0n9gNuBSyJiUEQMAy4G1q+nQEl9gLWBLm8YAFcBIyNiKLAV8PucPhxoU8Mgx91Z3o2IoRHxUq2NIuI84IxOLNfMzOrghoGZLReSNpU0QdJkSZMkDc7p4yRdIOkhSc9LOjSnD5c0UdINkp6UNF6S8rq9JU2V1CzpCkmr5vS5kkbn3vzmUhkVvAD0k7RBznM/4H8LsW4m6U+Spue8NgX+A3g4Iv5Y2i4iJkbETEkNuU5T8t8uhTpMknQrMBsYA2yae83PaaWO20m6Px+vOyUNzMdwSiHOQcXlgn8B/pZjbImI2ZIagOOBU3L5u0v6fB5ZmJrru0HO90xJv5X0IPDbsvN4gKSHJa0n6bP59RRJ10vqL2kvSbcUtt9X0s1VrokRkp6W9Biwa5VzZWZmy4kbBma2vIwFToiI7YBTSb3tJQOB3YADSTfPJdsCJwNbAJsAu+ae+3HA4RGxNelZqW8U9nkt9+Zfksup5gbgMFIP+hTgvcK68cAvI2JIXv83Us/75Cp5vQLsm8s9HLigsG4YcFJEbA6MAp7LvebfqVHHvsCFwKH5eF0BnB0RzwHzJQ3N+44ArqwQz3nAU5JulvSfkvpFxFzgV8B5ufxJwAPAThGxLXAt8N1CHlsA+0TEkaUESQfnOnwuJ52etxkGNAHfBu4DBksqjaSMyPEvRdJAYDSpQbBbLq9VkkZKapLU1LJwfj27mJlZnfzwsZl1OUn9STfY1+cOcYBVC5vcEhGLgdlaes7+YxExL+cxDWgA3gbmRMTTeZurgG8C5+flm/K/k4Ev1gjr98B1wGDgmhwfktYENoqImwEiYlFOr1XFvsBF+Ya9Bdi8rA5zauxbqY5vkhoid+dye5NHAIDLgRGSvk1qhOxQnmFEnCVpPPBZ0kjHkaRpROU+DlyXb9JXAYpx3hoR7xaW9wIagc9GxFuSDiTdzD+YY1yFNKISkn4LfFnSlcDOwFcqlL0jMDEiXs11v46lj1tFETGW1Mhk1YGDorXtzcysfm4YmNny0At4M895r6TYW68q6S3U95lV2qfm9hHxd0kfAPsCJ9H63PtZwGeqrDsFeBkYQqrrosK6d+qMtxizgFkRsXOF7W8EfgjcC0yOiNcrZZpHFy6RdBnwqqR1K2x2IfDziLhV0nDgzBpxP0ca0dicNDog4O7iiELBlcAfScfh+oj4sFKMZmb2z8VTicysy0XEW8AcSYcBKBnSzuyeAhokbZaXjwbub2deZwDfi4iWQqxvA/MkfSHHuqqk1YHfAbtI+ui7MCXtIWkrYADwtzzqcTSph7+St4E164jrKWB9STvncvpK2jLHtwi4kzRVqtI0otJzAKUG1iBSg+PNCuUPAF7Mr7/aSkwvAIcAv8mxPEKa9rRZLnMNSZvnGF8CXiJNNaoYI/Ao8BlJ6+apU4e1Ur6ZmXUxjxiYWVdYXdK8wvLPgaNIPdink6beXEsr3wRUSUQskjSCNC2pD/A4ae58m0XEQ1VWHQ1cKuks4APgsIh4Pk+fOV/S+Tl9Bmm04WLgRklfASZQZZQgIl6X9KCkmaSHnZf9Ev603ftKD2FfIGkA6bP6fNKoBaRnIA4G7qoR/3mSFgIfAkdFRIukPwI3SDoIOIE0QnC9pDdIIxCfqpJfKa4nJR0FXA98HjgGuEb54W9SQ6A0xWs8sH5EPFElr78pfY3qw6RGy7RaZVey9UYDaPJvFpiZdRpFeIqmmVlPovR7CwMi4gfdHUs1Sr9BMDUifl1IWxAR/evc/xigMSK+VW2bxsbGaGpq6nCsZmYrE0mTI6Kx0jpPJTIz60HyV39+BfhFd8dSjaTJwDbA1WWr3lKVHzgr2/8U4L+Bt7ooRDMzq8BTiczMepCIOLi7Y2hN/orVSuk1GwSF7c4jfeWqmZktRx4xMDMzMzMzNwzMzMzMzMwNAzMzMzMzww0DMzMzMzPDDQMzMzMzM8PfSmRmZj1U84vzaRi17G/EzfWPnpmZtYtHDMzMrMMknSZplqQZ+bcKdpR0sqTVuzs2MzOrj0cMzMysQyTtDBwIDIuI9yStB6wCXEf6kbOFbcird0S0VFs2M7Ou4xEDMzPrqIHAaxHxHkBEvAYcCmwI3CfpPgBJl0hqyiMLo0s7S5or6SeSpgCHlS8v/+qYma2c3DAwM7OOugvYWNLTki6W9JmIuAB4CdgzIvbM250WEY3ANsBnJG1TyOP1iBgWEddWWQZA0sjcuGhqWTi/q+tlZrZSccPAzMw6JCIWANsBI4FXgeskHVNh0y/lUYCpwJbAFoV115VtW75cKmtsRDRGRGPv1Qd0OHYzM1vCzxiYmVmH5ecAJgITJTUDXy2ul/Qp4FRg+4h4Q9I4oF9hk3fKsixfNjOzLuYRAzMz6xBJn5Y0qJA0FHgBeBtYM6etRbrZny9pA2D/5RqkmZm1yiMGZmbWUf2BCyWtDXwIPEuaVnQkMEHSSxGxp6SpwJPAX4EHO1ro1hsNoMm/WWBm1mkUEd0dg5mZWZs1NjZGU1NTd4dhZtajSJqcvwhiGZ5KZGZmZmZmbhiYmZmZmZkbBmZmZmZmhhsGZmZmZmaGGwZmZmZmZoYbBmZmZmZmhn/HwMzMeqjmF+fTMOr2ZdLn+rcNzMzapdURA0kh6erCch9Jr0q6rZX9+ku6VNJzkiZLmihpx7YEJ+lkSau3ZZ/2kPQFSWfk12dKOkbSOEnDc9qBkqZKmi5ptqT/LOy3RSfF0CBpZjv3PUvSPhXSh7d2njorhjrzP7P4l9N+JmmvKtuPk3RoV8XTWVb090h+P1xUljZRUsXvQG5DvhWv284kqZekCyTNlNQs6XFJn8rrvt9FZZ4vaY/8emJ+X80trF/QiWUNlzRf0jRJT0j6YWfl3Y5YHmrnfm36XDAzs65Tz1Sid4CtJK2Wl/cFXqxjv8uBfwCDImI7YASwXr2BSeoNnAx0ecMA+C5wcZU4+gJjgc9HxBBgW2BiXv0FoFMaBh0REWdExJ+6O446fBx4tPAvwIXAqG6LqHOsDO+RDsmxLrW8nK7bw4ENgW0iYmvgYODNvK7NDYNK9ShbXhfYKSL+3K5o22dSRAwFGoEvSxpWz06SOnXEOCJ2aeeuK+rngplZj1PvMwZ3AKWx2SOBa0orcq/nlbk3boakQyRtCuwInB4RiwEiYk5E3J73uSX3kM6SNLKQ1wJJ50qaDpxG+g/9Pkn3FdafnXvuH5G0QU5fX9KNuTfwcUm75p7CZyStn7fpJenZ0nKhzM2B9yLitZy0AHgXmA+8D6xJmnL1eq7HexHxlKRdgH8Hzsm9dZvmvwm5bpMkDc5ljJP0K0lNkp6WdGCtg517aG/KeT0j6ac5vXfOq9T7eUoh/0Pz6/0kPSlpCvDFQp5rSLpC0mNKox8H1TzjS8ezd96nOeexai7n+sI2H41OSPqspIclTZF0vaT+ebMPgQmFf4mIF4B1Jf1rnbH0lnROPs8ztGT0Znjunb0h13+8JOV1cyWNzvE0F87Lx/K1OCNfT9vk9DNzPSdKel7SiXWEtsK+R+o4J5fka3uWpNGF9LmSfpKvxcMqLBev2zFKo3EzJP0spzVIujen3SPpEzl9nNIowEP5/NQaVRoI/K1wjOdFxBuSxgCrKb13x7fhmO9cvlxW3iHkazv7B9ACvNrKMRyaz9cMSTdLWienn1g4LtfWyiMi3gEmA5tJOiOf55mSxhbeCxOVRjSagJMkfV7So0rv7z8Vrpeq7wFJ3875zpR0cvE45X/75/NVer8dlNPXkHR7vjZnSjo879rhzwUzM+skEVHzj3SjvA1wA9APmAYMB27L638CnF/Yfh3SDfPNNfL8WP53NWAmsG5eDuBLhe3mAusVloPUcw/wU9JNFcDvgN3y608AT+TXPwROzq8/C9xYIZYRwLmtHIPLgVdIN3tHAb1y+jjg0MJ295B6fyHd9N1b2G4CqSE2CJgH9CsrowGYmV8fAzwPDMjH/AVgY2A74O7CPmsX48jb/jWXIeD3hfP0Y+DLpf2Ap4E1qsVQSCvluXle/g2pl7oP8JdSHsAlwJdJPd5/LqR/DzijleN7GXBIhfSljm9OG1k476sCTcCnSNfkfFKvYy/g4cI1MRc4Ib/+v8Dl+fWFwA/z672Aafn1mcBDOf/1SI3Cvivxe+QY0o3ttMLfAqCxLNbepNG0bQqxfbcs1uLyONJ1uy7wFKCy6/qPwFfz62OBWwr7XZ/P8xbAszWO48dzudOAc4Fti+etncd8qeWyPK4qHf9a10uFtBnAZ/Lrs0rXC/ASsGrxuJTtN5wl19m6ua5bluqS039buCYmAheXXYul434c+bOQKu8B0mdQM7AG0B+YVTqmpXqRPhvWyq/XA54lfR4dAlxWKHtAez4Xin+r/Otm8cnv3bbMn5mZVQc0RZXP1bpGDCJiBumm8UhSz2jRPsAvC9u+UUeWJ+betkdIN7yDcnoLcGON/d4HSvO2J+eYSjFcJGkacCuwllIv9RXAV/I2xwJXVshzIK305kXEccDewGPAqTnfpeTydgGuz3FcmvMu+X1ELI6IZ0g3/YNrlQncExHzI2IRMBv4ZN5vE0kXStoPeKtsn8HAnIh4Jp/4qwvrPguMyrFNJN3AfqKVGAA+nfN8Oi9fBewREaXevc8rTUk4APgDsBPpZu3BXNZXc+y1vELq+a7HZ4Gv5LwfJd0Mla6fxyL1CC8m3Qg2FPa7Kf9bvG52I900ERH3knoo18rrbo80OvRajm+DWkGt4O8RgOsiYmjpj9QgK/lSHgWYSropLU6vu648nwp5zwcWAb+W9EVgYU7fmdSggXSedivsc0t+P82mxrmJiHmka/i/gcXAPZL2rrJ5vce81jlo9fOknKQBpJv++3PSVcAe+fUMYLykL5N61CvZXdJU4C5gTETMAvbMIwHNpEbvloXti+fg48CdebvvlG1X6T2wG6lB+05ELCC9r3YvrxLwY0kzgD8BG+V9m4F986jR7hExv5VDU/FzQdLIPELV1LKwtSzMzKwt2jLH9FbgZ6QeqnVb2XYWMERpHnFLcYXSA737ADtHxEJJE0k3qQCLyrcv80G+4YX0n3Mp/l6keb2LyrZfIOllpYfYdiD19pd7l9QzX1NENAPNkn4LzCH1ohb1At7MN00Vs2hludx7hdctQJ9IUyCGAP8GHA98iXQzVw+Ret+eqnP7elwLfIs0XaIpIt7OUxbujogj25BPP9J5qIdIvf93LpWYrqtljllh+b0q6dUsk5ekbwJfL6RfFhG/LCyvqO+RqpQe5D0V2D5fn+MKsUJ6/oIay0TEh5J2IDW+DyVdU609eFo8P6VpMmezZDoXwOiIuDki3gP+F/hfSS+Tng26p6wew6n/mNc6B++ydP076gBSI+HzwGmSts6N8qJJEfHR9ERJ/UjPTDVGxF+VHuitdk4uBH4eEbfmY3BmYV2t91MtRwHrA9tFxAdKD173i4inlZ5/+BzwI0n3RMRZNfKp+LkQEWNJz32x6sBBrX2OmplZG7TldwyuIP1H21yWfjfwzdKCpHUi4jlSj+LowtzWBkkHkG7C38j/+Q4m9TBX8zZpjn9r7gJOKMQwtLDuclLP+fVV/jN/AtisWsZ5vuzwQtJQ0tSepeKLiLeAOZIOy/sp38SXHKY0h3tTYBPS1Ik2kbQeaRrTjcDpQPlDhk8CDbkMSL3XJXcCJxTOx7Z1FvtUzrN0jI4GSj2b9+cYvk5qJEDqbd21tH2eV7x5K2VsTpq6UY87gW8oPRSOpM0lrVHnvuUmkW+E8zl+LZ/HiiLil8Ve87JGAay475Fa1iLdaM7P89P3b+P+pdG2ARFxB3AKUHrfPAQckV8fRTpfVUXEaWXn52ZJwyRtmMvpRZryVXr/flC6jmjbMa+l5udJlbjnA29IKvW8Hw3cn+PdOCLuI03JG0CavtOaUiPgtXxsaz2DMYAlD8p/tY68JwFfkLR6ft8dzLLnZQDwSm4U7EkeMcznYWFEXA2cw7KfX+Xa8rlgZmadoO6GQZ6icUGFVT8C1skPk00H9szpx5GGj59V+grMcaSh4Qmk3tcngDGkG8lqxgITlB+srOFEoFHpAb3ZpN70kltJ/5lWmyLxZ2Db0s1ZBQK+K+mpPA1jNEtGC64FvqP04N6mpJuXr+XjMAs4qJDPX0hTkf4XOL5Cz209NgIm5jiuJk2P+EjOcyRwe57a8Uph9f8jzRGeIWlWXq7k05Lmlf5IPZUjSFOkmknTMX6Vy2shTVvZP/9LRLxKOj7X5KkED1Nj2lS+MduMpaemFF1aiOdh0k3sbGBKvq4upf2/x3EmsF2Ocwz13RhVtQK/R6qKiOmkKURPkqb9PNjWPEgNm9vyeXgA+HZOPwEYkdOPBk5qR97/AvwxH98ZpOk4pa9eHUt6P4ynbce8lttJI0a1rF58j0n6NunaOyfXdSjpOYPewNX5fTcVuCAi3mwtgLzNZaSb6juBx2tsfibpvT0ZeK3GdqW8p5Cu08dIU/kuj4ipZZuNJ11rzaRpak/m9K2Bx/Ln1w9J74uK6vhcMDOzLlB66GyFpfRd6+dFRPk82OI2vwD+GF301Yl5esVtEXFDV+Tfk0k6GBgWET/o7lhWVvW8R6x+kh4ADqznJt4qq/dzobGxMZqa3HYwM2sLSZMjouJvEbVlKlGPI2kU6SHB/25l0x/TA74LfgXVh/RtMdYN2vAesfr9F/U92G/V+XPBzKwbrPAjBmZmtmLyiIGZWduttCMGZmZmZmZWHzcMzMzMzMzMDQMzMzMzM3PDwMzMzMzMcMPAzMzMzMxo/w9DmZmZdavmF+fTMOr2ZdLnjjmgG6IxM+v5PGJgZj2epJB0dWG5j6RXJd3Wyn79JV0q6TlJkyVNlLRjG8s+WdI/9e+gSDpG0kX1pOdjUPFr7NpQ3lmS9ulIHmZmtvx5xMDMVgTvAFtJWi0i3gX2BV6sY7/LgTnAoIhYLOlTwBb1FiqpN3AycDWwsM1RrwAk9Y6IlrLlM7ozJjMzax+PGJjZiuIOoDSH5EjgmtKKPDJwpaRmSTMkHSJpU2BH4PSIWAwQEXMi4va8zy15FGGWpJGFvBZIOlfSdOA0YEPgPkn3FdafLWm6pEckbZDT15d0o6TH89+uknpJekbS+nmbXpKeLS0XytxB0sOSpkp6SNKnc/oxkm6SNCHn89PCPiMkPS3pMWDX9hxQSZdIasrHYHQhfa6kn0iaAhxWYXmcpEPztmMkzc7H/Wc5rUHSvTntHkmfyOnjJF2Q6/h8KQ8zM1s+3DAwsxXFtcARkvoB2wCPFtb9AJgfEVtHxDbAvcCWwLRib3eZYyNiO6AROFHSujl9DeDRiBgSEWcBLwF7RsSehfWPRMQQ4M/A13P6L4DzImJ74BDg8twguRo4Km+zDzA9Il4ti+VJYPeI2BY4A/hxYd1Q4HBga+BwSRtLGgiMJjUIdqP2KMjhkqaV/nJ9S07Lv465DfAZSdsU1r0eEcMi4toqy+RjdjCwZT7uP8qrLgSuymnjgQsK+Q7MMR8IjCkPVtLI3Fhpalk4v0a1zMysrTyVyMxWCBExQ1IDabTgjrLV+wBHFLZ9Q1JrWZ4o6eD8emNgEPA60ALcWGO/94HSsw2TSdOaSjFsUSh3LUn9gSuAPwDnA8cCV1bIcwBwlaRBQAB9C+vuiYj5AJJmA58E1gMmlhoYkq4DNq8S73UR8a3SgqSJhXVfyqMlfUg37FsAM0r7ledTIe/5wCLg1/l5j9Jx2Rn4Yn79W+CnhX1uyQ2m2aXRlqKIGAuMBVh14KCoUiczM2sHNwzMbEVyK/AzYDiwbu1NmQUMKZ8jDyBpOOlGfueIWJhvlvvl1YtqjDIAfBARpRvWFpZ8zvYCdoqIRWXbL5D0sqS9gB1YMnpQ9P+A+yLi4Nz4mVhY917hdbG8DsnPW5wKbJ8bUuNYcgwgPddBjWUi4kNJOwB7A4cC3wL2aqXoYn1abb2ZmVnn8VQiM1uRXAGMjojmsvS7gW+WFiStExHPAU3AaOVu/Dz3/QBSD/0buVEwGNipRplvA2vWEdtdwAmFGIYW1l1OmlJ0fZVGxwCWPEx9TB1lPUqa+rOupL7AYXXsU24t0s3+/Nxzv39bM8gjIgMi4g7gFGBIXvUQS0ZwjgImtSM+MzPrZG4YmNkKIyLmRcQFFVb9CFhH0sz80HDpeYDjgA2AZyXNBMYBrwATgD6SniDNc3+kRrFjgQmlh49rOBFozA/czgaOL6y7FehP5WlEkKba/I+kqdQxIhARfwPOBB4GHgSeaG2fCnlMB6aSnm/4Xc6nrdYEbpM0A3gA+HZOPwEYkdOPBk5qR95mZtbJtGTE28zMuoPS7wacFxG7d3csPUljY2M0NTV1dxhmZj2KpMn5iyWW4WcMzMy6kaRRwDeo/GyBmZnZcuOpRGZm3SgixkTEJyPige6OxczMVm5uGJiZmZmZmRsGZmZmZmbmhoGZmZmZmeGGgZmZmZmZ4YaBmZmZmZnhrys1M7MeqvnF+TSMun2Z9LljDuiGaMzMej6PGJjZSk/Sgu6OoatIGi7ptnrSJY2TdGgHyzte0lc6koeZmXUPjxiYmVm7SOoTER+WLf+qO2MyM7P284iBmVkFkjaVNEHSZEmTJA3O6eMkXSDpIUnPl3rYcw/8REk3SHpS0nhJyuv2ljRVUrOkKyStmtPnShotaUpeN7hCHA25/Cn5b5c6ytsvp00BvtjO+p8h6XFJMyWNLeQ9UdL5kpqAkyosnynp1LztiZJmS5oh6dqc9jFJt+S0RyRtk9PPzMdmYj6uJ7YnbjMzaz83DMzMKhsLnBAR2wGnAhcX1g0EdgMOBMYU0rcFTga2ADYBdpXUDxgHHB4RW5NGar9R2Oe1iBgGXJLLKfcKsG/e5nDggjrKuwz4PLAd8K816ri7pGmlP+DfC+suiojtI2IrYLVc15JVIqIxIs6tslwyCtg2IrYBjs9po4GpOe37wG8K2w8G/g3YAfihpL7lAUsaKalJUlPLwvk1qmZmZm3lhoGZWRlJ/YFdgOvzDfOlpMZAyS0RsTgiZgMbFNIfi4h5EbEYmAY0AJ8G5kTE03mbq4A9CvvclP+dnLcv1xe4TFIzcD2pEVCrvMG5vGciIoCra1R1UkQMLf0BtxbW7Snp0VzuXsCWhXXXleVTvlwyAxgv6ctAacrRbsBvASLiXmBdSWvldbdHxHsR8RqpQbRBeYYRMTY3Qhp7rz6gRtXMzKyt/IyBmdmyegFv5pvlSt4rvFaV9Bbq+4wt7VNt+1OAl4EhOa5FHSyvVXnU4WKgMSL+KulMoF9hk3fKdilfLjmA1Aj6PHCapK1bKbpL6mNmZvXxiIGZWZmIeAuYI+kwACVD2pndU0CDpM3y8tHA/W3YfwDwtzwqcDTQu5Xtn8zlbZqXj2xLsFmpEfBaHj1p8zcVSeoFbBwR9wHfI9WjPzAJOCpvM5w0leqtdsRoZmadzL0xZmawuqR5heWfk25eL5F0Omk6z7XA9LZmHBGLJI0gTUvqAzwOtOWbey4GbsxfATqB6r3zxfJGArdLWki6EV+zjTG/KekyYCbw9xxzW/UGrpY0gDSqckHO90zgCkkzgIXAV9uRNwBbbzSAJv9mgZlZp1GagmpmZtazNDY2RlNTU3eHYWbWo0iaHBGNldZ5KpGZmZmZmblhYGZmZmZmbhiYmZmZmRluGJiZmZmZGW4YmJmZmZkZbhiYmZmZmRluGJiZmZmZGf6BMzMz66GaX5xPw6jbl0mf6x89MzNrF48YWJtJWlBj3XBJt3Ug7w7t39UknSnpRUnTJM2U9O8dyOfUKukhabNC2sk5reKPkRS2219Sk6TZkqZKOreNMQ2V9Lm27NMekvpLukTSc5KmSJos6etdXW49JB0j6aKytImtHfs68j1L0j4di65m/i2Fa/KPktbO6RtKuqGrys1lbCDpNknT87V3R05vkPQfXVm2mZl1LjcMzNruvIgYChwGXCGps99HzcARheXDgFm1dpC0FXAR8OWI2AJoBJ6tt0BJfYChQJc3DIDLgTeAQRExDNgP+FhHM1XS7Z9pknqXL0fEGRHxpy4s9t2IGBoRWwH/AL4JEBEvRcShXVguwFnA3RExJF97o3J6A9CmhkG+Dqsum5lZ1+r2/0StZ8o3YefkHspmSYcXVveXdIOkJyWNl6S8z1xJo3MvcbOkwW0o77OSHs77Xi+pf608c8/7Fbm393lJJxby+naOe6akk3Nag6QnJF0maZakuyStViumiHgC+BBYT9Itued7lqSRhbIWFF4fKmlcHdW9BTgo77MpMB94rZDPfrm+0yXdk5O/C5wdEU/m2Foi4pK8/eclPZpHEf4kaYPCMfqtpAeB35Ju8A7PPc+Ht3IMvyzpsbztpZJ6SzpW0vmFbb4u6bxixXJ9dgBOj4jFOdZXI+InhW2+I+lxSTMkjS6kVztvT0n6DTAT2FjSD3LaA5KuUR6ZkbSppAn5PE1qy/VXiOESpVGZWWWxzZX0E0lTgMMqLI+TdGjedoxSz/oMST8r1OPenHaPpE/k9HGSLpD0UD4H9dzkPwxsVMh3Zn59jKSb8jF4RtJPC/F/TdLT+ZxepjxqUi2uMgOBeaWFiJiRX44Bds/XyCk5r0n52p0iaZdcxvCcfiswu3y5nvNiZmadww0Da68vknqYhwD7AOdIGpjXbQucDGwBbALsWtjvtdxLfAmwzFSaSiStB5wO7JP3bQK+XUeeg4F/I92I/lBSX0nbASOAHYGdgK9L2jZvPwj4ZURsCbwJHNJKXDsCi4FXgWMjYjtST/2Jktatp25VvAX8VWkU4AjgukKZ6wOXAYdExBDSaALAVsDkKvk9AOwUEdsC15IaESVbkI7rkcAZwHW557lUZqVj+H+Aw4Fd88hJC3AU8Hvg85L65n1HAFeUxbIlML3UKCgn6bOk87AD6fraTtIedZy3i/N5+xfSeRsC7E86HyVjgRPyeToVuLjK8So1jqZJmlaWx2kR0QhsA3xG0jaFda9HxLCIuLbKMvm6OBjYMiK2AX6UV10IXJXTxgMXFPIdCOwGHEi62a5KabRib+DWKpsMJZ27rXM9N5a0IfAD0nHdlXTOS2rFVfJL4NeS7pN0Ws4P0sjBpHw9nQe8Auyb36uHl+U1DDgpIjavslys48jcOGtqWTi/1uEwM7M28jCttdduwDUR0QK8LOl+YHvSTe1jETEPIN9YNZBuTgFuyv9OJjUu6rET6Qb2QaXBh1VIvaIl1fK8PSLeA96T9AqwQY775oh4J8d3E7A76UZqTkRMK+TVUCWeUyR9GXgbODwiQtKJkg7O6zcm3ay+Xmf9KrmW1Cj4N9KN3oicvhPw54iYAxAR/6gjr48D1+WG2yrAnMK6WyPi3Rr7VjqGewPbAY/n87Ea8EpELJB0L3CgpCeAvhHRXCswSaeRGjf/EhEbAp/Nf1PzJv1Jx7I/1c/bCxHxSN5+V+APEbEIWCTpj3n7/sAuwPU5ZoBVq4R1XUR8qxDjxMK6LymNCPUh3bBvAZR6yK9jaeXLkEZ/FpFupG8DSs/T7MySa/e3wE8L+9ySG1KzlUd7Klgtv9c2Ap4A7q6y3T0RMT/XazbwSWA94P7StSTpeqB0Q14rLgAi4k5Jm5CmhO0PTM2N2nJ9gYskDSU1Jos3/Y+Vrukqy8XyxpIaeaw6cFBUqaeZmbWDGwbWFd4rvG5h6evsvSrptYg0h/nIVsqrVla95ZVvX20q0XkR8bOPgpOGk0ZNdo6IhflGsl9eXbxx6Uf9bgPOAZoi4q3CzWw1s0g369MrrLsQ+HlE3JpjPbOw7p1W8q10DEXqRf7vCttfDnwfeBK4ssL62cAQSb0iYnFEnA2crSVTrgT8T0RcWtxJ0kk1YmytDpBGR9/MIxztIulTpJGG7SPiDaVpYcVzWh7HMnFFxIeSdiA1rg4FvgXs1UrRxXNQ7UJ4NyKGSloduJP0jEGl3v22vifqkhsVvwN+lxs8e7Bsw/gU4GXSaE4vUgOppNVjZ2ZmXc9Tiay9JpGmIvTO01v2AB7rorIeAXZV/qYeSWtIWmaKQZ0mAV+QtLqkNUjTOiZ1ML4BwBu5UTCY1Ktf8rKk/6P0UOzBlXdfVkQsBL4HnF226hFgj3yTiqTSQ7vnAN8vHRdJvSQdX4jvxfz6qzWKfRtYs47w7gEOlfQvpRgkfTLH/ShpxOQ/gGsq1OtZ0lSwH+VpL0jqx5Ib3juBY7XkGZKNcjn1nrcHSdOZ+uU8DszlvgXMkXRYzleShtRR16K1SDes83PP/f5t3L80cjEgIu4g3SiXYniIJQ+cH0U7r8l83ZwI/Jfqf3D3cdK0qHXyPsUpdK3GJWmv3CBB0prApsBfWPZ6GgD8LY9+HA30Ls/LzMy6l0cMrE3yjcN7wM2kaQbTSb3i342Iv6sdD3RWsLekeYXlw4BjgGsklaZ/nA483daMI2JK7uktNWIuj4ipkhraHy4TgOPz9JmnSDfvJaNIvf+vkm6I+7ch1msrpL2ap7LclBsbpXnbM5QeyL0m36QFS6apnEmaQvMGcC/wqSpF3geMylNS/qdGXLMlnQ7clWP4gNRD/ULe5PfA0Ih4o0oWx5EaMs9Keh14l/zcQ0TclZ9heDiPkiwgfdNSXectIh5Xemh1Bql3upk0fQfSje0lOfa+pOlalUZYqtV7uqSppNGQv5IaIW21JvCHQmOo9KzMCcCVkr5DulZGVNm/njinSpoBHEkdDYyIeFHSj0nH9h+k+pWOWT1xbUeaIvQhqbPp8nwe+gItkqYD40jPdNwo6Suk90yHRwW23mgATf7NAjOzTqMIT9G0+uVe1ssiYofujsX+OeWpJOdFxD2tbtw15ffPzzusDvwZGBkRU7ojlp6icMz6kBr9V0TEzd0dV2saGxujqampu8MwM+tRJE3OX6SxDE8lsrrlqSnXkHrrzZYiaW1JT5Pmu3dLoyAbm0c9pgA3ulFQlzPzMZtJejj9lm6NxszMuoVHDMzMrEfyiIGZWdt5xMDMzMzMzGpyw8DMzMzMzNwwMDMzMzMzNwzMzMzMzAz/joGZmfVQzS/Op2HU7Z2e71z/NoKZraQ8YmBmH5G0oLtjqEbScEkh6bhC2tCcdmor+24u6Q5Jz0iaIun3+deL6y17bUn/tyPx11nOOEmHlqV1+Jzkuq/d0Xyq5L26pPGSmiXNlPSApP7L65iZmVnnccPAzHqSmcCXCstH0sqvF+dfGb4duCQiBkXEMNKv8K5fT4H5R7/WBv7pb3KV9CpfjojPRcSbXVTsScDLEbF1RGwFfI30a9hr08ZjVi3+zgzWzMyq8weumdUkaVNJEyRNljRJ0uCcPk7SBZIekvR8qac79+xPlHSDpCdzb7Lyur0lTc29y1dIWjWnz5U0OvfmN5fKqOAFoJ+kDXKe+wH/W4h1M0l/kjQ957Up8B/AwxHxx9J2ETExImZKash1mpL/dinUYZKkW4HZwBhgU0nTJJ3TSh23k3R/Pl53ShqYj+GUQpyDist1nof+ku4pHKODcnqDpKck/YbUcNq9bHnjfHzXk7SGpNvz8Zkp6fBOOC8DgRcLx/apiHivwjFrd/xtOU5mZtZ+fsbAzFozFjg+Ip6RtCOpt32vvG4gsBswGLgVuCGnbwtsCbwEPAjsKqkJGAfsHRFP5xu/bwDn531ei4hhStNPTgU+mjJU5gbgMGAq6deN3yusGw+MiYiblUYKegFbAZOr5PUKsG9ELJI0iPTL3qUffRkGbBURcyQ15NdDITUcqtTxUeBC4KCIeDXfeJ8dEcdKmi9paERMA0YAV1aJ6RxJlX5dfBFwcES8JWk94JHccAEYBHw1Ih7JsX60nOMt5bEf8FJEHJDTB+TjNI72n5crgLtyw/Ae4KqIeAYYVXbM+rQ3fjMzWz48YmBmVUnqD+wCXC9pGnApqTFQcktELI6I2UBxzv5jETEvIhYD04AG4NPAnIh4Om9zFbBHYZ+b8r+T8/bV/J7UMDiSdCNfinVNYKOIuBkgIhZFxMJWqtgXuExSM3A9sEVZHebU2LdaHbcC7s7H63Tg43n7y4ERknoDhwO/q5LvdyJiaOmvkC7gx5JmAH8CNmLJMX+h7Ca6fLmkGdhX0k8k7R4R8+ngeckNnU2Ac4CPAY9L+j8Vyu6M+JE0UlKTpKaWhfMrbWJmZu3kEQMzq6UX8GbZDWpRsbdeVdJbqO+zprRPze0j4u+SPgD2Jc1v36WVfGcBn6my7hTgZWAIqa6LCuveqTPeYswCZkXEzhW2vxH4IXAvMDkiXm8l/3JHkZ6L2C4iPpA0F+hXJdaKsecRgWHA54AfSboH+EMr5bZ6XiJiAakBcZOkxTn/Gzs7/lzWWNIoFqsOHBStxG5mZm3gEQMzqyoi3gLmSDoMPnoYdEg7s3sKaJC0WV4+Gri/nXmdAXwvIloKsb4NzJP0hRzrqpJWJ/XM7yLpo++glLSHpK2AAcDfcq//0UDvKuW9DaxZR1xPAetL2jmX01fSljm+RcCdwCVUn0ZUywDglXxTvSfwybZmIGlDYGFEXE3q4R9GB8+LpF0lrZNfr0IadXmBZY9Zh+M3M7Ou5YaBmRWtLmle4e/bpJ7er0maTup9P6g9Gecb4xGkaUnNwGLgV+3M66GIuKXCqqOBE/N0lYeAf42Id4EDgROUvq50Nunbcl4lPS/x1Vy3wVTvaX8deDA/sHtOjbjeBw4FfpLznMbSIxrjSfW+qy31LezbmI/dV4An25HH1sBjeZrTD4EfdcJ52RS4P+87FWgCbqxwzDojfjMz60KK8EismdnyoPR7CwMi4gfdHcuKoLGxMZqamro7DDOzHkXS5IhorLTOzxiYmS0Hkm4m9a7v1dq2ZmZm3cENAzOz5SAiDu7uGMzMzGrxMwZmZmZmZuaGgZmZmZmZuWFgZmZmZma4YWBmZmZmZrhhYGZmZmZm+FuJzMysh2p+cT4No27v7jCsB5g75oDWNzIzjxiYma2sJC0oWz5G0kUdzLNR0gUdi8zMzLqDRwzMzKxdJPWJiA/LlpsA/xyxmVkP5IaBmZktQ9LngdOBVYDXgaMi4mVJZ5J+wXkT4C+SnipbvhQ4NSIOlPQZ4Bc5ywD2ABYAPwX2z2k/iojrJA0HzgReA7YCJgNfjojo+tqamRm4YWBmtjJbTdK0wvLHgFvz6weAnSIiJB0HfBf4r7xuC2C3iHg3NxSKy8ML+Z0KfDMiHpTUH1gEfBEYCgwB1gMel/TnvP22wJbAS8CDwK45jo9IGgmMBOi91vodqbuZmZVxw8DMbOX1bkQMLS1IOgZozIsfB66TNJA0ajCnsN+tEfFujeWSB4GfSxoP3BQR8yTtBlwTES3Ay5LuB7YH3gIei4h5OZZpQANlDYOIGAuMBVh14CCPJpiZdSI/fGxmZpVcCFwUEVsD/wn0K6x7p2zb8mUAImIMcBywGvCgpMGtlPle4XUL7rwyM1uu3DAwM7NKBgAv5tdfbU8GkjaNiOaI+AnwODAYmAQcLqm3pPVJzx081hkBm5lZx7g3xszMKjkTuF7SG8C9wKfakcfJkvYEFgOzgP8F3gd2BqaTHj7+bkT8vY7RhGVsvdEAmvz99GZmnUb+wgczM+uJGhsbo6nJ34xqZtYWkiZHRGOldZ5KZGZmZmZmbhiYmZmZmZkbBmZmZmZmhhsGZmZmZmaGGwZmZmZmZoYbBmZmZmZmhhsGZmZmZmaGf+DMzMx6qOYX59Mw6vbuDsPMbLma24U/7OgRAzOzNpC0oLtjqEXSREl/kaRC2i31xC3pVElPSpom6XFJX2lj2V+QtEV74jYzs+7nhoGZ2YrnTWBXAElrAwNb20HS8cC+wA4RMRTYG1DNnZbevw/wBcANAzOzHsoNAzOzDpK0qaQJkiZLmiRpcE4fJ+kCSQ9Jel7SoTl9eO7ZvyH30I8v9fBL2lvSVEnNkq6QtGpOnytptKQped3gGiFdCxyRX38RuKks3u/lPKZLGpOTvw98IyLeAoiItyLiqrz9GXkEYaaksYVYJ0o6X1IT8D3g34Fz8ojDpnn9TyQ9JulpSbvn/XpLOifnOUPSf+b030j6QiHO8ZIOat9ZMTOztnLDwMys48YCJ0TEdsCpwMWFdQOB3YADgTGF9G2Bk0k97JsAu0rqB4wDDo+IrUnPgX2jsM9rETEMuCSXU809wB6SepMaCNeVVkjaHzgI2DEihgA/lbQWsGZEPF8lv4siYvuI2ApYLdelZJWIaIyIs4Fbge9ExNCIeC6v7xMRO+S6/jCnfQ2YHxHbA9sDX5f0KeDXwDE5zgHALsBSDxFIGimpSVJTy8L5NQ6BmZm1lRsGZmYdIKk/6Qb2eknTgEtZeurOLRGxOCJmAxsU0h+LiHkRsRiYBjQAnwbmRMTTeZurgD0K+5R6/ifn7atpAR4gNQpWi4i5hXX7AFdGxEKAiPhHHdXcU9KjkpqBvYAtC+uuq7JPrZg/C3wlH69HgXWBQRFxPzBI0vrAkcCNEfFhMbOIGJsbIo29Vx9QR+hmZlYvfyuRmVnH9ALezPPyK3mv8FpV0luo7/O4tM9H20u6k9TgaIqI4wrbXgvcDJzZWqYR8ZakBZI2KR81yKMYFwONEfFXSWcC/QqbvNPWmEnH4YSIuLPC9r8Bvkxq1IxoLXYzM+s8HjEwM+uAPCd/jqTDAJQMaWd2TwENkjbLy0cD97dS/r/lqTvHla2aBPwPcE1Z+t3ACEmr53g/ltP/B/hlnlaEpP75W4lKjYDX8ujIoTXCeRtYs1a82Z3ANyT1zWVtLmmNvG4cadoReZTFzMyWE48YmJm1zeqS5hWWfw4cBVwi6XSgL6m3fnpbM46IRZJGkKYl9QEeB37VniAjIoCfVUifIGko0CTpfeAO0oPHlwD9gcclfQB8AJwbEW9KugyYCfw9x1TNtcBlkk6kdgPictK0oin5QeZXSd9oRES8LOkJ4JbW6rj1RgNo6sLv8zYzW9ko/d9hZmbW/fJIRjMwLCJqPl3c2NgYTU1NyycwM7MVhKTJEdFYaZ2nEpmZ2T8FSfsATwAXttYoMDOzzuepRGZm9k8hIv4EfLK74zAzW1l5xMDMzMzMzNwwMDMzMzMzNwzMzMzMzAw3DMzMzMzMDDcMzMzMzMwMfyuRmZn1UM0vzqdh1O3dHYaZ2XI1twt/2NEjBmZmthRJC7o7BjMzW/7cMDAzMzMzMzcMzMysdZI2lTRB0mRJkyQNzunjJF0g6SFJz0s6NKcPlzRR0g2SnpQ0XpLyur0lTZXULOkKSavm9LmSRkuaktcN7r4am5mtfNwwMDOzeowFToiI7YBTgYsL6wYCuwEHAmMK6dsCJwNbAJsAu0rqB4wDDo+IrUnPun2jsM9rETEMuCSXsxRJIyU1SWpqWTi/k6pmZmbghoGZmbVCUn9gF+B6SdOAS0mNgZJbImJxRMwGNiikPxYR8yJiMTANaAA+DcyJiKfzNlcBexT2uSn/Ozlvv5SIGBsRjRHR2Hv1AR2tmpmZFfhbiczMrDW9gDcjYmiV9e8VXqtKegv1/Z9T2qfe7c3MrJN4xMDMzGqKiLeAOZIOA1AypJ3ZPQU0SNosLx8N3N8JYZqZWQe5N8bMzMqtLmleYfnnwFHAJZJOB/oC1wLT25pxRCySNII0LakP8Djwq/YEufVGA2jqwu/zNjNb2SgiujsGMzOzNmtsbIympqbuDsPMrEeRNDkiGiut81QiMzMzMzNzw8DMzMzMzNwwMDMzMzMz3DAwMzMzMzPcMDAzMzMzM9wwMDMzMzMz/DsGZmbWQzW/OJ+GUbd3dxhmZsvV3C78/RaPGJiZrUAkhaSrC8t9JL0q6bZW9usv6VJJz0maLGmipB3bWPbJklZvb+xmZta93DAwM1uxvANsJWm1vLwv8GId+10O/AMYFBHbASOA9eotVFJv4GTADQMzsx7KDQMzsxXPHUBprPlI4JrSijwycKWkZkkzJB0iaVNgR+D0iFgMEBFzIuL2vM8teRRhlqSRhbwWSDpX0nTgNGBD4D5J9xXWny1puqRHJG2Q09eXdKOkx/PfrpJ6SXpG0vp5m16Sni0tm5lZ13PDwMxsxXMtcISkfsA2wKOFdT8A5kfE1hGxDXAvsCUwLSJaquR3bB5FaAROlLRuTl8DeDQihkTEWcBLwJ4RsWdh/SMRMQT4M/D1nP4L4LyI2B44BLg8N0iuBo7K2+wDTI+IV4uBSBopqUlSU8vC+W0+MGZmVp0fPjYzW8FExAxJDaTRgjvKVu8DHFHY9g1JrWV5oqSD8+uNgUHA60ALcGON/d4HSs82TCZNayrFsEWh3LUk9QeuAP4AnA8cC1xZoW5jgbEAqw4cFK0FbmZm9XPDwMxsxXQr8DNgOLBu7U2ZBQyR1Lt81EDScNKN/M4RsVDSRKBfXr2oxigDwAcRUbp5b2HJ/zm9gJ0iYlHZ9gskvSxpL2AHlowemJnZcuCpRGZmK6YrgNER0VyWfjfwzdKCpHUi4jmgCRit3I0vqUHSAcAA4I3cKBgM7FSjzLeBNeuI7S7ghEIMQwvrLidNKbq+lUaHmZl1MjcMzMxWQBExLyIuqLDqR8A6kmbmh4ZLzwMcB2wAPCtpJjAOeAWYAPSR9AQwBnikRrFjgQmlh49rOBFozA8/zwaOL6y7FehPhWlEZmbWtbRklNfMzKx7SWokPZi8e2vbNjY2RlNT03KIysxsxSFpckQ0VlrnZwzMzOyfgqRRwDfwswVmZt3CU4nMzOyfQkSMiYhPRsQD3R2LmdnKyA0DMzMzMzPzMwZmZtYzSXobeKq74+gC6wGvdXcQncx16hlcp56ho3X6ZERU/FV5P2NgZmY91VPVHqDrySQ1rWj1cp16BtepZ+jKOnkqkZmZmZmZuWFgZmZmZmZuGJiZWc81trsD6CIrYr1cp57BdeoZuqxOfvjYzMzMzMw8YmBmZmZmZm4YmJmZmZkZbhiYmVkPJGk/SU9JelbSqO6Opz0kXSHpFUkzC2kfk3S3pGfyv+t0Z4xtJWljSfdJmi1plqSTcnqPrZekfpIekzQ912l0Tv+UpEfzNXidpFW6O9a2ktRb0lRJt+XlFaFOcyU1S5omqSmn9djrD0DS2pJukPSkpCck7dxVdXLDwMzMehRJvYFfAvsDWwBHStqie6Nql3HAfmVpo4B7ImIQcE9e7kk+BP4rIrYAdgK+mc9NT67Xe8BeETEEGArsJ2kn4CfAeRGxGfAG8LXuC7HdTgKeKCyvCHUC2DMihha+678nX38AvwAmRMRgYAjpnHVJndwwMDOznmYH4NmIeD4i3geuBQ7q5pjaLCL+DPyjLPkg4Kr8+irgC8szpo6KiL9FxJT8+m3SDcxG9OB6RbIgL/bNfwHsBdyQ03tUnQAkfRw4ALg8L4seXqcaeuz1J2kAsAfwa4CIeD8i3qSL6uSGgZmZ9TQbAX8tLM/LaSuCDSLib/n134ENujOYjpDUAGwLPEoPr1eecjMNeAW4G3gOeDMiPsyb9MRr8Hzgu8DivLwuPb9OkBptd0maLGlkTuvJ19+ngFeBK/O0r8slrUEX1ckNAzMzs39Ckb5PvEd+p7ik/sCNwMkR8VZxXU+sV0S0RMRQ4OOkEavB3RtRx0g6EHglIiZ3dyxdYLeIGEaaavhNSXsUV/bA668PMAy4JCK2Bd6hbNpQZ9bJDQMzM+tpXgQ2Lix/PKetCF6WNBAg//tKN8fTZpL6khoF4yPippzc4+sFkKdw3AfsDKwtqU9e1dOuwV2Bf5c0lzQVby/SPPaeXCcAIuLF/O8rwM2khlxPvv7mAfMi4tG8fAOpodAldXLDwMzMeprHgUH5G1RWAY4Abu3mmDrLrcBX8+uvAn/oxljaLM9T/zXwRET8vLCqx9ZL0vqS1s6vVwP2JT07cR9waN6sR9UpIv47Ij4eEQ2k98+9EXEUPbhOAJLWkLRm6TXwWWAmPfj6i4i/A3+V9OmctDcwmy6qk3/52MzMehxJnyPNke4NXBERZ3dvRG0n6RpgOLAe8DLwQ+AW4PfAJ4AXgC9FRPkDyv+0JO0GTAKaWTJ3/fuk5wx6ZL0kbUN6uLM3qUP19xFxlqRNSL3tHwOmAl+OiPe6L9L2kTQcODUiDuzpdcrx35wX+wC/i4izJa1LD73+ACQNJT0kvgrwPDCCfC3SyXVyw8DMzMzMzDyVyMzMzMzM3DAwMzMzMzPcMDAzMzMzM9wwMDMzMzMz3DAwMzMzMzPcMDAzMzMzM9wwMDMzMzMz4P8DjUt++/77aJYAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Viz :\n",
    "\n",
    "corpus_clean['Songwriter(s)'].value_counts().plot(kind='barh')\n",
    "\n",
    "## 60 / 60 / 60, pratique...!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>Song</th>\n",
       "      <th>Album Debut</th>\n",
       "      <th>Songwriter(s)</th>\n",
       "      <th>Lead Vocal(s)</th>\n",
       "      <th>Year</th>\n",
       "      <th>Lyrics</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>\"All I've Got to Do\"</td>\n",
       "      <td>UK: With the Beatles\\n US: Meet the Beatles!</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1963</td>\n",
       "      <td>Whenever I want you around yeh \\nAll I gotta d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>\"All My Loving\"</td>\n",
       "      <td>UK: With the Beatles\\n US: Meet the Beatles!</td>\n",
       "      <td>McCartney</td>\n",
       "      <td>McCartney</td>\n",
       "      <td>1963</td>\n",
       "      <td>Close your eyes and I'll kiss you\\nTomorrow I'...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>\"All Together Now\"</td>\n",
       "      <td>Yellow Submarine</td>\n",
       "      <td>Lennon-McCartney</td>\n",
       "      <td>McCartney</td>\n",
       "      <td>1967</td>\n",
       "      <td>One two three four\\nCan I have a little more\\n...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>\"All You Need Is Love\"</td>\n",
       "      <td>Magical Mystery Tour</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1967</td>\n",
       "      <td>Love, love, love\\nLove, love, love\\nLove, love...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>\"And I Love Her\"</td>\n",
       "      <td>UK: A Hard Day's Night\\n US: Something New</td>\n",
       "      <td>Lennon-McCartney</td>\n",
       "      <td>McCartney</td>\n",
       "      <td>1964</td>\n",
       "      <td>I give her all my love\\nThat's all I do\\nAnd i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>\"And Your Bird Can Sing\"</td>\n",
       "      <td>UK: Revolver\\n US: Yesterday and Today</td>\n",
       "      <td>Lennon-McCartney</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1966</td>\n",
       "      <td>You tell me that you've got everything you wan...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>\"Another Girl\"</td>\n",
       "      <td>Help!</td>\n",
       "      <td>McCartney</td>\n",
       "      <td>McCartney</td>\n",
       "      <td>1965</td>\n",
       "      <td>For I have got another girl, another girl\\nYou...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>\"Any Time at All\"</td>\n",
       "      <td>UK: A Hard Day's Night\\n US: Something New</td>\n",
       "      <td>Lennon-McCartney</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1964</td>\n",
       "      <td>Any time at all, any time at all, any time at ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>\"Ask Me Why\"</td>\n",
       "      <td>UK: Please Please Me\\n US: The Early Beatles</td>\n",
       "      <td>Lennon-McCartney</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1963</td>\n",
       "      <td>I love you, 'cause you tell me things I want t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>\"Baby, You're a Rich Man\"</td>\n",
       "      <td>Magical Mystery Tour</td>\n",
       "      <td>Lennon-McCartney</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1967</td>\n",
       "      <td>How does it feel to be\\nOne of the beautiful p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>\"Baby's in Black\"</td>\n",
       "      <td>UK: Beatles for Sale\\n US: Beatles '65</td>\n",
       "      <td>Lennon-McCartney</td>\n",
       "      <td>Lennon\\n McCartney</td>\n",
       "      <td>1964</td>\n",
       "      <td>Oh dear, what can I do?\\nBaby's in black and I...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>\"Back in the U.S.S.R.</td>\n",
       "      <td>The Beatles</td>\n",
       "      <td>McCartney</td>\n",
       "      <td>McCartney</td>\n",
       "      <td>1968</td>\n",
       "      <td>Flew in from Miami Beach BOAC\\nDidn't get to b...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>\"Bad to Me\"</td>\n",
       "      <td>The Beatles Bootleg Recordings 1963</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1963</td>\n",
       "      <td>If you ever leave me, I'll be sad and blue\\nDo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>\"The Ballad of John and Yoko\"</td>\n",
       "      <td>UK: 1967–1970\\n US: Hey Jude</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon\\n (with McCartney)</td>\n",
       "      <td>1969</td>\n",
       "      <td>Standing in the dock at Southampton\\nTrying to...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                             Song  \\\n",
       "2            \"All I've Got to Do\"   \n",
       "3                 \"All My Loving\"   \n",
       "5              \"All Together Now\"   \n",
       "6          \"All You Need Is Love\"   \n",
       "7                \"And I Love Her\"   \n",
       "8        \"And Your Bird Can Sing\"   \n",
       "9                  \"Another Girl\"   \n",
       "10              \"Any Time at All\"   \n",
       "11                   \"Ask Me Why\"   \n",
       "12      \"Baby, You're a Rich Man\"   \n",
       "13              \"Baby's in Black\"   \n",
       "14          \"Back in the U.S.S.R.   \n",
       "15                    \"Bad to Me\"   \n",
       "16  \"The Ballad of John and Yoko\"   \n",
       "\n",
       "                                     Album Debut     Songwriter(s)  \\\n",
       "2   UK: With the Beatles\\n US: Meet the Beatles!            Lennon   \n",
       "3   UK: With the Beatles\\n US: Meet the Beatles!         McCartney   \n",
       "5                               Yellow Submarine  Lennon-McCartney   \n",
       "6                           Magical Mystery Tour            Lennon   \n",
       "7     UK: A Hard Day's Night\\n US: Something New  Lennon-McCartney   \n",
       "8         UK: Revolver\\n US: Yesterday and Today  Lennon-McCartney   \n",
       "9                                          Help!         McCartney   \n",
       "10    UK: A Hard Day's Night\\n US: Something New  Lennon-McCartney   \n",
       "11  UK: Please Please Me\\n US: The Early Beatles  Lennon-McCartney   \n",
       "12                          Magical Mystery Tour  Lennon-McCartney   \n",
       "13        UK: Beatles for Sale\\n US: Beatles '65  Lennon-McCartney   \n",
       "14                                   The Beatles         McCartney   \n",
       "15           The Beatles Bootleg Recordings 1963            Lennon   \n",
       "16                  UK: 1967–1970\\n US: Hey Jude            Lennon   \n",
       "\n",
       "                Lead Vocal(s)  Year  \\\n",
       "2                      Lennon  1963   \n",
       "3                   McCartney  1963   \n",
       "5                   McCartney  1967   \n",
       "6                      Lennon  1967   \n",
       "7                   McCartney  1964   \n",
       "8                      Lennon  1966   \n",
       "9                   McCartney  1965   \n",
       "10                     Lennon  1964   \n",
       "11                     Lennon  1963   \n",
       "12                     Lennon  1967   \n",
       "13         Lennon\\n McCartney  1964   \n",
       "14                  McCartney  1968   \n",
       "15                     Lennon  1963   \n",
       "16  Lennon\\n (with McCartney)  1969   \n",
       "\n",
       "                                               Lyrics  \n",
       "2   Whenever I want you around yeh \\nAll I gotta d...  \n",
       "3   Close your eyes and I'll kiss you\\nTomorrow I'...  \n",
       "5   One two three four\\nCan I have a little more\\n...  \n",
       "6   Love, love, love\\nLove, love, love\\nLove, love...  \n",
       "7   I give her all my love\\nThat's all I do\\nAnd i...  \n",
       "8   You tell me that you've got everything you wan...  \n",
       "9   For I have got another girl, another girl\\nYou...  \n",
       "10  Any time at all, any time at all, any time at ...  \n",
       "11  I love you, 'cause you tell me things I want t...  \n",
       "12  How does it feel to be\\nOne of the beautiful p...  \n",
       "13  Oh dear, what can I do?\\nBaby's in black and I...  \n",
       "14  Flew in from Miami Beach BOAC\\nDidn't get to b...  \n",
       "15  If you ever leave me, I'll be sad and blue\\nDo...  \n",
       "16  Standing in the dock at Southampton\\nTrying to...  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Sélection des chansons qui ont été seulement écrites par Lennon, Lennon-McCartney, McCartney.\n",
    "\n",
    "# If you have multiple values you want to include, put them in a list (or more generally, any iterable) and use isin:\n",
    "\n",
    "corpus_clean_select = corpus_clean.loc[corpus_clean['Songwriter(s)'].isin(['Lennon','McCartney', 'Lennon-McCartney'])]\n",
    "\n",
    "corpus_clean_select[1:15]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Si on veut trois corpus distincts :\n",
    "\n",
    "# corpus_Lennon = corpus_clean.loc[(corpus_clean['Songwriter(s)'] == \"Lennon\")]\n",
    "# corpus_McCartney = corpus_clean.loc[(corpus_clean['Songwriter(s)'] == \"McCartney\")]\n",
    "# corpus_LMC = corpus_clean.loc[(corpus_clean['Songwriter(s)'] == \"Lennon-McCartney\")]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "# TODO : nettoyage dans les Lyrics '\\n'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Tokénisation, lemmatisation, étiquetage morphosyntaxique : \n",
    "---\n",
    "\n",
    "**Objectif** : \n",
    "\n",
    "    - Avoir un tableau avec mot / lemme / POS / Oeuvre / Songwriter.\n",
    "    \n",
    "==> Boîte à outils SpaCy : https://spacy.io/api/tokenizer \n",
    "==> https://spacy.io/usage/linguistic-features"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Installation de spacy :\n",
    "\n",
    "# pip install spacy"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Construction :\n",
    "from spacy.lang.en import English\n",
    "nlp = English()\n",
    "# Create a Tokenizer with the default settings for English\n",
    "# including punctuation rules and exceptions\n",
    "tokenizer = nlp.tokenizer\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>Song</th>\n",
       "      <th>Album Debut</th>\n",
       "      <th>Songwriter(s)</th>\n",
       "      <th>Lead Vocal(s)</th>\n",
       "      <th>Year</th>\n",
       "      <th>Lyrics</th>\n",
       "      <th>words</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>\"Across the Universe\"</td>\n",
       "      <td>Let It Be</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1968</td>\n",
       "      <td>Words are flowing out like endless rain into a...</td>\n",
       "      <td>(Words, are, flowing, out, like, endless, rain...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>\"All I've Got to Do\"</td>\n",
       "      <td>UK: With the Beatles\\n US: Meet the Beatles!</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1963</td>\n",
       "      <td>Whenever I want you around yeh \\nAll I gotta d...</td>\n",
       "      <td>(Whenever, I, want, you, around, yeh, \\n, All,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>\"All My Loving\"</td>\n",
       "      <td>UK: With the Beatles\\n US: Meet the Beatles!</td>\n",
       "      <td>McCartney</td>\n",
       "      <td>McCartney</td>\n",
       "      <td>1963</td>\n",
       "      <td>Close your eyes and I'll kiss you\\nTomorrow I'...</td>\n",
       "      <td>(Close, your, eyes, and, I, 'll, kiss, you, \\n...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>\"All Together Now\"</td>\n",
       "      <td>Yellow Submarine</td>\n",
       "      <td>Lennon-McCartney</td>\n",
       "      <td>McCartney</td>\n",
       "      <td>1967</td>\n",
       "      <td>One two three four\\nCan I have a little more\\n...</td>\n",
       "      <td>(One, two, three, four, \\n, Can, I, have, a, l...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>\"All You Need Is Love\"</td>\n",
       "      <td>Magical Mystery Tour</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1967</td>\n",
       "      <td>Love, love, love\\nLove, love, love\\nLove, love...</td>\n",
       "      <td>(Love, ,, love, ,, love, \\n, Love, ,, love, ,,...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Song                                   Album Debut  \\\n",
       "1   \"Across the Universe\"                                     Let It Be   \n",
       "2    \"All I've Got to Do\"  UK: With the Beatles\\n US: Meet the Beatles!   \n",
       "3         \"All My Loving\"  UK: With the Beatles\\n US: Meet the Beatles!   \n",
       "5      \"All Together Now\"                              Yellow Submarine   \n",
       "6  \"All You Need Is Love\"                          Magical Mystery Tour   \n",
       "\n",
       "      Songwriter(s) Lead Vocal(s)  Year  \\\n",
       "1            Lennon        Lennon  1968   \n",
       "2            Lennon        Lennon  1963   \n",
       "3         McCartney     McCartney  1963   \n",
       "5  Lennon-McCartney     McCartney  1967   \n",
       "6            Lennon        Lennon  1967   \n",
       "\n",
       "                                              Lyrics  \\\n",
       "1  Words are flowing out like endless rain into a...   \n",
       "2  Whenever I want you around yeh \\nAll I gotta d...   \n",
       "3  Close your eyes and I'll kiss you\\nTomorrow I'...   \n",
       "5  One two three four\\nCan I have a little more\\n...   \n",
       "6  Love, love, love\\nLove, love, love\\nLove, love...   \n",
       "\n",
       "                                               words  \n",
       "1  (Words, are, flowing, out, like, endless, rain...  \n",
       "2  (Whenever, I, want, you, around, yeh, \\n, All,...  \n",
       "3  (Close, your, eyes, and, I, 'll, kiss, you, \\n...  \n",
       "5  (One, two, three, four, \\n, Can, I, have, a, l...  \n",
       "6  (Love, ,, love, ,, love, \\n, Love, ,, love, ,,...  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import spacy\n",
    "\n",
    "# Petit réglage pour permettre d'écrire sur les données...\n",
    "# (sécurité panda)\n",
    "\n",
    "pd.options.mode.chained_assignment = None  # default='warn' (Cf. https://stackoverflow.com/questions/20625582/how-to-deal-with-settingwithcopywarning-in-pandas)\n",
    "\n",
    "corpus_test = corpus_clean_select\n",
    "\n",
    "corpus_test['words'] = corpus_test['Lyrics'].apply(lambda x: nlp.tokenizer(str(x)))\n",
    "# df['sents'] = df['text'].apply(lambda x: list(nlp(x).sents))\n",
    "# Réf : https://stackoverflow.com/questions/46981137/tokenizing-using-pandas-and-spacy\n",
    "\n",
    "# Note that nlp by default runs the entire SpaCy pipeline, which includes part-of-speech tagging, parsing and named entity recognition. You can significantly speed up your code by using nlp.tokenizer(x) instead of nlp(x), or by disabling parts of the pipeline when you load the model. E.g. nlp = spacy.load('en', parser=False, entity=False).\n",
    "\n",
    "# Transform data using spaCy\n",
    "# nlp = spacy.load(\"en_core_web_sm\")\n",
    "# WARNING: takes a long time!\n",
    "# corpus_test['words'] = corpus_test['Lyrics'].apply(lambda x: [sent.text for sent in nlp(x).sents])\n",
    "\n",
    "corpus_test.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>Song</th>\n",
       "      <th>Album Debut</th>\n",
       "      <th>Songwriter(s)</th>\n",
       "      <th>Lead Vocal(s)</th>\n",
       "      <th>Year</th>\n",
       "      <th>Lyrics</th>\n",
       "      <th>words</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>\"Across the Universe\"</td>\n",
       "      <td>Let It Be</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1968</td>\n",
       "      <td>Words are flowing out like endless rain into a...</td>\n",
       "      <td>Words</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>\"Across the Universe\"</td>\n",
       "      <td>Let It Be</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1968</td>\n",
       "      <td>Words are flowing out like endless rain into a...</td>\n",
       "      <td>are</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>\"Across the Universe\"</td>\n",
       "      <td>Let It Be</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1968</td>\n",
       "      <td>Words are flowing out like endless rain into a...</td>\n",
       "      <td>flowing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>\"Across the Universe\"</td>\n",
       "      <td>Let It Be</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1968</td>\n",
       "      <td>Words are flowing out like endless rain into a...</td>\n",
       "      <td>out</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>\"Across the Universe\"</td>\n",
       "      <td>Let It Be</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1968</td>\n",
       "      <td>Words are flowing out like endless rain into a...</td>\n",
       "      <td>like</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Song Album Debut Songwriter(s) Lead Vocal(s)  Year  \\\n",
       "0  \"Across the Universe\"   Let It Be        Lennon        Lennon  1968   \n",
       "1  \"Across the Universe\"   Let It Be        Lennon        Lennon  1968   \n",
       "2  \"Across the Universe\"   Let It Be        Lennon        Lennon  1968   \n",
       "3  \"Across the Universe\"   Let It Be        Lennon        Lennon  1968   \n",
       "4  \"Across the Universe\"   Let It Be        Lennon        Lennon  1968   \n",
       "\n",
       "                                              Lyrics    words  \n",
       "0  Words are flowing out like endless rain into a...    Words  \n",
       "1  Words are flowing out like endless rain into a...      are  \n",
       "2  Words are flowing out like endless rain into a...  flowing  \n",
       "3  Words are flowing out like endless rain into a...      out  \n",
       "4  Words are flowing out like endless rain into a...     like  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# https://towardsdatascience.com/tokenize-text-columns-into-sentences-in-pandas-2c08bc1ca790\n",
    "corpus_test = corpus_test.explode(\"words\", ignore_index=True)\n",
    "corpus_test.head()\n",
    "# The explode() function is used to transform each element of a list-like to a row, \n",
    "# replicating the index values. Returns: Series- Exploded lists to rows; index will \n",
    "\n",
    "# be duplicated for these rows."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "# À faire : téléchargement du modèle :   \n",
    "\n",
    "# python -m spacy download en_core_web_sm\n",
    "\n",
    "nlp = spacy.load(\"en_core_web_sm\")\n",
    "\n",
    "## Méthode :\n",
    "\n",
    "## Cf. https://stackoverflow.com/questions/44395656/applying-spacy-parser-to-pandas-dataframe-w-multiprocessing\n",
    "\n",
    "## Spacy is highly optimised and does the multiprocessing for you. \n",
    "## As a result, I think your best bet is to take the data out of \n",
    "## the Dataframe and pass it to the Spacy pipeline as a list rather \n",
    "## than trying to use .apply directly.\n",
    "## You then need to the collate the results of the parse, and put \n",
    "## this back into the Dataframe. \n",
    "\n",
    "lemma = []\n",
    "pos = []\n",
    "\n",
    "for doc in nlp.pipe(corpus_test['words'].astype('unicode').values, batch_size=50):\n",
    "    if doc.has_annotation(\"DEP\"):\n",
    "        #tokens.append([n.text for n in doc])\n",
    "        lemma.append([n.lemma_ for n in doc])\n",
    "        pos.append([n.pos_ for n in doc])\n",
    "    else:\n",
    "        # We want to make sure that the lists of parsed results have the\n",
    "        # same number of entries of the original Dataframe, so add some blanks in case the parse fails\n",
    "        # tokens.append(None)\n",
    "        lemma.append(None)\n",
    "        pos.append(None)\n",
    "        \n",
    "# corpus_test['tokens'] = tokens\n",
    "corpus_test['lemma'] = lemma\n",
    "corpus_test['pos'] = pos\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>Song</th>\n",
       "      <th>Album Debut</th>\n",
       "      <th>Songwriter(s)</th>\n",
       "      <th>Lead Vocal(s)</th>\n",
       "      <th>Year</th>\n",
       "      <th>Lyrics</th>\n",
       "      <th>words</th>\n",
       "      <th>lemma</th>\n",
       "      <th>pos</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>\"Across the Universe\"</td>\n",
       "      <td>Let It Be</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1968</td>\n",
       "      <td>Words are flowing out like endless rain into a...</td>\n",
       "      <td>Words</td>\n",
       "      <td>[word]</td>\n",
       "      <td>[NOUN]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>\"Across the Universe\"</td>\n",
       "      <td>Let It Be</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1968</td>\n",
       "      <td>Words are flowing out like endless rain into a...</td>\n",
       "      <td>are</td>\n",
       "      <td>[be]</td>\n",
       "      <td>[AUX]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>\"Across the Universe\"</td>\n",
       "      <td>Let It Be</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1968</td>\n",
       "      <td>Words are flowing out like endless rain into a...</td>\n",
       "      <td>flowing</td>\n",
       "      <td>[flow]</td>\n",
       "      <td>[VERB]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>\"Across the Universe\"</td>\n",
       "      <td>Let It Be</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1968</td>\n",
       "      <td>Words are flowing out like endless rain into a...</td>\n",
       "      <td>out</td>\n",
       "      <td>[out]</td>\n",
       "      <td>[ADP]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>\"Across the Universe\"</td>\n",
       "      <td>Let It Be</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1968</td>\n",
       "      <td>Words are flowing out like endless rain into a...</td>\n",
       "      <td>like</td>\n",
       "      <td>[like]</td>\n",
       "      <td>[INTJ]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Song Album Debut Songwriter(s) Lead Vocal(s)  Year  \\\n",
       "0  \"Across the Universe\"   Let It Be        Lennon        Lennon  1968   \n",
       "1  \"Across the Universe\"   Let It Be        Lennon        Lennon  1968   \n",
       "2  \"Across the Universe\"   Let It Be        Lennon        Lennon  1968   \n",
       "3  \"Across the Universe\"   Let It Be        Lennon        Lennon  1968   \n",
       "4  \"Across the Universe\"   Let It Be        Lennon        Lennon  1968   \n",
       "\n",
       "                                              Lyrics    words   lemma     pos  \n",
       "0  Words are flowing out like endless rain into a...    Words  [word]  [NOUN]  \n",
       "1  Words are flowing out like endless rain into a...      are    [be]   [AUX]  \n",
       "2  Words are flowing out like endless rain into a...  flowing  [flow]  [VERB]  \n",
       "3  Words are flowing out like endless rain into a...      out   [out]   [ADP]  \n",
       "4  Words are flowing out like endless rain into a...     like  [like]  [INTJ]  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Regard sur les données : \n",
    "\n",
    "corpus_test[0:5] "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "40756"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(corpus_test)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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>Song</th>\n",
       "      <th>Album Debut</th>\n",
       "      <th>Songwriter(s)</th>\n",
       "      <th>Lead Vocal(s)</th>\n",
       "      <th>Year</th>\n",
       "      <th>Lyrics</th>\n",
       "      <th>words</th>\n",
       "      <th>lemma</th>\n",
       "      <th>pos</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>40751</th>\n",
       "      <td>\"You've Got to Hide Your Love Away\"</td>\n",
       "      <td>Help!</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1965</td>\n",
       "      <td>Here I stand head in hand\\nTurn my face to the...</td>\n",
       "      <td>to</td>\n",
       "      <td>[to]</td>\n",
       "      <td>[ADP]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40752</th>\n",
       "      <td>\"You've Got to Hide Your Love Away\"</td>\n",
       "      <td>Help!</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1965</td>\n",
       "      <td>Here I stand head in hand\\nTurn my face to the...</td>\n",
       "      <td>hide</td>\n",
       "      <td>[hide]</td>\n",
       "      <td>[VERB]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40753</th>\n",
       "      <td>\"You've Got to Hide Your Love Away\"</td>\n",
       "      <td>Help!</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1965</td>\n",
       "      <td>Here I stand head in hand\\nTurn my face to the...</td>\n",
       "      <td>your</td>\n",
       "      <td>[your]</td>\n",
       "      <td>[PRON]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40754</th>\n",
       "      <td>\"You've Got to Hide Your Love Away\"</td>\n",
       "      <td>Help!</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1965</td>\n",
       "      <td>Here I stand head in hand\\nTurn my face to the...</td>\n",
       "      <td>love</td>\n",
       "      <td>[love]</td>\n",
       "      <td>[NOUN]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40755</th>\n",
       "      <td>\"You've Got to Hide Your Love Away\"</td>\n",
       "      <td>Help!</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>Lennon</td>\n",
       "      <td>1965</td>\n",
       "      <td>Here I stand head in hand\\nTurn my face to the...</td>\n",
       "      <td>away</td>\n",
       "      <td>[away]</td>\n",
       "      <td>[ADV]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      Song Album Debut Songwriter(s)  \\\n",
       "40751  \"You've Got to Hide Your Love Away\"       Help!        Lennon   \n",
       "40752  \"You've Got to Hide Your Love Away\"       Help!        Lennon   \n",
       "40753  \"You've Got to Hide Your Love Away\"       Help!        Lennon   \n",
       "40754  \"You've Got to Hide Your Love Away\"       Help!        Lennon   \n",
       "40755  \"You've Got to Hide Your Love Away\"       Help!        Lennon   \n",
       "\n",
       "      Lead Vocal(s)  Year                                             Lyrics  \\\n",
       "40751        Lennon  1965  Here I stand head in hand\\nTurn my face to the...   \n",
       "40752        Lennon  1965  Here I stand head in hand\\nTurn my face to the...   \n",
       "40753        Lennon  1965  Here I stand head in hand\\nTurn my face to the...   \n",
       "40754        Lennon  1965  Here I stand head in hand\\nTurn my face to the...   \n",
       "40755        Lennon  1965  Here I stand head in hand\\nTurn my face to the...   \n",
       "\n",
       "      words   lemma     pos  \n",
       "40751    to    [to]   [ADP]  \n",
       "40752  hide  [hide]  [VERB]  \n",
       "40753  your  [your]  [PRON]  \n",
       "40754  love  [love]  [NOUN]  \n",
       "40755  away  [away]   [ADV]  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Vérification qu'il n'y a pas de pb d'alignement entre words / lemma / pos\n",
    "corpus_test.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Analyse supervisée"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "data/songs_files/Lennon_Across-the-Universe.txt\n",
      "data/songs_files/Lennon_All-I've-Got-to-Do.txt\n",
      "data/songs_files/McCartney_All-My-Loving.txt\n",
      "data/songs_files/Lennon-McCartney_All-Together-Now.txt\n",
      "data/songs_files/Lennon_All-You-Need-Is-Love.txt\n",
      "data/songs_files/Lennon-McCartney_And-I-Love-Her.txt\n",
      "data/songs_files/Lennon-McCartney_And-Your-Bird-Can-Sing.txt\n",
      "data/songs_files/McCartney_Another-Girl.txt\n",
      "data/songs_files/Lennon-McCartney_Any-Time-at-All.txt\n",
      "data/songs_files/Lennon-McCartney_Ask-Me-Why.txt\n",
      "data/songs_files/Lennon-McCartney_Baby,-You're-a-Rich-Man.txt\n",
      "data/songs_files/Lennon-McCartney_Baby's-in-Black.txt\n",
      "data/songs_files/McCartney_Back-in-the-U.S.S.R..txt\n",
      "data/songs_files/Lennon_Bad-to-Me.txt\n",
      "data/songs_files/Lennon_The-Ballad-of-John-and-Yoko.txt\n",
      "data/songs_files/Lennon_Because.txt\n",
      "data/songs_files/Lennon-McCartney_Because-I-Know-You-Love-Me-So.txt\n",
      "data/songs_files/Lennon-McCartney_Being-for-the-Benefit-of-Mr.-Kite!.txt\n",
      "data/songs_files/Lennon-McCartney_Birthday.txt\n",
      "data/songs_files/McCartney_Blackbird.txt\n",
      "data/songs_files/McCartney_Can't-Buy-Me-Love.txt\n",
      "data/songs_files/McCartney_Carry-That-Weight.txt\n",
      "data/songs_files/Lennon_Child-of-Nature.txt\n",
      "data/songs_files/McCartney_Come-and-Get-It.txt\n",
      "data/songs_files/Lennon_Come-Together.txt\n",
      "data/songs_files/Lennon_The-Continuing-Story-of-Bungalow-Bill.txt\n",
      "data/songs_files/Lennon_Cry-Baby-Cry”.txt\n",
      "data/songs_files/Lennon-McCartney_A-Day-in-the-Life.txt\n",
      "data/songs_files/Lennon-McCartney_Day-Tripper.txt\n",
      "data/songs_files/Lennon_Dear-Prudence.txt\n",
      "data/songs_files/Lennon_Dig-a-Pony.txt\n",
      "data/songs_files/Lennon_Do-You-Want-to-Know-a-Secret?.txt\n",
      "data/songs_files/Lennon-McCartney_Doctor-Robert.txt\n",
      "data/songs_files/Lennon_Don't-Let-Me-Down.txt\n",
      "data/songs_files/Lennon-McCartney_Drive-My-Car.txt\n",
      "data/songs_files/Lennon-McCartney_Eight-Days-a-Week.txt\n",
      "data/songs_files/Lennon-McCartney_Eleanor-Rigby.txt\n",
      "data/songs_files/McCartney_The-End.txt\n",
      "data/songs_files/McCartney_Every-Little-Thing.txt\n",
      "data/songs_files/Lennon_Everybody's-Got-Something-to-Hide-Except-Me-and-My-Monkey.txt\n",
      "data/songs_files/McCartney_Fixing-a-Hole.txt\n",
      "data/songs_files/Lennon-McCartney_Fancy-My-Chances-with-You.txt\n",
      "data/songs_files/McCartney_The-Fool-on-the-Hill.txt\n",
      "data/songs_files/McCartney_For-No-One.txt\n",
      "data/songs_files/Lennon-McCartney_From-Me-to-You.txt\n",
      "data/songs_files/McCartney_Get-Back.txt\n",
      "data/songs_files/Lennon-McCartney_Getting-Better.txt\n",
      "data/songs_files/Lennon_Girl.txt\n",
      "data/songs_files/Lennon_Glass-Onion.txt\n",
      "data/songs_files/McCartney_Golden-Slumbers.txt\n",
      "data/songs_files/Lennon-McCartney_Good-Day-Sunshine.txt\n",
      "data/songs_files/Lennon_Good-Morning-Good-Morning.txt\n",
      "data/songs_files/Lennon_Good-Night.txt\n",
      "data/songs_files/McCartney_Got-to-Get-You-into-My-Life.txt\n",
      "data/songs_files/Lennon_Happiness-Is-a-Warm-Gun.txt\n",
      "data/songs_files/Lennon-McCartney_A-Hard-Day's-Night.txt\n",
      "data/songs_files/McCartney_Heather.txt\n",
      "data/songs_files/McCartney_Hello,-Goodbye.txt\n",
      "data/songs_files/Lennon_Hello-Little-Girl.txt\n",
      "data/songs_files/Lennon-McCartney_Help!.txt\n",
      "data/songs_files/McCartney_Helter-Skelter.txt\n",
      "data/songs_files/McCartney_Her-Majesty.txt\n",
      "data/songs_files/McCartney_Here,-There-and-Everywhere.txt\n",
      "data/songs_files/Lennon_Hey-Bulldog.txt\n",
      "data/songs_files/McCartney_Hey-Jude.txt\n",
      "data/songs_files/Lennon-McCartney_Hold-Me-Tight.txt\n",
      "data/songs_files/McCartney_Honey-Pie.txt\n",
      "data/songs_files/Lennon_I-Am-the-Walrus.txt\n",
      "data/songs_files/Lennon_I-Call-Your-Name.txt\n",
      "data/songs_files/Lennon_I-Don't-Want-to-Spoil-the-Party.txt\n",
      "data/songs_files/Lennon_I-Feel-Fine.txt\n",
      "data/songs_files/McCartney_I-Lost-My-Little-Girl.txt\n",
      "data/songs_files/Lennon-McCartney_I-Saw-Her-Standing-There.txt\n",
      "data/songs_files/Lennon_I-Should-Have-Known-Better.txt\n",
      "data/songs_files/Lennon-McCartney_I-Wanna-Be-Your-Man.txt\n",
      "data/songs_files/Lennon-McCartney_I-Want-to-Hold-Your-Hand.txt\n",
      "data/songs_files/Lennon_I-Want-You-(She's-So-Heavy).txt\n",
      "data/songs_files/McCartney_I-Will.txt\n",
      "data/songs_files/Lennon_If-I-Fell.txt\n",
      "data/songs_files/Lennon-McCartney_If-You've-Got-Trouble.txt\n",
      "data/songs_files/Lennon_I'll-Be-Back.txt\n",
      "data/songs_files/McCartney_I'll-Be-on-My-Way.txt\n",
      "data/songs_files/Lennon_I'll-Cry-Instead.txt\n",
      "data/songs_files/McCartney_I'll-Follow-the-Sun.txt\n",
      "data/songs_files/Lennon-McCartney_I'll-Get-You.txt\n",
      "data/songs_files/Lennon_I'm-a-Loser.txt\n",
      "data/songs_files/McCartney_I'm-Down.txt\n",
      "data/songs_files/Lennon-McCartney_I'm-Happy-Just-to-Dance-with-You.txt\n",
      "data/songs_files/Lennon_I'm-In-Love.txt\n",
      "data/songs_files/McCartney_I'm-Looking-Through-You.txt\n",
      "data/songs_files/Lennon_I'm-Only-Sleeping.txt\n",
      "data/songs_files/Lennon_I'm-So-Tired.txt\n",
      "data/songs_files/Lennon-McCartney_In-My-Life.txt\n",
      "data/songs_files/Lennon-McCartney_It-Won't-Be-Long.txt\n",
      "data/songs_files/Lennon_It's-Only-Love.txt\n",
      "data/songs_files/Lennon-McCartney_I've-Got-a-Feeling.txt\n",
      "data/songs_files/McCartney_I've-Just-Seen-a-Face.txt\n",
      "data/songs_files/Lennon_Julia.txt\n",
      "data/songs_files/McCartney_Junk.txt\n",
      "data/songs_files/Lennon-McCartney_Lady-Madonna.txt\n",
      "data/songs_files/McCartney_Let-It-Be.txt\n",
      "data/songs_files/McCartney_Like-Dreamers-Do.txt\n",
      "data/songs_files/Lennon-McCartney_Little-Child.txt\n",
      "data/songs_files/McCartney_The-Long-and-Winding-Road.txt\n",
      "data/songs_files/Lennon-McCartney_Love-Me-Do.txt\n",
      "data/songs_files/Lennon-McCartney_Love-of-the-Loved.txt\n",
      "data/songs_files/McCartney_Lovely-Rita.txt\n",
      "data/songs_files/Lennon-McCartney_Lucy-in-the-Sky-with-Diamonds.txt\n",
      "data/songs_files/Lennon-McCartney_Magical-Mystery-Tour.txt\n",
      "data/songs_files/McCartney_Martha-My-Dear.txt\n",
      "data/songs_files/McCartney_Maxwell's-Silver-Hammer.txt\n",
      "data/songs_files/Lennon_Mean-Mr.-Mustard.txt\n",
      "data/songs_files/Lennon-McCartney_Michelle.txt\n",
      "data/songs_files/Lennon-McCartney_Misery.txt\n",
      "data/songs_files/McCartney_Mother-Nature's-Son.txt\n",
      "data/songs_files/McCartney_The-Night-Before.txt\n",
      "data/songs_files/Lennon-McCartney_No-Reply.txt\n",
      "data/songs_files/Lennon-McCartney_Norwegian-Wood-(This-Bird-Has-Flown).txt\n",
      "data/songs_files/Lennon_Not-a-Second-Time.txt\n",
      "data/songs_files/Lennon-McCartney_Nowhere-Man.txt\n",
      "data/songs_files/McCartney_Ob-La-Di,-Ob-La-Da.txt\n",
      "data/songs_files/McCartney_Oh!-Darling.txt\n",
      "data/songs_files/Lennon_One-After-909.txt\n",
      "data/songs_files/McCartney_One-and-One-Is-Two.txt\n",
      "data/songs_files/McCartney_Paperback-Writer.txt\n",
      "data/songs_files/McCartney_Penny-Lane.txt\n",
      "data/songs_files/Lennon_Please-Please-Me.txt\n",
      "data/songs_files/Lennon_Polythene-Pam.txt\n",
      "data/songs_files/Lennon-McCartney_P.S.-I-Love-You.txt\n",
      "data/songs_files/Lennon_Rain.txt\n",
      "data/songs_files/Lennon_Real-Love.txt\n",
      "data/songs_files/Lennon_Revolution.txt\n",
      "data/songs_files/Lennon-McCartney_Rocky-Raccoon.txt\n",
      "data/songs_files/Lennon-McCartney_Run-for-Your-Life.txt\n",
      "data/songs_files/Lennon_Sexy-Sadie.txt\n",
      "data/songs_files/McCartney_Sgt.-Pepper's-Lonely-Hearts-Club-Band.txt\n",
      "data/songs_files/McCartney_Sgt.-Pepper's-Lonely-Hearts-Club-Band-(Reprise).txt\n",
      "data/songs_files/McCartney_She-Came-in-Through-the-Bathroom-Window.txt\n",
      "data/songs_files/Lennon-McCartney_She-Loves-You.txt\n",
      "data/songs_files/Lennon_She-Said-She-Said.txt\n",
      "data/songs_files/Lennon-McCartney_She's-a-Woman.txt\n",
      "data/songs_files/Lennon-McCartney_She's-Leaving-Home.txt\n",
      "data/songs_files/Lennon_Strawberry-Fields-Forever.txt\n",
      "data/songs_files/Lennon_Sun-King.txt\n",
      "data/songs_files/McCartney_Teddy-Boy.txt\n",
      "data/songs_files/Lennon-McCartney_Tell-Me-What-You-See.txt\n",
      "data/songs_files/Lennon_Tell-Me-Why.txt\n",
      "data/songs_files/Lennon-McCartney_Thank-You-Girl.txt\n",
      "data/songs_files/McCartney_That-Means-a-Lot.txt\n",
      "data/songs_files/Lennon-McCartney_There's-a-Place.txt\n",
      "data/songs_files/McCartney_Things-We-Said-Today.txt\n",
      "data/songs_files/Lennon_This-Boy.txt\n",
      "data/songs_files/Lennon_Ticket-to-Ride.txt\n",
      "data/songs_files/Lennon_Tomorrow-Never-Knows.txt\n",
      "data/songs_files/McCartney_Two-of-Us.txt\n",
      "data/songs_files/Lennon-McCartney_Wait.txt\n",
      "data/songs_files/Lennon-McCartney_Watching-Rainbows.txt\n",
      "data/songs_files/Lennon-McCartney_We-Can-Work-It-Out.txt\n",
      "data/songs_files/McCartney_What-You're-Doing.txt\n",
      "data/songs_files/Lennon_What's-The-New-Mary-Jane.txt\n",
      "data/songs_files/Lennon_When-I-Get-Home.txt\n",
      "data/songs_files/McCartney_When-I'm-Sixty-Four.txt\n",
      "data/songs_files/McCartney_Why-Don't-We-Do-It-in-the-Road?.txt\n",
      "data/songs_files/McCartney_Wild-Honey-Pie.txt\n",
      "data/songs_files/Lennon-McCartney_With-a-Little-Help-from-My-Friends.txt\n",
      "data/songs_files/McCartney_Woman.txt\n",
      "data/songs_files/Lennon-McCartney_The-Word.txt\n",
      "data/songs_files/Lennon-McCartney_Yellow-Submarine.txt\n",
      "data/songs_files/Lennon_Yer-Blues.txt\n",
      "data/songs_files/Lennon_Yes-It-Is.txt\n",
      "data/songs_files/McCartney_Yesterday.txt\n",
      "data/songs_files/Lennon_You-Can't-Do-That.txt\n",
      "data/songs_files/Lennon-McCartney_You-Know-My-Name-(Look-Up-the-Number).txt\n",
      "data/songs_files/McCartney_You-Never-Give-Me-Your-Money.txt\n",
      "data/songs_files/McCartney_You-Won't-See-Me.txt\n",
      "data/songs_files/Lennon-McCartney_You'll-Be-Mine.txt\n",
      "data/songs_files/McCartney_Your-Mother-Should-Know.txt\n",
      "data/songs_files/Lennon_You're-Going-to-Lose-That-Girl.txt\n",
      "data/songs_files/Lennon_You've-Got-to-Hide-Your-Love-Away.txt\n"
     ]
    }
   ],
   "source": [
    "# Turning the corpus into the expected format for our functions\n",
    "import jagen_will.preproc.tuyau as tuy\n",
    "import jagen_will.preproc.features_extract as fex\n",
    "from jagen_will.preproc.text_count import count_process\n",
    "\n",
    "myTexts = []\n",
    "    \n",
    "# extract features\n",
    "\n",
    "#for index, row in corpus_clean_select.iterrows():\n",
    "#    if isinstance(row[\"Lyrics\"], str) and row[\"Lyrics\"] is not \"\":\n",
    "#        myTexts.append({\"name\": row[\"Song\"], \"aut\": row[\"Songwriter(s)\"], \"text\": tuy.normalise(row[\"Lyrics\"]), \"lang\": 'en'})\n",
    "\n",
    "        \n",
    "### HACK: j'écris les données dont on a besoin pour l'usage tradi du module\n",
    "for index, row in corpus_clean_select.iterrows():\n",
    "    if isinstance(row[\"Lyrics\"], str) and row[\"Lyrics\"] is not \"\":\n",
    "        print(\"data/songs_files/\"+row[\"Songwriter(s)\"]+\"_\"+row[\"Song\"].replace('\"', '').replace(' ','-')+'.txt')\n",
    "        with open(\"data/songs_files/\"+row[\"Songwriter(s)\"]+\"_\"+row[\"Song\"].replace('\"', '').replace(' ','-')+'.txt', 'w') as f:\n",
    "            f.write(row[\"Lyrics\"])\n",
    "        \n",
    "#        with open(\"\")\n",
    "        \n",
    "#        myTexts.append({\"name\": row[\"Song\"], \"aut\": row[\"Songwriter(s)\"], \"text\": tuy.normalise(row[\"Lyrics\"]), \"lang\": 'en'})\n",
    "\n",
    "# Now, you can use the CLI for jagen_will…\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Song                                                \"Cry Baby Cry”\n",
       "Album Debut                                            The Beatles\n",
       "Songwriter(s)                                               Lennon\n",
       "Lead Vocal(s)                            Lennon\\n (with McCartney)\n",
       "Year                                                          1968\n",
       "Lyrics           Cry baby cry\\nMake your mother sigh\\nShe's old...\n",
       "Name: 32, dtype: object"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#corpus_clean_select.iloc[27]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [],
   "source": [
    "#myTexts\n",
    "# corpus_clean_select\n",
    "my_feats = fex.get_feature_list(myTexts, feats='chars', n=3, relFreqs=True)\n",
    "feat_list = [m[0] for m in my_feats]\n",
    "myTexts = fex.get_counts(myTexts, feat_list=feat_list, feats=\"chars\", n=3, relFreqs=True)\n",
    "unique_texts = [text[\"name\"] for text in myTexts]\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "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.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}