Merging_DataSets_For_WebScrapping.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Merging all the Data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<div style=\"background-color:green; padding:10px\">\n",
    "Notice that we have been iterating through this notebook as it took a lot of time to process everything.\n",
    "We have been merging datasets here, so that we could end up completing what we named: full_merged_dataset15 (Yes it took 15 attempts)\n",
    "</div>\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "/mnt/d/OneDrive - Universidad Carlos III de Madrid/UC3M/Year 4/Segundo Cuatri/ML/final_project\n"
     ]
    }
   ],
   "source": [
    "import os\n",
    "print(os.getcwd())\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "File found: full_poems_data.csv\n"
     ]
    }
   ],
   "source": [
    "file_path = 'full_poems_data.csv'  # or the correct path to your file\n",
    "if os.path.isfile(file_path):\n",
    "    print(f\"File found: {file_path}\")\n",
    "else:\n",
    "    print(f\"File not found: {file_path}\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "# Read the first dataset\n",
    "df1 = pd.read_csv('full_merged_dataset14.csv', encoding='utf-8', low_memory=False)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Read the second dataset\n",
    "df2 = pd.read_csv('full_poems_data.csv', encoding='utf-8')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Merge the datasets on a shared column\n",
    "combined_df = pd.concat([df1, df2], ignore_index=True)\n",
    "\n",
    "# Save the merged dataset to a new CSV file\n",
    "combined_df.to_csv('full_merged_dataset15.csv', index=False) # CAREFUL, you can overwrite your previous dataset, UPDATE the name when used\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>id</th>\n",
       "      <th>title</th>\n",
       "      <th>author</th>\n",
       "      <th>snippet</th>\n",
       "      <th>link</th>\n",
       "      <th>categories</th>\n",
       "      <th>poem</th>\n",
       "      <th>Unnamed: 7</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>...</th>\n",
       "      <th>Unnamed: 1857</th>\n",
       "      <th>Unnamed: 1858</th>\n",
       "      <th>Unnamed: 1859</th>\n",
       "      <th>Unnamed: 1860</th>\n",
       "      <th>Unnamed: 1861</th>\n",
       "      <th>Unnamed: 1862</th>\n",
       "      <th>Unnamed: 1863</th>\n",
       "      <th>Unnamed: 1864</th>\n",
       "      <th>Unnamed: 1865</th>\n",
       "      <th>Unnamed: 1866</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>162275</td>\n",
       "      <td>The 80&amp;rsquo;s Miracle Diet</td>\n",
       "      <td>By Melvin Dixon</td>\n",
       "      <td>Yours free without the asking</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>['Living', 'Health &amp; Illness']</td>\n",
       "      <td>Yours free without the asking Quick delivery v...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>162250</td>\n",
       "      <td>All Saints&amp;rsquo;</td>\n",
       "      <td>By Corey Van Landingham</td>\n",
       "      <td>CaravaggioÃ¢â‚¬â„¢s face in the sunken pumpkin.</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>CaravaggioÃ¢â‚¬â„¢s face in the sunken pumpkin...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>162279</td>\n",
       "      <td>And These Are Just a Few ...</td>\n",
       "      <td>By Melvin Dixon</td>\n",
       "      <td>This poem is for the epidemic dead and the liv...</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>['Living', 'Health &amp; Illness', 'Social Comment...</td>\n",
       "      <td>This poem is for the epidemic dead and the liv...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>162248</td>\n",
       "      <td>ASMR</td>\n",
       "      <td>By Corey Van Landingham</td>\n",
       "      <td>Why not climb up the mountain</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>Why not climb up the mountain of delight? To t...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>162249</td>\n",
       "      <td>ASMR</td>\n",
       "      <td>By Corey Van Landingham</td>\n",
       "      <td>HelloÃ¢â‚¬â€Tonight</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>HelloÃ¢â‚¬â€Tonight weÃ¢â‚¬â„¢ll trace the st...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>162276</td>\n",
       "      <td>Autumn Leaving</td>\n",
       "      <td>By Melvin Dixon</td>\n",
       "      <td>Vermont leaves under glass,</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>For Didier Vermont leaves under glass, Your ha...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>162292</td>\n",
       "      <td>Babble</td>\n",
       "      <td>By Nica Giromini</td>\n",
       "      <td>Say under land</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>Say under land are remembered and muddy rushes...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>162295</td>\n",
       "      <td>Chiaroscuro Spring time</td>\n",
       "      <td>By Cyrus Cassells</td>\n",
       "      <td>That was the season I couldnÃ¢â‚¬â„¢t think or...</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>['Arts &amp; Sciences', 'Painting &amp; Sculpture']</td>\n",
       "      <td>Galleria Nazionale dÃ¢â‚¬â„¢Arte Antica, Rome ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>162291</td>\n",
       "      <td>Currency</td>\n",
       "      <td>By Nica Giromini</td>\n",
       "      <td>As in a net. Headfirst</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>As in a net. Headfirst on the prairie through ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>162267</td>\n",
       "      <td>Everyday around the world a woman is pulled in...</td>\n",
       "      <td>By Krista Franklin</td>\n",
       "      <td>Everyday some brown</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>['Types/Modes', 'Ekphrasis']</td>\n",
       "      <td>After Kara WalkerÃ¢â‚¬â„¢s Ã¢â‚¬Å“Blue,Ã¢â‚¬Â...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>162260</td>\n",
       "      <td>Fosfor</td>\n",
       "      <td>By Kacper Bartczak</td>\n",
       "      <td>w terrarium jesteÃ…â€º</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>w terrarium jesteÃ…â€º czarna skrzyneczka rzec...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>162269</td>\n",
       "      <td>The Future Is Black as a Pocket</td>\n",
       "      <td>By Krista Franklin</td>\n",
       "      <td>The handwriting is on the wall</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>['Types/Modes', 'Ekphrasis']</td>\n",
       "      <td>After Kara WalkerÃ¢â‚¬â„¢s Ã¢â‚¬Å“Untitled,Ã¢â...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>162274</td>\n",
       "      <td>Getting Your Rocks Off</td>\n",
       "      <td>By Melvin Dixon</td>\n",
       "      <td>Reading clouds beyond the road</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>Reading clouds beyond the road I calculate our...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>162282</td>\n",
       "      <td>Going to Africa</td>\n",
       "      <td>By Melvin Dixon</td>\n",
       "      <td>Ã¢â‚¬Å“I am not the prodigal son,Ã¢â‚¬Â I said</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>Ã¢â‚¬Å“I am not the prodigal son,Ã¢â‚¬Â I sai...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>162284</td>\n",
       "      <td>Grandmother: Crossing Jordan</td>\n",
       "      <td>By Melvin Dixon</td>\n",
       "      <td>Rippling hospital sheets</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>Rippling hospital sheets circle your brown bod...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>162283</td>\n",
       "      <td>Hands</td>\n",
       "      <td>By Melvin Dixon</td>\n",
       "      <td>Once teaching English in Ivory Coast</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>Once teaching English in Ivory Coast you gave ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>162289</td>\n",
       "      <td>Happiness Index</td>\n",
       "      <td>By Melanie Tafejian</td>\n",
       "      <td>Your children are always grinning, doing backf...</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>['Relationships', 'Family &amp; Ancestors']</td>\n",
       "      <td>To Armenag Arekian Your children are always gr...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>162245</td>\n",
       "      <td>Hats May Perish</td>\n",
       "      <td>By Sid Ghosh</td>\n",
       "      <td>Some bequeath poetry.</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>Some bequeath poetry. Some bequeath hats. Tome...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>162285</td>\n",
       "      <td>Heartbeats</td>\n",
       "      <td>By Melvin Dixon</td>\n",
       "      <td>Work out. Ten laps.</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>['Living', 'Health &amp; Illness', 'The Body']</td>\n",
       "      <td>Work out. Ten laps. Chin ups. Look good. Steam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>162294</td>\n",
       "      <td>His Own Apollo</td>\n",
       "      <td>By Cyrus Cassells</td>\n",
       "      <td>My friend is by no means Dracula or a werewolf,</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>['Living', 'The Body', 'Love', 'Desire', 'Rela...</td>\n",
       "      <td>My friend is by no means Dracula or a werewolf...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>162246</td>\n",
       "      <td>Hope</td>\n",
       "      <td>By Sid Ghosh</td>\n",
       "      <td>Another day</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>Another day tearing steeds off my mind toward ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>162244</td>\n",
       "      <td>Let Me Go</td>\n",
       "      <td>By Sid Ghosh</td>\n",
       "      <td>Haystacks, I need</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>Haystacks, I need the needle of queer bees and...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>162240</td>\n",
       "      <td>Make-Believe</td>\n",
       "      <td>By Rosalie Moffett</td>\n",
       "      <td>Mostly dumb, but hens are finely tuned</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>Mostly dumb, but hens are finely tuned to leng...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>162281</td>\n",
       "      <td>Mother&amp;rsquo;s Tour</td>\n",
       "      <td>By Melvin Dixon</td>\n",
       "      <td>At the Louvre you find Mona Lisa</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>At the Louvre you find Mona Lisa gone secretly...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>162270</td>\n",
       "      <td>My Enemy. My Love.</td>\n",
       "      <td>By Ruth Ellen Kocher</td>\n",
       "      <td>We end easy. Your hand always your hand,</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>After Kara WalkerÃ¢â‚¬â„¢s Ã¢â‚¬Å“Tar pit,Ã¢â‚...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>162271</td>\n",
       "      <td>nail hard</td>\n",
       "      <td>By Samiya Bashir</td>\n",
       "      <td>Ã¢â‚¬â€ as i was saying</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>Alongside Kara WalkerÃ¢â‚¬â„¢s Ã¢â‚¬Å“Wokey Wo...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>162247</td>\n",
       "      <td>Once, While Disemboweling the Chicken</td>\n",
       "      <td>By Isabella Desendi</td>\n",
       "      <td>readying it for my loverÃ¢â‚¬â„¢s dinner, I re...</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>readying it for my loverÃ¢â‚¬â„¢s dinner, I re...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>162280</td>\n",
       "      <td>One by One</td>\n",
       "      <td>By Melvin Dixon</td>\n",
       "      <td>The children in the life:</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>['Living', 'Health &amp; Illness', 'Relationships'...</td>\n",
       "      <td>They wonÃ¢â‚¬â„¢t go when I go. Ã¢â‚¬â€Stevie...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>162259</td>\n",
       "      <td>Phosphorus</td>\n",
       "      <td>By Kacper Bartczak</td>\n",
       "      <td>youÃ¢â‚¬â„¢re in the terrarium</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>youÃ¢â‚¬â„¢re in the terrarium a black box thi...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>162261</td>\n",
       "      <td>PieÃ…â€ºÃ…â€ž tego</td>\n",
       "      <td>By Kacper Bartczak</td>\n",
       "      <td>perÃ…â€šo Ã…â€ºwiata wymiocino wieprzu jestem</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>perÃ…â€šo Ã…â€ºwiata wymiocino wieprzu jestem ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>162277</td>\n",
       "      <td>Place, Places</td>\n",
       "      <td>By Melvin Dixon</td>\n",
       "      <td>The first night you were gone</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>The first night you were gone I heard fingers ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>162258</td>\n",
       "      <td>portrait of the rain</td>\n",
       "      <td>By Jan Wagner</td>\n",
       "      <td>it appears as a hand-kiss, gentle nudge,</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>['Nature']</td>\n",
       "      <td>it appears as a hand-kiss, gentle nudge, spray...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>162263</td>\n",
       "      <td>Prawda obrazu</td>\n",
       "      <td>By Kacper Bartczak</td>\n",
       "      <td>Kobieta naprzeciwko czyta</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>Kobieta naprzeciwko czyta Ã¢â‚¬Å¾NajwiÃ„â„¢ksz...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>162243</td>\n",
       "      <td>A Prophecy</td>\n",
       "      <td>By Rosalie Moffett</td>\n",
       "      <td>This morning, the windowsill full</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>This morning, the windowsill full of roly poli...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>162241</td>\n",
       "      <td>Redeem</td>\n",
       "      <td>By Rosalie Moffett</td>\n",
       "      <td>The sun was losing</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>The sun was losing a long gold tooth on the li...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>162257</td>\n",
       "      <td>regenportr&amp;auml;t</td>\n",
       "      <td>By Jan Wagner</td>\n",
       "      <td>erscheint als handkuÃƒÅ¸, als sanfter stubser,</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>['Nature']</td>\n",
       "      <td>erscheint als handkuÃƒÅ¸, als sanfter stubser,...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>162290</td>\n",
       "      <td>Regret</td>\n",
       "      <td>By Melanie Tafejian</td>\n",
       "      <td>How many days did I write</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>['Living', 'Life Choices']</td>\n",
       "      <td>How many days did I write then look into a mir...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>162256</td>\n",
       "      <td>reifen</td>\n",
       "      <td>By Jan Wagner</td>\n",
       "      <td>dort, wo die stadt versickert,</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>['Social Commentaries', 'Cities &amp; Urban Life']</td>\n",
       "      <td>dort, wo die stadt versickert, beim bahndamm, ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>162252</td>\n",
       "      <td>Respite</td>\n",
       "      <td>By Elane Kim</td>\n",
       "      <td>ItÃ¢â‚¬â„¢s New YearÃ¢â‚¬â„¢s.</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>['Living', 'Death', 'Sorrow &amp; Grieving', 'Rela...</td>\n",
       "      <td>ItÃ¢â‚¬â„¢s New YearÃ¢â‚¬â„¢s. ItÃ¢â‚¬â„¢s New...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>162254</td>\n",
       "      <td>Roll Call</td>\n",
       "      <td>By Erik Tschekunow</td>\n",
       "      <td>Six times every day we stand at the thresholds</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>['Social Commentaries', 'Crime &amp; Punishment']</td>\n",
       "      <td>Six times every day we stand at the thresholds...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>162293</td>\n",
       "      <td>Sacrifice: I Was Named by the Orphanage</td>\n",
       "      <td>By Bo Hee Moon</td>\n",
       "      <td>My singing</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>['Relationships', 'Family &amp; Ancestors']</td>\n",
       "      <td>My singing voice isnÃ¢â‚¬â„¢t very good, my su...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>162251</td>\n",
       "      <td>Seeing a UFO and Singing Frank Sinatra&amp;rsquo;s...</td>\n",
       "      <td>By Ariel Francisco</td>\n",
       "      <td>How many poems does a guy have to write</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>How many poems does a guy have to write to get...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>162278</td>\n",
       "      <td>Spring Cleaning</td>\n",
       "      <td>By Melvin Dixon</td>\n",
       "      <td>First goes floordust, then newspapers</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>First goes floordust, then newspapers stacked ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>162262</td>\n",
       "      <td>This song</td>\n",
       "      <td>By Kacper Bartczak</td>\n",
       "      <td>a pearl of Ã¢â‚¬Å the world you spew you swine...</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>a pearl of Ã¢â‚¬Å the world you spew you swine...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>162255</td>\n",
       "      <td>tires</td>\n",
       "      <td>By Jan Wagner</td>\n",
       "      <td>where the city starts to come undone,</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>['Social Commentaries', 'Cities &amp; Urban Life']</td>\n",
       "      <td>where the city starts to come undone, at the r...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>162265</td>\n",
       "      <td>To Compare III</td>\n",
       "      <td>By Xuela Zhang</td>\n",
       "      <td>The unexpected</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>The unexpected intervals in his tone converged...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>162242</td>\n",
       "      <td>Transfer of Power</td>\n",
       "      <td>By Rosalie Moffett</td>\n",
       "      <td>Sleep ate silent</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>Sleep ate silent holes in day after day. I let...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>162264</td>\n",
       "      <td>The truth of the picture</td>\n",
       "      <td>By Kacper Bartczak</td>\n",
       "      <td>The woman across from meÃ¢â‚¬â„¢s reading</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>[]</td>\n",
       "      <td>The woman across from meÃ¢â‚¬â„¢s reading The ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>162268</td>\n",
       "      <td>Untitled (Blues)</td>\n",
       "      <td>By Krista Franklin</td>\n",
       "      <td>Indigo pool, color of the wings</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>['Types/Modes', 'Ekphrasis']</td>\n",
       "      <td>After Kara WalkerÃ¢â‚¬â„¢s Ã¢â‚¬Å“Blue,Ã¢â‚¬Â...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>162253</td>\n",
       "      <td>(Untitled) g111</td>\n",
       "      <td>By Marc Isaac Potter</td>\n",
       "      <td>There is not anyÃ¢â‚¬â€°...Ã¢â‚¬â€°thingÃ¢â‚¬â...</td>\n",
       "      <td>https://www.poetryfoundation.org/poetrymagazin...</td>\n",
       "      <td>['Nature', 'Animals']</td>\n",
       "      <td>There is not anyÃ¢â‚¬â€°...Ã¢â‚¬â€°thingÃ¢â‚¬â...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>50 rows × 1867 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        id                                              title  \\\n",
       "0   162275                        The 80&rsquo;s Miracle Diet   \n",
       "1   162250                                  All Saints&rsquo;   \n",
       "2   162279                       And These Are Just a Few ...   \n",
       "3   162248                                               ASMR   \n",
       "4   162249                                               ASMR   \n",
       "5   162276                                     Autumn Leaving   \n",
       "6   162292                                             Babble   \n",
       "7   162295                            Chiaroscuro Spring time   \n",
       "8   162291                                           Currency   \n",
       "9   162267  Everyday around the world a woman is pulled in...   \n",
       "10  162260                                             Fosfor   \n",
       "11  162269                    The Future Is Black as a Pocket   \n",
       "12  162274                             Getting Your Rocks Off   \n",
       "13  162282                                    Going to Africa   \n",
       "14  162284                       Grandmother: Crossing Jordan   \n",
       "15  162283                                              Hands   \n",
       "16  162289                                    Happiness Index   \n",
       "17  162245                                    Hats May Perish   \n",
       "18  162285                                         Heartbeats   \n",
       "19  162294                                     His Own Apollo   \n",
       "20  162246                                               Hope   \n",
       "21  162244                                          Let Me Go   \n",
       "22  162240                                       Make-Believe   \n",
       "23  162281                                Mother&rsquo;s Tour   \n",
       "24  162270                                 My Enemy. My Love.   \n",
       "25  162271                                          nail hard   \n",
       "26  162247              Once, While Disemboweling the Chicken   \n",
       "27  162280                                         One by One   \n",
       "28  162259                                         Phosphorus   \n",
       "29  162261                                 PieÃ…â€ºÃ…â€ž tego   \n",
       "30  162277                                      Place, Places   \n",
       "31  162258                               portrait of the rain   \n",
       "32  162263                                      Prawda obrazu   \n",
       "33  162243                                         A Prophecy   \n",
       "34  162241                                             Redeem   \n",
       "35  162257                                  regenportr&auml;t   \n",
       "36  162290                                             Regret   \n",
       "37  162256                                             reifen   \n",
       "38  162252                                            Respite   \n",
       "39  162254                                          Roll Call   \n",
       "40  162293            Sacrifice: I Was Named by the Orphanage   \n",
       "41  162251  Seeing a UFO and Singing Frank Sinatra&rsquo;s...   \n",
       "42  162278                                    Spring Cleaning   \n",
       "43  162262                                          This song   \n",
       "44  162255                                              tires   \n",
       "45  162265                                     To Compare III   \n",
       "46  162242                                  Transfer of Power   \n",
       "47  162264                           The truth of the picture   \n",
       "48  162268                                   Untitled (Blues)   \n",
       "49  162253                                    (Untitled) g111   \n",
       "\n",
       "                     author  \\\n",
       "0           By Melvin Dixon   \n",
       "1   By Corey Van Landingham   \n",
       "2           By Melvin Dixon   \n",
       "3   By Corey Van Landingham   \n",
       "4   By Corey Van Landingham   \n",
       "5           By Melvin Dixon   \n",
       "6          By Nica Giromini   \n",
       "7         By Cyrus Cassells   \n",
       "8          By Nica Giromini   \n",
       "9        By Krista Franklin   \n",
       "10       By Kacper Bartczak   \n",
       "11       By Krista Franklin   \n",
       "12          By Melvin Dixon   \n",
       "13          By Melvin Dixon   \n",
       "14          By Melvin Dixon   \n",
       "15          By Melvin Dixon   \n",
       "16      By Melanie Tafejian   \n",
       "17             By Sid Ghosh   \n",
       "18          By Melvin Dixon   \n",
       "19        By Cyrus Cassells   \n",
       "20             By Sid Ghosh   \n",
       "21             By Sid Ghosh   \n",
       "22       By Rosalie Moffett   \n",
       "23          By Melvin Dixon   \n",
       "24     By Ruth Ellen Kocher   \n",
       "25         By Samiya Bashir   \n",
       "26      By Isabella Desendi   \n",
       "27          By Melvin Dixon   \n",
       "28       By Kacper Bartczak   \n",
       "29       By Kacper Bartczak   \n",
       "30          By Melvin Dixon   \n",
       "31            By Jan Wagner   \n",
       "32       By Kacper Bartczak   \n",
       "33       By Rosalie Moffett   \n",
       "34       By Rosalie Moffett   \n",
       "35            By Jan Wagner   \n",
       "36      By Melanie Tafejian   \n",
       "37            By Jan Wagner   \n",
       "38             By Elane Kim   \n",
       "39       By Erik Tschekunow   \n",
       "40           By Bo Hee Moon   \n",
       "41       By Ariel Francisco   \n",
       "42          By Melvin Dixon   \n",
       "43       By Kacper Bartczak   \n",
       "44            By Jan Wagner   \n",
       "45           By Xuela Zhang   \n",
       "46       By Rosalie Moffett   \n",
       "47       By Kacper Bartczak   \n",
       "48       By Krista Franklin   \n",
       "49     By Marc Isaac Potter   \n",
       "\n",
       "                                              snippet  \\\n",
       "0                       Yours free without the asking   \n",
       "1     CaravaggioÃ¢â‚¬â„¢s face in the sunken pumpkin.   \n",
       "2   This poem is for the epidemic dead and the liv...   \n",
       "3                       Why not climb up the mountain   \n",
       "4                                HelloÃ¢â‚¬â€Tonight   \n",
       "5                         Vermont leaves under glass,   \n",
       "6                                      Say under land   \n",
       "7   That was the season I couldnÃ¢â‚¬â„¢t think or...   \n",
       "8                              As in a net. Headfirst   \n",
       "9                                 Everyday some brown   \n",
       "10                             w terrarium jesteÃ…â€º   \n",
       "11                     The handwriting is on the wall   \n",
       "12                     Reading clouds beyond the road   \n",
       "13    Ã¢â‚¬Å“I am not the prodigal son,Ã¢â‚¬Â I said   \n",
       "14                           Rippling hospital sheets   \n",
       "15               Once teaching English in Ivory Coast   \n",
       "16  Your children are always grinning, doing backf...   \n",
       "17                              Some bequeath poetry.   \n",
       "18                                Work out. Ten laps.   \n",
       "19    My friend is by no means Dracula or a werewolf,   \n",
       "20                                        Another day   \n",
       "21                                  Haystacks, I need   \n",
       "22             Mostly dumb, but hens are finely tuned   \n",
       "23                   At the Louvre you find Mona Lisa   \n",
       "24           We end easy. Your hand always your hand,   \n",
       "25                           Ã¢â‚¬â€ as i was saying   \n",
       "26  readying it for my loverÃ¢â‚¬â„¢s dinner, I re...   \n",
       "27                          The children in the life:   \n",
       "28                     youÃ¢â‚¬â„¢re in the terrarium   \n",
       "29      perÃ…â€šo Ã…â€ºwiata wymiocino wieprzu jestem   \n",
       "30                      The first night you were gone   \n",
       "31           it appears as a hand-kiss, gentle nudge,   \n",
       "32                          Kobieta naprzeciwko czyta   \n",
       "33                  This morning, the windowsill full   \n",
       "34                                 The sun was losing   \n",
       "35     erscheint als handkuÃƒÅ¸, als sanfter stubser,   \n",
       "36                          How many days did I write   \n",
       "37                     dort, wo die stadt versickert,   \n",
       "38                     ItÃ¢â‚¬â„¢s New YearÃ¢â‚¬â„¢s.   \n",
       "39     Six times every day we stand at the thresholds   \n",
       "40                                         My singing   \n",
       "41            How many poems does a guy have to write   \n",
       "42              First goes floordust, then newspapers   \n",
       "43  a pearl of Ã¢â‚¬Å the world you spew you swine...   \n",
       "44              where the city starts to come undone,   \n",
       "45                                     The unexpected   \n",
       "46                                   Sleep ate silent   \n",
       "47          The woman across from meÃ¢â‚¬â„¢s reading   \n",
       "48                    Indigo pool, color of the wings   \n",
       "49  There is not anyÃ¢â‚¬â€°...Ã¢â‚¬â€°thingÃ¢â‚¬â...   \n",
       "\n",
       "                                                 link  \\\n",
       "0   https://www.poetryfoundation.org/poetrymagazin...   \n",
       "1   https://www.poetryfoundation.org/poetrymagazin...   \n",
       "2   https://www.poetryfoundation.org/poetrymagazin...   \n",
       "3   https://www.poetryfoundation.org/poetrymagazin...   \n",
       "4   https://www.poetryfoundation.org/poetrymagazin...   \n",
       "5   https://www.poetryfoundation.org/poetrymagazin...   \n",
       "6   https://www.poetryfoundation.org/poetrymagazin...   \n",
       "7   https://www.poetryfoundation.org/poetrymagazin...   \n",
       "8   https://www.poetryfoundation.org/poetrymagazin...   \n",
       "9   https://www.poetryfoundation.org/poetrymagazin...   \n",
       "10  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "11  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "12  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "13  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "14  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "15  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "16  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "17  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "18  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "19  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "20  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "21  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "22  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "23  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "24  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "25  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "26  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "27  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "28  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "29  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "30  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "31  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "32  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "33  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "34  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "35  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "36  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "37  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "38  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "39  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "40  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "41  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "42  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "43  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "44  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "45  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "46  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "47  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "48  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "49  https://www.poetryfoundation.org/poetrymagazin...   \n",
       "\n",
       "                                           categories  \\\n",
       "0                      ['Living', 'Health & Illness']   \n",
       "1                                                  []   \n",
       "2   ['Living', 'Health & Illness', 'Social Comment...   \n",
       "3                                                  []   \n",
       "4                                                  []   \n",
       "5                                                  []   \n",
       "6                                                  []   \n",
       "7         ['Arts & Sciences', 'Painting & Sculpture']   \n",
       "8                                                  []   \n",
       "9                        ['Types/Modes', 'Ekphrasis']   \n",
       "10                                                 []   \n",
       "11                       ['Types/Modes', 'Ekphrasis']   \n",
       "12                                                 []   \n",
       "13                                                 []   \n",
       "14                                                 []   \n",
       "15                                                 []   \n",
       "16            ['Relationships', 'Family & Ancestors']   \n",
       "17                                                 []   \n",
       "18         ['Living', 'Health & Illness', 'The Body']   \n",
       "19  ['Living', 'The Body', 'Love', 'Desire', 'Rela...   \n",
       "20                                                 []   \n",
       "21                                                 []   \n",
       "22                                                 []   \n",
       "23                                                 []   \n",
       "24                                                 []   \n",
       "25                                                 []   \n",
       "26                                                 []   \n",
       "27  ['Living', 'Health & Illness', 'Relationships'...   \n",
       "28                                                 []   \n",
       "29                                                 []   \n",
       "30                                                 []   \n",
       "31                                         ['Nature']   \n",
       "32                                                 []   \n",
       "33                                                 []   \n",
       "34                                                 []   \n",
       "35                                         ['Nature']   \n",
       "36                         ['Living', 'Life Choices']   \n",
       "37     ['Social Commentaries', 'Cities & Urban Life']   \n",
       "38  ['Living', 'Death', 'Sorrow & Grieving', 'Rela...   \n",
       "39      ['Social Commentaries', 'Crime & Punishment']   \n",
       "40            ['Relationships', 'Family & Ancestors']   \n",
       "41                                                 []   \n",
       "42                                                 []   \n",
       "43                                                 []   \n",
       "44     ['Social Commentaries', 'Cities & Urban Life']   \n",
       "45                                                 []   \n",
       "46                                                 []   \n",
       "47                                                 []   \n",
       "48                       ['Types/Modes', 'Ekphrasis']   \n",
       "49                              ['Nature', 'Animals']   \n",
       "\n",
       "                                                 poem Unnamed: 7 Unnamed: 8  \\\n",
       "0   Yours free without the asking Quick delivery v...        NaN        NaN   \n",
       "1   CaravaggioÃ¢â‚¬â„¢s face in the sunken pumpkin...        NaN        NaN   \n",
       "2   This poem is for the epidemic dead and the liv...        NaN        NaN   \n",
       "3   Why not climb up the mountain of delight? To t...        NaN        NaN   \n",
       "4   HelloÃ¢â‚¬â€Tonight weÃ¢â‚¬â„¢ll trace the st...        NaN        NaN   \n",
       "5   For Didier Vermont leaves under glass, Your ha...        NaN        NaN   \n",
       "6   Say under land are remembered and muddy rushes...        NaN        NaN   \n",
       "7   Galleria Nazionale dÃ¢â‚¬â„¢Arte Antica, Rome ...        NaN        NaN   \n",
       "8   As in a net. Headfirst on the prairie through ...        NaN        NaN   \n",
       "9   After Kara WalkerÃ¢â‚¬â„¢s Ã¢â‚¬Å“Blue,Ã¢â‚¬Â...        NaN        NaN   \n",
       "10  w terrarium jesteÃ…â€º czarna skrzyneczka rzec...        NaN        NaN   \n",
       "11  After Kara WalkerÃ¢â‚¬â„¢s Ã¢â‚¬Å“Untitled,Ã¢â...        NaN        NaN   \n",
       "12  Reading clouds beyond the road I calculate our...        NaN        NaN   \n",
       "13  Ã¢â‚¬Å“I am not the prodigal son,Ã¢â‚¬Â I sai...        NaN        NaN   \n",
       "14  Rippling hospital sheets circle your brown bod...        NaN        NaN   \n",
       "15  Once teaching English in Ivory Coast you gave ...        NaN        NaN   \n",
       "16  To Armenag Arekian Your children are always gr...        NaN        NaN   \n",
       "17  Some bequeath poetry. Some bequeath hats. Tome...        NaN        NaN   \n",
       "18  Work out. Ten laps. Chin ups. Look good. Steam...        NaN        NaN   \n",
       "19  My friend is by no means Dracula or a werewolf...        NaN        NaN   \n",
       "20  Another day tearing steeds off my mind toward ...        NaN        NaN   \n",
       "21  Haystacks, I need the needle of queer bees and...        NaN        NaN   \n",
       "22  Mostly dumb, but hens are finely tuned to leng...        NaN        NaN   \n",
       "23  At the Louvre you find Mona Lisa gone secretly...        NaN        NaN   \n",
       "24  After Kara WalkerÃ¢â‚¬â„¢s Ã¢â‚¬Å“Tar pit,Ã¢â‚...        NaN        NaN   \n",
       "25  Alongside Kara WalkerÃ¢â‚¬â„¢s Ã¢â‚¬Å“Wokey Wo...        NaN        NaN   \n",
       "26  readying it for my loverÃ¢â‚¬â„¢s dinner, I re...        NaN        NaN   \n",
       "27  They wonÃ¢â‚¬â„¢t go when I go. Ã¢â‚¬â€Stevie...        NaN        NaN   \n",
       "28  youÃ¢â‚¬â„¢re in the terrarium a black box thi...        NaN        NaN   \n",
       "29  perÃ…â€šo Ã…â€ºwiata wymiocino wieprzu jestem ...        NaN        NaN   \n",
       "30  The first night you were gone I heard fingers ...        NaN        NaN   \n",
       "31  it appears as a hand-kiss, gentle nudge, spray...        NaN        NaN   \n",
       "32  Kobieta naprzeciwko czyta Ã¢â‚¬Å¾NajwiÃ„â„¢ksz...        NaN        NaN   \n",
       "33  This morning, the windowsill full of roly poli...        NaN        NaN   \n",
       "34  The sun was losing a long gold tooth on the li...        NaN        NaN   \n",
       "35  erscheint als handkuÃƒÅ¸, als sanfter stubser,...        NaN        NaN   \n",
       "36  How many days did I write then look into a mir...        NaN        NaN   \n",
       "37  dort, wo die stadt versickert, beim bahndamm, ...        NaN        NaN   \n",
       "38  ItÃ¢â‚¬â„¢s New YearÃ¢â‚¬â„¢s. ItÃ¢â‚¬â„¢s New...        NaN        NaN   \n",
       "39  Six times every day we stand at the thresholds...        NaN        NaN   \n",
       "40  My singing voice isnÃ¢â‚¬â„¢t very good, my su...        NaN        NaN   \n",
       "41  How many poems does a guy have to write to get...        NaN        NaN   \n",
       "42  First goes floordust, then newspapers stacked ...        NaN        NaN   \n",
       "43  a pearl of Ã¢â‚¬Å the world you spew you swine...        NaN        NaN   \n",
       "44  where the city starts to come undone, at the r...        NaN        NaN   \n",
       "45  The unexpected intervals in his tone converged...        NaN        NaN   \n",
       "46  Sleep ate silent holes in day after day. I let...        NaN        NaN   \n",
       "47  The woman across from meÃ¢â‚¬â„¢s reading The ...        NaN        NaN   \n",
       "48  After Kara WalkerÃ¢â‚¬â„¢s Ã¢â‚¬Å“Blue,Ã¢â‚¬Â...        NaN        NaN   \n",
       "49  There is not anyÃ¢â‚¬â€°...Ã¢â‚¬â€°thingÃ¢â‚¬â...        NaN        NaN   \n",
       "\n",
       "   Unnamed: 9  ... Unnamed: 1857 Unnamed: 1858 Unnamed: 1859 Unnamed: 1860  \\\n",
       "0         NaN  ...           NaN           NaN           NaN           NaN   \n",
       "1         NaN  ...           NaN           NaN           NaN           NaN   \n",
       "2         NaN  ...           NaN           NaN           NaN           NaN   \n",
       "3         NaN  ...           NaN           NaN           NaN           NaN   \n",
       "4         NaN  ...           NaN           NaN           NaN           NaN   \n",
       "5         NaN  ...           NaN           NaN           NaN           NaN   \n",
       "6         NaN  ...           NaN           NaN           NaN           NaN   \n",
       "7         NaN  ...           NaN           NaN           NaN           NaN   \n",
       "8         NaN  ...           NaN           NaN           NaN           NaN   \n",
       "9         NaN  ...           NaN           NaN           NaN           NaN   \n",
       "10        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "11        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "12        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "13        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "14        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "15        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "16        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "17        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "18        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "19        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "20        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "21        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "22        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "23        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "24        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "25        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "26        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "27        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "28        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "29        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "30        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "31        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "32        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "33        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "34        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "35        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "36        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "37        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "38        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "39        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "40        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "41        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "42        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "43        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "44        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "45        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "46        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "47        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "48        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "49        NaN  ...           NaN           NaN           NaN           NaN   \n",
       "\n",
       "   Unnamed: 1861 Unnamed: 1862 Unnamed: 1863 Unnamed: 1864 Unnamed: 1865  \\\n",
       "0            NaN           NaN           NaN           NaN           NaN   \n",
       "1            NaN           NaN           NaN           NaN           NaN   \n",
       "2            NaN           NaN           NaN           NaN           NaN   \n",
       "3            NaN           NaN           NaN           NaN           NaN   \n",
       "4            NaN           NaN           NaN           NaN           NaN   \n",
       "5            NaN           NaN           NaN           NaN           NaN   \n",
       "6            NaN           NaN           NaN           NaN           NaN   \n",
       "7            NaN           NaN           NaN           NaN           NaN   \n",
       "8            NaN           NaN           NaN           NaN           NaN   \n",
       "9            NaN           NaN           NaN           NaN           NaN   \n",
       "10           NaN           NaN           NaN           NaN           NaN   \n",
       "11           NaN           NaN           NaN           NaN           NaN   \n",
       "12           NaN           NaN           NaN           NaN           NaN   \n",
       "13           NaN           NaN           NaN           NaN           NaN   \n",
       "14           NaN           NaN           NaN           NaN           NaN   \n",
       "15           NaN           NaN           NaN           NaN           NaN   \n",
       "16           NaN           NaN           NaN           NaN           NaN   \n",
       "17           NaN           NaN           NaN           NaN           NaN   \n",
       "18           NaN           NaN           NaN           NaN           NaN   \n",
       "19           NaN           NaN           NaN           NaN           NaN   \n",
       "20           NaN           NaN           NaN           NaN           NaN   \n",
       "21           NaN           NaN           NaN           NaN           NaN   \n",
       "22           NaN           NaN           NaN           NaN           NaN   \n",
       "23           NaN           NaN           NaN           NaN           NaN   \n",
       "24           NaN           NaN           NaN           NaN           NaN   \n",
       "25           NaN           NaN           NaN           NaN           NaN   \n",
       "26           NaN           NaN           NaN           NaN           NaN   \n",
       "27           NaN           NaN           NaN           NaN           NaN   \n",
       "28           NaN           NaN           NaN           NaN           NaN   \n",
       "29           NaN           NaN           NaN           NaN           NaN   \n",
       "30           NaN           NaN           NaN           NaN           NaN   \n",
       "31           NaN           NaN           NaN           NaN           NaN   \n",
       "32           NaN           NaN           NaN           NaN           NaN   \n",
       "33           NaN           NaN           NaN           NaN           NaN   \n",
       "34           NaN           NaN           NaN           NaN           NaN   \n",
       "35           NaN           NaN           NaN           NaN           NaN   \n",
       "36           NaN           NaN           NaN           NaN           NaN   \n",
       "37           NaN           NaN           NaN           NaN           NaN   \n",
       "38           NaN           NaN           NaN           NaN           NaN   \n",
       "39           NaN           NaN           NaN           NaN           NaN   \n",
       "40           NaN           NaN           NaN           NaN           NaN   \n",
       "41           NaN           NaN           NaN           NaN           NaN   \n",
       "42           NaN           NaN           NaN           NaN           NaN   \n",
       "43           NaN           NaN           NaN           NaN           NaN   \n",
       "44           NaN           NaN           NaN           NaN           NaN   \n",
       "45           NaN           NaN           NaN           NaN           NaN   \n",
       "46           NaN           NaN           NaN           NaN           NaN   \n",
       "47           NaN           NaN           NaN           NaN           NaN   \n",
       "48           NaN           NaN           NaN           NaN           NaN   \n",
       "49           NaN           NaN           NaN           NaN           NaN   \n",
       "\n",
       "   Unnamed: 1866  \n",
       "0            NaN  \n",
       "1            NaN  \n",
       "2            NaN  \n",
       "3            NaN  \n",
       "4            NaN  \n",
       "5            NaN  \n",
       "6            NaN  \n",
       "7            NaN  \n",
       "8            NaN  \n",
       "9            NaN  \n",
       "10           NaN  \n",
       "11           NaN  \n",
       "12           NaN  \n",
       "13           NaN  \n",
       "14           NaN  \n",
       "15           NaN  \n",
       "16           NaN  \n",
       "17           NaN  \n",
       "18           NaN  \n",
       "19           NaN  \n",
       "20           NaN  \n",
       "21           NaN  \n",
       "22           NaN  \n",
       "23           NaN  \n",
       "24           NaN  \n",
       "25           NaN  \n",
       "26           NaN  \n",
       "27           NaN  \n",
       "28           NaN  \n",
       "29           NaN  \n",
       "30           NaN  \n",
       "31           NaN  \n",
       "32           NaN  \n",
       "33           NaN  \n",
       "34           NaN  \n",
       "35           NaN  \n",
       "36           NaN  \n",
       "37           NaN  \n",
       "38           NaN  \n",
       "39           NaN  \n",
       "40           NaN  \n",
       "41           NaN  \n",
       "42           NaN  \n",
       "43           NaN  \n",
       "44           NaN  \n",
       "45           NaN  \n",
       "46           NaN  \n",
       "47           NaN  \n",
       "48           NaN  \n",
       "49           NaN  \n",
       "\n",
       "[50 rows x 1867 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combined_df.head(50)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "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.11.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}