csv_to_txt.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Import Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('data/book_titles/good_reads_final.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>author_average_rating</th>\n",
       "      <th>author_gender</th>\n",
       "      <th>author_genres</th>\n",
       "      <th>author_id</th>\n",
       "      <th>author_name</th>\n",
       "      <th>author_page_url</th>\n",
       "      <th>author_rating_count</th>\n",
       "      <th>author_review_count</th>\n",
       "      <th>birthplace</th>\n",
       "      <th>book_average_rating</th>\n",
       "      <th>book_fullurl</th>\n",
       "      <th>book_id</th>\n",
       "      <th>book_title</th>\n",
       "      <th>genre_1</th>\n",
       "      <th>genre_2</th>\n",
       "      <th>num_ratings</th>\n",
       "      <th>num_reviews</th>\n",
       "      <th>pages</th>\n",
       "      <th>publish_date</th>\n",
       "      <th>score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4.01</td>\n",
       "      <td>female</td>\n",
       "      <td>historical-fiction,</td>\n",
       "      <td>74489</td>\n",
       "      <td>Victoria Thompson\\n</td>\n",
       "      <td>/author/show/74489.Victoria_Thompson</td>\n",
       "      <td>74399</td>\n",
       "      <td>6268</td>\n",
       "      <td>United States\\n</td>\n",
       "      <td>4.02</td>\n",
       "      <td>https://www.goodreads.com/book/show/686717.Mur...</td>\n",
       "      <td>686717</td>\n",
       "      <td>\\n      Murder on St. Mark's Place\\n</td>\n",
       "      <td>Mystery</td>\n",
       "      <td>Historical</td>\n",
       "      <td>5260</td>\n",
       "      <td>375</td>\n",
       "      <td>277</td>\n",
       "      <td>2000</td>\n",
       "      <td>3230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4.15</td>\n",
       "      <td>male</td>\n",
       "      <td>literature-fiction,mystery-thrillers,</td>\n",
       "      <td>706255</td>\n",
       "      <td>Stieg Larsson\\n</td>\n",
       "      <td>/author/show/706255.Stieg_Larsson</td>\n",
       "      <td>3726435</td>\n",
       "      <td>142704</td>\n",
       "      <td>Sweden\\n</td>\n",
       "      <td>4.13</td>\n",
       "      <td>https://www.goodreads.com/book/show/2429135.Th...</td>\n",
       "      <td>2429135</td>\n",
       "      <td>\\n      The Girl with the Dragon Tattoo\\n</td>\n",
       "      <td>Fiction</td>\n",
       "      <td>Mystery</td>\n",
       "      <td>2229163</td>\n",
       "      <td>65227</td>\n",
       "      <td>465</td>\n",
       "      <td>August 2005</td>\n",
       "      <td>3062</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4.00</td>\n",
       "      <td>female</td>\n",
       "      <td>romance,</td>\n",
       "      <td>5618190</td>\n",
       "      <td>Mimi Jean Pamfiloff\\n</td>\n",
       "      <td>/author/show/5618190.Mimi_Jean_Pamfiloff</td>\n",
       "      <td>76496</td>\n",
       "      <td>7975</td>\n",
       "      <td>United States\\n</td>\n",
       "      <td>3.99</td>\n",
       "      <td>https://www.goodreads.com/book/show/27833684-t...</td>\n",
       "      <td>27833684</td>\n",
       "      <td>\\n      Tailored for Trouble\\n</td>\n",
       "      <td>Romance</td>\n",
       "      <td>Contemporary</td>\n",
       "      <td>2151</td>\n",
       "      <td>391</td>\n",
       "      <td>354</td>\n",
       "      <td>2016</td>\n",
       "      <td>4585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3.88</td>\n",
       "      <td>male</td>\n",
       "      <td>fiction,memoir,</td>\n",
       "      <td>37871</td>\n",
       "      <td>José Donoso\\n</td>\n",
       "      <td>/author/show/37871.Jos_Donoso</td>\n",
       "      <td>5522</td>\n",
       "      <td>489</td>\n",
       "      <td>Chile\\n</td>\n",
       "      <td>4.14</td>\n",
       "      <td>https://www.goodreads.com/book/show/382975.The...</td>\n",
       "      <td>382975</td>\n",
       "      <td>\\n      The Obscene Bird of Night\\n</td>\n",
       "      <td>Fiction</td>\n",
       "      <td>Magical Realism</td>\n",
       "      <td>1844</td>\n",
       "      <td>173</td>\n",
       "      <td>438</td>\n",
       "      <td>1970</td>\n",
       "      <td>1533</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4.10</td>\n",
       "      <td>female</td>\n",
       "      <td>young-adult,fantasy,</td>\n",
       "      <td>36122</td>\n",
       "      <td>Patricia C. Wrede\\n</td>\n",
       "      <td>/author/show/36122.Patricia_C_Wrede</td>\n",
       "      <td>291013</td>\n",
       "      <td>13453</td>\n",
       "      <td>United States\\n</td>\n",
       "      <td>4.01</td>\n",
       "      <td>https://www.goodreads.com/book/show/64207.Sorc...</td>\n",
       "      <td>64207</td>\n",
       "      <td>\\n      Sorcery &amp; Cecelia: or The Enchanted Ch...</td>\n",
       "      <td>Fantasy</td>\n",
       "      <td>Young Adult</td>\n",
       "      <td>17051</td>\n",
       "      <td>1890</td>\n",
       "      <td>326</td>\n",
       "      <td>April 15th 1988</td>\n",
       "      <td>2105</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   author_average_rating author_gender                          author_genres  \\\n",
       "0                   4.01        female                    historical-fiction,   \n",
       "1                   4.15          male  literature-fiction,mystery-thrillers,   \n",
       "2                   4.00        female                               romance,   \n",
       "3                   3.88          male                        fiction,memoir,   \n",
       "4                   4.10        female                   young-adult,fantasy,   \n",
       "\n",
       "   author_id            author_name                           author_page_url  \\\n",
       "0      74489    Victoria Thompson\\n      /author/show/74489.Victoria_Thompson   \n",
       "1     706255        Stieg Larsson\\n         /author/show/706255.Stieg_Larsson   \n",
       "2    5618190  Mimi Jean Pamfiloff\\n  /author/show/5618190.Mimi_Jean_Pamfiloff   \n",
       "3      37871          José Donoso\\n             /author/show/37871.Jos_Donoso   \n",
       "4      36122    Patricia C. Wrede\\n       /author/show/36122.Patricia_C_Wrede   \n",
       "\n",
       "   author_rating_count  author_review_count            birthplace  \\\n",
       "0                74399                 6268   United States\\n       \n",
       "1              3726435               142704          Sweden\\n       \n",
       "2                76496                 7975     United States\\n     \n",
       "3                 5522                  489           Chile\\n       \n",
       "4               291013                13453   United States\\n       \n",
       "\n",
       "   book_average_rating                                       book_fullurl  \\\n",
       "0                 4.02  https://www.goodreads.com/book/show/686717.Mur...   \n",
       "1                 4.13  https://www.goodreads.com/book/show/2429135.Th...   \n",
       "2                 3.99  https://www.goodreads.com/book/show/27833684-t...   \n",
       "3                 4.14  https://www.goodreads.com/book/show/382975.The...   \n",
       "4                 4.01  https://www.goodreads.com/book/show/64207.Sorc...   \n",
       "\n",
       "    book_id                                         book_title  genre_1  \\\n",
       "0    686717               \\n      Murder on St. Mark's Place\\n  Mystery   \n",
       "1   2429135          \\n      The Girl with the Dragon Tattoo\\n  Fiction   \n",
       "2  27833684                     \\n      Tailored for Trouble\\n  Romance   \n",
       "3    382975                \\n      The Obscene Bird of Night\\n  Fiction   \n",
       "4     64207  \\n      Sorcery & Cecelia: or The Enchanted Ch...  Fantasy   \n",
       "\n",
       "           genre_2  num_ratings  num_reviews pages     publish_date  score  \n",
       "0       Historical         5260          375   277             2000   3230  \n",
       "1          Mystery      2229163        65227   465      August 2005   3062  \n",
       "2     Contemporary         2151          391   354             2016   4585  \n",
       "3  Magical Realism         1844          173   438             1970   1533  \n",
       "4      Young Adult        17051         1890   326  April 15th 1988   2105  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "books = df[['book_title', 'genre_1']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>book_title</th>\n",
       "      <th>genre_1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>\\n      Murder on St. Mark's Place\\n</td>\n",
       "      <td>Mystery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>\\n      The Girl with the Dragon Tattoo\\n</td>\n",
       "      <td>Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>\\n      Tailored for Trouble\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>\\n      The Obscene Bird of Night\\n</td>\n",
       "      <td>Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>\\n      Sorcery &amp; Cecelia: or The Enchanted Ch...</td>\n",
       "      <td>Fantasy</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          book_title  genre_1\n",
       "0               \\n      Murder on St. Mark's Place\\n  Mystery\n",
       "1          \\n      The Girl with the Dragon Tattoo\\n  Fiction\n",
       "2                     \\n      Tailored for Trouble\\n  Romance\n",
       "3                \\n      The Obscene Bird of Night\\n  Fiction\n",
       "4  \\n      Sorcery & Cecelia: or The Enchanted Ch...  Fantasy"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "books.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Get Genres"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Romance                    3397\n",
       "Fantasy                    3397\n",
       "Young Adult                2497\n",
       "Fiction                    2172\n",
       "Historical                 1399\n",
       "Nonfiction                  987\n",
       "Science Fiction             971\n",
       "Mystery                     820\n",
       "Classics                    655\n",
       "Sequential Art              640\n",
       "Horror                      531\n",
       "Childrens                   432\n",
       "History                     420\n",
       "Paranormal                  335\n",
       "New Adult                   326\n",
       "Poetry                      290\n",
       "Erotica                     194\n",
       "Novels                      186\n",
       "Biography                   169\n",
       "Short Stories               166\n",
       "Thriller                    162\n",
       "Dark                        153\n",
       "Christian Fiction           140\n",
       "Religion                    123\n",
       "Philosophy                  118\n",
       "Adult Fiction               113\n",
       "Contemporary                111\n",
       "Humor                       110\n",
       "Lgbt                        102\n",
       "Autobiography                98\n",
       "                           ... \n",
       "Science Fiction Fantasy       2\n",
       "Sexuality                     2\n",
       "Eastern Africa                2\n",
       "Adult                         2\n",
       "Occult                        2\n",
       "Relationships                 2\n",
       "Dark Fantasy                  1\n",
       "Fan Fiction                   1\n",
       "Gardening                     1\n",
       "Reference                     1\n",
       "Love                          1\n",
       "Speculative Fiction           1\n",
       "Medical                       1\n",
       "United States                 1\n",
       "Teaching                      1\n",
       "Design                        1\n",
       "Couture                       1\n",
       "Lds                           1\n",
       "Fairy Tales                   1\n",
       "Esoterica                     1\n",
       "How To                        1\n",
       "Own                           1\n",
       "Social Science                1\n",
       "Dc Comics                     1\n",
       "Pulp                          1\n",
       "Football                      1\n",
       "Did Not Finish                1\n",
       "Epic                          1\n",
       "Dungeons and Dragons          1\n",
       "Death                         1\n",
       "Name: genre_1, Length: 124, dtype: int64"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "books['genre_1'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "124"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(books['genre_1'].value_counts())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "pop_genres = books['genre_1'].value_counts().index.tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Romance',\n",
       " 'Fantasy',\n",
       " 'Young Adult',\n",
       " 'Fiction',\n",
       " 'Historical',\n",
       " 'Nonfiction',\n",
       " 'Science Fiction',\n",
       " 'Mystery',\n",
       " 'Classics',\n",
       " 'Sequential Art',\n",
       " 'Horror',\n",
       " 'Childrens',\n",
       " 'History',\n",
       " 'Paranormal',\n",
       " 'New Adult',\n",
       " 'Poetry',\n",
       " 'Erotica',\n",
       " 'Novels',\n",
       " 'Biography',\n",
       " 'Short Stories',\n",
       " 'Thriller',\n",
       " 'Dark',\n",
       " 'Christian Fiction',\n",
       " 'Religion',\n",
       " 'Philosophy',\n",
       " 'Adult Fiction',\n",
       " 'Contemporary',\n",
       " 'Humor',\n",
       " 'Lgbt',\n",
       " 'Autobiography',\n",
       " 'Womens Fiction',\n",
       " 'Business',\n",
       " 'Holiday',\n",
       " 'Self Help',\n",
       " 'Science',\n",
       " 'Travel',\n",
       " 'Psychology',\n",
       " 'Christian',\n",
       " 'Cultural',\n",
       " 'Politics',\n",
       " 'Sports and Games',\n",
       " 'Asian Literature',\n",
       " 'Food and Drink',\n",
       " 'Plays',\n",
       " 'Spirituality',\n",
       " 'Glbt',\n",
       " 'Feminism',\n",
       " 'Animals',\n",
       " 'Mythology',\n",
       " 'Realistic Fiction',\n",
       " 'Crime',\n",
       " 'Adventure',\n",
       " 'Music',\n",
       " 'Anthologies',\n",
       " 'Comics',\n",
       " 'War',\n",
       " 'Shapeshifters',\n",
       " 'Suspense',\n",
       " 'Westerns',\n",
       " 'Language',\n",
       " 'Health',\n",
       " 'Amish',\n",
       " 'Polyamorous',\n",
       " 'Art',\n",
       " 'Literature',\n",
       " 'World War II',\n",
       " 'Sports',\n",
       " 'Economics',\n",
       " 'Military History',\n",
       " 'Education',\n",
       " 'Magical Realism',\n",
       " 'Warfare',\n",
       " 'Mental Health',\n",
       " 'Apocalyptic',\n",
       " 'Category Romance',\n",
       " 'Media Tie In',\n",
       " 'Sociology',\n",
       " 'Writing',\n",
       " 'Leadership',\n",
       " 'Inspirational',\n",
       " 'Novella',\n",
       " 'Drama',\n",
       " 'European Literature',\n",
       " 'Literary Fiction',\n",
       " 'Spy Thriller',\n",
       " 'Retellings',\n",
       " 'Parenting',\n",
       " 'Manga',\n",
       " 'Northern Africa',\n",
       " 'Christianity',\n",
       " 'Unfinished',\n",
       " 'Marriage',\n",
       " 'Family',\n",
       " 'Biblical Fiction',\n",
       " 'Science Fiction Fantasy',\n",
       " 'Sexuality',\n",
       " 'Eastern Africa',\n",
       " 'Adult',\n",
       " 'Occult',\n",
       " 'Relationships',\n",
       " 'Dark Fantasy',\n",
       " 'Fan Fiction',\n",
       " 'Gardening',\n",
       " 'Reference',\n",
       " 'Love',\n",
       " 'Speculative Fiction',\n",
       " 'Medical',\n",
       " 'United States',\n",
       " 'Teaching',\n",
       " 'Design',\n",
       " 'Couture',\n",
       " 'Lds',\n",
       " 'Fairy Tales',\n",
       " 'Esoterica',\n",
       " 'How To',\n",
       " 'Own',\n",
       " 'Social Science',\n",
       " 'Dc Comics',\n",
       " 'Pulp',\n",
       " 'Football',\n",
       " 'Did Not Finish',\n",
       " 'Epic',\n",
       " 'Dungeons and Dragons',\n",
       " 'Death']"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pop_genres # Genres in order of popularity"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Romance',\n",
       " 'Fantasy',\n",
       " 'Young Adult',\n",
       " 'Fiction',\n",
       " 'Historical',\n",
       " 'Nonfiction',\n",
       " 'Science Fiction',\n",
       " 'Mystery',\n",
       " 'Classics',\n",
       " 'Sequential Art',\n",
       " 'Horror',\n",
       " 'Childrens',\n",
       " 'History',\n",
       " 'Paranormal',\n",
       " 'New Adult',\n",
       " 'Poetry',\n",
       " 'Erotica',\n",
       " 'Novels',\n",
       " 'Biography',\n",
       " 'Short Stories',\n",
       " 'Thriller',\n",
       " 'Dark',\n",
       " 'Christian Fiction',\n",
       " 'Religion',\n",
       " 'Philosophy',\n",
       " 'Adult Fiction',\n",
       " 'Contemporary',\n",
       " 'Humor',\n",
       " 'Lgbt',\n",
       " 'Autobiography']"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pop_genres[:30]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "top_genres = pop_genres[:30]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>book_title</th>\n",
       "      <th>genre_1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>\\n      Murder on St. Mark's Place\\n</td>\n",
       "      <td>Mystery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>\\n      The Girl with the Dragon Tattoo\\n</td>\n",
       "      <td>Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>\\n      Tailored for Trouble\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>\\n      The Obscene Bird of Night\\n</td>\n",
       "      <td>Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>\\n      Sorcery &amp; Cecelia: or The Enchanted Ch...</td>\n",
       "      <td>Fantasy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>\\n      30 Days of Night, Vol. 1\\n</td>\n",
       "      <td>Sequential Art</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>\\n      Stalk Me\\n</td>\n",
       "      <td>Young Adult</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>\\n      Bonk: The Curious Coupling of Science ...</td>\n",
       "      <td>Nonfiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>\\n      Kiss of the Vampire\\n</td>\n",
       "      <td>Paranormal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>\\n      Leaving Paradise\\n</td>\n",
       "      <td>Young Adult</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>\\n      Firefight\\n</td>\n",
       "      <td>Fantasy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>\\n      Loki's Wolves\\n</td>\n",
       "      <td>Fantasy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>\\n      Devil in Winter\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>\\n      Mockingjay\\n</td>\n",
       "      <td>Young Adult</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>\\n      Island\\n</td>\n",
       "      <td>Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>\\n      Dirty Ross\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>\\n      Screwups\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>\\n      Pull Me Under\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>\\n      Strength of the Mate\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>\\n      Tequila Mockingbird\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>\\n      Of Last Resort\\n</td>\n",
       "      <td>Fantasy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>\\n      Slow Burn\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>\\n      Complementary Colors\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>\\n      Mark of Cain\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>\\n      Wood, Screws, &amp; Nails\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>\\n      Beauty And The Bookworm\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>\\n      Bad Influence\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>\\n      The Understatement of the Year\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>\\n      The Only One Who Knows\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>\\n      Payoff\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22861</th>\n",
       "      <td>\\n      The Last Lecture\\n</td>\n",
       "      <td>Nonfiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22862</th>\n",
       "      <td>\\n      Being You, Changing the World\\n</td>\n",
       "      <td>Self Help</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22863</th>\n",
       "      <td>\\n      Your Ultimate Life Plan: How to Deeply...</td>\n",
       "      <td>Self Help</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22864</th>\n",
       "      <td>\\n      Mountains Beyond Mountains: The Quest ...</td>\n",
       "      <td>Nonfiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22865</th>\n",
       "      <td>\\n      Awakening Inner Guru\\n</td>\n",
       "      <td>Spirituality</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22866</th>\n",
       "      <td>\\n      Within a Man's Heart\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22867</th>\n",
       "      <td>\\n      Awaken Your Alpha: Tales and Tactics t...</td>\n",
       "      <td>Psychology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22868</th>\n",
       "      <td>\\n      The Butterfly Experience\\n</td>\n",
       "      <td>Self Help</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22869</th>\n",
       "      <td>\\n      Am I Black Enough For You?\\n</td>\n",
       "      <td>Nonfiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22870</th>\n",
       "      <td>\\n      October Snow\\n</td>\n",
       "      <td>Thriller</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22871</th>\n",
       "      <td>\\n      The Emotional Life of Your Brain: How ...</td>\n",
       "      <td>Psychology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22872</th>\n",
       "      <td>\\n      The Leper Messiah\\n</td>\n",
       "      <td>Christian Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22873</th>\n",
       "      <td>\\n      Lights on the Sea\\n</td>\n",
       "      <td>Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22874</th>\n",
       "      <td>\\n      Rafael\\n</td>\n",
       "      <td>Fantasy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22875</th>\n",
       "      <td>\\n      Rebecca\\n</td>\n",
       "      <td>Fantasy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22876</th>\n",
       "      <td>\\n      Dark Wolf Rising\\n</td>\n",
       "      <td>Fantasy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22877</th>\n",
       "      <td>\\n      Wicked Memories\\n</td>\n",
       "      <td>Fantasy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22878</th>\n",
       "      <td>\\n      Emerald Fire\\n</td>\n",
       "      <td>Fantasy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22879</th>\n",
       "      <td>\\n      Light a Candle for the Beast\\n</td>\n",
       "      <td>Fantasy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22880</th>\n",
       "      <td>\\n      Hidden Moon\\n</td>\n",
       "      <td>Young Adult</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22881</th>\n",
       "      <td>\\n      The Master of Whitehall - Katelyn's Ch...</td>\n",
       "      <td>Paranormal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22882</th>\n",
       "      <td>\\n      Given to the Pack\\n</td>\n",
       "      <td>Fantasy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22883</th>\n",
       "      <td>\\n      The Mating: The Original Law of the Ly...</td>\n",
       "      <td>Fantasy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22884</th>\n",
       "      <td>\\n      The Seventh\\n</td>\n",
       "      <td>Young Adult</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22885</th>\n",
       "      <td>\\n      Highland Storm\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22886</th>\n",
       "      <td>\\n      Gotta Have Faith\\n</td>\n",
       "      <td>Fantasy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22887</th>\n",
       "      <td>\\n      Payton's Pursuit\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22888</th>\n",
       "      <td>\\n      My Viking Vampire\\n</td>\n",
       "      <td>Fantasy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22889</th>\n",
       "      <td>\\n      The Trinity\\n</td>\n",
       "      <td>Fantasy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22890</th>\n",
       "      <td>\\n      Volatile Breath of Darkness\\n</td>\n",
       "      <td>Fantasy</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>22891 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              book_title            genre_1\n",
       "0                   \\n      Murder on St. Mark's Place\\n            Mystery\n",
       "1              \\n      The Girl with the Dragon Tattoo\\n            Fiction\n",
       "2                         \\n      Tailored for Trouble\\n            Romance\n",
       "3                    \\n      The Obscene Bird of Night\\n            Fiction\n",
       "4      \\n      Sorcery & Cecelia: or The Enchanted Ch...            Fantasy\n",
       "5                     \\n      30 Days of Night, Vol. 1\\n     Sequential Art\n",
       "6                                     \\n      Stalk Me\\n        Young Adult\n",
       "7      \\n      Bonk: The Curious Coupling of Science ...         Nonfiction\n",
       "8                          \\n      Kiss of the Vampire\\n         Paranormal\n",
       "9                             \\n      Leaving Paradise\\n        Young Adult\n",
       "10                                   \\n      Firefight\\n            Fantasy\n",
       "11                               \\n      Loki's Wolves\\n            Fantasy\n",
       "12                             \\n      Devil in Winter\\n            Romance\n",
       "13                                  \\n      Mockingjay\\n        Young Adult\n",
       "14                                      \\n      Island\\n            Fiction\n",
       "15                                  \\n      Dirty Ross\\n            Romance\n",
       "16                                    \\n      Screwups\\n            Romance\n",
       "17                               \\n      Pull Me Under\\n            Romance\n",
       "18                        \\n      Strength of the Mate\\n            Romance\n",
       "19                         \\n      Tequila Mockingbird\\n            Romance\n",
       "20                              \\n      Of Last Resort\\n            Fantasy\n",
       "21                                   \\n      Slow Burn\\n            Romance\n",
       "22                        \\n      Complementary Colors\\n            Romance\n",
       "23                                \\n      Mark of Cain\\n            Romance\n",
       "24                       \\n      Wood, Screws, & Nails\\n            Romance\n",
       "25                     \\n      Beauty And The Bookworm\\n            Romance\n",
       "26                               \\n      Bad Influence\\n            Romance\n",
       "27              \\n      The Understatement of the Year\\n            Romance\n",
       "28                      \\n      The Only One Who Knows\\n            Romance\n",
       "29                                      \\n      Payoff\\n            Romance\n",
       "...                                                  ...                ...\n",
       "22861                         \\n      The Last Lecture\\n         Nonfiction\n",
       "22862            \\n      Being You, Changing the World\\n          Self Help\n",
       "22863  \\n      Your Ultimate Life Plan: How to Deeply...          Self Help\n",
       "22864  \\n      Mountains Beyond Mountains: The Quest ...         Nonfiction\n",
       "22865                     \\n      Awakening Inner Guru\\n       Spirituality\n",
       "22866                     \\n      Within a Man's Heart\\n            Romance\n",
       "22867  \\n      Awaken Your Alpha: Tales and Tactics t...         Psychology\n",
       "22868                 \\n      The Butterfly Experience\\n          Self Help\n",
       "22869               \\n      Am I Black Enough For You?\\n         Nonfiction\n",
       "22870                             \\n      October Snow\\n           Thriller\n",
       "22871  \\n      The Emotional Life of Your Brain: How ...         Psychology\n",
       "22872                        \\n      The Leper Messiah\\n  Christian Fiction\n",
       "22873                        \\n      Lights on the Sea\\n            Fiction\n",
       "22874                                   \\n      Rafael\\n            Fantasy\n",
       "22875                                  \\n      Rebecca\\n            Fantasy\n",
       "22876                         \\n      Dark Wolf Rising\\n            Fantasy\n",
       "22877                          \\n      Wicked Memories\\n            Fantasy\n",
       "22878                             \\n      Emerald Fire\\n            Fantasy\n",
       "22879             \\n      Light a Candle for the Beast\\n            Fantasy\n",
       "22880                              \\n      Hidden Moon\\n        Young Adult\n",
       "22881  \\n      The Master of Whitehall - Katelyn's Ch...         Paranormal\n",
       "22882                        \\n      Given to the Pack\\n            Fantasy\n",
       "22883  \\n      The Mating: The Original Law of the Ly...            Fantasy\n",
       "22884                              \\n      The Seventh\\n        Young Adult\n",
       "22885                           \\n      Highland Storm\\n            Romance\n",
       "22886                         \\n      Gotta Have Faith\\n            Fantasy\n",
       "22887                         \\n      Payton's Pursuit\\n            Romance\n",
       "22888                        \\n      My Viking Vampire\\n            Fantasy\n",
       "22889                              \\n      The Trinity\\n            Fantasy\n",
       "22890              \\n      Volatile Breath of Darkness\\n            Fantasy\n",
       "\n",
       "[22891 rows x 2 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "books"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "romance = books.loc[books['genre_1'] == 'Romance']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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>book_title</th>\n",
       "      <th>genre_1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>\\n      Tailored for Trouble\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>\\n      Devil in Winter\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>\\n      Dirty Ross\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>\\n      Screwups\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>\\n      Pull Me Under\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>\\n      Strength of the Mate\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>\\n      Tequila Mockingbird\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>\\n      Slow Burn\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>\\n      Complementary Colors\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>\\n      Mark of Cain\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>\\n      Wood, Screws, &amp; Nails\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>\\n      Beauty And The Bookworm\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>\\n      Bad Influence\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>\\n      The Understatement of the Year\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>\\n      The Only One Who Knows\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>\\n      Payoff\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>\\n      Personal Secrets\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>\\n      The House on Hancock Hill\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>\\n      Timber Pack Chronicles\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>\\n      Remnant: A Caldwell &amp; Feximal/Whyborne...</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>\\n      The River Leith\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>\\n      Turning 16\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>\\n      Tough Love\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>\\n      Stories Beneath Our Skin\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>\\n      Beneath the Stain\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>\\n      Fair Play\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>\\n      1/27: An ICoS Anthology\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>\\n      Wolf in Gucci Loafers\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>\\n      Bloodline\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>\\n      Being Sawyer Knight\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22676</th>\n",
       "      <td>\\n      The Billionaire's Bauble\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22689</th>\n",
       "      <td>\\n      Lie Down In Roses\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22690</th>\n",
       "      <td>\\n      The Ground She Walks Upon\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22691</th>\n",
       "      <td>\\n      Fierce Eden\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22692</th>\n",
       "      <td>\\n      Enchantress Mine\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22694</th>\n",
       "      <td>\\n      Untamed\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22695</th>\n",
       "      <td>\\n      Lady Vixen\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22696</th>\n",
       "      <td>\\n      When the Splendor Falls\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22698</th>\n",
       "      <td>\\n      The Sheik\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22699</th>\n",
       "      <td>\\n      Dark Fires\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22700</th>\n",
       "      <td>\\n      Enslaved\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22701</th>\n",
       "      <td>\\n      Love's Tender Fury\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22702</th>\n",
       "      <td>\\n      Stormfire\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22730</th>\n",
       "      <td>\\n      Let Me Fall\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22738</th>\n",
       "      <td>\\n      The Simple Soul of Susan\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22769</th>\n",
       "      <td>\\n      Her Heart for the Asking\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22770</th>\n",
       "      <td>\\n      Lacuna\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22771</th>\n",
       "      <td>\\n      Fresh Temptation\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22772</th>\n",
       "      <td>\\n      For a Hero\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22803</th>\n",
       "      <td>\\n      Road to Hallelujah\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22809</th>\n",
       "      <td>\\n      Gut gegen Nordwind\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22815</th>\n",
       "      <td>\\n      Kirschroter Sommer\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22826</th>\n",
       "      <td>\\n      My Wattpad Love\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22828</th>\n",
       "      <td>\\n      Behind Bars\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22829</th>\n",
       "      <td>\\n      Believe Me, I'm Lying\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22830</th>\n",
       "      <td>\\n      Maid for Hire\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22832</th>\n",
       "      <td>\\n      548 Heartbeats\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22866</th>\n",
       "      <td>\\n      Within a Man's Heart\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22885</th>\n",
       "      <td>\\n      Highland Storm\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22887</th>\n",
       "      <td>\\n      Payton's Pursuit\\n</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3397 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              book_title  genre_1\n",
       "2                         \\n      Tailored for Trouble\\n  Romance\n",
       "12                             \\n      Devil in Winter\\n  Romance\n",
       "15                                  \\n      Dirty Ross\\n  Romance\n",
       "16                                    \\n      Screwups\\n  Romance\n",
       "17                               \\n      Pull Me Under\\n  Romance\n",
       "18                        \\n      Strength of the Mate\\n  Romance\n",
       "19                         \\n      Tequila Mockingbird\\n  Romance\n",
       "21                                   \\n      Slow Burn\\n  Romance\n",
       "22                        \\n      Complementary Colors\\n  Romance\n",
       "23                                \\n      Mark of Cain\\n  Romance\n",
       "24                       \\n      Wood, Screws, & Nails\\n  Romance\n",
       "25                     \\n      Beauty And The Bookworm\\n  Romance\n",
       "26                               \\n      Bad Influence\\n  Romance\n",
       "27              \\n      The Understatement of the Year\\n  Romance\n",
       "28                      \\n      The Only One Who Knows\\n  Romance\n",
       "29                                      \\n      Payoff\\n  Romance\n",
       "31                            \\n      Personal Secrets\\n  Romance\n",
       "32                   \\n      The House on Hancock Hill\\n  Romance\n",
       "33                      \\n      Timber Pack Chronicles\\n  Romance\n",
       "34     \\n      Remnant: A Caldwell & Feximal/Whyborne...  Romance\n",
       "35                             \\n      The River Leith\\n  Romance\n",
       "36                                  \\n      Turning 16\\n  Romance\n",
       "37                                  \\n      Tough Love\\n  Romance\n",
       "38                    \\n      Stories Beneath Our Skin\\n  Romance\n",
       "39                           \\n      Beneath the Stain\\n  Romance\n",
       "40                                   \\n      Fair Play\\n  Romance\n",
       "41                     \\n      1/27: An ICoS Anthology\\n  Romance\n",
       "42                       \\n      Wolf in Gucci Loafers\\n  Romance\n",
       "43                                   \\n      Bloodline\\n  Romance\n",
       "44                         \\n      Being Sawyer Knight\\n  Romance\n",
       "...                                                  ...      ...\n",
       "22676                 \\n      The Billionaire's Bauble\\n  Romance\n",
       "22689                        \\n      Lie Down In Roses\\n  Romance\n",
       "22690                \\n      The Ground She Walks Upon\\n  Romance\n",
       "22691                              \\n      Fierce Eden\\n  Romance\n",
       "22692                         \\n      Enchantress Mine\\n  Romance\n",
       "22694                                  \\n      Untamed\\n  Romance\n",
       "22695                               \\n      Lady Vixen\\n  Romance\n",
       "22696                  \\n      When the Splendor Falls\\n  Romance\n",
       "22698                                \\n      The Sheik\\n  Romance\n",
       "22699                               \\n      Dark Fires\\n  Romance\n",
       "22700                                 \\n      Enslaved\\n  Romance\n",
       "22701                       \\n      Love's Tender Fury\\n  Romance\n",
       "22702                                \\n      Stormfire\\n  Romance\n",
       "22730                              \\n      Let Me Fall\\n  Romance\n",
       "22738                 \\n      The Simple Soul of Susan\\n  Romance\n",
       "22769                 \\n      Her Heart for the Asking\\n  Romance\n",
       "22770                                   \\n      Lacuna\\n  Romance\n",
       "22771                         \\n      Fresh Temptation\\n  Romance\n",
       "22772                               \\n      For a Hero\\n  Romance\n",
       "22803                       \\n      Road to Hallelujah\\n  Romance\n",
       "22809                       \\n      Gut gegen Nordwind\\n  Romance\n",
       "22815                       \\n      Kirschroter Sommer\\n  Romance\n",
       "22826                          \\n      My Wattpad Love\\n  Romance\n",
       "22828                              \\n      Behind Bars\\n  Romance\n",
       "22829                    \\n      Believe Me, I'm Lying\\n  Romance\n",
       "22830                            \\n      Maid for Hire\\n  Romance\n",
       "22832                           \\n      548 Heartbeats\\n  Romance\n",
       "22866                     \\n      Within a Man's Heart\\n  Romance\n",
       "22885                           \\n      Highland Storm\\n  Romance\n",
       "22887                         \\n      Payton's Pursuit\\n  Romance\n",
       "\n",
       "[3397 rows x 2 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "romance"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "romance_list = list(romance['book_title'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "with open('romance.txt', 'w') as f:\n",
    "    [f.write(title.lstrip()) for title in romance_list]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### For each of the top 30 genres, write book titles to a txt file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "for genre in top_genres:\n",
    "    genre_titles = books.loc[books['genre_1'] == genre]\n",
    "    genre_list = list(genre_titles['book_title'])\n",
    "    \n",
    "    # Write to file\n",
    "    filename = str(genre) + '.txt'\n",
    "    with open(filename, 'w') as f:\n",
    "        \n",
    "        [f.write(title.lstrip()) for title in genre_list]"
   ]
  }
 ],
 "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}