Traduction_News_EN-FR.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "#!pip install googletrans"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {
    "scrolled": true
   },
   "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>0</th>\n",
       "      <th>1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1410</th>\n",
       "      <td>Reunited Police to start world tour in May</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1411</th>\n",
       "      <td>Turkmen acting leader sworn in as new president</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1412</th>\n",
       "      <td>Allen and Okur get All-Star call</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1413</th>\n",
       "      <td>Svindal claims are golden double</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1414</th>\n",
       "      <td>Trolley Square shooting leaves 6 dead, includi...</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1415</th>\n",
       "      <td>Bridge blast stops I-95 traffic</td>\n",
       "      <td>fear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1416</th>\n",
       "      <td>Mother, daughter stabbed near school</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1417</th>\n",
       "      <td>Excerpt: Politicians and the press</td>\n",
       "      <td>disgust</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1418</th>\n",
       "      <td>North Korea gets 'money and respect'</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1419</th>\n",
       "      <td>Beyonce in a bikini as SI's swimsuit cover model</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1420</th>\n",
       "      <td>Loving with all your ... brain</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421</th>\n",
       "      <td>Shoplifters' choice: Police or T-shirt of shame</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1422</th>\n",
       "      <td>Cuban official: Web a 'wild colt'</td>\n",
       "      <td>fear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1423</th>\n",
       "      <td>Slow 'Music and Lyrics'</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1424</th>\n",
       "      <td>Mexican navy helps in hunt for U.S. engineer</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1425</th>\n",
       "      <td>Smith baby may not be pot of gold</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1426</th>\n",
       "      <td>Latest updates on world's top stories</td>\n",
       "      <td>fear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1427</th>\n",
       "      <td>Beating leaves teen in coma</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1428</th>\n",
       "      <td>Tiempo Libre has Grammy dreams</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1429</th>\n",
       "      <td>GPS sneakers locate with press of a button</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1430</th>\n",
       "      <td>Embattled Edwards blogger quits campaign</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1431</th>\n",
       "      <td>Britons deported from Somalia held under Terro...</td>\n",
       "      <td>fear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1432</th>\n",
       "      <td>Updates on world's top stories</td>\n",
       "      <td>fear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1433</th>\n",
       "      <td>Breast cancer drug promises hope</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1434</th>\n",
       "      <td>Ancient coin shows Cleopatra was no beauty</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1435</th>\n",
       "      <td>YouTube yields surprising payback</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1436</th>\n",
       "      <td>Up to 22 inches of snow in forecast</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1437</th>\n",
       "      <td>Werder make 10-man Ajax pay price</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1438</th>\n",
       "      <td>EU condemns 'illegal' CIA flights</td>\n",
       "      <td>anger</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1439</th>\n",
       "      <td>Report links humans to global warming</td>\n",
       "      <td>fear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1470</th>\n",
       "      <td>Frantic 911 call in Ryan O'Neal case</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1471</th>\n",
       "      <td>Durant's success trumps the Gators</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1472</th>\n",
       "      <td>Scientist snoops in astronauts' journals</td>\n",
       "      <td>disgust</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1473</th>\n",
       "      <td>YouTube founders split $650M payout</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1474</th>\n",
       "      <td>African nation hopes Whoopi can help</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1475</th>\n",
       "      <td>United hang on to six-point lead</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1476</th>\n",
       "      <td>Lawyer seizes Smith's Bahamas home</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1477</th>\n",
       "      <td>Was Prince's super show too revealing?</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1478</th>\n",
       "      <td>Clijsters looks for a long goodbye</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1479</th>\n",
       "      <td>Snow's too deep even for snowmobiles</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1480</th>\n",
       "      <td>Study: Female seals picky about mates</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1481</th>\n",
       "      <td>ROUNDUP: Protests erupt despite \"state of sieg...</td>\n",
       "      <td>anger</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1482</th>\n",
       "      <td>Study: More kids exposed to online porn</td>\n",
       "      <td>disgust</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1483</th>\n",
       "      <td>Beyonce new SI bikini cover girl</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1484</th>\n",
       "      <td>Marijuana helps ease HIV nerve pain, study says</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1485</th>\n",
       "      <td>Serena misses Bangalore tournament</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1486</th>\n",
       "      <td>Dryer blamed for fire killing 39 cats, dogs</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1487</th>\n",
       "      <td>Roddick, Murray score in San Jose</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1488</th>\n",
       "      <td>Apple trademark dispute settled</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1489</th>\n",
       "      <td>U.S. online love brokers eye China</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1490</th>\n",
       "      <td>U.S. diverts troops to fight Taliban</td>\n",
       "      <td>anger</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1491</th>\n",
       "      <td>'House of Cards' actor Ian Richardson dead</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1492</th>\n",
       "      <td>Taliban leader killed in airstrike</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1493</th>\n",
       "      <td>Escape to Prague without the summer hordes</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1494</th>\n",
       "      <td>Kathmandu: First snow in 63 years</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1495</th>\n",
       "      <td>Nasdaq fails in bid for LSE</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1496</th>\n",
       "      <td>Ex-pastor gets death sentence</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1497</th>\n",
       "      <td>Baby born on turnpike after dad misses exit</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1498</th>\n",
       "      <td>Study links chimps and 'hammers'</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1499</th>\n",
       "      <td>UN-Google Earth map climate change</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>90 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                      0         1\n",
       "1410         Reunited Police to start world tour in May       joy\n",
       "1411    Turkmen acting leader sworn in as new president       joy\n",
       "1412                   Allen and Okur get All-Star call       joy\n",
       "1413                   Svindal claims are golden double       joy\n",
       "1414  Trolley Square shooting leaves 6 dead, includi...   sadness\n",
       "1415                    Bridge blast stops I-95 traffic      fear\n",
       "1416               Mother, daughter stabbed near school   sadness\n",
       "1417                 Excerpt: Politicians and the press   disgust\n",
       "1418               North Korea gets 'money and respect'       joy\n",
       "1419   Beyonce in a bikini as SI's swimsuit cover model       joy\n",
       "1420                     Loving with all your ... brain  surprise\n",
       "1421    Shoplifters' choice: Police or T-shirt of shame  surprise\n",
       "1422                  Cuban official: Web a 'wild colt'      fear\n",
       "1423                            Slow 'Music and Lyrics'       joy\n",
       "1424       Mexican navy helps in hunt for U.S. engineer       joy\n",
       "1425                  Smith baby may not be pot of gold   sadness\n",
       "1426              Latest updates on world's top stories      fear\n",
       "1427                        Beating leaves teen in coma   sadness\n",
       "1428                     Tiempo Libre has Grammy dreams       joy\n",
       "1429         GPS sneakers locate with press of a button  surprise\n",
       "1430           Embattled Edwards blogger quits campaign   sadness\n",
       "1431  Britons deported from Somalia held under Terro...      fear\n",
       "1432                     Updates on world's top stories      fear\n",
       "1433                   Breast cancer drug promises hope       joy\n",
       "1434         Ancient coin shows Cleopatra was no beauty  surprise\n",
       "1435                  YouTube yields surprising payback  surprise\n",
       "1436                Up to 22 inches of snow in forecast  surprise\n",
       "1437                  Werder make 10-man Ajax pay price       joy\n",
       "1438                  EU condemns 'illegal' CIA flights     anger\n",
       "1439              Report links humans to global warming      fear\n",
       "...                                                 ...       ...\n",
       "1470               Frantic 911 call in Ryan O'Neal case  surprise\n",
       "1471                 Durant's success trumps the Gators       joy\n",
       "1472           Scientist snoops in astronauts' journals   disgust\n",
       "1473                YouTube founders split $650M payout       joy\n",
       "1474               African nation hopes Whoopi can help       joy\n",
       "1475                   United hang on to six-point lead       joy\n",
       "1476                 Lawyer seizes Smith's Bahamas home   sadness\n",
       "1477             Was Prince's super show too revealing?  surprise\n",
       "1478                 Clijsters looks for a long goodbye   sadness\n",
       "1479               Snow's too deep even for snowmobiles  surprise\n",
       "1480              Study: Female seals picky about mates  surprise\n",
       "1481  ROUNDUP: Protests erupt despite \"state of sieg...     anger\n",
       "1482            Study: More kids exposed to online porn   disgust\n",
       "1483                   Beyonce new SI bikini cover girl       joy\n",
       "1484    Marijuana helps ease HIV nerve pain, study says  surprise\n",
       "1485                 Serena misses Bangalore tournament   sadness\n",
       "1486        Dryer blamed for fire killing 39 cats, dogs   sadness\n",
       "1487                  Roddick, Murray score in San Jose       joy\n",
       "1488                    Apple trademark dispute settled       joy\n",
       "1489                 U.S. online love brokers eye China   sadness\n",
       "1490               U.S. diverts troops to fight Taliban     anger\n",
       "1491         'House of Cards' actor Ian Richardson dead   sadness\n",
       "1492                 Taliban leader killed in airstrike   sadness\n",
       "1493         Escape to Prague without the summer hordes       joy\n",
       "1494                  Kathmandu: First snow in 63 years  surprise\n",
       "1495                        Nasdaq fails in bid for LSE   sadness\n",
       "1496                      Ex-pastor gets death sentence   sadness\n",
       "1497        Baby born on turnpike after dad misses exit  surprise\n",
       "1498                   Study links chimps and 'hammers'  surprise\n",
       "1499                 UN-Google Earth map climate change       joy\n",
       "\n",
       "[90 rows x 2 columns]"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#loadDEFT2015()\n",
    "df_en = pd.read_pickle(\"data/SemEval_EN.p\")\n",
    "df_en[910:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "#!pip install goslate\n",
    "#import goslate\n",
    "#gs = goslate.Goslate()\n",
    "#print(gs.translate('hello world', 'fr'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "from googletrans import Translator\n",
    "\n",
    "translator = Translator()\n",
    "\n",
    "#print(len('hello.'))\n",
    "#translated_text = translator.translate('hello', src='en', dest='fr')\n",
    "#print(translated_text.text)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "#df_fr['texte'] = translator.translate(df_en[0], dest='fr').text\n",
    "\n",
    "#print(translator.translate(x[0], dest='fr').text)\n",
    "#print(translator.translate(x[1], dest='fr').text)\n",
    "\n",
    "#for t in df_en[0]:\n",
    "   # translated_text = translator.translate('hello.', src='en', dest='fr')\n",
    "   # print(t)\n",
    "    #df_fr.append({'texte': }, ignore_index=True)\n",
    "#df_fr['sentiment'] = [translator.translate(x, dest='fr').text for x in df_en[1]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Chef turkmène par intérim prêté serment comme nouveau président\n",
      "joie\n",
      "Allen et Okur reçoivent l'appel des étoiles\n",
      "joie\n",
      "Svindal prétend être double d'or\n",
      "joie\n",
      "La fusillade de Trolley Square laisse 6 morts, dont un homme armé\n",
      "tristesse\n",
      "Une explosion de pont arrête le trafic I-95\n",
      "peur\n",
      "Mère et fille poignardées près de l'école\n",
      "tristesse\n",
      "Extrait: Les politiciens et la presse\n",
      "dégoûter\n",
      "La Corée du Nord obtient de l'argent et du respect\n",
      "joie\n",
      "Beyonce en bikini comme modèle de maillot de bain pour SI\n",
      "joie\n",
      "Aimer de tout ton ... cerveau\n",
      "surprise\n",
      "Choix des voleurs à l'étalage: police ou t-shirt de honte\n",
      "surprise\n",
      "Un responsable cubain: un \"poulain sauvage\" sur le Web\n",
      "peur\n",
      "Slow 'Musique et Paroles'\n",
      "joie\n",
      "La marine mexicaine aide à la recherche d'un ingénieur américain\n",
      "joie\n",
      "Bébé Smith ne peut pas être pot d'or\n",
      "tristesse\n",
      "Dernières mises à jour sur les meilleures histoires du monde\n",
      "peur\n",
      "Battre laisse l'adolescent dans le coma\n",
      "tristesse\n",
      "Le temps libre a des rêves Grammy\n",
      "joie\n",
      "Baskets GPS localiser avec la pression d'un bouton\n",
      "surprise\n",
      "Le blogueur Edwards en difficulté quitte la campagne\n",
      "tristesse\n",
      "Des Britanniques déportés de Somalie détenus en vertu de la loi sur le terrorisme\n",
      "peur\n",
      "Mises à jour sur les meilleures histoires du monde\n",
      "peur\n",
      "Un médicament contre le cancer du sein promet de l'espoir\n",
      "joie\n",
      "Une ancienne pièce de monnaie montre que Cléopâtre n'était pas une beauté\n",
      "surprise\n",
      "YouTube rapporte des retours surprenants\n",
      "surprise\n",
      "Jusqu'à 22 pouces de neige en prévision\n",
      "surprise\n",
      "Werder fait le prix du prix de l'Ajax à 10 hommes\n",
      "joie\n",
      "Je condamne les vols \"illégaux\" de la CIA\n",
      "colère\n",
      "Un rapport établit un lien entre l'homme et le réchauffement climatique\n",
      "peur\n",
      "UN nuclear watchdog slashes Iran aid\n",
      "colère\n",
      "Enquête: Tech est un outil pour abuser des adolescents\n",
      "tristesse\n",
      "La percée du cancer du sein sauve 1000 femmes par an\n",
      "joie\n",
      "Le spot touristique résiste à la gravité mais ne progresse\n",
      "tristesse\n",
      "Les 20 plus gros agents libres potentiels de la NFL\n",
      "joie\n",
      "Le tourisme mondial établit un record en 2006\n",
      "joie\n",
      "BA facturera 470 $ pour un sac supplémentaire\n",
      "surprise\n",
      "Kuerten revient dans le cercle des gagnants\n",
      "joie\n",
      "Le plus ancien journal du monde n'existe plus qu'en ligne\n",
      "surprise\n",
      "Baleinier japonais en feu en Antarctique\n",
      "tristesse\n",
      "EU document: Iranian bomb unstoppable\n",
      "peur\n",
      "Les États-Unis sont invités à mener des actions «vertes»\n",
      "joie\n",
      "Voyez si votre ville fait partie des 10 États américains les plus en forme\n",
      "surprise\n",
      "Lee fait peur aux blessés avant la Coupe du Monde\n",
      "peur\n",
      "Un nouveau médicament contre le cancer pour sauver mille vies par an\n",
      "joie\n",
      "Ex-enseignant coupable en matière de nu-images\n",
      "dégoûter\n",
      "Extincteur faisant partie du kit d'exécution du Tennessee\n",
      "surprise\n",
      "Le fondateur revient à la barre de Dell\n",
      "joie\n",
      "Charles Gibson prend la première place\n",
      "joie\n",
      "Un ancien agent de la patrouille des frontières battu en prison\n",
      "tristesse\n",
      "'Made in China' irrite certains acheteurs de Burberry\n",
      "colère\n",
      "Le village des travailleurs de Stonehenge trouvé\n",
      "surprise\n",
      "Qui est le prince Frédéric d'Anhalt?\n",
      "surprise\n",
      "Dernières mange de la nourriture - «pommes de terre de l'espace»\n",
      "surprise\n",
      "L'Ethiopie se prépare pour son millénaire\n",
      "joie\n",
      "Bonne nouvelle pour les fainéants: les siestes peuvent réduire les risques de problèmes cardiaques\n",
      "joie\n",
      "Les Snowbirds raccourcissent leurs séjours en Floride\n",
      "tristesse\n",
      "Gagnez un rendez-vous avec la police\n",
      "joie\n",
      "La neige commence, de fortes accumulations sont attendues\n",
      "peur\n",
      "Jet secoue dans la tempête de neige, aucun mort\n",
      "joie\n",
      "Appel frénétique au 911 dans l'affaire Ryan O'Neal\n",
      "surprise\n",
      "Le succès de Durant l'emporte sur les Gators\n",
      "joie\n",
      "Un scientifique fouine dans le journal des astronautes\n",
      "dégoûter\n",
      "Les fondateurs de YouTube ont partagé 650 millions de dollars\n",
      "joie\n",
      "Une nation africaine espère que Whoopi pourra aider\n",
      "joie\n",
      "United s'accrocher à six points d'avance\n",
      "joie\n",
      "Un avocat s'empare de la maison de Smith aux Bahamas\n",
      "tristesse\n",
      "Le super show de Prince était-il trop révélateur?\n",
      "surprise\n",
      "Clijsters cherche un long au revoir\n",
      "tristesse\n",
      "La neige est trop profonde même pour les motoneiges\n",
      "surprise\n",
      "Étude: Les phoques sont difficiles au sujet des partenaires\n",
      "surprise\n",
      "ROUNDUP: Des manifestations éclatent malgré \"l'état de siège\" en Guinée\n",
      "colère\n",
      "Étude: Plus d'enfants exposés au porno en ligne\n",
      "dégoûter\n",
      "Beyonce nouvelle SI cover girl bikini\n",
      "joie\n",
      "La marijuana aide à soulager la douleur nerveuse liée au VIH, selon une étude\n",
      "surprise\n",
      "Serena manque le tournoi de Bangalore\n",
      "tristesse\n",
      "Une sécheuse responsable du feu tuant 39 chats et chiens\n",
      "tristesse\n",
      "Roddick et Murray marquent à San Jose\n",
      "joie\n",
      "Conflit de marque Apple réglé\n",
      "joie\n",
      "Les courtiers en ligne américains regardent la Chine\n",
      "tristesse\n",
      "Les États-Unis détournent des troupes pour combattre les talibans\n",
      "colère\n",
      "Décès de Ian Richardson, acteur de 'House of Cards'\n",
      "tristesse\n",
      "Un chef taliban tué dans une frappe aérienne\n",
      "tristesse\n",
      "S'échapper à Prague sans les hordes d'été\n",
      "joie\n",
      "Katmandou: première neige en 63 ans\n",
      "surprise\n",
      "Nasdaq échoue dans l'offre de LSE\n",
      "tristesse\n",
      "Un ex-pasteur condamné à mort\n",
      "tristesse\n",
      "Un bébé né sur un péage après que papa soit absent\n",
      "surprise\n",
      "Etude des liens chimpanzés et 'marteaux'\n",
      "surprise\n",
      "UN-Google Earth map climate change\n",
      "joie\n"
     ]
    },
    {
     "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>sentiment</th>\n",
       "      <th>text</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>joie</td>\n",
       "      <td>Chef turkmène par intérim prêté serment comme ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>joie</td>\n",
       "      <td>Allen et Okur reçoivent l'appel des étoiles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>joie</td>\n",
       "      <td>Svindal prétend être double d'or</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>La fusillade de Trolley Square laisse 6 morts,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>peur</td>\n",
       "      <td>Une explosion de pont arrête le trafic I-95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Mère et fille poignardées près de l'école</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>dégoûter</td>\n",
       "      <td>Extrait: Les politiciens et la presse</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>joie</td>\n",
       "      <td>La Corée du Nord obtient de l'argent et du res...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>joie</td>\n",
       "      <td>Beyonce en bikini comme modèle de maillot de b...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Aimer de tout ton ... cerveau</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Choix des voleurs à l'étalage: police ou t-shi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>peur</td>\n",
       "      <td>Un responsable cubain: un \"poulain sauvage\" su...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>joie</td>\n",
       "      <td>Slow 'Musique et Paroles'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>joie</td>\n",
       "      <td>La marine mexicaine aide à la recherche d'un i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Bébé Smith ne peut pas être pot d'or</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>peur</td>\n",
       "      <td>Dernières mises à jour sur les meilleures hist...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Battre laisse l'adolescent dans le coma</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>joie</td>\n",
       "      <td>Le temps libre a des rêves Grammy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Baskets GPS localiser avec la pression d'un bo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Le blogueur Edwards en difficulté quitte la ca...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>peur</td>\n",
       "      <td>Des Britanniques déportés de Somalie détenus e...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>peur</td>\n",
       "      <td>Mises à jour sur les meilleures histoires du m...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>joie</td>\n",
       "      <td>Un médicament contre le cancer du sein promet ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Une ancienne pièce de monnaie montre que Cléop...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>surprise</td>\n",
       "      <td>YouTube rapporte des retours surprenants</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Jusqu'à 22 pouces de neige en prévision</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>joie</td>\n",
       "      <td>Werder fait le prix du prix de l'Ajax à 10 hommes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>colère</td>\n",
       "      <td>Je condamne les vols \"illégaux\" de la CIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>peur</td>\n",
       "      <td>Un rapport établit un lien entre l'homme et le...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>colère</td>\n",
       "      <td>UN nuclear watchdog slashes Iran aid</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Appel frénétique au 911 dans l'affaire Ryan O'...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>joie</td>\n",
       "      <td>Le succès de Durant l'emporte sur les Gators</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>dégoûter</td>\n",
       "      <td>Un scientifique fouine dans le journal des ast...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>joie</td>\n",
       "      <td>Les fondateurs de YouTube ont partagé 650 mill...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>joie</td>\n",
       "      <td>Une nation africaine espère que Whoopi pourra ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>joie</td>\n",
       "      <td>United s'accrocher à six points d'avance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Un avocat s'empare de la maison de Smith aux B...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Le super show de Prince était-il trop révélateur?</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Clijsters cherche un long au revoir</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>surprise</td>\n",
       "      <td>La neige est trop profonde même pour les moton...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Étude: Les phoques sont difficiles au sujet de...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>colère</td>\n",
       "      <td>ROUNDUP: Des manifestations éclatent malgré \"l...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>dégoûter</td>\n",
       "      <td>Étude: Plus d'enfants exposés au porno en ligne</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>joie</td>\n",
       "      <td>Beyonce nouvelle SI cover girl bikini</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>surprise</td>\n",
       "      <td>La marijuana aide à soulager la douleur nerveu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Serena manque le tournoi de Bangalore</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Une sécheuse responsable du feu tuant 39 chats...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>joie</td>\n",
       "      <td>Roddick et Murray marquent à San Jose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>joie</td>\n",
       "      <td>Conflit de marque Apple réglé</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Les courtiers en ligne américains regardent la...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>colère</td>\n",
       "      <td>Les États-Unis détournent des troupes pour com...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Décès de Ian Richardson, acteur de 'House of C...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Un chef taliban tué dans une frappe aérienne</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>joie</td>\n",
       "      <td>S'échapper à Prague sans les hordes d'été</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Katmandou: première neige en 63 ans</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Nasdaq échoue dans l'offre de LSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Un ex-pasteur condamné à mort</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Un bébé né sur un péage après que papa soit ab...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Etude des liens chimpanzés et 'marteaux'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>joie</td>\n",
       "      <td>UN-Google Earth map climate change</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>89 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    sentiment                                               text\n",
       "0        joie  Chef turkmène par intérim prêté serment comme ...\n",
       "1        joie        Allen et Okur reçoivent l'appel des étoiles\n",
       "2        joie                   Svindal prétend être double d'or\n",
       "3   tristesse  La fusillade de Trolley Square laisse 6 morts,...\n",
       "4        peur        Une explosion de pont arrête le trafic I-95\n",
       "5   tristesse          Mère et fille poignardées près de l'école\n",
       "6    dégoûter              Extrait: Les politiciens et la presse\n",
       "7        joie  La Corée du Nord obtient de l'argent et du res...\n",
       "8        joie  Beyonce en bikini comme modèle de maillot de b...\n",
       "9    surprise                      Aimer de tout ton ... cerveau\n",
       "10   surprise  Choix des voleurs à l'étalage: police ou t-shi...\n",
       "11       peur  Un responsable cubain: un \"poulain sauvage\" su...\n",
       "12       joie                          Slow 'Musique et Paroles'\n",
       "13       joie  La marine mexicaine aide à la recherche d'un i...\n",
       "14  tristesse               Bébé Smith ne peut pas être pot d'or\n",
       "15       peur  Dernières mises à jour sur les meilleures hist...\n",
       "16  tristesse            Battre laisse l'adolescent dans le coma\n",
       "17       joie                  Le temps libre a des rêves Grammy\n",
       "18   surprise  Baskets GPS localiser avec la pression d'un bo...\n",
       "19  tristesse  Le blogueur Edwards en difficulté quitte la ca...\n",
       "20       peur  Des Britanniques déportés de Somalie détenus e...\n",
       "21       peur  Mises à jour sur les meilleures histoires du m...\n",
       "22       joie  Un médicament contre le cancer du sein promet ...\n",
       "23   surprise  Une ancienne pièce de monnaie montre que Cléop...\n",
       "24   surprise           YouTube rapporte des retours surprenants\n",
       "25   surprise            Jusqu'à 22 pouces de neige en prévision\n",
       "26       joie  Werder fait le prix du prix de l'Ajax à 10 hommes\n",
       "27     colère          Je condamne les vols \"illégaux\" de la CIA\n",
       "28       peur  Un rapport établit un lien entre l'homme et le...\n",
       "29     colère               UN nuclear watchdog slashes Iran aid\n",
       "..        ...                                                ...\n",
       "59   surprise  Appel frénétique au 911 dans l'affaire Ryan O'...\n",
       "60       joie       Le succès de Durant l'emporte sur les Gators\n",
       "61   dégoûter  Un scientifique fouine dans le journal des ast...\n",
       "62       joie  Les fondateurs de YouTube ont partagé 650 mill...\n",
       "63       joie  Une nation africaine espère que Whoopi pourra ...\n",
       "64       joie           United s'accrocher à six points d'avance\n",
       "65  tristesse  Un avocat s'empare de la maison de Smith aux B...\n",
       "66   surprise  Le super show de Prince était-il trop révélateur?\n",
       "67  tristesse                Clijsters cherche un long au revoir\n",
       "68   surprise  La neige est trop profonde même pour les moton...\n",
       "69   surprise  Étude: Les phoques sont difficiles au sujet de...\n",
       "70     colère  ROUNDUP: Des manifestations éclatent malgré \"l...\n",
       "71   dégoûter    Étude: Plus d'enfants exposés au porno en ligne\n",
       "72       joie              Beyonce nouvelle SI cover girl bikini\n",
       "73   surprise  La marijuana aide à soulager la douleur nerveu...\n",
       "74  tristesse              Serena manque le tournoi de Bangalore\n",
       "75  tristesse  Une sécheuse responsable du feu tuant 39 chats...\n",
       "76       joie              Roddick et Murray marquent à San Jose\n",
       "77       joie                      Conflit de marque Apple réglé\n",
       "78  tristesse  Les courtiers en ligne américains regardent la...\n",
       "79     colère  Les États-Unis détournent des troupes pour com...\n",
       "80  tristesse  Décès de Ian Richardson, acteur de 'House of C...\n",
       "81  tristesse       Un chef taliban tué dans une frappe aérienne\n",
       "82       joie          S'échapper à Prague sans les hordes d'été\n",
       "83   surprise                Katmandou: première neige en 63 ans\n",
       "84  tristesse                  Nasdaq échoue dans l'offre de LSE\n",
       "85  tristesse                      Un ex-pasteur condamné à mort\n",
       "86   surprise  Un bébé né sur un péage après que papa soit ab...\n",
       "87   surprise           Etude des liens chimpanzés et 'marteaux'\n",
       "88       joie                 UN-Google Earth map climate change\n",
       "\n",
       "[89 rows x 2 columns]"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import copy\n",
    "from googletrans import Translator\n",
    "\n",
    "df_fr = pd.DataFrame() \n",
    "count = 0\n",
    "for index, row in df_en[911:].iterrows():\n",
    "    # REINITIALIZE THE API\n",
    "    translator = Translator()\n",
    "    newrow = copy.deepcopy(row)\n",
    "    #print(newrow)\n",
    "    try:\n",
    "            # translate the 'text' column\n",
    "            text_translated = translator.translate(row[0], dest='fr')\n",
    "            print(text_translated.text)\n",
    "            sentiment_translated = translator.translate(row[1], dest='fr')\n",
    "            print(sentiment_translated.text)\n",
    "            df_fr = df_fr.append({'text': text_translated.text, 'sentiment': sentiment_translated.text}, ignore_index=True)\n",
    "    except Exception as e:\n",
    "        print(str(e))\n",
    "        continue\n",
    "df_fr"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [],
   "source": [
    "#df_fr.to_pickle('data/df_FR_News911.p')\n",
    "df_fr.to_pickle('data/df_FR_News911-1000.p')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "HTTP Error 503: Service Unavailable\n",
      "I'm out \n"
     ]
    }
   ],
   "source": [
    "import goslate\n",
    "\n",
    "import copy\n",
    "nb = 0\n",
    "df_fr = pd.DataFrame() \n",
    "for index, row in df_en.iterrows():\n",
    "    # REINITIALIZE THE API\n",
    "    gs = goslate.Goslate()\n",
    "    if(nb<101):\n",
    "        nb = nb +1 \n",
    "        try:\n",
    "            # translate the 'text' column\n",
    "            text_translated = gs.translate(row[0], 'fr')\n",
    "            print(text_translated)\n",
    "            newrow['text'] = text_translated\n",
    "            sentiment_translated = gs.translate(row[1], 'fr')\n",
    "            newrow['sentiment'] = sentiment_translated\n",
    "            print(sentiment_translated)\n",
    "            #print(newrow)\n",
    "            df_fr.append({'text': text_translated, 'sentiment': sentiment_translated}, ignore_index=True)\n",
    "\n",
    "        except Exception as e:\n",
    "            print(str(e))\n",
    "            continue\n",
    "    else: break \n",
    "print (\"I'm out \")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "ename": "TypeError",
     "evalue": "__init__() got an unexpected keyword argument 'max_rows'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mTypeError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\IPython\\core\\formatters.py\u001b[0m in \u001b[0;36m__call__\u001b[1;34m(self, obj)\u001b[0m\n\u001b[0;32m    343\u001b[0m             \u001b[0mmethod\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mget_real_method\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mobj\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mprint_method\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    344\u001b[0m             \u001b[1;32mif\u001b[0m \u001b[0mmethod\u001b[0m \u001b[1;32mis\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[1;32mNone\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 345\u001b[1;33m                 \u001b[1;32mreturn\u001b[0m \u001b[0mmethod\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    346\u001b[0m             \u001b[1;32mreturn\u001b[0m \u001b[1;32mNone\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    347\u001b[0m         \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\pandas\\core\\frame.py\u001b[0m in \u001b[0;36m_repr_html_\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m    694\u001b[0m         \u001b[0mSee\u001b[0m \u001b[0mAlso\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    695\u001b[0m         \u001b[1;33m-\u001b[0m\u001b[1;33m-\u001b[0m\u001b[1;33m-\u001b[0m\u001b[1;33m-\u001b[0m\u001b[1;33m-\u001b[0m\u001b[1;33m-\u001b[0m\u001b[1;33m-\u001b[0m\u001b[1;33m-\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 696\u001b[1;33m         \u001b[0mto_html\u001b[0m \u001b[1;33m:\u001b[0m \u001b[0mConvert\u001b[0m \u001b[0mDataFrame\u001b[0m \u001b[0mto\u001b[0m \u001b[0mHTML\u001b[0m\u001b[1;33m.\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    697\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    698\u001b[0m         \u001b[0mExamples\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\pandas\\core\\frame.py\u001b[0m in \u001b[0;36mto_html\u001b[1;34m(self, buf, columns, col_space, header, index, na_rep, formatters, float_format, sparsify, index_names, justify, bold_rows, classes, escape, max_rows, max_cols, show_dimensions, notebook, decimal, border, table_id)\u001b[0m\n\u001b[0;32m   2035\u001b[0m             \u001b[0mDictionary\u001b[0m \u001b[0mmapping\u001b[0m \u001b[0mcolumns\u001b[0m \u001b[0mcontaining\u001b[0m \u001b[0mdatetime\u001b[0m \u001b[0mtypes\u001b[0m \u001b[0mto\u001b[0m \u001b[0mstata\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   2036\u001b[0m             \u001b[0minternal\u001b[0m \u001b[0mformat\u001b[0m \u001b[0mto\u001b[0m \u001b[0muse\u001b[0m \u001b[0mwhen\u001b[0m \u001b[0mwriting\u001b[0m \u001b[0mthe\u001b[0m \u001b[0mdates\u001b[0m\u001b[1;33m.\u001b[0m \u001b[0mOptions\u001b[0m \u001b[0mare\u001b[0m \u001b[1;34m'tc'\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 2037\u001b[1;33m             \u001b[1;34m'td'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m'tm'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m'tw'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m'th'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m'tq'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m'ty'\u001b[0m\u001b[1;33m.\u001b[0m \u001b[0mColumn\u001b[0m \u001b[0mcan\u001b[0m \u001b[0mbe\u001b[0m \u001b[0meither\u001b[0m \u001b[0man\u001b[0m \u001b[0minteger\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m   2038\u001b[0m             \u001b[1;32mor\u001b[0m \u001b[0ma\u001b[0m \u001b[0mname\u001b[0m\u001b[1;33m.\u001b[0m \u001b[0mDatetime\u001b[0m \u001b[0mcolumns\u001b[0m \u001b[0mthat\u001b[0m \u001b[0mdo\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[0mhave\u001b[0m \u001b[0ma\u001b[0m \u001b[0mconversion\u001b[0m \u001b[0mtype\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   2039\u001b[0m             \u001b[0mspecified\u001b[0m \u001b[0mwill\u001b[0m \u001b[0mbe\u001b[0m \u001b[0mconverted\u001b[0m \u001b[0mto\u001b[0m \u001b[1;34m'tc'\u001b[0m\u001b[1;33m.\u001b[0m \u001b[0mRaises\u001b[0m \u001b[0mNotImplementedError\u001b[0m \u001b[1;32mif\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\pandas\\io\\formats\\format.py\u001b[0m in \u001b[0;36mto_html\u001b[1;34m(self, classes, notebook, border)\u001b[0m\n\u001b[0;32m    751\u001b[0m             \u001b[0mneed_leadsp\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mdict\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mzip\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfmt_columns\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mmap\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mis_numeric_dtype\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mdtypes\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    752\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 753\u001b[1;33m             \u001b[1;32mdef\u001b[0m \u001b[0mspace_format\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mx\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0my\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    754\u001b[0m                 if (y not in self.formatters and\n\u001b[0;32m    755\u001b[0m                         need_leadsp[x] and not restrict_formatting):\n",
      "\u001b[1;31mTypeError\u001b[0m: __init__() got an unexpected keyword argument 'max_rows'"
     ]
    },
    {
     "data": {
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: []\n",
       "Index: []"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_fr"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "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>0</th>\n",
       "      <th>1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1411</th>\n",
       "      <td>Turkmen acting leader sworn in as new president</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1412</th>\n",
       "      <td>Allen and Okur get All-Star call</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1413</th>\n",
       "      <td>Svindal claims are golden double</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1414</th>\n",
       "      <td>Trolley Square shooting leaves 6 dead, includi...</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1415</th>\n",
       "      <td>Bridge blast stops I-95 traffic</td>\n",
       "      <td>fear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1416</th>\n",
       "      <td>Mother, daughter stabbed near school</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1417</th>\n",
       "      <td>Excerpt: Politicians and the press</td>\n",
       "      <td>disgust</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1418</th>\n",
       "      <td>North Korea gets 'money and respect'</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1419</th>\n",
       "      <td>Beyonce in a bikini as SI's swimsuit cover model</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1420</th>\n",
       "      <td>Loving with all your ... brain</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421</th>\n",
       "      <td>Shoplifters' choice: Police or T-shirt of shame</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1422</th>\n",
       "      <td>Cuban official: Web a 'wild colt'</td>\n",
       "      <td>fear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1423</th>\n",
       "      <td>Slow 'Music and Lyrics'</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1424</th>\n",
       "      <td>Mexican navy helps in hunt for U.S. engineer</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1425</th>\n",
       "      <td>Smith baby may not be pot of gold</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1426</th>\n",
       "      <td>Latest updates on world's top stories</td>\n",
       "      <td>fear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1427</th>\n",
       "      <td>Beating leaves teen in coma</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1428</th>\n",
       "      <td>Tiempo Libre has Grammy dreams</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1429</th>\n",
       "      <td>GPS sneakers locate with press of a button</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1430</th>\n",
       "      <td>Embattled Edwards blogger quits campaign</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1431</th>\n",
       "      <td>Britons deported from Somalia held under Terro...</td>\n",
       "      <td>fear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1432</th>\n",
       "      <td>Updates on world's top stories</td>\n",
       "      <td>fear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1433</th>\n",
       "      <td>Breast cancer drug promises hope</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1434</th>\n",
       "      <td>Ancient coin shows Cleopatra was no beauty</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1435</th>\n",
       "      <td>YouTube yields surprising payback</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1436</th>\n",
       "      <td>Up to 22 inches of snow in forecast</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1437</th>\n",
       "      <td>Werder make 10-man Ajax pay price</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1438</th>\n",
       "      <td>EU condemns 'illegal' CIA flights</td>\n",
       "      <td>anger</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1439</th>\n",
       "      <td>Report links humans to global warming</td>\n",
       "      <td>fear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1440</th>\n",
       "      <td>UN nuclear watchdog slashes Iran aid</td>\n",
       "      <td>anger</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1470</th>\n",
       "      <td>Frantic 911 call in Ryan O'Neal case</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1471</th>\n",
       "      <td>Durant's success trumps the Gators</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1472</th>\n",
       "      <td>Scientist snoops in astronauts' journals</td>\n",
       "      <td>disgust</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1473</th>\n",
       "      <td>YouTube founders split $650M payout</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1474</th>\n",
       "      <td>African nation hopes Whoopi can help</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1475</th>\n",
       "      <td>United hang on to six-point lead</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1476</th>\n",
       "      <td>Lawyer seizes Smith's Bahamas home</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1477</th>\n",
       "      <td>Was Prince's super show too revealing?</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1478</th>\n",
       "      <td>Clijsters looks for a long goodbye</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1479</th>\n",
       "      <td>Snow's too deep even for snowmobiles</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1480</th>\n",
       "      <td>Study: Female seals picky about mates</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1481</th>\n",
       "      <td>ROUNDUP: Protests erupt despite \"state of sieg...</td>\n",
       "      <td>anger</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1482</th>\n",
       "      <td>Study: More kids exposed to online porn</td>\n",
       "      <td>disgust</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1483</th>\n",
       "      <td>Beyonce new SI bikini cover girl</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1484</th>\n",
       "      <td>Marijuana helps ease HIV nerve pain, study says</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1485</th>\n",
       "      <td>Serena misses Bangalore tournament</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1486</th>\n",
       "      <td>Dryer blamed for fire killing 39 cats, dogs</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1487</th>\n",
       "      <td>Roddick, Murray score in San Jose</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1488</th>\n",
       "      <td>Apple trademark dispute settled</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1489</th>\n",
       "      <td>U.S. online love brokers eye China</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1490</th>\n",
       "      <td>U.S. diverts troops to fight Taliban</td>\n",
       "      <td>anger</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1491</th>\n",
       "      <td>'House of Cards' actor Ian Richardson dead</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1492</th>\n",
       "      <td>Taliban leader killed in airstrike</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1493</th>\n",
       "      <td>Escape to Prague without the summer hordes</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1494</th>\n",
       "      <td>Kathmandu: First snow in 63 years</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1495</th>\n",
       "      <td>Nasdaq fails in bid for LSE</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1496</th>\n",
       "      <td>Ex-pastor gets death sentence</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1497</th>\n",
       "      <td>Baby born on turnpike after dad misses exit</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1498</th>\n",
       "      <td>Study links chimps and 'hammers'</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1499</th>\n",
       "      <td>UN-Google Earth map climate change</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>89 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                      0         1\n",
       "1411    Turkmen acting leader sworn in as new president       joy\n",
       "1412                   Allen and Okur get All-Star call       joy\n",
       "1413                   Svindal claims are golden double       joy\n",
       "1414  Trolley Square shooting leaves 6 dead, includi...   sadness\n",
       "1415                    Bridge blast stops I-95 traffic      fear\n",
       "1416               Mother, daughter stabbed near school   sadness\n",
       "1417                 Excerpt: Politicians and the press   disgust\n",
       "1418               North Korea gets 'money and respect'       joy\n",
       "1419   Beyonce in a bikini as SI's swimsuit cover model       joy\n",
       "1420                     Loving with all your ... brain  surprise\n",
       "1421    Shoplifters' choice: Police or T-shirt of shame  surprise\n",
       "1422                  Cuban official: Web a 'wild colt'      fear\n",
       "1423                            Slow 'Music and Lyrics'       joy\n",
       "1424       Mexican navy helps in hunt for U.S. engineer       joy\n",
       "1425                  Smith baby may not be pot of gold   sadness\n",
       "1426              Latest updates on world's top stories      fear\n",
       "1427                        Beating leaves teen in coma   sadness\n",
       "1428                     Tiempo Libre has Grammy dreams       joy\n",
       "1429         GPS sneakers locate with press of a button  surprise\n",
       "1430           Embattled Edwards blogger quits campaign   sadness\n",
       "1431  Britons deported from Somalia held under Terro...      fear\n",
       "1432                     Updates on world's top stories      fear\n",
       "1433                   Breast cancer drug promises hope       joy\n",
       "1434         Ancient coin shows Cleopatra was no beauty  surprise\n",
       "1435                  YouTube yields surprising payback  surprise\n",
       "1436                Up to 22 inches of snow in forecast  surprise\n",
       "1437                  Werder make 10-man Ajax pay price       joy\n",
       "1438                  EU condemns 'illegal' CIA flights     anger\n",
       "1439              Report links humans to global warming      fear\n",
       "1440               UN nuclear watchdog slashes Iran aid     anger\n",
       "...                                                 ...       ...\n",
       "1470               Frantic 911 call in Ryan O'Neal case  surprise\n",
       "1471                 Durant's success trumps the Gators       joy\n",
       "1472           Scientist snoops in astronauts' journals   disgust\n",
       "1473                YouTube founders split $650M payout       joy\n",
       "1474               African nation hopes Whoopi can help       joy\n",
       "1475                   United hang on to six-point lead       joy\n",
       "1476                 Lawyer seizes Smith's Bahamas home   sadness\n",
       "1477             Was Prince's super show too revealing?  surprise\n",
       "1478                 Clijsters looks for a long goodbye   sadness\n",
       "1479               Snow's too deep even for snowmobiles  surprise\n",
       "1480              Study: Female seals picky about mates  surprise\n",
       "1481  ROUNDUP: Protests erupt despite \"state of sieg...     anger\n",
       "1482            Study: More kids exposed to online porn   disgust\n",
       "1483                   Beyonce new SI bikini cover girl       joy\n",
       "1484    Marijuana helps ease HIV nerve pain, study says  surprise\n",
       "1485                 Serena misses Bangalore tournament   sadness\n",
       "1486        Dryer blamed for fire killing 39 cats, dogs   sadness\n",
       "1487                  Roddick, Murray score in San Jose       joy\n",
       "1488                    Apple trademark dispute settled       joy\n",
       "1489                 U.S. online love brokers eye China   sadness\n",
       "1490               U.S. diverts troops to fight Taliban     anger\n",
       "1491         'House of Cards' actor Ian Richardson dead   sadness\n",
       "1492                 Taliban leader killed in airstrike   sadness\n",
       "1493         Escape to Prague without the summer hordes       joy\n",
       "1494                  Kathmandu: First snow in 63 years  surprise\n",
       "1495                        Nasdaq fails in bid for LSE   sadness\n",
       "1496                      Ex-pastor gets death sentence   sadness\n",
       "1497        Baby born on turnpike after dad misses exit  surprise\n",
       "1498                   Study links chimps and 'hammers'  surprise\n",
       "1499                 UN-Google Earth map climate change       joy\n",
       "\n",
       "[89 rows x 2 columns]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_en[911:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_fr1 = pd.read_pickle(\"data/df_FR_News911-1000.p\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_fr2 = pd.read_pickle(\"data/df_FR_News911.p\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "frames = [df_fr2, df_fr1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "result = pd.concat(frames)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "len(result)\n",
    "result.to_pickle('data/NotIot_FR_News.p')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>sentiment</th>\n",
       "      <th>text</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>joie</td>\n",
       "      <td>Un test pour prédire la rechute du cancer du s...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Un allié de Saddam Hussein est pendu, selon un...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>joie</td>\n",
       "      <td>Vues et sons du CES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>joie</td>\n",
       "      <td>Schuey voit Ferrari dévoiler une nouvelle voiture</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>peur</td>\n",
       "      <td>Les clôtures et les annulations sont les meill...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Camions avalés dans l'effondrement du métro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Une lettre de Sarkozy surprend l'audience sur ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Construire un monument à un fils, un enfant à ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Un législateur veut interdire les iPod dans le...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Diabetic attend des lunettes pendant des mois</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Le Soudan demande à l'envoyé des Nations Unies...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>surprise</td>\n",
       "      <td>5000 ans après, mais un couple est toujours da...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>surprise</td>\n",
       "      <td>La Défense conteste la crédibilité de Russert</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>joie</td>\n",
       "      <td>Ozzy, un héros pour les masses hard rock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Résumé des essais de fuite de la CIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>joie</td>\n",
       "      <td>Le film de danse prend le dessus sur le numéro 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Les nations asiatiques demandent la réforme du...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>joie</td>\n",
       "      <td>Après le voyage en Irak, Clinton propose des l...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>7 morts dans un immeuble en feu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>surprise</td>\n",
       "      <td>La sueur masculine augmente les niveaux d'horm...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Les signaux mitigés de Carphone Warehouse</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Les démocrates complotent de censurer les trou...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>colère</td>\n",
       "      <td>Cisco poursuit Apple contre le nom de l'iPhone</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>dégoûter</td>\n",
       "      <td>La star de BB Jackson nie les commentaires de ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>joie</td>\n",
       "      <td>Inter Milan set Serie A win record</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>surprise</td>\n",
       "      <td>US Airways augmente son offre pour Delta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>joie</td>\n",
       "      <td>La presse voit de l'espoir dans les négociatio...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Le fan des Bears perd son pari et change de nom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>dégoûter</td>\n",
       "      <td>Buste d'anneau pornographique national majeur ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Indice 'cheveux humains' dans la chasse pour a...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Appel frénétique au 911 dans l'affaire Ryan O'...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>joie</td>\n",
       "      <td>Le succès de Durant l'emporte sur les Gators</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>dégoûter</td>\n",
       "      <td>Un scientifique fouine dans le journal des ast...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>joie</td>\n",
       "      <td>Les fondateurs de YouTube ont partagé 650 mill...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>joie</td>\n",
       "      <td>Une nation africaine espère que Whoopi pourra ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>joie</td>\n",
       "      <td>United s'accrocher à six points d'avance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Un avocat s'empare de la maison de Smith aux B...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Le super show de Prince était-il trop révélateur?</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Clijsters cherche un long au revoir</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>surprise</td>\n",
       "      <td>La neige est trop profonde même pour les moton...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Étude: Les phoques sont difficiles au sujet de...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>colère</td>\n",
       "      <td>ROUNDUP: Des manifestations éclatent malgré \"l...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>dégoûter</td>\n",
       "      <td>Étude: Plus d'enfants exposés au porno en ligne</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>joie</td>\n",
       "      <td>Beyonce nouvelle SI cover girl bikini</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>surprise</td>\n",
       "      <td>La marijuana aide à soulager la douleur nerveu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Serena manque le tournoi de Bangalore</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Une sécheuse responsable du feu tuant 39 chats...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>joie</td>\n",
       "      <td>Roddick et Murray marquent à San Jose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>joie</td>\n",
       "      <td>Conflit de marque Apple réglé</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Les courtiers en ligne américains regardent la...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>colère</td>\n",
       "      <td>Les États-Unis détournent des troupes pour com...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Décès de Ian Richardson, acteur de 'House of C...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Un chef taliban tué dans une frappe aérienne</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>joie</td>\n",
       "      <td>S'échapper à Prague sans les hordes d'été</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Katmandou: première neige en 63 ans</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Nasdaq échoue dans l'offre de LSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>tristesse</td>\n",
       "      <td>Un ex-pasteur condamné à mort</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Un bébé né sur un péage après que papa soit ab...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>surprise</td>\n",
       "      <td>Etude des liens chimpanzés et 'marteaux'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>joie</td>\n",
       "      <td>UN-Google Earth map climate change</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    sentiment                                               text\n",
       "0        joie  Un test pour prédire la rechute du cancer du s...\n",
       "1   tristesse  Un allié de Saddam Hussein est pendu, selon un...\n",
       "2        joie                                Vues et sons du CES\n",
       "3        joie  Schuey voit Ferrari dévoiler une nouvelle voiture\n",
       "4        peur  Les clôtures et les annulations sont les meill...\n",
       "5   tristesse        Camions avalés dans l'effondrement du métro\n",
       "6    surprise  Une lettre de Sarkozy surprend l'audience sur ...\n",
       "7   tristesse  Construire un monument à un fils, un enfant à ...\n",
       "8    surprise  Un législateur veut interdire les iPod dans le...\n",
       "9   tristesse      Diabetic attend des lunettes pendant des mois\n",
       "10   surprise  Le Soudan demande à l'envoyé des Nations Unies...\n",
       "11   surprise  5000 ans après, mais un couple est toujours da...\n",
       "12   surprise      La Défense conteste la crédibilité de Russert\n",
       "13       joie           Ozzy, un héros pour les masses hard rock\n",
       "14   surprise               Résumé des essais de fuite de la CIA\n",
       "15       joie   Le film de danse prend le dessus sur le numéro 1\n",
       "16   surprise  Les nations asiatiques demandent la réforme du...\n",
       "17       joie  Après le voyage en Irak, Clinton propose des l...\n",
       "18  tristesse                    7 morts dans un immeuble en feu\n",
       "19   surprise  La sueur masculine augmente les niveaux d'horm...\n",
       "20   surprise          Les signaux mitigés de Carphone Warehouse\n",
       "21   surprise  Les démocrates complotent de censurer les trou...\n",
       "22     colère     Cisco poursuit Apple contre le nom de l'iPhone\n",
       "23   dégoûter  La star de BB Jackson nie les commentaires de ...\n",
       "24       joie                 Inter Milan set Serie A win record\n",
       "25   surprise           US Airways augmente son offre pour Delta\n",
       "26       joie  La presse voit de l'espoir dans les négociatio...\n",
       "27   surprise    Le fan des Bears perd son pari et change de nom\n",
       "28   dégoûter  Buste d'anneau pornographique national majeur ...\n",
       "29   surprise  Indice 'cheveux humains' dans la chasse pour a...\n",
       "..        ...                                                ...\n",
       "59   surprise  Appel frénétique au 911 dans l'affaire Ryan O'...\n",
       "60       joie       Le succès de Durant l'emporte sur les Gators\n",
       "61   dégoûter  Un scientifique fouine dans le journal des ast...\n",
       "62       joie  Les fondateurs de YouTube ont partagé 650 mill...\n",
       "63       joie  Une nation africaine espère que Whoopi pourra ...\n",
       "64       joie           United s'accrocher à six points d'avance\n",
       "65  tristesse  Un avocat s'empare de la maison de Smith aux B...\n",
       "66   surprise  Le super show de Prince était-il trop révélateur?\n",
       "67  tristesse                Clijsters cherche un long au revoir\n",
       "68   surprise  La neige est trop profonde même pour les moton...\n",
       "69   surprise  Étude: Les phoques sont difficiles au sujet de...\n",
       "70     colère  ROUNDUP: Des manifestations éclatent malgré \"l...\n",
       "71   dégoûter    Étude: Plus d'enfants exposés au porno en ligne\n",
       "72       joie              Beyonce nouvelle SI cover girl bikini\n",
       "73   surprise  La marijuana aide à soulager la douleur nerveu...\n",
       "74  tristesse              Serena manque le tournoi de Bangalore\n",
       "75  tristesse  Une sécheuse responsable du feu tuant 39 chats...\n",
       "76       joie              Roddick et Murray marquent à San Jose\n",
       "77       joie                      Conflit de marque Apple réglé\n",
       "78  tristesse  Les courtiers en ligne américains regardent la...\n",
       "79     colère  Les États-Unis détournent des troupes pour com...\n",
       "80  tristesse  Décès de Ian Richardson, acteur de 'House of C...\n",
       "81  tristesse       Un chef taliban tué dans une frappe aérienne\n",
       "82       joie          S'échapper à Prague sans les hordes d'été\n",
       "83   surprise                Katmandou: première neige en 63 ans\n",
       "84  tristesse                  Nasdaq échoue dans l'offre de LSE\n",
       "85  tristesse                      Un ex-pasteur condamné à mort\n",
       "86   surprise  Un bébé né sur un péage après que papa soit ab...\n",
       "87   surprise           Etude des liens chimpanzés et 'marteaux'\n",
       "88       joie                 UN-Google Earth map climate change\n",
       "\n",
       "[1000 rows x 2 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>0</th>\n",
       "      <th>1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>500</th>\n",
       "      <td>Test to predict breast cancer relapse is approved</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501</th>\n",
       "      <td>Two Hussein allies are hanged, Iraqi official ...</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>502</th>\n",
       "      <td>Sights and sounds from CES</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>503</th>\n",
       "      <td>Schuey sees Ferrari unveil new car</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>504</th>\n",
       "      <td>Closings and cancellations top advice on flu o...</td>\n",
       "      <td>fear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>505</th>\n",
       "      <td>Trucks swallowed in subway collapse</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>506</th>\n",
       "      <td>Sarkozy letter surprises French cartoons hearing</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>507</th>\n",
       "      <td>Building a memorial to a son, one child at a time</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>508</th>\n",
       "      <td>Lawmaker seeks iPod ban in crosswalks in New York</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>509</th>\n",
       "      <td>Diabetic waits months for eyeglasses</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>510</th>\n",
       "      <td>Sudan tells United Nations envoy to leave in 7...</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511</th>\n",
       "      <td>5000 years on but couple still hugging</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>512</th>\n",
       "      <td>Defense to challenge Russert's credibility</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>513</th>\n",
       "      <td>Ozzy, a Hero for the hard-rocking masses</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>514</th>\n",
       "      <td>CIA leak trial summary</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>515</th>\n",
       "      <td>Dance movie takes over No. 1</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516</th>\n",
       "      <td>Asian nations urge Myanmar reform</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>517</th>\n",
       "      <td>After Iraq trip, Clinton proposes war limits</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>518</th>\n",
       "      <td>7 dead in apartment building fire</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>519</th>\n",
       "      <td>Male sweat boosts women's hormone levels</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>520</th>\n",
       "      <td>Carphone Warehouse's mixed signals</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>521</th>\n",
       "      <td>Democrats plot Bush troop increase censure</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>522</th>\n",
       "      <td>Cisco sues Apple over iPhone name</td>\n",
       "      <td>anger</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>523</th>\n",
       "      <td>BB star Jackson denies Goody comments</td>\n",
       "      <td>disgust</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>524</th>\n",
       "      <td>Inter Milan set Serie A win record</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>525</th>\n",
       "      <td>US Airways boosts bid for Delta</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>526</th>\n",
       "      <td>Press sees hope in Mecca talks</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>527</th>\n",
       "      <td>Bears fan loses bet and changes name</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>528</th>\n",
       "      <td>Global National\\tMajor child porn ring bust</td>\n",
       "      <td>disgust</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>529</th>\n",
       "      <td>'Human hair' clue in hunt for airliner</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1470</th>\n",
       "      <td>Frantic 911 call in Ryan O'Neal case</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1471</th>\n",
       "      <td>Durant's success trumps the Gators</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1472</th>\n",
       "      <td>Scientist snoops in astronauts' journals</td>\n",
       "      <td>disgust</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1473</th>\n",
       "      <td>YouTube founders split $650M payout</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1474</th>\n",
       "      <td>African nation hopes Whoopi can help</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1475</th>\n",
       "      <td>United hang on to six-point lead</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1476</th>\n",
       "      <td>Lawyer seizes Smith's Bahamas home</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1477</th>\n",
       "      <td>Was Prince's super show too revealing?</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1478</th>\n",
       "      <td>Clijsters looks for a long goodbye</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1479</th>\n",
       "      <td>Snow's too deep even for snowmobiles</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1480</th>\n",
       "      <td>Study: Female seals picky about mates</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1481</th>\n",
       "      <td>ROUNDUP: Protests erupt despite \"state of sieg...</td>\n",
       "      <td>anger</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1482</th>\n",
       "      <td>Study: More kids exposed to online porn</td>\n",
       "      <td>disgust</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1483</th>\n",
       "      <td>Beyonce new SI bikini cover girl</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1484</th>\n",
       "      <td>Marijuana helps ease HIV nerve pain, study says</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1485</th>\n",
       "      <td>Serena misses Bangalore tournament</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1486</th>\n",
       "      <td>Dryer blamed for fire killing 39 cats, dogs</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1487</th>\n",
       "      <td>Roddick, Murray score in San Jose</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1488</th>\n",
       "      <td>Apple trademark dispute settled</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1489</th>\n",
       "      <td>U.S. online love brokers eye China</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1490</th>\n",
       "      <td>U.S. diverts troops to fight Taliban</td>\n",
       "      <td>anger</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1491</th>\n",
       "      <td>'House of Cards' actor Ian Richardson dead</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1492</th>\n",
       "      <td>Taliban leader killed in airstrike</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1493</th>\n",
       "      <td>Escape to Prague without the summer hordes</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1494</th>\n",
       "      <td>Kathmandu: First snow in 63 years</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1495</th>\n",
       "      <td>Nasdaq fails in bid for LSE</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1496</th>\n",
       "      <td>Ex-pastor gets death sentence</td>\n",
       "      <td>sadness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1497</th>\n",
       "      <td>Baby born on turnpike after dad misses exit</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1498</th>\n",
       "      <td>Study links chimps and 'hammers'</td>\n",
       "      <td>surprise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1499</th>\n",
       "      <td>UN-Google Earth map climate change</td>\n",
       "      <td>joy</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                      0         1\n",
       "500   Test to predict breast cancer relapse is approved       joy\n",
       "501   Two Hussein allies are hanged, Iraqi official ...   sadness\n",
       "502                          Sights and sounds from CES       joy\n",
       "503                  Schuey sees Ferrari unveil new car       joy\n",
       "504   Closings and cancellations top advice on flu o...      fear\n",
       "505                 Trucks swallowed in subway collapse   sadness\n",
       "506    Sarkozy letter surprises French cartoons hearing  surprise\n",
       "507   Building a memorial to a son, one child at a time   sadness\n",
       "508   Lawmaker seeks iPod ban in crosswalks in New York  surprise\n",
       "509                Diabetic waits months for eyeglasses   sadness\n",
       "510   Sudan tells United Nations envoy to leave in 7...  surprise\n",
       "511              5000 years on but couple still hugging  surprise\n",
       "512          Defense to challenge Russert's credibility  surprise\n",
       "513            Ozzy, a Hero for the hard-rocking masses       joy\n",
       "514                              CIA leak trial summary  surprise\n",
       "515                        Dance movie takes over No. 1       joy\n",
       "516                   Asian nations urge Myanmar reform  surprise\n",
       "517        After Iraq trip, Clinton proposes war limits       joy\n",
       "518                   7 dead in apartment building fire   sadness\n",
       "519            Male sweat boosts women's hormone levels  surprise\n",
       "520                  Carphone Warehouse's mixed signals  surprise\n",
       "521          Democrats plot Bush troop increase censure  surprise\n",
       "522                   Cisco sues Apple over iPhone name     anger\n",
       "523               BB star Jackson denies Goody comments   disgust\n",
       "524                  Inter Milan set Serie A win record       joy\n",
       "525                     US Airways boosts bid for Delta  surprise\n",
       "526                      Press sees hope in Mecca talks       joy\n",
       "527                Bears fan loses bet and changes name  surprise\n",
       "528         Global National\\tMajor child porn ring bust   disgust\n",
       "529              'Human hair' clue in hunt for airliner  surprise\n",
       "...                                                 ...       ...\n",
       "1470               Frantic 911 call in Ryan O'Neal case  surprise\n",
       "1471                 Durant's success trumps the Gators       joy\n",
       "1472           Scientist snoops in astronauts' journals   disgust\n",
       "1473                YouTube founders split $650M payout       joy\n",
       "1474               African nation hopes Whoopi can help       joy\n",
       "1475                   United hang on to six-point lead       joy\n",
       "1476                 Lawyer seizes Smith's Bahamas home   sadness\n",
       "1477             Was Prince's super show too revealing?  surprise\n",
       "1478                 Clijsters looks for a long goodbye   sadness\n",
       "1479               Snow's too deep even for snowmobiles  surprise\n",
       "1480              Study: Female seals picky about mates  surprise\n",
       "1481  ROUNDUP: Protests erupt despite \"state of sieg...     anger\n",
       "1482            Study: More kids exposed to online porn   disgust\n",
       "1483                   Beyonce new SI bikini cover girl       joy\n",
       "1484    Marijuana helps ease HIV nerve pain, study says  surprise\n",
       "1485                 Serena misses Bangalore tournament   sadness\n",
       "1486        Dryer blamed for fire killing 39 cats, dogs   sadness\n",
       "1487                  Roddick, Murray score in San Jose       joy\n",
       "1488                    Apple trademark dispute settled       joy\n",
       "1489                 U.S. online love brokers eye China   sadness\n",
       "1490               U.S. diverts troops to fight Taliban     anger\n",
       "1491         'House of Cards' actor Ian Richardson dead   sadness\n",
       "1492                 Taliban leader killed in airstrike   sadness\n",
       "1493         Escape to Prague without the summer hordes       joy\n",
       "1494                  Kathmandu: First snow in 63 years  surprise\n",
       "1495                        Nasdaq fails in bid for LSE   sadness\n",
       "1496                      Ex-pastor gets death sentence   sadness\n",
       "1497        Baby born on turnpike after dad misses exit  surprise\n",
       "1498                   Study links chimps and 'hammers'  surprise\n",
       "1499                 UN-Google Earth map climate change       joy\n",
       "\n",
       "[1000 rows x 2 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_en"
   ]
  },
  {
   "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.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}