02_filtering.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>artist</th>\n",
       "      <th>song</th>\n",
       "      <th>link</th>\n",
       "      <th>text</th>\n",
       "      <th>embedding</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ABBA</td>\n",
       "      <td>Ahe's My Kind Of Girl</td>\n",
       "      <td>/a/abba/ahes+my+kind+of+girl_20598417.html</td>\n",
       "      <td>Look at her face, it's a wonderful face  \\nAnd...</td>\n",
       "      <td>[0.06642276793718338, 0.029657185077667236, -0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ABBA</td>\n",
       "      <td>Andante, Andante</td>\n",
       "      <td>/a/abba/andante+andante_20002708.html</td>\n",
       "      <td>Take it easy with me, please  \\nTouch me gentl...</td>\n",
       "      <td>[-0.0038928603753447533, -0.001233731512911617...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ABBA</td>\n",
       "      <td>As Good As New</td>\n",
       "      <td>/a/abba/as+good+as+new_20003033.html</td>\n",
       "      <td>I'll never know why I had to go  \\nWhy I had t...</td>\n",
       "      <td>[0.013708599843084812, -0.0019766672048717737,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ABBA</td>\n",
       "      <td>Bang</td>\n",
       "      <td>/a/abba/bang_20598415.html</td>\n",
       "      <td>Making somebody happy is a question of give an...</td>\n",
       "      <td>[-0.01959819346666336, -7.80902337282896e-05, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ABBA</td>\n",
       "      <td>Bang-A-Boomerang</td>\n",
       "      <td>/a/abba/bang+a+boomerang_20002668.html</td>\n",
       "      <td>Making somebody happy is a question of give an...</td>\n",
       "      <td>[-0.01218902412801981, -0.0025808592326939106,...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  artist                   song                                        link  \\\n",
       "0   ABBA  Ahe's My Kind Of Girl  /a/abba/ahes+my+kind+of+girl_20598417.html   \n",
       "1   ABBA       Andante, Andante       /a/abba/andante+andante_20002708.html   \n",
       "2   ABBA         As Good As New        /a/abba/as+good+as+new_20003033.html   \n",
       "3   ABBA                   Bang                  /a/abba/bang_20598415.html   \n",
       "4   ABBA       Bang-A-Boomerang      /a/abba/bang+a+boomerang_20002668.html   \n",
       "\n",
       "                                                text  \\\n",
       "0  Look at her face, it's a wonderful face  \\nAnd...   \n",
       "1  Take it easy with me, please  \\nTouch me gentl...   \n",
       "2  I'll never know why I had to go  \\nWhy I had t...   \n",
       "3  Making somebody happy is a question of give an...   \n",
       "4  Making somebody happy is a question of give an...   \n",
       "\n",
       "                                           embedding  \n",
       "0  [0.06642276793718338, 0.029657185077667236, -0...  \n",
       "1  [-0.0038928603753447533, -0.001233731512911617...  \n",
       "2  [0.013708599843084812, -0.0019766672048717737,...  \n",
       "3  [-0.01959819346666336, -7.80902337282896e-05, ...  \n",
       "4  [-0.01218902412801981, -0.0025808592326939106,...  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"data/cache/57k_spotify_songs_with_embeddings.csv\")\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "overcoming_adversity_songs = [\"Eye of The Tiger\", \"Lose Yourself\", \"I Will Survive\"]\n",
    "lost_love_songs = [\"Someone Like You\", \"Yesterday\", \"Fast Car\"]\n",
    "unconventional_love = [\"A Sky Full Of Stars\", \"Born This Way\", \"You Oughta Know\"]\n",
    "social_commentary_protest = [\"Fight The Power\", \"Imagine\", \"The Times They Are a-Changin\"]\n",
    "celebrating_life_simple_joys = [\"Three Little Birds\", \"Mr. Blue Sky\", \"Count Your Blessings\"]\n",
    "finding_unexpected_hope = [\"Fix You\", \"Hallelujah\", \"Lean on Me\"]\n",
    "embracing_change = [\"Metamorphosis\", \"Time\", \"Beautiful Boy\"]\n",
    "vulnerability = [\"Someone You Loved\", \"All Too Well\", \"Hallelujah\"]\n",
    "#questionin_authority =[]  # redundant with social_commentary_protest\n",
    "enduring_power = [\"Can't Help Falling in Love\", \"I Will Always Love You\", \"You've Got a Friend in Me\"]\n",
    "hustle_and_ambition = [\"HUMBLE\", \"Humble\", \"Motivation\", \"APESHIT\", \"Apeshit\", \"Headlines\", \"Started From The Bottom\"]\n",
    "vulnerability_modern = [\"Someone You Loved\", \"thank u, next\", \"Runaway\"]\n",
    "digital_love = [\"Love Again\", \"Positions\", \"Blank Space\"]\n",
    "socal_commentary_modern = [\"This is America\", \"Alright\", \"FORMATION\"]\n",
    "celebrating_life_simple_joys_modern = [\"Uptown Funk\", \"7 Rings\", \"Happy\"]\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_some_titles(df:pd.DataFrame, titles:list[str])->pd.DataFrame:\n",
    "    return df[df['song'].isin(titles)]\n",
    "\n",
    "def get_some_artists(df:pd.DataFrame, artists:list[str])->pd.DataFrame:\n",
    "    return df[df['artist'].isin(artists)]\n",
    "\n",
    "def get_specific_song(df:pd.DataFrame, doc:dict)->pd.DataFrame:\n",
    "    return df[(df['song'] == doc[\"title\"]) & (df['artist'] == doc[\"artist\"])]\n",
    "\n",
    "def get_specific_songs(df:pd.DataFrame, docs:list[dict])->pd.DataFrame:\n",
    "    dfs = []\n",
    "    for doc in docs:\n",
    "        dfs.append(get_specific_song(df, doc))\n",
    "\n",
    "    return pd.concat(dfs, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>artist</th>\n",
       "      <th>song</th>\n",
       "      <th>link</th>\n",
       "      <th>text</th>\n",
       "      <th>embedding</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4400</th>\n",
       "      <td>Donna Summer</td>\n",
       "      <td>I Will Survive</td>\n",
       "      <td>/d/donna+summer/i+will+survive_20344036.html</td>\n",
       "      <td>At First I was afriad I was petrified kept  \\n...</td>\n",
       "      <td>[0.003032202133908868, 0.023577341809868813, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5225</th>\n",
       "      <td>Enrique Iglesias</td>\n",
       "      <td>I Will Survive</td>\n",
       "      <td>/e/enrique+iglesias/i+will+survive_20050490.html</td>\n",
       "      <td>You like to think  \\nThat you're the only one ...</td>\n",
       "      <td>[-0.012407868169248104, -0.012963099405169487,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18615</th>\n",
       "      <td>Snoop Dogg</td>\n",
       "      <td>I Will Survive</td>\n",
       "      <td>/s/snoop+dogg/i+will+survive_20127250.html</td>\n",
       "      <td>[Technique]  \\nBy dawn's early light  \\nI shin...</td>\n",
       "      <td>[0.03273875266313553, -0.03275517001748085, -0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26716</th>\n",
       "      <td>Cake</td>\n",
       "      <td>I Will Survive</td>\n",
       "      <td>/c/cake/i+will+survive_20026649.html</td>\n",
       "      <td>At first I was afraid  \\nI was petrified  \\nI ...</td>\n",
       "      <td>[0.011708802543580532, 0.005558684002608061, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29781</th>\n",
       "      <td>Diana Ross</td>\n",
       "      <td>I Will Survive</td>\n",
       "      <td>/d/diana+ross/i+will+survive_20040334.html</td>\n",
       "      <td>At first I was afraid, I was petrified  \\nKept...</td>\n",
       "      <td>[-0.0015416833339259028, 0.0010260598501190543...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31412</th>\n",
       "      <td>Eminem</td>\n",
       "      <td>Lose Yourself</td>\n",
       "      <td>/e/eminem/lose+yourself_20049853.html</td>\n",
       "      <td>Look,  \\nIf you had  \\nOne shot,  \\nOr one opp...</td>\n",
       "      <td>[0.009385927580296993, -0.01625148393213749, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34222</th>\n",
       "      <td>Gloria Gaynor</td>\n",
       "      <td>I Will Survive</td>\n",
       "      <td>/g/gloria+gaynor/i+will+survive_20060853.html</td>\n",
       "      <td>At first I was afraid  \\nI was petrified  \\nKe...</td>\n",
       "      <td>[0.003166492562741041, -0.0008579716086387634,...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 artist            song  \\\n",
       "4400       Donna Summer  I Will Survive   \n",
       "5225   Enrique Iglesias  I Will Survive   \n",
       "18615        Snoop Dogg  I Will Survive   \n",
       "26716              Cake  I Will Survive   \n",
       "29781        Diana Ross  I Will Survive   \n",
       "31412            Eminem   Lose Yourself   \n",
       "34222     Gloria Gaynor  I Will Survive   \n",
       "\n",
       "                                                   link  \\\n",
       "4400       /d/donna+summer/i+will+survive_20344036.html   \n",
       "5225   /e/enrique+iglesias/i+will+survive_20050490.html   \n",
       "18615        /s/snoop+dogg/i+will+survive_20127250.html   \n",
       "26716              /c/cake/i+will+survive_20026649.html   \n",
       "29781        /d/diana+ross/i+will+survive_20040334.html   \n",
       "31412             /e/eminem/lose+yourself_20049853.html   \n",
       "34222     /g/gloria+gaynor/i+will+survive_20060853.html   \n",
       "\n",
       "                                                    text  \\\n",
       "4400   At First I was afriad I was petrified kept  \\n...   \n",
       "5225   You like to think  \\nThat you're the only one ...   \n",
       "18615  [Technique]  \\nBy dawn's early light  \\nI shin...   \n",
       "26716  At first I was afraid  \\nI was petrified  \\nI ...   \n",
       "29781  At first I was afraid, I was petrified  \\nKept...   \n",
       "31412  Look,  \\nIf you had  \\nOne shot,  \\nOr one opp...   \n",
       "34222  At first I was afraid  \\nI was petrified  \\nKe...   \n",
       "\n",
       "                                               embedding  \n",
       "4400   [0.003032202133908868, 0.023577341809868813, -...  \n",
       "5225   [-0.012407868169248104, -0.012963099405169487,...  \n",
       "18615  [0.03273875266313553, -0.03275517001748085, -0...  \n",
       "26716  [0.011708802543580532, 0.005558684002608061, -...  \n",
       "29781  [-0.0015416833339259028, 0.0010260598501190543...  \n",
       "31412  [0.009385927580296993, -0.01625148393213749, -...  \n",
       "34222  [0.003166492562741041, -0.0008579716086387634,...  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_adversity = get_some_titles(df, overcoming_adversity_songs)\n",
    "df_adversity"
   ]
  },
  {
   "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>artist</th>\n",
       "      <th>song</th>\n",
       "      <th>link</th>\n",
       "      <th>text</th>\n",
       "      <th>embedding</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>Adele</td>\n",
       "      <td>Someone Like You</td>\n",
       "      <td>/a/adele/someone+like+you_20895042.html</td>\n",
       "      <td>I heard, that you're settled down  \\nThat you ...</td>\n",
       "      <td>[-0.001011601067148149, 0.015197799541056156, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>737</th>\n",
       "      <td>Andrea Bocelli</td>\n",
       "      <td>Someone Like You</td>\n",
       "      <td>/a/andrea+bocelli/someone+like+you_20259252.html</td>\n",
       "      <td>There's a wind that blows  \\nIts calling your ...</td>\n",
       "      <td>[-0.010463973507285118, -0.005383264273405075,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11249</th>\n",
       "      <td>Lea Salonga</td>\n",
       "      <td>Someone Like You</td>\n",
       "      <td>/l/lea+salonga/someone+like+you_20259250.html</td>\n",
       "      <td>I peer through windows, watch life go by  \\nDr...</td>\n",
       "      <td>[-0.023078233003616333, 0.00800719577819109, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11330</th>\n",
       "      <td>Leann Rimes</td>\n",
       "      <td>Yesterday</td>\n",
       "      <td>/l/leann+rimes/yesterday_20081755.html</td>\n",
       "      <td>Yesterday  \\nAll my troubles seemed so far awa...</td>\n",
       "      <td>[0.005206454079598188, -0.00895118247717619, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29033</th>\n",
       "      <td>David Guetta</td>\n",
       "      <td>Yesterday</td>\n",
       "      <td>/d/david+guetta/yesterday_21091494.html</td>\n",
       "      <td>Black hearts, black days  \\nRaindrops on my wi...</td>\n",
       "      <td>[-0.006372200325131416, 0.008253052830696106, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30431</th>\n",
       "      <td>Doris Day</td>\n",
       "      <td>Someone Like You</td>\n",
       "      <td>/d/doris+day/someone+like+you_20259247.html</td>\n",
       "      <td>SOMEONE LIKE YOU  \\nDoris Day  \\nSomeone like ...</td>\n",
       "      <td>[0.0042880019173026085, -0.011537902057170868,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38404</th>\n",
       "      <td>John Waite</td>\n",
       "      <td>Someone Like You</td>\n",
       "      <td>/j/john+waite/someone+like+you_20074927.html</td>\n",
       "      <td>I've been searchin' for a long time  \\nFor som...</td>\n",
       "      <td>[0.009535818360745907, -0.03921271115541458, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39627</th>\n",
       "      <td>Keith Urban</td>\n",
       "      <td>Yesterday</td>\n",
       "      <td>/k/keith+urban/yesterday_20355268.html</td>\n",
       "      <td>I remember as a kid wishin' I was seventeen  \\...</td>\n",
       "      <td>[-0.013970003463327885, -0.00858971755951643, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41436</th>\n",
       "      <td>Lenny Kravitz</td>\n",
       "      <td>Someone Like You</td>\n",
       "      <td>/l/lenny+kravitz/someone+like+you_20082708.html</td>\n",
       "      <td>Waiting impatiently for you to come  \\nWonderi...</td>\n",
       "      <td>[-0.017525682225823402, -0.019543791189789772,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45493</th>\n",
       "      <td>New Order</td>\n",
       "      <td>Someone Like You</td>\n",
       "      <td>/n/new+order/someone+like+you_20099848.html</td>\n",
       "      <td>This can't be real  \\nMy heart is burning  \\nH...</td>\n",
       "      <td>[0.01765388436615467, -4.970571171725169e-05, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53447</th>\n",
       "      <td>Tom Jones</td>\n",
       "      <td>Yesterday</td>\n",
       "      <td>/t/tom+jones/yesterday_20822926.html</td>\n",
       "      <td>Yesterday  \\nAll my trouble seemed so far away...</td>\n",
       "      <td>[0.008172382600605488, -0.004260649438947439, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53837</th>\n",
       "      <td>Tracy Chapman</td>\n",
       "      <td>Fast Car</td>\n",
       "      <td>/t/tracy+chapman/fast+car_20140283.html</td>\n",
       "      <td>You got a fast car  \\nI want a ticket to anywh...</td>\n",
       "      <td>[0.0014589953934773803, -0.01970677077770233, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54208</th>\n",
       "      <td>UB40</td>\n",
       "      <td>Someone Like You</td>\n",
       "      <td>/u/ub40/someone+like+you_20141704.html</td>\n",
       "      <td>There must be some place we can go  \\nThere mu...</td>\n",
       "      <td>[0.02701108157634735, -0.01824222318828106, -0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54845</th>\n",
       "      <td>Vanessa Williams</td>\n",
       "      <td>Someone Like You</td>\n",
       "      <td>/v/vanessa+williams/someone+like+you_20143494....</td>\n",
       "      <td>I've been searching a long time  \\nFor someone...</td>\n",
       "      <td>[0.013681726530194283, -0.032380834221839905, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56067</th>\n",
       "      <td>Wet Wet Wet</td>\n",
       "      <td>Someone Like You</td>\n",
       "      <td>/w/wet+wet+wet/someone+like+you_20146037.html</td>\n",
       "      <td>Give your broken heart to me  \\nLet me give yo...</td>\n",
       "      <td>[-0.002741436241194606, 0.005262381862848997, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56079</th>\n",
       "      <td>Wet Wet Wet</td>\n",
       "      <td>Yesterday</td>\n",
       "      <td>/w/wet+wet+wet/yesterday_20145994.html</td>\n",
       "      <td>Yesterday  \\nAll my troubles seem so far away ...</td>\n",
       "      <td>[0.00959842186421156, -0.004123372957110405, -...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 artist              song  \\\n",
       "142               Adele  Someone Like You   \n",
       "737      Andrea Bocelli  Someone Like You   \n",
       "11249       Lea Salonga  Someone Like You   \n",
       "11330       Leann Rimes         Yesterday   \n",
       "29033      David Guetta         Yesterday   \n",
       "30431         Doris Day  Someone Like You   \n",
       "38404        John Waite  Someone Like You   \n",
       "39627       Keith Urban         Yesterday   \n",
       "41436     Lenny Kravitz  Someone Like You   \n",
       "45493         New Order  Someone Like You   \n",
       "53447         Tom Jones         Yesterday   \n",
       "53837     Tracy Chapman          Fast Car   \n",
       "54208              UB40  Someone Like You   \n",
       "54845  Vanessa Williams  Someone Like You   \n",
       "56067       Wet Wet Wet  Someone Like You   \n",
       "56079       Wet Wet Wet         Yesterday   \n",
       "\n",
       "                                                    link  \\\n",
       "142              /a/adele/someone+like+you_20895042.html   \n",
       "737     /a/andrea+bocelli/someone+like+you_20259252.html   \n",
       "11249      /l/lea+salonga/someone+like+you_20259250.html   \n",
       "11330             /l/leann+rimes/yesterday_20081755.html   \n",
       "29033            /d/david+guetta/yesterday_21091494.html   \n",
       "30431        /d/doris+day/someone+like+you_20259247.html   \n",
       "38404       /j/john+waite/someone+like+you_20074927.html   \n",
       "39627             /k/keith+urban/yesterday_20355268.html   \n",
       "41436    /l/lenny+kravitz/someone+like+you_20082708.html   \n",
       "45493        /n/new+order/someone+like+you_20099848.html   \n",
       "53447               /t/tom+jones/yesterday_20822926.html   \n",
       "53837            /t/tracy+chapman/fast+car_20140283.html   \n",
       "54208             /u/ub40/someone+like+you_20141704.html   \n",
       "54845  /v/vanessa+williams/someone+like+you_20143494....   \n",
       "56067      /w/wet+wet+wet/someone+like+you_20146037.html   \n",
       "56079             /w/wet+wet+wet/yesterday_20145994.html   \n",
       "\n",
       "                                                    text  \\\n",
       "142    I heard, that you're settled down  \\nThat you ...   \n",
       "737    There's a wind that blows  \\nIts calling your ...   \n",
       "11249  I peer through windows, watch life go by  \\nDr...   \n",
       "11330  Yesterday  \\nAll my troubles seemed so far awa...   \n",
       "29033  Black hearts, black days  \\nRaindrops on my wi...   \n",
       "30431  SOMEONE LIKE YOU  \\nDoris Day  \\nSomeone like ...   \n",
       "38404  I've been searchin' for a long time  \\nFor som...   \n",
       "39627  I remember as a kid wishin' I was seventeen  \\...   \n",
       "41436  Waiting impatiently for you to come  \\nWonderi...   \n",
       "45493  This can't be real  \\nMy heart is burning  \\nH...   \n",
       "53447  Yesterday  \\nAll my trouble seemed so far away...   \n",
       "53837  You got a fast car  \\nI want a ticket to anywh...   \n",
       "54208  There must be some place we can go  \\nThere mu...   \n",
       "54845  I've been searching a long time  \\nFor someone...   \n",
       "56067  Give your broken heart to me  \\nLet me give yo...   \n",
       "56079  Yesterday  \\nAll my troubles seem so far away ...   \n",
       "\n",
       "                                               embedding  \n",
       "142    [-0.001011601067148149, 0.015197799541056156, ...  \n",
       "737    [-0.010463973507285118, -0.005383264273405075,...  \n",
       "11249  [-0.023078233003616333, 0.00800719577819109, -...  \n",
       "11330  [0.005206454079598188, -0.00895118247717619, -...  \n",
       "29033  [-0.006372200325131416, 0.008253052830696106, ...  \n",
       "30431  [0.0042880019173026085, -0.011537902057170868,...  \n",
       "38404  [0.009535818360745907, -0.03921271115541458, -...  \n",
       "39627  [-0.013970003463327885, -0.00858971755951643, ...  \n",
       "41436  [-0.017525682225823402, -0.019543791189789772,...  \n",
       "45493  [0.01765388436615467, -4.970571171725169e-05, ...  \n",
       "53447  [0.008172382600605488, -0.004260649438947439, ...  \n",
       "53837  [0.0014589953934773803, -0.01970677077770233, ...  \n",
       "54208  [0.02701108157634735, -0.01824222318828106, -0...  \n",
       "54845  [0.013681726530194283, -0.032380834221839905, ...  \n",
       "56067  [-0.002741436241194606, 0.005262381862848997, ...  \n",
       "56079  [0.00959842186421156, -0.004123372957110405, -...  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_lost_love = get_some_titles(df, lost_love_songs)\n",
    "df_lost_love"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>artist</th>\n",
       "      <th>song</th>\n",
       "      <th>link</th>\n",
       "      <th>text</th>\n",
       "      <th>embedding</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4590</th>\n",
       "      <td>Dusty Springfield</td>\n",
       "      <td>Born This Way</td>\n",
       "      <td>/d/dusty+springfield/born+this+way_20043916.html</td>\n",
       "      <td>Some people know what they want to be  \\nSome ...</td>\n",
       "      <td>[-0.008672240190207958, -0.021503286436200142,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28154</th>\n",
       "      <td>Coldplay</td>\n",
       "      <td>A Sky Full Of Stars</td>\n",
       "      <td>/c/coldplay/a+sky+full+of+stars_21080656.html</td>\n",
       "      <td>Cause you're a sky  \\nCause you're a sky full ...</td>\n",
       "      <td>[-0.0010626889998093247, -0.003887535771355033...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41071</th>\n",
       "      <td>Lady Gaga</td>\n",
       "      <td>Born This Way</td>\n",
       "      <td>/l/lady+gaga/born+this+way_20886224.html</td>\n",
       "      <td>It doesn't matter if you love him, or capital ...</td>\n",
       "      <td>[-0.034117475152015686, -0.01094469428062439, ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  artist                 song  \\\n",
       "4590   Dusty Springfield        Born This Way   \n",
       "28154           Coldplay  A Sky Full Of Stars   \n",
       "41071          Lady Gaga        Born This Way   \n",
       "\n",
       "                                                   link  \\\n",
       "4590   /d/dusty+springfield/born+this+way_20043916.html   \n",
       "28154     /c/coldplay/a+sky+full+of+stars_21080656.html   \n",
       "41071          /l/lady+gaga/born+this+way_20886224.html   \n",
       "\n",
       "                                                    text  \\\n",
       "4590   Some people know what they want to be  \\nSome ...   \n",
       "28154  Cause you're a sky  \\nCause you're a sky full ...   \n",
       "41071  It doesn't matter if you love him, or capital ...   \n",
       "\n",
       "                                               embedding  \n",
       "4590   [-0.008672240190207958, -0.021503286436200142,...  \n",
       "28154  [-0.0010626889998093247, -0.003887535771355033...  \n",
       "41071  [-0.034117475152015686, -0.01094469428062439, ...  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_unconventional_love = get_some_titles(df, unconventional_love)\n",
    "df_unconventional_love"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>artist</th>\n",
       "      <th>song</th>\n",
       "      <th>link</th>\n",
       "      <th>text</th>\n",
       "      <th>embedding</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1769</th>\n",
       "      <td>Bon Jovi</td>\n",
       "      <td>Imagine</td>\n",
       "      <td>/b/bon+jovi/imagine_20525130.html</td>\n",
       "      <td>Imagine there's no heaven,  \\nIt's easy if you...</td>\n",
       "      <td>[7.887257379479706e-05, -0.014932435937225819,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4215</th>\n",
       "      <td>Diana Ross</td>\n",
       "      <td>Imagine</td>\n",
       "      <td>/d/diana+ross/imagine_20040404.html</td>\n",
       "      <td>Imagine there's no heaven  \\nIt's easy if you ...</td>\n",
       "      <td>[-0.0030573096591979265, -0.011585594154894352...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6885</th>\n",
       "      <td>Glee</td>\n",
       "      <td>Imagine</td>\n",
       "      <td>/g/glee/imagine_20854234.html</td>\n",
       "      <td>Imagine there's no countries,  \\nIt isn't hard...</td>\n",
       "      <td>[0.0005396539927460253, -0.005662862677127123,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7340</th>\n",
       "      <td>Guns N' Roses</td>\n",
       "      <td>Imagine</td>\n",
       "      <td>/g/guns+n+roses/imagine_20254363.html</td>\n",
       "      <td>Imagine there's no heaven  \\nIt's easy if you ...</td>\n",
       "      <td>[-0.0028800235595554113, -0.013500225730240345...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8782</th>\n",
       "      <td>Isley Brothers</td>\n",
       "      <td>Fight The Power</td>\n",
       "      <td>/i/isley+brothers/fight+the+power_20550091.html</td>\n",
       "      <td>Time is truly wastin'  \\nThere's no guarantee ...</td>\n",
       "      <td>[0.005122637376189232, -0.03986527770757675, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19748</th>\n",
       "      <td>Train</td>\n",
       "      <td>Imagine</td>\n",
       "      <td>/t/train/imagine_21054702.html</td>\n",
       "      <td>Finally met Virginia on a slow summer night  \\...</td>\n",
       "      <td>[0.014494938775897026, 0.0026340431068092585, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24406</th>\n",
       "      <td>Avril Lavigne</td>\n",
       "      <td>Imagine</td>\n",
       "      <td>/a/avril+lavigne/imagine_20785697.html</td>\n",
       "      <td>Imagine there's no Heaven  \\nIt's easy if you ...</td>\n",
       "      <td>[0.0019653926137834787, -0.014208001084625721,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24783</th>\n",
       "      <td>The Beatles</td>\n",
       "      <td>Imagine</td>\n",
       "      <td>/b/beatles/imagine_20254326.html</td>\n",
       "      <td>Imagine there's no heaven  \\nIt's easy if you ...</td>\n",
       "      <td>[-0.0028800235595554113, -0.013500225730240345...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42531</th>\n",
       "      <td>Madonna</td>\n",
       "      <td>Imagine</td>\n",
       "      <td>/m/madonna/imagine_21007422.html</td>\n",
       "      <td>Imagine there's no heaven, it's easy if you tr...</td>\n",
       "      <td>[0.0028323810547590256, -0.005683011841028929,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47054</th>\n",
       "      <td>Our Lady Peace</td>\n",
       "      <td>Imagine</td>\n",
       "      <td>/o/our+lady+peace/imagine_20254375.html</td>\n",
       "      <td>Imagine there's no heaven  \\nIt's easy if you ...</td>\n",
       "      <td>[-0.00010684491280699149, -0.01777328364551067...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57048</th>\n",
       "      <td>Xzibit</td>\n",
       "      <td>Fight The Power</td>\n",
       "      <td>/x/xzibit/fight+the+power_20676422.html</td>\n",
       "      <td>Yeah, yeah, yeah, yeah  \\nLet's go...  \\n  \\nF...</td>\n",
       "      <td>[0.003855300834402442, 0.010755379684269428, -...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               artist             song  \\\n",
       "1769         Bon Jovi          Imagine   \n",
       "4215       Diana Ross          Imagine   \n",
       "6885             Glee          Imagine   \n",
       "7340    Guns N' Roses          Imagine   \n",
       "8782   Isley Brothers  Fight The Power   \n",
       "19748           Train          Imagine   \n",
       "24406   Avril Lavigne          Imagine   \n",
       "24783     The Beatles          Imagine   \n",
       "42531         Madonna          Imagine   \n",
       "47054  Our Lady Peace          Imagine   \n",
       "57048          Xzibit  Fight The Power   \n",
       "\n",
       "                                                  link  \\\n",
       "1769                 /b/bon+jovi/imagine_20525130.html   \n",
       "4215               /d/diana+ross/imagine_20040404.html   \n",
       "6885                     /g/glee/imagine_20854234.html   \n",
       "7340             /g/guns+n+roses/imagine_20254363.html   \n",
       "8782   /i/isley+brothers/fight+the+power_20550091.html   \n",
       "19748                   /t/train/imagine_21054702.html   \n",
       "24406           /a/avril+lavigne/imagine_20785697.html   \n",
       "24783                 /b/beatles/imagine_20254326.html   \n",
       "42531                 /m/madonna/imagine_21007422.html   \n",
       "47054          /o/our+lady+peace/imagine_20254375.html   \n",
       "57048          /x/xzibit/fight+the+power_20676422.html   \n",
       "\n",
       "                                                    text  \\\n",
       "1769   Imagine there's no heaven,  \\nIt's easy if you...   \n",
       "4215   Imagine there's no heaven  \\nIt's easy if you ...   \n",
       "6885   Imagine there's no countries,  \\nIt isn't hard...   \n",
       "7340   Imagine there's no heaven  \\nIt's easy if you ...   \n",
       "8782   Time is truly wastin'  \\nThere's no guarantee ...   \n",
       "19748  Finally met Virginia on a slow summer night  \\...   \n",
       "24406  Imagine there's no Heaven  \\nIt's easy if you ...   \n",
       "24783  Imagine there's no heaven  \\nIt's easy if you ...   \n",
       "42531  Imagine there's no heaven, it's easy if you tr...   \n",
       "47054  Imagine there's no heaven  \\nIt's easy if you ...   \n",
       "57048  Yeah, yeah, yeah, yeah  \\nLet's go...  \\n  \\nF...   \n",
       "\n",
       "                                               embedding  \n",
       "1769   [7.887257379479706e-05, -0.014932435937225819,...  \n",
       "4215   [-0.0030573096591979265, -0.011585594154894352...  \n",
       "6885   [0.0005396539927460253, -0.005662862677127123,...  \n",
       "7340   [-0.0028800235595554113, -0.013500225730240345...  \n",
       "8782   [0.005122637376189232, -0.03986527770757675, -...  \n",
       "19748  [0.014494938775897026, 0.0026340431068092585, ...  \n",
       "24406  [0.0019653926137834787, -0.014208001084625721,...  \n",
       "24783  [-0.0028800235595554113, -0.013500225730240345...  \n",
       "42531  [0.0028323810547590256, -0.005683011841028929,...  \n",
       "47054  [-0.00010684491280699149, -0.01777328364551067...  \n",
       "57048  [0.003855300834402442, 0.010755379684269428, -...  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_social_commentary = get_some_titles(df, social_commentary_protest)\n",
    "df_social_commentary"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>artist</th>\n",
       "      <th>song</th>\n",
       "      <th>link</th>\n",
       "      <th>text</th>\n",
       "      <th>embedding</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>25468</th>\n",
       "      <td>Bing Crosby</td>\n",
       "      <td>Count Your Blessings</td>\n",
       "      <td>/b/bing+crosby/count+your+blessings_20174318.html</td>\n",
       "      <td>When I'm worried and I can't sleep  \\nI count ...</td>\n",
       "      <td>[0.04553067311644554, 0.025391507893800735, -0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25939</th>\n",
       "      <td>Bob Marley</td>\n",
       "      <td>Three Little Birds</td>\n",
       "      <td>/b/bob+marley/three+little+birds_20021728.html</td>\n",
       "      <td>\"Don't worry about a thing,  \\n'Cause every li...</td>\n",
       "      <td>[0.03456290066242218, 0.012554642744362354, -0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30890</th>\n",
       "      <td>Electric Light Orchestra</td>\n",
       "      <td>Mr. Blue Sky</td>\n",
       "      <td>/e/electric+light+orchestra/mr+blue+sky_100955...</td>\n",
       "      <td>Sun is shinin' in the sky  \\nThere ain't a clo...</td>\n",
       "      <td>[0.010506678372621536, -0.03418045863509178, 0...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         artist                  song  \\\n",
       "25468               Bing Crosby  Count Your Blessings   \n",
       "25939                Bob Marley    Three Little Birds   \n",
       "30890  Electric Light Orchestra          Mr. Blue Sky   \n",
       "\n",
       "                                                    link  \\\n",
       "25468  /b/bing+crosby/count+your+blessings_20174318.html   \n",
       "25939     /b/bob+marley/three+little+birds_20021728.html   \n",
       "30890  /e/electric+light+orchestra/mr+blue+sky_100955...   \n",
       "\n",
       "                                                    text  \\\n",
       "25468  When I'm worried and I can't sleep  \\nI count ...   \n",
       "25939  \"Don't worry about a thing,  \\n'Cause every li...   \n",
       "30890  Sun is shinin' in the sky  \\nThere ain't a clo...   \n",
       "\n",
       "                                               embedding  \n",
       "25468  [0.04553067311644554, 0.025391507893800735, -0...  \n",
       "25939  [0.03456290066242218, 0.012554642744362354, -0...  \n",
       "30890  [0.010506678372621536, -0.03418045863509178, 0...  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_celebrating_life = get_some_titles(df, celebrating_life_simple_joys)\n",
    "df_celebrating_life"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>artist</th>\n",
       "      <th>song</th>\n",
       "      <th>link</th>\n",
       "      <th>text</th>\n",
       "      <th>embedding</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3259</th>\n",
       "      <td>Coldplay</td>\n",
       "      <td>Fix You</td>\n",
       "      <td>/c/coldplay/fix+you_10069035.html</td>\n",
       "      <td>When you try your best but you don't succeed  ...</td>\n",
       "      <td>[-0.0026855459436774254, 0.0014632658567279577...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3968</th>\n",
       "      <td>Deep Purple</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/d/deep+purple/hallelujah_20038862.html</td>\n",
       "      <td>Hallelujah  \\n  \\nI am a preacher with a messa...</td>\n",
       "      <td>[0.021293198689818382, -0.013212421908974648, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6859</th>\n",
       "      <td>Glee</td>\n",
       "      <td>Fix You</td>\n",
       "      <td>/g/glee/fix+you_20986203.html</td>\n",
       "      <td>When you try your best, but you don't succeed ...</td>\n",
       "      <td>[-0.0027727694250643253, -0.001137596438638866...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10045</th>\n",
       "      <td>Justin Timberlake</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/j/justin+timberlake/hallelujah_20869243.html</td>\n",
       "      <td>Well I heard there was a secret chord  \\nThat ...</td>\n",
       "      <td>[0.0678350031375885, -0.0015728170983493328, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11458</th>\n",
       "      <td>Leonard Cohen</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/l/leonard+cohen/hallelujah_20082898.html</td>\n",
       "      <td>Now I've heard there was a secret chord  \\nTha...</td>\n",
       "      <td>[0.0684051588177681, 0.007501555606722832, -0....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14709</th>\n",
       "      <td>Offspring</td>\n",
       "      <td>Fix You</td>\n",
       "      <td>/o/offspring/fix+you_20746531.html</td>\n",
       "      <td>She wakes up  \\nRage and grace  \\nPulling me c...</td>\n",
       "      <td>[0.0073354062624275684, -0.020965302363038063,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23332</th>\n",
       "      <td>Aled Jones</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/a/aled+jones/hallelujah_20996423.html</td>\n",
       "      <td>Hallelujah  \\n  \\nNow I've heard there was a s...</td>\n",
       "      <td>[0.0685945451259613, 0.009993200190365314, -0....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24395</th>\n",
       "      <td>Avril Lavigne</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/a/avril+lavigne/hallelujah_20517915.html</td>\n",
       "      <td>We sat by the fire  \\nUnited in song  \\nUnder ...</td>\n",
       "      <td>[0.02589884214103222, -0.019296027719974518, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25125</th>\n",
       "      <td>Bette Midler</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/b/bette+midler/hallelujah_21017441.html</td>\n",
       "      <td>I don't know if you can hear me  \\nOr if you'r...</td>\n",
       "      <td>[-0.007787676528096199, -0.0084657808765769, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26132</th>\n",
       "      <td>Bon Jovi</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/b/bon+jovi/hallelujah_20834623.html</td>\n",
       "      <td>Well, I heard there was a secret chord  \\nThat...</td>\n",
       "      <td>[0.06314229965209961, -0.01527197752147913, -0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35849</th>\n",
       "      <td>Hillsong</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/h/hillsong/hallelujah_20769123.html</td>\n",
       "      <td>Saved by Your mercy,  \\nFound in Your grace,  ...</td>\n",
       "      <td>[0.027860939502716064, 0.034558702260255814, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35952</th>\n",
       "      <td>Hillsong United</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/h/hillsong+united/hallelujah_20214284.html</td>\n",
       "      <td>Saved by your mercy  \\nFound in your grace  \\n...</td>\n",
       "      <td>[0.02531852014362812, 0.0398869514465332, 0.00...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39786</th>\n",
       "      <td>Kelly Family</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/k/kelly+family/hallelujah_20214282.html</td>\n",
       "      <td>Fell in love with a beautiful girl  \\nWith a b...</td>\n",
       "      <td>[0.01493329368531704, -0.004307958763092756, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45550</th>\n",
       "      <td>Nick Cave</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/n/nick+cave/hallelujah_20214279.html</td>\n",
       "      <td>On the first day of May I took to the road  \\n...</td>\n",
       "      <td>[0.04142089560627937, -0.027789535000920296, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49949</th>\n",
       "      <td>Rammstein</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/r/rammstein/hallelujah_10238419.html</td>\n",
       "      <td>Er ist fromm und sehr sensibel  \\nAn seiner Wa...</td>\n",
       "      <td>[0.05139243230223656, -0.010995015501976013, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50687</th>\n",
       "      <td>Rem</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/r/rem/hallelujah_20984700.html</td>\n",
       "      <td>The world is an oyster, the bitter refrain  \\n...</td>\n",
       "      <td>[0.02759125642478466, -0.02506842464208603, -0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56577</th>\n",
       "      <td>Willie Nelson</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/w/willie+nelson/hallelujah_20818044.html</td>\n",
       "      <td>All the years combine, they melt into a dream,...</td>\n",
       "      <td>[0.009090729989111423, -0.014868603087961674, ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  artist        song  \\\n",
       "3259            Coldplay     Fix You   \n",
       "3968         Deep Purple  Hallelujah   \n",
       "6859                Glee     Fix You   \n",
       "10045  Justin Timberlake  Hallelujah   \n",
       "11458      Leonard Cohen  Hallelujah   \n",
       "14709          Offspring     Fix You   \n",
       "23332         Aled Jones  Hallelujah   \n",
       "24395      Avril Lavigne  Hallelujah   \n",
       "25125       Bette Midler  Hallelujah   \n",
       "26132           Bon Jovi  Hallelujah   \n",
       "35849           Hillsong  Hallelujah   \n",
       "35952    Hillsong United  Hallelujah   \n",
       "39786       Kelly Family  Hallelujah   \n",
       "45550          Nick Cave  Hallelujah   \n",
       "49949          Rammstein  Hallelujah   \n",
       "50687                Rem  Hallelujah   \n",
       "56577      Willie Nelson  Hallelujah   \n",
       "\n",
       "                                                link  \\\n",
       "3259               /c/coldplay/fix+you_10069035.html   \n",
       "3968         /d/deep+purple/hallelujah_20038862.html   \n",
       "6859                   /g/glee/fix+you_20986203.html   \n",
       "10045  /j/justin+timberlake/hallelujah_20869243.html   \n",
       "11458      /l/leonard+cohen/hallelujah_20082898.html   \n",
       "14709             /o/offspring/fix+you_20746531.html   \n",
       "23332         /a/aled+jones/hallelujah_20996423.html   \n",
       "24395      /a/avril+lavigne/hallelujah_20517915.html   \n",
       "25125       /b/bette+midler/hallelujah_21017441.html   \n",
       "26132           /b/bon+jovi/hallelujah_20834623.html   \n",
       "35849           /h/hillsong/hallelujah_20769123.html   \n",
       "35952    /h/hillsong+united/hallelujah_20214284.html   \n",
       "39786       /k/kelly+family/hallelujah_20214282.html   \n",
       "45550          /n/nick+cave/hallelujah_20214279.html   \n",
       "49949          /r/rammstein/hallelujah_10238419.html   \n",
       "50687                /r/rem/hallelujah_20984700.html   \n",
       "56577      /w/willie+nelson/hallelujah_20818044.html   \n",
       "\n",
       "                                                    text  \\\n",
       "3259   When you try your best but you don't succeed  ...   \n",
       "3968   Hallelujah  \\n  \\nI am a preacher with a messa...   \n",
       "6859   When you try your best, but you don't succeed ...   \n",
       "10045  Well I heard there was a secret chord  \\nThat ...   \n",
       "11458  Now I've heard there was a secret chord  \\nTha...   \n",
       "14709  She wakes up  \\nRage and grace  \\nPulling me c...   \n",
       "23332  Hallelujah  \\n  \\nNow I've heard there was a s...   \n",
       "24395  We sat by the fire  \\nUnited in song  \\nUnder ...   \n",
       "25125  I don't know if you can hear me  \\nOr if you'r...   \n",
       "26132  Well, I heard there was a secret chord  \\nThat...   \n",
       "35849  Saved by Your mercy,  \\nFound in Your grace,  ...   \n",
       "35952  Saved by your mercy  \\nFound in your grace  \\n...   \n",
       "39786  Fell in love with a beautiful girl  \\nWith a b...   \n",
       "45550  On the first day of May I took to the road  \\n...   \n",
       "49949  Er ist fromm und sehr sensibel  \\nAn seiner Wa...   \n",
       "50687  The world is an oyster, the bitter refrain  \\n...   \n",
       "56577  All the years combine, they melt into a dream,...   \n",
       "\n",
       "                                               embedding  \n",
       "3259   [-0.0026855459436774254, 0.0014632658567279577...  \n",
       "3968   [0.021293198689818382, -0.013212421908974648, ...  \n",
       "6859   [-0.0027727694250643253, -0.001137596438638866...  \n",
       "10045  [0.0678350031375885, -0.0015728170983493328, -...  \n",
       "11458  [0.0684051588177681, 0.007501555606722832, -0....  \n",
       "14709  [0.0073354062624275684, -0.020965302363038063,...  \n",
       "23332  [0.0685945451259613, 0.009993200190365314, -0....  \n",
       "24395  [0.02589884214103222, -0.019296027719974518, -...  \n",
       "25125  [-0.007787676528096199, -0.0084657808765769, -...  \n",
       "26132  [0.06314229965209961, -0.01527197752147913, -0...  \n",
       "35849  [0.027860939502716064, 0.034558702260255814, -...  \n",
       "35952  [0.02531852014362812, 0.0398869514465332, 0.00...  \n",
       "39786  [0.01493329368531704, -0.004307958763092756, -...  \n",
       "45550  [0.04142089560627937, -0.027789535000920296, -...  \n",
       "49949  [0.05139243230223656, -0.010995015501976013, -...  \n",
       "50687  [0.02759125642478466, -0.02506842464208603, -0...  \n",
       "56577  [0.009090729989111423, -0.014868603087961674, ...  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_finding_unexpected_hope = get_some_titles(df, finding_unexpected_hope)\n",
    "df_finding_unexpected_hope"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>artist</th>\n",
       "      <th>song</th>\n",
       "      <th>link</th>\n",
       "      <th>text</th>\n",
       "      <th>embedding</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>469</th>\n",
       "      <td>Alan Parsons Project</td>\n",
       "      <td>Time</td>\n",
       "      <td>/a/alan+parsons+project/time_20005407.html</td>\n",
       "      <td>Time, flowing like a river  \\nTime, beckoning ...</td>\n",
       "      <td>[-0.039811164140701294, -0.03449476882815361, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11781</th>\n",
       "      <td>Lionel Richie</td>\n",
       "      <td>Time</td>\n",
       "      <td>/l/lionel+richie/time_20490893.html</td>\n",
       "      <td>As I wake up in the morning on life's big roll...</td>\n",
       "      <td>[0.012520577758550644, -0.008200659416615963, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16342</th>\n",
       "      <td>Pretenders</td>\n",
       "      <td>Time</td>\n",
       "      <td>/p/pretenders/time_20321330.html</td>\n",
       "      <td>You're always welcome  \\nTo stop on by  \\nI'll...</td>\n",
       "      <td>[0.013232952915132046, -0.028795422986149788, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24540</th>\n",
       "      <td>Backstreet Boys</td>\n",
       "      <td>Time</td>\n",
       "      <td>/b/backstreet+boys/time_20011556.html</td>\n",
       "      <td>I know that I  \\nI can't believe  \\nJust what ...</td>\n",
       "      <td>[-0.00933157466351986, -0.02158532105386257, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27024</th>\n",
       "      <td>Celine Dion</td>\n",
       "      <td>Beautiful Boy</td>\n",
       "      <td>/c/celine+dion/beautiful+boy_20422413.html</td>\n",
       "      <td>You're a beautiful boy  \\nWith all your little...</td>\n",
       "      <td>[0.02668825164437294, -0.004220354370772839, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28480</th>\n",
       "      <td>Culture Club</td>\n",
       "      <td>Time</td>\n",
       "      <td>/c/culture+club/time_10073793.html</td>\n",
       "      <td>Don't put your head on my shoulder  \\nSink me ...</td>\n",
       "      <td>[0.004418435040861368, -0.022462952882051468, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34169</th>\n",
       "      <td>Glen Campbell</td>\n",
       "      <td>Time</td>\n",
       "      <td>/g/glen+campbell/time_20320476.html</td>\n",
       "      <td>Some people run, some people crawl  \\nSome peo...</td>\n",
       "      <td>[0.01612345688045025, -0.04075673967599869, -0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35782</th>\n",
       "      <td>Helloween</td>\n",
       "      <td>Time</td>\n",
       "      <td>/h/helloween/time_20065131.html</td>\n",
       "      <td>Feel it running off  \\nSo strong and clear  \\n...</td>\n",
       "      <td>[-0.023307006806135178, -0.04097108542919159, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37108</th>\n",
       "      <td>INXS</td>\n",
       "      <td>Time</td>\n",
       "      <td>/i/inxs/time_20067787.html</td>\n",
       "      <td>Got to make a sense yeah  \\nEverything affects...</td>\n",
       "      <td>[-0.0002824359980877489, -0.028917821124196053...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47307</th>\n",
       "      <td>Ozzy Osbourne</td>\n",
       "      <td>Time</td>\n",
       "      <td>/o/ozzy+osbourne/time_20534552.html</td>\n",
       "      <td>The time has come for you  \\nTo make up your o...</td>\n",
       "      <td>[-0.01812022551894188, -0.014986223541200161, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47971</th>\n",
       "      <td>Pet Shop Boys</td>\n",
       "      <td>Metamorphosis</td>\n",
       "      <td>/p/pet+shop+boys/metamorphosis_20107113.html</td>\n",
       "      <td>Please allow me to try and explain  \\nI'm livi...</td>\n",
       "      <td>[0.015279334969818592, 0.010907626710832119, -...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     artist           song  \\\n",
       "469    Alan Parsons Project           Time   \n",
       "11781         Lionel Richie           Time   \n",
       "16342            Pretenders           Time   \n",
       "24540       Backstreet Boys           Time   \n",
       "27024           Celine Dion  Beautiful Boy   \n",
       "28480          Culture Club           Time   \n",
       "34169         Glen Campbell           Time   \n",
       "35782             Helloween           Time   \n",
       "37108                  INXS           Time   \n",
       "47307         Ozzy Osbourne           Time   \n",
       "47971         Pet Shop Boys  Metamorphosis   \n",
       "\n",
       "                                               link  \\\n",
       "469      /a/alan+parsons+project/time_20005407.html   \n",
       "11781           /l/lionel+richie/time_20490893.html   \n",
       "16342              /p/pretenders/time_20321330.html   \n",
       "24540         /b/backstreet+boys/time_20011556.html   \n",
       "27024    /c/celine+dion/beautiful+boy_20422413.html   \n",
       "28480            /c/culture+club/time_10073793.html   \n",
       "34169           /g/glen+campbell/time_20320476.html   \n",
       "35782               /h/helloween/time_20065131.html   \n",
       "37108                    /i/inxs/time_20067787.html   \n",
       "47307           /o/ozzy+osbourne/time_20534552.html   \n",
       "47971  /p/pet+shop+boys/metamorphosis_20107113.html   \n",
       "\n",
       "                                                    text  \\\n",
       "469    Time, flowing like a river  \\nTime, beckoning ...   \n",
       "11781  As I wake up in the morning on life's big roll...   \n",
       "16342  You're always welcome  \\nTo stop on by  \\nI'll...   \n",
       "24540  I know that I  \\nI can't believe  \\nJust what ...   \n",
       "27024  You're a beautiful boy  \\nWith all your little...   \n",
       "28480  Don't put your head on my shoulder  \\nSink me ...   \n",
       "34169  Some people run, some people crawl  \\nSome peo...   \n",
       "35782  Feel it running off  \\nSo strong and clear  \\n...   \n",
       "37108  Got to make a sense yeah  \\nEverything affects...   \n",
       "47307  The time has come for you  \\nTo make up your o...   \n",
       "47971  Please allow me to try and explain  \\nI'm livi...   \n",
       "\n",
       "                                               embedding  \n",
       "469    [-0.039811164140701294, -0.03449476882815361, ...  \n",
       "11781  [0.012520577758550644, -0.008200659416615963, ...  \n",
       "16342  [0.013232952915132046, -0.028795422986149788, ...  \n",
       "24540  [-0.00933157466351986, -0.02158532105386257, -...  \n",
       "27024  [0.02668825164437294, -0.004220354370772839, -...  \n",
       "28480  [0.004418435040861368, -0.022462952882051468, ...  \n",
       "34169  [0.01612345688045025, -0.04075673967599869, -0...  \n",
       "35782  [-0.023307006806135178, -0.04097108542919159, ...  \n",
       "37108  [-0.0002824359980877489, -0.028917821124196053...  \n",
       "47307  [-0.01812022551894188, -0.014986223541200161, ...  \n",
       "47971  [0.015279334969818592, 0.010907626710832119, -...  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_embracing_change = get_some_titles(df, embracing_change)\n",
    "df_embracing_change"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>artist</th>\n",
       "      <th>song</th>\n",
       "      <th>link</th>\n",
       "      <th>text</th>\n",
       "      <th>embedding</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3968</th>\n",
       "      <td>Deep Purple</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/d/deep+purple/hallelujah_20038862.html</td>\n",
       "      <td>Hallelujah  \\n  \\nI am a preacher with a messa...</td>\n",
       "      <td>[0.021293198689818382, -0.013212421908974648, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10045</th>\n",
       "      <td>Justin Timberlake</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/j/justin+timberlake/hallelujah_20869243.html</td>\n",
       "      <td>Well I heard there was a secret chord  \\nThat ...</td>\n",
       "      <td>[0.0678350031375885, -0.0015728170983493328, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11458</th>\n",
       "      <td>Leonard Cohen</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/l/leonard+cohen/hallelujah_20082898.html</td>\n",
       "      <td>Now I've heard there was a secret chord  \\nTha...</td>\n",
       "      <td>[0.0684051588177681, 0.007501555606722832, -0....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23332</th>\n",
       "      <td>Aled Jones</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/a/aled+jones/hallelujah_20996423.html</td>\n",
       "      <td>Hallelujah  \\n  \\nNow I've heard there was a s...</td>\n",
       "      <td>[0.0685945451259613, 0.009993200190365314, -0....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24395</th>\n",
       "      <td>Avril Lavigne</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/a/avril+lavigne/hallelujah_20517915.html</td>\n",
       "      <td>We sat by the fire  \\nUnited in song  \\nUnder ...</td>\n",
       "      <td>[0.02589884214103222, -0.019296027719974518, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25125</th>\n",
       "      <td>Bette Midler</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/b/bette+midler/hallelujah_21017441.html</td>\n",
       "      <td>I don't know if you can hear me  \\nOr if you'r...</td>\n",
       "      <td>[-0.007787676528096199, -0.0084657808765769, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26132</th>\n",
       "      <td>Bon Jovi</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/b/bon+jovi/hallelujah_20834623.html</td>\n",
       "      <td>Well, I heard there was a secret chord  \\nThat...</td>\n",
       "      <td>[0.06314229965209961, -0.01527197752147913, -0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35849</th>\n",
       "      <td>Hillsong</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/h/hillsong/hallelujah_20769123.html</td>\n",
       "      <td>Saved by Your mercy,  \\nFound in Your grace,  ...</td>\n",
       "      <td>[0.027860939502716064, 0.034558702260255814, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35952</th>\n",
       "      <td>Hillsong United</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/h/hillsong+united/hallelujah_20214284.html</td>\n",
       "      <td>Saved by your mercy  \\nFound in your grace  \\n...</td>\n",
       "      <td>[0.02531852014362812, 0.0398869514465332, 0.00...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39786</th>\n",
       "      <td>Kelly Family</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/k/kelly+family/hallelujah_20214282.html</td>\n",
       "      <td>Fell in love with a beautiful girl  \\nWith a b...</td>\n",
       "      <td>[0.01493329368531704, -0.004307958763092756, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45550</th>\n",
       "      <td>Nick Cave</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/n/nick+cave/hallelujah_20214279.html</td>\n",
       "      <td>On the first day of May I took to the road  \\n...</td>\n",
       "      <td>[0.04142089560627937, -0.027789535000920296, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49949</th>\n",
       "      <td>Rammstein</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/r/rammstein/hallelujah_10238419.html</td>\n",
       "      <td>Er ist fromm und sehr sensibel  \\nAn seiner Wa...</td>\n",
       "      <td>[0.05139243230223656, -0.010995015501976013, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50687</th>\n",
       "      <td>Rem</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/r/rem/hallelujah_20984700.html</td>\n",
       "      <td>The world is an oyster, the bitter refrain  \\n...</td>\n",
       "      <td>[0.02759125642478466, -0.02506842464208603, -0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52736</th>\n",
       "      <td>Taylor Swift</td>\n",
       "      <td>All Too Well</td>\n",
       "      <td>/t/taylor+swift/all+too+well_21048507.html</td>\n",
       "      <td>I walked through the door with you, the air wa...</td>\n",
       "      <td>[0.01707783341407776, -0.022243959829211235, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56577</th>\n",
       "      <td>Willie Nelson</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/w/willie+nelson/hallelujah_20818044.html</td>\n",
       "      <td>All the years combine, they melt into a dream,...</td>\n",
       "      <td>[0.009090729989111423, -0.014868603087961674, ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  artist          song  \\\n",
       "3968         Deep Purple    Hallelujah   \n",
       "10045  Justin Timberlake    Hallelujah   \n",
       "11458      Leonard Cohen    Hallelujah   \n",
       "23332         Aled Jones    Hallelujah   \n",
       "24395      Avril Lavigne    Hallelujah   \n",
       "25125       Bette Midler    Hallelujah   \n",
       "26132           Bon Jovi    Hallelujah   \n",
       "35849           Hillsong    Hallelujah   \n",
       "35952    Hillsong United    Hallelujah   \n",
       "39786       Kelly Family    Hallelujah   \n",
       "45550          Nick Cave    Hallelujah   \n",
       "49949          Rammstein    Hallelujah   \n",
       "50687                Rem    Hallelujah   \n",
       "52736       Taylor Swift  All Too Well   \n",
       "56577      Willie Nelson    Hallelujah   \n",
       "\n",
       "                                                link  \\\n",
       "3968         /d/deep+purple/hallelujah_20038862.html   \n",
       "10045  /j/justin+timberlake/hallelujah_20869243.html   \n",
       "11458      /l/leonard+cohen/hallelujah_20082898.html   \n",
       "23332         /a/aled+jones/hallelujah_20996423.html   \n",
       "24395      /a/avril+lavigne/hallelujah_20517915.html   \n",
       "25125       /b/bette+midler/hallelujah_21017441.html   \n",
       "26132           /b/bon+jovi/hallelujah_20834623.html   \n",
       "35849           /h/hillsong/hallelujah_20769123.html   \n",
       "35952    /h/hillsong+united/hallelujah_20214284.html   \n",
       "39786       /k/kelly+family/hallelujah_20214282.html   \n",
       "45550          /n/nick+cave/hallelujah_20214279.html   \n",
       "49949          /r/rammstein/hallelujah_10238419.html   \n",
       "50687                /r/rem/hallelujah_20984700.html   \n",
       "52736     /t/taylor+swift/all+too+well_21048507.html   \n",
       "56577      /w/willie+nelson/hallelujah_20818044.html   \n",
       "\n",
       "                                                    text  \\\n",
       "3968   Hallelujah  \\n  \\nI am a preacher with a messa...   \n",
       "10045  Well I heard there was a secret chord  \\nThat ...   \n",
       "11458  Now I've heard there was a secret chord  \\nTha...   \n",
       "23332  Hallelujah  \\n  \\nNow I've heard there was a s...   \n",
       "24395  We sat by the fire  \\nUnited in song  \\nUnder ...   \n",
       "25125  I don't know if you can hear me  \\nOr if you'r...   \n",
       "26132  Well, I heard there was a secret chord  \\nThat...   \n",
       "35849  Saved by Your mercy,  \\nFound in Your grace,  ...   \n",
       "35952  Saved by your mercy  \\nFound in your grace  \\n...   \n",
       "39786  Fell in love with a beautiful girl  \\nWith a b...   \n",
       "45550  On the first day of May I took to the road  \\n...   \n",
       "49949  Er ist fromm und sehr sensibel  \\nAn seiner Wa...   \n",
       "50687  The world is an oyster, the bitter refrain  \\n...   \n",
       "52736  I walked through the door with you, the air wa...   \n",
       "56577  All the years combine, they melt into a dream,...   \n",
       "\n",
       "                                               embedding  \n",
       "3968   [0.021293198689818382, -0.013212421908974648, ...  \n",
       "10045  [0.0678350031375885, -0.0015728170983493328, -...  \n",
       "11458  [0.0684051588177681, 0.007501555606722832, -0....  \n",
       "23332  [0.0685945451259613, 0.009993200190365314, -0....  \n",
       "24395  [0.02589884214103222, -0.019296027719974518, -...  \n",
       "25125  [-0.007787676528096199, -0.0084657808765769, -...  \n",
       "26132  [0.06314229965209961, -0.01527197752147913, -0...  \n",
       "35849  [0.027860939502716064, 0.034558702260255814, -...  \n",
       "35952  [0.02531852014362812, 0.0398869514465332, 0.00...  \n",
       "39786  [0.01493329368531704, -0.004307958763092756, -...  \n",
       "45550  [0.04142089560627937, -0.027789535000920296, -...  \n",
       "49949  [0.05139243230223656, -0.010995015501976013, -...  \n",
       "50687  [0.02759125642478466, -0.02506842464208603, -0...  \n",
       "52736  [0.01707783341407776, -0.022243959829211235, -...  \n",
       "56577  [0.009090729989111423, -0.014868603087961674, ...  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_vulnerability = get_some_titles(df, vulnerability)\n",
    "df_vulnerability"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>artist</th>\n",
       "      <th>song</th>\n",
       "      <th>link</th>\n",
       "      <th>text</th>\n",
       "      <th>embedding</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>11288</th>\n",
       "      <td>Leann Rimes</td>\n",
       "      <td>I Will Always Love You</td>\n",
       "      <td>/l/leann+rimes/i+will+always+love+you_20081749...</td>\n",
       "      <td>If should stay  \\nI would only get in your way...</td>\n",
       "      <td>[0.0047250608913600445, -0.00931481458246708, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20809</th>\n",
       "      <td>Vince Gill</td>\n",
       "      <td>I Will Always Love You</td>\n",
       "      <td>/v/vince+gill/i+will+always+love+you_20144420....</td>\n",
       "      <td>If I should stay  \\nWell, I would only be in y...</td>\n",
       "      <td>[0.01523897610604763, -0.017268959432840347, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25045</th>\n",
       "      <td>Bee Gees</td>\n",
       "      <td>I Will Always Love You</td>\n",
       "      <td>/b/bee+gees/i+will+always+love+you_20749274.html</td>\n",
       "      <td>(Kenny Rogers On Vocals)  \\n  \\nI saw you toni...</td>\n",
       "      <td>[0.0182180292904377, 0.0015648266999050975, -0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34082</th>\n",
       "      <td>Glee</td>\n",
       "      <td>I Will Always Love You</td>\n",
       "      <td>/g/glee/i+will+always+love+you_21004693.html</td>\n",
       "      <td>If I should stay,  \\nI would only be in your w...</td>\n",
       "      <td>[0.0038850409910082817, -0.01704128459095955, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40068</th>\n",
       "      <td>Kenny Rogers</td>\n",
       "      <td>I Will Always Love You</td>\n",
       "      <td>/k/kenny+rogers/i+will+always+love+you_2034390...</td>\n",
       "      <td>If I should stay  \\nI would only be in your wa...</td>\n",
       "      <td>[0.009056491777300835, -0.013057866133749485, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41721</th>\n",
       "      <td>Linda Ronstadt</td>\n",
       "      <td>I Will Always Love You</td>\n",
       "      <td>/l/linda+ronstadt/i+will+always+love+you_20343...</td>\n",
       "      <td>If I should stay  \\nWell, I would only be in y...</td>\n",
       "      <td>[0.015449640341103077, -0.01721329800784588, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56263</th>\n",
       "      <td>Whitney Houston</td>\n",
       "      <td>I Will Always Love You</td>\n",
       "      <td>/w/whitney+houston/i+will+always+love+you_2014...</td>\n",
       "      <td>If I should stay, I'll only be in your way  \\n...</td>\n",
       "      <td>[0.010172651149332523, -0.01772145926952362, -...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                artist                    song  \\\n",
       "11288      Leann Rimes  I Will Always Love You   \n",
       "20809       Vince Gill  I Will Always Love You   \n",
       "25045         Bee Gees  I Will Always Love You   \n",
       "34082             Glee  I Will Always Love You   \n",
       "40068     Kenny Rogers  I Will Always Love You   \n",
       "41721   Linda Ronstadt  I Will Always Love You   \n",
       "56263  Whitney Houston  I Will Always Love You   \n",
       "\n",
       "                                                    link  \\\n",
       "11288  /l/leann+rimes/i+will+always+love+you_20081749...   \n",
       "20809  /v/vince+gill/i+will+always+love+you_20144420....   \n",
       "25045   /b/bee+gees/i+will+always+love+you_20749274.html   \n",
       "34082       /g/glee/i+will+always+love+you_21004693.html   \n",
       "40068  /k/kenny+rogers/i+will+always+love+you_2034390...   \n",
       "41721  /l/linda+ronstadt/i+will+always+love+you_20343...   \n",
       "56263  /w/whitney+houston/i+will+always+love+you_2014...   \n",
       "\n",
       "                                                    text  \\\n",
       "11288  If should stay  \\nI would only get in your way...   \n",
       "20809  If I should stay  \\nWell, I would only be in y...   \n",
       "25045  (Kenny Rogers On Vocals)  \\n  \\nI saw you toni...   \n",
       "34082  If I should stay,  \\nI would only be in your w...   \n",
       "40068  If I should stay  \\nI would only be in your wa...   \n",
       "41721  If I should stay  \\nWell, I would only be in y...   \n",
       "56263  If I should stay, I'll only be in your way  \\n...   \n",
       "\n",
       "                                               embedding  \n",
       "11288  [0.0047250608913600445, -0.00931481458246708, ...  \n",
       "20809  [0.01523897610604763, -0.017268959432840347, -...  \n",
       "25045  [0.0182180292904377, 0.0015648266999050975, -0...  \n",
       "34082  [0.0038850409910082817, -0.01704128459095955, ...  \n",
       "40068  [0.009056491777300835, -0.013057866133749485, ...  \n",
       "41721  [0.015449640341103077, -0.01721329800784588, -...  \n",
       "56263  [0.010172651149332523, -0.01772145926952362, -...  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_enduring_power = get_some_titles(df, enduring_power)\n",
    "df_enduring_power"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>artist</th>\n",
       "      <th>song</th>\n",
       "      <th>link</th>\n",
       "      <th>text</th>\n",
       "      <th>embedding</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>497</th>\n",
       "      <td>Alice Cooper</td>\n",
       "      <td>Headlines</td>\n",
       "      <td>/a/alice+cooper/headlines_20211774.html</td>\n",
       "      <td>Do a show  \\nSave a child  \\nRaise a million b...</td>\n",
       "      <td>[0.061338990926742554, -0.05824422463774681, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>614</th>\n",
       "      <td>Alphaville</td>\n",
       "      <td>Headlines</td>\n",
       "      <td>/a/alphaville/headlines+demo+1_20211775.html</td>\n",
       "      <td>We call ourselves the crown of creation  \\nI w...</td>\n",
       "      <td>[-0.008164091035723686, -0.04473574832081795, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4516</th>\n",
       "      <td>Drake</td>\n",
       "      <td>Headlines</td>\n",
       "      <td>/d/drake/headlines_20977821.html</td>\n",
       "      <td>I might be too strung out on compliments  \\nOv...</td>\n",
       "      <td>[0.018836120143532753, -0.026189839467406273, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49652</th>\n",
       "      <td>Quietdrive</td>\n",
       "      <td>Motivation</td>\n",
       "      <td>/q/quietdrive/motivation_20764103.html</td>\n",
       "      <td>See you right around the corner  \\nI know that...</td>\n",
       "      <td>[0.016446547582745552, 0.00604992127045989, -0...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             artist        song                                          link  \\\n",
       "497    Alice Cooper   Headlines       /a/alice+cooper/headlines_20211774.html   \n",
       "614      Alphaville   Headlines  /a/alphaville/headlines+demo+1_20211775.html   \n",
       "4516          Drake   Headlines              /d/drake/headlines_20977821.html   \n",
       "49652    Quietdrive  Motivation        /q/quietdrive/motivation_20764103.html   \n",
       "\n",
       "                                                    text  \\\n",
       "497    Do a show  \\nSave a child  \\nRaise a million b...   \n",
       "614    We call ourselves the crown of creation  \\nI w...   \n",
       "4516   I might be too strung out on compliments  \\nOv...   \n",
       "49652  See you right around the corner  \\nI know that...   \n",
       "\n",
       "                                               embedding  \n",
       "497    [0.061338990926742554, -0.05824422463774681, -...  \n",
       "614    [-0.008164091035723686, -0.04473574832081795, ...  \n",
       "4516   [0.018836120143532753, -0.026189839467406273, ...  \n",
       "49652  [0.016446547582745552, 0.00604992127045989, -0...  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_hustle_and_ambition = get_some_titles(df, hustle_and_ambition)\n",
    "df_hustle_and_ambition"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>artist</th>\n",
       "      <th>song</th>\n",
       "      <th>link</th>\n",
       "      <th>text</th>\n",
       "      <th>embedding</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2850</th>\n",
       "      <td>Chris Rea</td>\n",
       "      <td>Runaway</td>\n",
       "      <td>/c/chris+rea/runaway_20030541.html</td>\n",
       "      <td>Sitting at the crossways  \\nTrying to keep my ...</td>\n",
       "      <td>[-0.009416221641004086, -0.01810741238296032, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16192</th>\n",
       "      <td>P!nk</td>\n",
       "      <td>Runaway</td>\n",
       "      <td>/p/pnk/runaway_20479949.html</td>\n",
       "      <td>I've got my things packed  \\nMy favorite pillo...</td>\n",
       "      <td>[-0.002205262193456292, -0.011622381396591663,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21638</th>\n",
       "      <td>Wishbone Ash</td>\n",
       "      <td>Runaway</td>\n",
       "      <td>/w/wishbone+ash/runaway_20147215.html</td>\n",
       "      <td>I thought I had been every place a man could b...</td>\n",
       "      <td>[0.05322633311152458, -0.012224229983985424, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22445</th>\n",
       "      <td>Zebrahead</td>\n",
       "      <td>Runaway</td>\n",
       "      <td>/z/zebrahead/runaway_10198503.html</td>\n",
       "      <td>She wakes up in the morning  \\nIn the same roo...</td>\n",
       "      <td>[0.0004889509873464704, 0.005889297928661108, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26308</th>\n",
       "      <td>Bonnie Raitt</td>\n",
       "      <td>Runaway</td>\n",
       "      <td>/b/bonnie+raitt/runaway_20022672.html</td>\n",
       "      <td>As I walk along I wonder what went wrong  \\nWi...</td>\n",
       "      <td>[0.024388570338487625, 0.041070353239774704, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26661</th>\n",
       "      <td>Bruno Mars</td>\n",
       "      <td>Runaway</td>\n",
       "      <td>/b/bruno+mars/runaway_20825145.html</td>\n",
       "      <td>[Verse 1]  \\nSo easy to forget our love, the l...</td>\n",
       "      <td>[-0.014894611202180386, -0.036250632256269455,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30769</th>\n",
       "      <td>Ed Sheeran</td>\n",
       "      <td>Runaway</td>\n",
       "      <td>/e/ed+sheeran/runaway_21085122.html</td>\n",
       "      <td>I've known it for a long time  \\nDaddy wakes u...</td>\n",
       "      <td>[0.02545579895377159, -0.003133518388494849, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35417</th>\n",
       "      <td>Hanson</td>\n",
       "      <td>Runaway</td>\n",
       "      <td>/h/hanson/runaway_20630046.html</td>\n",
       "      <td>Did somebody dare to tell you what's right  \\n...</td>\n",
       "      <td>[-0.037271786481142044, -0.017129873856902122,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39311</th>\n",
       "      <td>Kanye West</td>\n",
       "      <td>Runaway</td>\n",
       "      <td>/k/kanye+west/runaway_20888526.html</td>\n",
       "      <td>And I always find, yeah I always find somethin...</td>\n",
       "      <td>[-0.028336936607956886, -0.04977979511022568, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41789</th>\n",
       "      <td>Linkin Park</td>\n",
       "      <td>Runaway</td>\n",
       "      <td>/l/linkin+park/runaway_20083788.html</td>\n",
       "      <td>Graffiti decorations  \\nUnder the sky of dust ...</td>\n",
       "      <td>[-0.006102082319557667, -0.015683721750974655,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42909</th>\n",
       "      <td>Marillion</td>\n",
       "      <td>Runaway</td>\n",
       "      <td>/m/marillion/runaway_20088830.html</td>\n",
       "      <td>Did you cry when they dragged you home  \\nPut ...</td>\n",
       "      <td>[0.024551022797822952, -0.012086414732038975, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43152</th>\n",
       "      <td>Maroon 5</td>\n",
       "      <td>Runaway</td>\n",
       "      <td>/m/maroon+5/runaway_20988163.html</td>\n",
       "      <td>What am I supposed to do with this time  \\nIt ...</td>\n",
       "      <td>[-0.007107664830982685, 0.0005128081538714468,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44168</th>\n",
       "      <td>Misfits</td>\n",
       "      <td>Runaway</td>\n",
       "      <td>/m/misfits/runaway_10181441.html</td>\n",
       "      <td>As I walk along,  \\nI wonder what went wrong, ...</td>\n",
       "      <td>[0.02980850264430046, 0.02980850264430046, -0....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46817</th>\n",
       "      <td>Olly Murs</td>\n",
       "      <td>Runaway</td>\n",
       "      <td>/o/olly+murs/runaway_21048172.html</td>\n",
       "      <td>Butterflies inside, freaking me out  \\nI shoul...</td>\n",
       "      <td>[-0.011843440122902393, -0.011588399298489094,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50552</th>\n",
       "      <td>Red Hot Chili Peppers</td>\n",
       "      <td>Runaway</td>\n",
       "      <td>/r/red+hot+chili+peppers/runaway_20477905.html</td>\n",
       "      <td>Walkin' around  \\nOut of a town  \\nWalkin' it ...</td>\n",
       "      <td>[0.028578829020261765, -0.01193912886083126, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57083</th>\n",
       "      <td>Yeah Yeah Yeahs</td>\n",
       "      <td>Runaway</td>\n",
       "      <td>/y/yeah+yeah+yeahs/runaway_20836813.html</td>\n",
       "      <td>I was feeling sad  \\nCan't help looking back  ...</td>\n",
       "      <td>[0.01524402853101492, -0.01511387713253498, -0...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      artist     song  \\\n",
       "2850               Chris Rea  Runaway   \n",
       "16192                   P!nk  Runaway   \n",
       "21638           Wishbone Ash  Runaway   \n",
       "22445              Zebrahead  Runaway   \n",
       "26308           Bonnie Raitt  Runaway   \n",
       "26661             Bruno Mars  Runaway   \n",
       "30769             Ed Sheeran  Runaway   \n",
       "35417                 Hanson  Runaway   \n",
       "39311             Kanye West  Runaway   \n",
       "41789            Linkin Park  Runaway   \n",
       "42909              Marillion  Runaway   \n",
       "43152               Maroon 5  Runaway   \n",
       "44168                Misfits  Runaway   \n",
       "46817              Olly Murs  Runaway   \n",
       "50552  Red Hot Chili Peppers  Runaway   \n",
       "57083        Yeah Yeah Yeahs  Runaway   \n",
       "\n",
       "                                                 link  \\\n",
       "2850               /c/chris+rea/runaway_20030541.html   \n",
       "16192                    /p/pnk/runaway_20479949.html   \n",
       "21638           /w/wishbone+ash/runaway_20147215.html   \n",
       "22445              /z/zebrahead/runaway_10198503.html   \n",
       "26308           /b/bonnie+raitt/runaway_20022672.html   \n",
       "26661             /b/bruno+mars/runaway_20825145.html   \n",
       "30769             /e/ed+sheeran/runaway_21085122.html   \n",
       "35417                 /h/hanson/runaway_20630046.html   \n",
       "39311             /k/kanye+west/runaway_20888526.html   \n",
       "41789            /l/linkin+park/runaway_20083788.html   \n",
       "42909              /m/marillion/runaway_20088830.html   \n",
       "43152               /m/maroon+5/runaway_20988163.html   \n",
       "44168                /m/misfits/runaway_10181441.html   \n",
       "46817              /o/olly+murs/runaway_21048172.html   \n",
       "50552  /r/red+hot+chili+peppers/runaway_20477905.html   \n",
       "57083        /y/yeah+yeah+yeahs/runaway_20836813.html   \n",
       "\n",
       "                                                    text  \\\n",
       "2850   Sitting at the crossways  \\nTrying to keep my ...   \n",
       "16192  I've got my things packed  \\nMy favorite pillo...   \n",
       "21638  I thought I had been every place a man could b...   \n",
       "22445  She wakes up in the morning  \\nIn the same roo...   \n",
       "26308  As I walk along I wonder what went wrong  \\nWi...   \n",
       "26661  [Verse 1]  \\nSo easy to forget our love, the l...   \n",
       "30769  I've known it for a long time  \\nDaddy wakes u...   \n",
       "35417  Did somebody dare to tell you what's right  \\n...   \n",
       "39311  And I always find, yeah I always find somethin...   \n",
       "41789  Graffiti decorations  \\nUnder the sky of dust ...   \n",
       "42909  Did you cry when they dragged you home  \\nPut ...   \n",
       "43152  What am I supposed to do with this time  \\nIt ...   \n",
       "44168  As I walk along,  \\nI wonder what went wrong, ...   \n",
       "46817  Butterflies inside, freaking me out  \\nI shoul...   \n",
       "50552  Walkin' around  \\nOut of a town  \\nWalkin' it ...   \n",
       "57083  I was feeling sad  \\nCan't help looking back  ...   \n",
       "\n",
       "                                               embedding  \n",
       "2850   [-0.009416221641004086, -0.01810741238296032, ...  \n",
       "16192  [-0.002205262193456292, -0.011622381396591663,...  \n",
       "21638  [0.05322633311152458, -0.012224229983985424, -...  \n",
       "22445  [0.0004889509873464704, 0.005889297928661108, ...  \n",
       "26308  [0.024388570338487625, 0.041070353239774704, -...  \n",
       "26661  [-0.014894611202180386, -0.036250632256269455,...  \n",
       "30769  [0.02545579895377159, -0.003133518388494849, -...  \n",
       "35417  [-0.037271786481142044, -0.017129873856902122,...  \n",
       "39311  [-0.028336936607956886, -0.04977979511022568, ...  \n",
       "41789  [-0.006102082319557667, -0.015683721750974655,...  \n",
       "42909  [0.024551022797822952, -0.012086414732038975, ...  \n",
       "43152  [-0.007107664830982685, 0.0005128081538714468,...  \n",
       "44168  [0.02980850264430046, 0.02980850264430046, -0....  \n",
       "46817  [-0.011843440122902393, -0.011588399298489094,...  \n",
       "50552  [0.028578829020261765, -0.01193912886083126, -...  \n",
       "57083  [0.01524402853101492, -0.01511387713253498, -0...  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_vulnerability_modern = get_some_titles(df, vulnerability_modern)\n",
    "df_vulnerability_modern"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "overcoming_adversity = [\n",
    "    {\n",
    "        \"artist\":\"Survivor\", \n",
    "        \"title\":\"Eye of The Tiger\",\n",
    "        \"theme\":\"Overcoming adversity\"\n",
    "    },\n",
    "    {\n",
    "        \"artist\":\"Eminem\", \n",
    "        \"title\":\"Lose Yourself\",\n",
    "        \"theme\":\"Overcoming adversity\"\n",
    "    }, \n",
    "    {\n",
    "        \"artist\":\"Gloria Gaynor\", \n",
    "        \"title\":\"I Will Survive\",\n",
    "        \"theme\":\"Overcoming adversity\"\n",
    "    }]\n",
    "lost_love = [\n",
    "     {\n",
    "        \"artist\":\"Adele\", \n",
    "        \"title\":\"Someone Like You\",\n",
    "        \"theme\":\"Lost love and longing\"\n",
    "    },\n",
    "    {\n",
    "        \"artist\":\"Tracy Chapman\", \n",
    "        \"title\":\"Yesterday\",\n",
    "        \"theme\":\"Lost love and longing\"\n",
    "    }, \n",
    "    {\n",
    "        \"artist\":\"The Beatles\", \n",
    "        \"title\":\"Fast Car\",\n",
    "        \"theme\":\"Lost love and longing\"\n",
    "    }\n",
    "]\n",
    "unconventional_love = [\n",
    "    {\n",
    "        \"artist\":\"Coldplay\", \n",
    "        \"title\":\"A Sky Full Of Stars\",\n",
    "        \"theme\":\"Unconventional love\"\n",
    "    },\n",
    "    {\n",
    "        \"artist\":\"Lady Gaga\", \n",
    "        \"title\":\"Born This Way\",\n",
    "        \"theme\":\"Unconventional love\"\n",
    "    }, \n",
    "    {\n",
    "        \"artist\":\"Alanis Morissette\", \n",
    "        \"title\":\"You Oughta Know\",\n",
    "        \"theme\":\"Unconventional love\"\n",
    "    }\n",
    "]\n",
    "social_commentary_protest = [\n",
    "     {\n",
    "        \"artist\":\"Public Enemy\", \n",
    "        \"title\":\"Fight The Power\",\n",
    "        \"theme\":\"Social commentary and protest\"\n",
    "    },\n",
    "    {\n",
    "        \"artist\":\"John Lennon\", \n",
    "        \"title\":\"Imagine\",\n",
    "        \"theme\":\"Social commentary and protest\"\n",
    "    }, \n",
    "    {\n",
    "        \"artist\":\"Bob Dylan\", \n",
    "        \"title\":\"The Times They Are a-Changin\",\n",
    "        \"theme\":\"Social commentary and protest\"\n",
    "    }\n",
    "]\n",
    "celebrating_life_simple_joys = [\n",
    "    {\n",
    "        \"artist\":\"Bob Marley\", \n",
    "        \"title\":\"Three Little Birds\",\n",
    "        \"theme\":\"Celebrating life's simple joys\"\n",
    "    },\n",
    "    {\n",
    "        \"artist\":\"Electric Light Orchestra\", \n",
    "        \"title\":\"Mr. Blue Sky\",\n",
    "        \"theme\":\"Celebrating life's simple joys\"\n",
    "    }, \n",
    "    {\n",
    "        \"artist\":\"Johnny Cash\", \n",
    "        \"title\":\"Count Your Blessings\",\n",
    "        \"theme\":\"Celebrating life's simple joys\"\n",
    "    }\n",
    "]\n",
    "finding_unexpected_hope = [\n",
    "     {\n",
    "        \"artist\":\"Coldplay\", \n",
    "        \"title\":\"Fix You\",\n",
    "        \"theme\":\"Finding Hope in Unexpected Places\"\n",
    "    },\n",
    "    {\n",
    "        \"artist\":\"Leonard Cohen\", \n",
    "        \"title\":\"Hallelujah\",\n",
    "        \"theme\":\"Finding Hope in Unexpected Places\"\n",
    "    }, \n",
    "    {\n",
    "        \"artist\":\"Bill Withers\", \n",
    "        \"title\":\"Lean on Me\",\n",
    "        \"theme\":\"Finding Hope in Unexpected Places\"\n",
    "    }\n",
    "]\n",
    "embracing_change = [\n",
    "     {\n",
    "        \"artist\":\"Papa Roach\", \n",
    "        \"title\":\"Metamorphosis\",\n",
    "        \"theme\":\"Embracing Change and Transformation\"\n",
    "    },\n",
    "    {\n",
    "        \"artist\":\"Pink Floyd\", \n",
    "        \"title\":\"Time\",\n",
    "        \"theme\":\"Embracing Change and Transformation\"\n",
    "    }, \n",
    "    {\n",
    "        \"artist\":\"John Lennon\", \n",
    "        \"title\":\"Beautiful Boy\",\n",
    "        \"theme\":\"Embracing Change and Transformation\"\n",
    "    },\n",
    "    {\n",
    "        \"artist\":\"John Lennon\", \n",
    "        \"title\":\"Darling Boy\",\n",
    "        \"theme\":\"Embracing Change and Transformation\"\n",
    "    },\n",
    "    {\n",
    "        \"artist\":\"John Lennon\", \n",
    "        \"title\":\"Beautiful Boy (Darling Boy)\",\n",
    "        \"theme\":\"Embracing Change and Transformation\"\n",
    "    }\n",
    "]\n",
    "vulnerability = [\n",
    "     {\n",
    "        \"artist\":\"Lewis Capaldi\", \n",
    "        \"title\":\"Someone You Loved\",\n",
    "        \"theme\":\"The Beauty and Pain of Vulnerability\"\n",
    "    },\n",
    "    {\n",
    "        \"artist\":\"Taylor Swift\", \n",
    "        \"title\":\"All Too Well\",\n",
    "        \"theme\":\"The Beauty and Pain of Vulnerability\"\n",
    "    }, \n",
    "    {\n",
    "        \"artist\":\"Jeff Buckley\", \n",
    "        \"title\":\"Hallelujah\",\n",
    "        \"theme\":\"The Beauty and Pain of Vulnerability\"\n",
    "    }\n",
    "]\n",
    "#questionin_authority =[]  # redundant with social_commentary_protest\n",
    "enduring_power = [\n",
    "     {\n",
    "        \"artist\":\"Elvis Presley\", \n",
    "        \"title\":\"Can't Help Falling in Love\",\n",
    "        \"theme\":\"The Enduring Power of Love and Connection\"\n",
    "    },\n",
    "    {\n",
    "        \"artist\":\"Whitney Houston\", \n",
    "        \"title\":\"I Will Always Love You\",\n",
    "        \"theme\":\"The Enduring Power of Love and Connection\"\n",
    "    }, \n",
    "    {\n",
    "        \"artist\":\"Randy Newman\", \n",
    "        \"title\":\"You've Got a Friend in Me\",\n",
    "        \"theme\":\"The Enduring Power of Love and Connection\"\n",
    "    }\n",
    "]\n",
    "hustle_and_ambition = [\n",
    "    {\n",
    "        \"artist\":\" Kendrick Lamar\", \n",
    "        \"title\":\"HUMBLE\",\n",
    "        \"theme\":\"Hustle and Ambition\"\n",
    "    },\n",
    "    {\n",
    "        \"artist\":\" Kendrick Lamar\", \n",
    "        \"title\":\"Humble\",\n",
    "        \"theme\":\"Hustle and Ambition\"\n",
    "    },\n",
    "    {\n",
    "        \"artist\":\"Normani\", \n",
    "        \"title\":\"Motivation\",\n",
    "        \"theme\":\"Hustle and Ambition\"\n",
    "    }, \n",
    "    {\n",
    "        \"artist\":\"The Carters\", \n",
    "        \"title\":\"APESHIT\",\n",
    "        \"theme\":\"Hustle and Ambition\"\n",
    "    },\n",
    "    {\n",
    "        \"artist\":\"The Carters\", \n",
    "        \"title\":\"Apeshit\",\n",
    "        \"theme\":\"Hustle and Ambition\"\n",
    "    },\n",
    "    {\n",
    "        \"artist\":\"Drake\", \n",
    "        \"title\":\"Headlines\",\n",
    "        \"theme\":\"Hustle and Ambition\"\n",
    "    },\n",
    "    {\n",
    "        \"artist\":\"Drake\", \n",
    "        \"title\":\"Started From The Bottom\",\n",
    "        \"theme\":\"Hustle and Ambition\"\n",
    "    },\n",
    "\n",
    "]\n",
    "vulnerability_modern = [\n",
    "     {\n",
    "        \"artist\":\"Lewis Capaldi\", \n",
    "        \"title\":\"Someone You Loved\",\n",
    "        \"theme\":\"Vulnerability and Emotional Honesty\"\n",
    "    },\n",
    "    {\n",
    "        \"artist\":\"Ariana Grande\", \n",
    "        \"title\":\"thank u, next\",\n",
    "        \"theme\":\"Vulnerability and Emotional Honesty\"\n",
    "    }, \n",
    "    {\n",
    "        \"artist\":\"Kanye West\", \n",
    "        \"title\":\"Runaway\",\n",
    "        \"theme\":\"Vulnerability and Emotional Honesty\"\n",
    "    }\n",
    "]\n",
    "digital_love = [\n",
    "     {\n",
    "        \"artist\":\"Drake\", \n",
    "        \"title\":\"Love Again\",\n",
    "        \"theme\":\"Love and Relationships in the Digital Age\"\n",
    "    },\n",
    "    {\n",
    "        \"artist\":\"Ariana Grande\", \n",
    "        \"title\":\"Positions\",\n",
    "        \"theme\":\"Love and Relationships in the Digital Age\"\n",
    "    }, \n",
    "    {\n",
    "        \"artist\":\"Taylor Swift\", \n",
    "        \"title\":\"Blank Space\",\n",
    "        \"theme\":\"Love and Relationships in the Digital Age\"\n",
    "    }\n",
    "]\n",
    "socal_commentary_modern = [\n",
    "     {\n",
    "        \"artist\":\"Childish Gambino\", \n",
    "        \"title\":\"This is America\",\n",
    "        \"theme\":\"Social Commentary and Protest\"\n",
    "    },\n",
    "    {\n",
    "        \"artist\":\"Kendrick Lamar\", \n",
    "        \"title\":\"Alright\",\n",
    "        \"theme\":\"Social Commentary and Protest\"\n",
    "    }, \n",
    "    {\n",
    "        \"artist\":\"Beyonce\", \n",
    "        \"title\":\"FORMATION\",\n",
    "        \"theme\":\"Social Commentary and Protest\"\n",
    "    },\n",
    "     {\n",
    "        \"artist\":\"Beyonce\", \n",
    "        \"title\":\"Formation\",\n",
    "        \"theme\":\"Social Commentary and Protest\"\n",
    "    }\n",
    "]\n",
    "celebrating_life_simple_joys_modern = [\n",
    "    {\n",
    "        \"artist\":\"Mark Ronson\", \n",
    "        \"title\":\"Uptown Funk\",\n",
    "        \"theme\":\"Finding Joy and Celebration in Life's Moments\"\n",
    "    },\n",
    "    {\n",
    "        \"artist\":\"Bruno Mars\", \n",
    "        \"title\":\"Uptown Funk\",\n",
    "        \"theme\":\"Finding Joy and Celebration in Life's Moments\"\n",
    "    },\n",
    "    {\n",
    "        \"artist\":\"Mark Ronson ft. Bruno Mars\", \n",
    "        \"title\":\"Uptown Funk\",\n",
    "        \"theme\":\"Finding Joy and Celebration in Life's Moments\"\n",
    "    },\n",
    "    {\n",
    "        \"artist\":\"Ariana Grande\", \n",
    "        \"title\":\"7 Rings\",\n",
    "        \"theme\":\"Finding Joy and Celebration in Life's Moments\"\n",
    "    }, \n",
    "    {\n",
    "        \"artist\":\"Pharrell Williams\", \n",
    "        \"title\":\"Happy\",\n",
    "        \"theme\":\"Finding Joy and Celebration in Life's Moments\"\n",
    "    }\n",
    "]\n",
    "all_themes = overcoming_adversity + lost_love +unconventional_love + social_commentary_protest + celebrating_life_simple_joys + finding_unexpected_hope + embracing_change + vulnerability + enduring_power + hustle_and_ambition + vulnerability_modern + digital_love + socal_commentary_modern + celebrating_life_simple_joys_modern"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "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>artist</th>\n",
       "      <th>song</th>\n",
       "      <th>link</th>\n",
       "      <th>text</th>\n",
       "      <th>embedding</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [artist, song, link, text, embedding]\n",
       "Index: []"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_filtered_test = get_specific_song(df, social_commentary_protest[1])\n",
    "df_filtered_test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(14, 5)"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_filtered = get_specific_songs(df, all_themes)\n",
    "df_filtered.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>artist</th>\n",
       "      <th>title</th>\n",
       "      <th>theme</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Survivor</td>\n",
       "      <td>Eye of The Tiger</td>\n",
       "      <td>Overcoming adversity</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Eminem</td>\n",
       "      <td>Lose Yourself</td>\n",
       "      <td>Overcoming adversity</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Gloria Gaynor</td>\n",
       "      <td>I Will Survive</td>\n",
       "      <td>Overcoming adversity</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Adele</td>\n",
       "      <td>Someone Like You</td>\n",
       "      <td>Lost love and longing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Tracy Chapman</td>\n",
       "      <td>Yesterday</td>\n",
       "      <td>Lost love and longing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>The Beatles</td>\n",
       "      <td>Fast Car</td>\n",
       "      <td>Lost love and longing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Coldplay</td>\n",
       "      <td>A Sky Full Of Stars</td>\n",
       "      <td>Unconventional love</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Lady Gaga</td>\n",
       "      <td>Born This Way</td>\n",
       "      <td>Unconventional love</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Alanis Morissette</td>\n",
       "      <td>You Oughta Know</td>\n",
       "      <td>Unconventional love</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Public Enemy</td>\n",
       "      <td>Fight The Power</td>\n",
       "      <td>Social commentary and protest</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>John Lennon</td>\n",
       "      <td>Imagine</td>\n",
       "      <td>Social commentary and protest</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Bob Dylan</td>\n",
       "      <td>The Times They Are a-Changin</td>\n",
       "      <td>Social commentary and protest</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Bob Marley</td>\n",
       "      <td>Three Little Birds</td>\n",
       "      <td>Celebrating life's simple joys</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Electric Light Orchestra</td>\n",
       "      <td>Mr. Blue Sky</td>\n",
       "      <td>Celebrating life's simple joys</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Johnny Cash</td>\n",
       "      <td>Count Your Blessings</td>\n",
       "      <td>Celebrating life's simple joys</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Coldplay</td>\n",
       "      <td>Fix You</td>\n",
       "      <td>Finding Hope in Unexpected Places</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Leonard Cohen</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>Finding Hope in Unexpected Places</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Bill Withers</td>\n",
       "      <td>Lean on Me</td>\n",
       "      <td>Finding Hope in Unexpected Places</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Papa Roach</td>\n",
       "      <td>Metamorphosis</td>\n",
       "      <td>Embracing Change and Transformation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Pink Floyd</td>\n",
       "      <td>Time</td>\n",
       "      <td>Embracing Change and Transformation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>John Lennon</td>\n",
       "      <td>Beautiful Boy</td>\n",
       "      <td>Embracing Change and Transformation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>John Lennon</td>\n",
       "      <td>Darling Boy</td>\n",
       "      <td>Embracing Change and Transformation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>John Lennon</td>\n",
       "      <td>Beautiful Boy (Darling Boy)</td>\n",
       "      <td>Embracing Change and Transformation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Lewis Capaldi</td>\n",
       "      <td>Someone You Loved</td>\n",
       "      <td>The Beauty and Pain of Vulnerability</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Taylor Swift</td>\n",
       "      <td>All Too Well</td>\n",
       "      <td>The Beauty and Pain of Vulnerability</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Jeff Buckley</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>The Beauty and Pain of Vulnerability</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Elvis Presley</td>\n",
       "      <td>Can't Help Falling in Love</td>\n",
       "      <td>The Enduring Power of Love and Connection</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Whitney Houston</td>\n",
       "      <td>I Will Always Love You</td>\n",
       "      <td>The Enduring Power of Love and Connection</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Randy Newman</td>\n",
       "      <td>You've Got a Friend in Me</td>\n",
       "      <td>The Enduring Power of Love and Connection</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Kendrick Lamar</td>\n",
       "      <td>HUMBLE</td>\n",
       "      <td>Hustle and Ambition</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Kendrick Lamar</td>\n",
       "      <td>Humble</td>\n",
       "      <td>Hustle and Ambition</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Normani</td>\n",
       "      <td>Motivation</td>\n",
       "      <td>Hustle and Ambition</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>The Carters</td>\n",
       "      <td>APESHIT</td>\n",
       "      <td>Hustle and Ambition</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>The Carters</td>\n",
       "      <td>Apeshit</td>\n",
       "      <td>Hustle and Ambition</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Drake</td>\n",
       "      <td>Headlines</td>\n",
       "      <td>Hustle and Ambition</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Drake</td>\n",
       "      <td>Started From The Bottom</td>\n",
       "      <td>Hustle and Ambition</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Lewis Capaldi</td>\n",
       "      <td>Someone You Loved</td>\n",
       "      <td>Vulnerability and Emotional Honesty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Ariana Grande</td>\n",
       "      <td>thank u, next</td>\n",
       "      <td>Vulnerability and Emotional Honesty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Kanye West</td>\n",
       "      <td>Runaway</td>\n",
       "      <td>Vulnerability and Emotional Honesty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Drake</td>\n",
       "      <td>Love Again</td>\n",
       "      <td>Love and Relationships in the Digital Age</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Ariana Grande</td>\n",
       "      <td>Positions</td>\n",
       "      <td>Love and Relationships in the Digital Age</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Taylor Swift</td>\n",
       "      <td>Blank Space</td>\n",
       "      <td>Love and Relationships in the Digital Age</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Childish Gambino</td>\n",
       "      <td>This is America</td>\n",
       "      <td>Social Commentary and Protest</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Kendrick Lamar</td>\n",
       "      <td>Alright</td>\n",
       "      <td>Social Commentary and Protest</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Beyonce</td>\n",
       "      <td>FORMATION</td>\n",
       "      <td>Social Commentary and Protest</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Beyonce</td>\n",
       "      <td>Formation</td>\n",
       "      <td>Social Commentary and Protest</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Mark Ronson</td>\n",
       "      <td>Uptown Funk</td>\n",
       "      <td>Finding Joy and Celebration in Life's Moments</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Bruno Mars</td>\n",
       "      <td>Uptown Funk</td>\n",
       "      <td>Finding Joy and Celebration in Life's Moments</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Mark Ronson ft. Bruno Mars</td>\n",
       "      <td>Uptown Funk</td>\n",
       "      <td>Finding Joy and Celebration in Life's Moments</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Ariana Grande</td>\n",
       "      <td>7 Rings</td>\n",
       "      <td>Finding Joy and Celebration in Life's Moments</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Pharrell Williams</td>\n",
       "      <td>Happy</td>\n",
       "      <td>Finding Joy and Celebration in Life's Moments</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        artist                         title  \\\n",
       "0                     Survivor              Eye of The Tiger   \n",
       "1                       Eminem                 Lose Yourself   \n",
       "2                Gloria Gaynor                I Will Survive   \n",
       "3                        Adele              Someone Like You   \n",
       "4                Tracy Chapman                     Yesterday   \n",
       "5                  The Beatles                      Fast Car   \n",
       "6                     Coldplay           A Sky Full Of Stars   \n",
       "7                    Lady Gaga                 Born This Way   \n",
       "8            Alanis Morissette               You Oughta Know   \n",
       "9                 Public Enemy               Fight The Power   \n",
       "10                 John Lennon                       Imagine   \n",
       "11                   Bob Dylan  The Times They Are a-Changin   \n",
       "12                  Bob Marley            Three Little Birds   \n",
       "13    Electric Light Orchestra                  Mr. Blue Sky   \n",
       "14                 Johnny Cash          Count Your Blessings   \n",
       "15                    Coldplay                       Fix You   \n",
       "16               Leonard Cohen                    Hallelujah   \n",
       "17                Bill Withers                    Lean on Me   \n",
       "18                  Papa Roach                 Metamorphosis   \n",
       "19                  Pink Floyd                          Time   \n",
       "20                 John Lennon                 Beautiful Boy   \n",
       "21                 John Lennon                   Darling Boy   \n",
       "22                 John Lennon   Beautiful Boy (Darling Boy)   \n",
       "23               Lewis Capaldi             Someone You Loved   \n",
       "24                Taylor Swift                  All Too Well   \n",
       "25                Jeff Buckley                    Hallelujah   \n",
       "26               Elvis Presley    Can't Help Falling in Love   \n",
       "27             Whitney Houston        I Will Always Love You   \n",
       "28                Randy Newman     You've Got a Friend in Me   \n",
       "29              Kendrick Lamar                        HUMBLE   \n",
       "30              Kendrick Lamar                        Humble   \n",
       "31                     Normani                    Motivation   \n",
       "32                 The Carters                       APESHIT   \n",
       "33                 The Carters                       Apeshit   \n",
       "34                       Drake                     Headlines   \n",
       "35                       Drake       Started From The Bottom   \n",
       "36               Lewis Capaldi             Someone You Loved   \n",
       "37               Ariana Grande                 thank u, next   \n",
       "38                  Kanye West                       Runaway   \n",
       "39                       Drake                    Love Again   \n",
       "40               Ariana Grande                     Positions   \n",
       "41                Taylor Swift                   Blank Space   \n",
       "42            Childish Gambino               This is America   \n",
       "43              Kendrick Lamar                       Alright   \n",
       "44                     Beyonce                     FORMATION   \n",
       "45                     Beyonce                     Formation   \n",
       "46                 Mark Ronson                   Uptown Funk   \n",
       "47                  Bruno Mars                   Uptown Funk   \n",
       "48  Mark Ronson ft. Bruno Mars                   Uptown Funk   \n",
       "49               Ariana Grande                       7 Rings   \n",
       "50           Pharrell Williams                         Happy   \n",
       "\n",
       "                                            theme  \n",
       "0                            Overcoming adversity  \n",
       "1                            Overcoming adversity  \n",
       "2                            Overcoming adversity  \n",
       "3                           Lost love and longing  \n",
       "4                           Lost love and longing  \n",
       "5                           Lost love and longing  \n",
       "6                             Unconventional love  \n",
       "7                             Unconventional love  \n",
       "8                             Unconventional love  \n",
       "9                   Social commentary and protest  \n",
       "10                  Social commentary and protest  \n",
       "11                  Social commentary and protest  \n",
       "12                 Celebrating life's simple joys  \n",
       "13                 Celebrating life's simple joys  \n",
       "14                 Celebrating life's simple joys  \n",
       "15              Finding Hope in Unexpected Places  \n",
       "16              Finding Hope in Unexpected Places  \n",
       "17              Finding Hope in Unexpected Places  \n",
       "18            Embracing Change and Transformation  \n",
       "19            Embracing Change and Transformation  \n",
       "20            Embracing Change and Transformation  \n",
       "21            Embracing Change and Transformation  \n",
       "22            Embracing Change and Transformation  \n",
       "23           The Beauty and Pain of Vulnerability  \n",
       "24           The Beauty and Pain of Vulnerability  \n",
       "25           The Beauty and Pain of Vulnerability  \n",
       "26      The Enduring Power of Love and Connection  \n",
       "27      The Enduring Power of Love and Connection  \n",
       "28      The Enduring Power of Love and Connection  \n",
       "29                            Hustle and Ambition  \n",
       "30                            Hustle and Ambition  \n",
       "31                            Hustle and Ambition  \n",
       "32                            Hustle and Ambition  \n",
       "33                            Hustle and Ambition  \n",
       "34                            Hustle and Ambition  \n",
       "35                            Hustle and Ambition  \n",
       "36            Vulnerability and Emotional Honesty  \n",
       "37            Vulnerability and Emotional Honesty  \n",
       "38            Vulnerability and Emotional Honesty  \n",
       "39      Love and Relationships in the Digital Age  \n",
       "40      Love and Relationships in the Digital Age  \n",
       "41      Love and Relationships in the Digital Age  \n",
       "42                  Social Commentary and Protest  \n",
       "43                  Social Commentary and Protest  \n",
       "44                  Social Commentary and Protest  \n",
       "45                  Social Commentary and Protest  \n",
       "46  Finding Joy and Celebration in Life's Moments  \n",
       "47  Finding Joy and Celebration in Life's Moments  \n",
       "48  Finding Joy and Celebration in Life's Moments  \n",
       "49  Finding Joy and Celebration in Life's Moments  \n",
       "50  Finding Joy and Celebration in Life's Moments  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_themes_df = pd.DataFrame(all_themes)\n",
    "all_themes_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>artist</th>\n",
       "      <th>title</th>\n",
       "      <th>link</th>\n",
       "      <th>text</th>\n",
       "      <th>embedding</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Eminem</td>\n",
       "      <td>Lose Yourself</td>\n",
       "      <td>/e/eminem/lose+yourself_20049853.html</td>\n",
       "      <td>Look,  \\nIf you had  \\nOne shot,  \\nOr one opp...</td>\n",
       "      <td>[0.009385927580296993, -0.01625148393213749, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Gloria Gaynor</td>\n",
       "      <td>I Will Survive</td>\n",
       "      <td>/g/gloria+gaynor/i+will+survive_20060853.html</td>\n",
       "      <td>At first I was afraid  \\nI was petrified  \\nKe...</td>\n",
       "      <td>[0.003166492562741041, -0.0008579716086387634,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Adele</td>\n",
       "      <td>Someone Like You</td>\n",
       "      <td>/a/adele/someone+like+you_20895042.html</td>\n",
       "      <td>I heard, that you're settled down  \\nThat you ...</td>\n",
       "      <td>[-0.001011601067148149, 0.015197799541056156, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Coldplay</td>\n",
       "      <td>A Sky Full Of Stars</td>\n",
       "      <td>/c/coldplay/a+sky+full+of+stars_21080656.html</td>\n",
       "      <td>Cause you're a sky  \\nCause you're a sky full ...</td>\n",
       "      <td>[-0.0010626889998093247, -0.003887535771355033...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Lady Gaga</td>\n",
       "      <td>Born This Way</td>\n",
       "      <td>/l/lady+gaga/born+this+way_20886224.html</td>\n",
       "      <td>It doesn't matter if you love him, or capital ...</td>\n",
       "      <td>[-0.034117475152015686, -0.01094469428062439, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Bob Marley</td>\n",
       "      <td>Three Little Birds</td>\n",
       "      <td>/b/bob+marley/three+little+birds_20021728.html</td>\n",
       "      <td>\"Don't worry about a thing,  \\n'Cause every li...</td>\n",
       "      <td>[0.03456290066242218, 0.012554642744362354, -0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Electric Light Orchestra</td>\n",
       "      <td>Mr. Blue Sky</td>\n",
       "      <td>/e/electric+light+orchestra/mr+blue+sky_100955...</td>\n",
       "      <td>Sun is shinin' in the sky  \\nThere ain't a clo...</td>\n",
       "      <td>[0.010506678372621536, -0.03418045863509178, 0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Coldplay</td>\n",
       "      <td>Fix You</td>\n",
       "      <td>/c/coldplay/fix+you_10069035.html</td>\n",
       "      <td>When you try your best but you don't succeed  ...</td>\n",
       "      <td>[-0.0026855459436774254, 0.0014632658567279577...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Leonard Cohen</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/l/leonard+cohen/hallelujah_20082898.html</td>\n",
       "      <td>Now I've heard there was a secret chord  \\nTha...</td>\n",
       "      <td>[0.0684051588177681, 0.007501555606722832, -0....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Taylor Swift</td>\n",
       "      <td>All Too Well</td>\n",
       "      <td>/t/taylor+swift/all+too+well_21048507.html</td>\n",
       "      <td>I walked through the door with you, the air wa...</td>\n",
       "      <td>[0.01707783341407776, -0.022243959829211235, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Whitney Houston</td>\n",
       "      <td>I Will Always Love You</td>\n",
       "      <td>/w/whitney+houston/i+will+always+love+you_2014...</td>\n",
       "      <td>If I should stay, I'll only be in your way  \\n...</td>\n",
       "      <td>[0.010172651149332523, -0.01772145926952362, -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Drake</td>\n",
       "      <td>Headlines</td>\n",
       "      <td>/d/drake/headlines_20977821.html</td>\n",
       "      <td>I might be too strung out on compliments  \\nOv...</td>\n",
       "      <td>[0.018836120143532753, -0.026189839467406273, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Kanye West</td>\n",
       "      <td>Runaway</td>\n",
       "      <td>/k/kanye+west/runaway_20888526.html</td>\n",
       "      <td>And I always find, yeah I always find somethin...</td>\n",
       "      <td>[-0.028336936607956886, -0.04977979511022568, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Pharrell Williams</td>\n",
       "      <td>Happy</td>\n",
       "      <td>/p/pharrell+williams/happy_21062630.html</td>\n",
       "      <td>It might seem crazy what I'm about to say  \\nS...</td>\n",
       "      <td>[-0.02772078663110733, -0.022948285564780235, ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      artist                   title  \\\n",
       "0                     Eminem           Lose Yourself   \n",
       "1              Gloria Gaynor          I Will Survive   \n",
       "2                      Adele        Someone Like You   \n",
       "3                   Coldplay     A Sky Full Of Stars   \n",
       "4                  Lady Gaga           Born This Way   \n",
       "5                 Bob Marley      Three Little Birds   \n",
       "6   Electric Light Orchestra            Mr. Blue Sky   \n",
       "7                   Coldplay                 Fix You   \n",
       "8              Leonard Cohen              Hallelujah   \n",
       "9               Taylor Swift            All Too Well   \n",
       "10           Whitney Houston  I Will Always Love You   \n",
       "11                     Drake               Headlines   \n",
       "12                Kanye West                 Runaway   \n",
       "13         Pharrell Williams                   Happy   \n",
       "\n",
       "                                                 link  \\\n",
       "0               /e/eminem/lose+yourself_20049853.html   \n",
       "1       /g/gloria+gaynor/i+will+survive_20060853.html   \n",
       "2             /a/adele/someone+like+you_20895042.html   \n",
       "3       /c/coldplay/a+sky+full+of+stars_21080656.html   \n",
       "4            /l/lady+gaga/born+this+way_20886224.html   \n",
       "5      /b/bob+marley/three+little+birds_20021728.html   \n",
       "6   /e/electric+light+orchestra/mr+blue+sky_100955...   \n",
       "7                   /c/coldplay/fix+you_10069035.html   \n",
       "8           /l/leonard+cohen/hallelujah_20082898.html   \n",
       "9          /t/taylor+swift/all+too+well_21048507.html   \n",
       "10  /w/whitney+houston/i+will+always+love+you_2014...   \n",
       "11                   /d/drake/headlines_20977821.html   \n",
       "12                /k/kanye+west/runaway_20888526.html   \n",
       "13           /p/pharrell+williams/happy_21062630.html   \n",
       "\n",
       "                                                 text  \\\n",
       "0   Look,  \\nIf you had  \\nOne shot,  \\nOr one opp...   \n",
       "1   At first I was afraid  \\nI was petrified  \\nKe...   \n",
       "2   I heard, that you're settled down  \\nThat you ...   \n",
       "3   Cause you're a sky  \\nCause you're a sky full ...   \n",
       "4   It doesn't matter if you love him, or capital ...   \n",
       "5   \"Don't worry about a thing,  \\n'Cause every li...   \n",
       "6   Sun is shinin' in the sky  \\nThere ain't a clo...   \n",
       "7   When you try your best but you don't succeed  ...   \n",
       "8   Now I've heard there was a secret chord  \\nTha...   \n",
       "9   I walked through the door with you, the air wa...   \n",
       "10  If I should stay, I'll only be in your way  \\n...   \n",
       "11  I might be too strung out on compliments  \\nOv...   \n",
       "12  And I always find, yeah I always find somethin...   \n",
       "13  It might seem crazy what I'm about to say  \\nS...   \n",
       "\n",
       "                                            embedding  \n",
       "0   [0.009385927580296993, -0.01625148393213749, -...  \n",
       "1   [0.003166492562741041, -0.0008579716086387634,...  \n",
       "2   [-0.001011601067148149, 0.015197799541056156, ...  \n",
       "3   [-0.0010626889998093247, -0.003887535771355033...  \n",
       "4   [-0.034117475152015686, -0.01094469428062439, ...  \n",
       "5   [0.03456290066242218, 0.012554642744362354, -0...  \n",
       "6   [0.010506678372621536, -0.03418045863509178, 0...  \n",
       "7   [-0.0026855459436774254, 0.0014632658567279577...  \n",
       "8   [0.0684051588177681, 0.007501555606722832, -0....  \n",
       "9   [0.01707783341407776, -0.022243959829211235, -...  \n",
       "10  [0.010172651149332523, -0.01772145926952362, -...  \n",
       "11  [0.018836120143532753, -0.026189839467406273, ...  \n",
       "12  [-0.028336936607956886, -0.04977979511022568, ...  \n",
       "13  [-0.02772078663110733, -0.022948285564780235, ...  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_filtered.rename(columns={\"song\":\"title\"}, inplace=True)\n",
    "df_filtered"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>artist</th>\n",
       "      <th>title</th>\n",
       "      <th>link</th>\n",
       "      <th>text</th>\n",
       "      <th>embedding</th>\n",
       "      <th>theme</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Eminem</td>\n",
       "      <td>Lose Yourself</td>\n",
       "      <td>/e/eminem/lose+yourself_20049853.html</td>\n",
       "      <td>Look,  \\nIf you had  \\nOne shot,  \\nOr one opp...</td>\n",
       "      <td>[0.009385927580296993, -0.01625148393213749, -...</td>\n",
       "      <td>Overcoming adversity</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Gloria Gaynor</td>\n",
       "      <td>I Will Survive</td>\n",
       "      <td>/g/gloria+gaynor/i+will+survive_20060853.html</td>\n",
       "      <td>At first I was afraid  \\nI was petrified  \\nKe...</td>\n",
       "      <td>[0.003166492562741041, -0.0008579716086387634,...</td>\n",
       "      <td>Overcoming adversity</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Adele</td>\n",
       "      <td>Someone Like You</td>\n",
       "      <td>/a/adele/someone+like+you_20895042.html</td>\n",
       "      <td>I heard, that you're settled down  \\nThat you ...</td>\n",
       "      <td>[-0.001011601067148149, 0.015197799541056156, ...</td>\n",
       "      <td>Lost love and longing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Coldplay</td>\n",
       "      <td>A Sky Full Of Stars</td>\n",
       "      <td>/c/coldplay/a+sky+full+of+stars_21080656.html</td>\n",
       "      <td>Cause you're a sky  \\nCause you're a sky full ...</td>\n",
       "      <td>[-0.0010626889998093247, -0.003887535771355033...</td>\n",
       "      <td>Unconventional love</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Lady Gaga</td>\n",
       "      <td>Born This Way</td>\n",
       "      <td>/l/lady+gaga/born+this+way_20886224.html</td>\n",
       "      <td>It doesn't matter if you love him, or capital ...</td>\n",
       "      <td>[-0.034117475152015686, -0.01094469428062439, ...</td>\n",
       "      <td>Unconventional love</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Bob Marley</td>\n",
       "      <td>Three Little Birds</td>\n",
       "      <td>/b/bob+marley/three+little+birds_20021728.html</td>\n",
       "      <td>\"Don't worry about a thing,  \\n'Cause every li...</td>\n",
       "      <td>[0.03456290066242218, 0.012554642744362354, -0...</td>\n",
       "      <td>Celebrating life's simple joys</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Electric Light Orchestra</td>\n",
       "      <td>Mr. Blue Sky</td>\n",
       "      <td>/e/electric+light+orchestra/mr+blue+sky_100955...</td>\n",
       "      <td>Sun is shinin' in the sky  \\nThere ain't a clo...</td>\n",
       "      <td>[0.010506678372621536, -0.03418045863509178, 0...</td>\n",
       "      <td>Celebrating life's simple joys</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Coldplay</td>\n",
       "      <td>Fix You</td>\n",
       "      <td>/c/coldplay/fix+you_10069035.html</td>\n",
       "      <td>When you try your best but you don't succeed  ...</td>\n",
       "      <td>[-0.0026855459436774254, 0.0014632658567279577...</td>\n",
       "      <td>Finding Hope in Unexpected Places</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Leonard Cohen</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>/l/leonard+cohen/hallelujah_20082898.html</td>\n",
       "      <td>Now I've heard there was a secret chord  \\nTha...</td>\n",
       "      <td>[0.0684051588177681, 0.007501555606722832, -0....</td>\n",
       "      <td>Finding Hope in Unexpected Places</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Taylor Swift</td>\n",
       "      <td>All Too Well</td>\n",
       "      <td>/t/taylor+swift/all+too+well_21048507.html</td>\n",
       "      <td>I walked through the door with you, the air wa...</td>\n",
       "      <td>[0.01707783341407776, -0.022243959829211235, -...</td>\n",
       "      <td>The Beauty and Pain of Vulnerability</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Whitney Houston</td>\n",
       "      <td>I Will Always Love You</td>\n",
       "      <td>/w/whitney+houston/i+will+always+love+you_2014...</td>\n",
       "      <td>If I should stay, I'll only be in your way  \\n...</td>\n",
       "      <td>[0.010172651149332523, -0.01772145926952362, -...</td>\n",
       "      <td>The Enduring Power of Love and Connection</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Drake</td>\n",
       "      <td>Headlines</td>\n",
       "      <td>/d/drake/headlines_20977821.html</td>\n",
       "      <td>I might be too strung out on compliments  \\nOv...</td>\n",
       "      <td>[0.018836120143532753, -0.026189839467406273, ...</td>\n",
       "      <td>Hustle and Ambition</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Kanye West</td>\n",
       "      <td>Runaway</td>\n",
       "      <td>/k/kanye+west/runaway_20888526.html</td>\n",
       "      <td>And I always find, yeah I always find somethin...</td>\n",
       "      <td>[-0.028336936607956886, -0.04977979511022568, ...</td>\n",
       "      <td>Vulnerability and Emotional Honesty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Pharrell Williams</td>\n",
       "      <td>Happy</td>\n",
       "      <td>/p/pharrell+williams/happy_21062630.html</td>\n",
       "      <td>It might seem crazy what I'm about to say  \\nS...</td>\n",
       "      <td>[-0.02772078663110733, -0.022948285564780235, ...</td>\n",
       "      <td>Finding Joy and Celebration in Life's Moments</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      artist                   title  \\\n",
       "0                     Eminem           Lose Yourself   \n",
       "1              Gloria Gaynor          I Will Survive   \n",
       "2                      Adele        Someone Like You   \n",
       "3                   Coldplay     A Sky Full Of Stars   \n",
       "4                  Lady Gaga           Born This Way   \n",
       "5                 Bob Marley      Three Little Birds   \n",
       "6   Electric Light Orchestra            Mr. Blue Sky   \n",
       "7                   Coldplay                 Fix You   \n",
       "8              Leonard Cohen              Hallelujah   \n",
       "9               Taylor Swift            All Too Well   \n",
       "10           Whitney Houston  I Will Always Love You   \n",
       "11                     Drake               Headlines   \n",
       "12                Kanye West                 Runaway   \n",
       "13         Pharrell Williams                   Happy   \n",
       "\n",
       "                                                 link  \\\n",
       "0               /e/eminem/lose+yourself_20049853.html   \n",
       "1       /g/gloria+gaynor/i+will+survive_20060853.html   \n",
       "2             /a/adele/someone+like+you_20895042.html   \n",
       "3       /c/coldplay/a+sky+full+of+stars_21080656.html   \n",
       "4            /l/lady+gaga/born+this+way_20886224.html   \n",
       "5      /b/bob+marley/three+little+birds_20021728.html   \n",
       "6   /e/electric+light+orchestra/mr+blue+sky_100955...   \n",
       "7                   /c/coldplay/fix+you_10069035.html   \n",
       "8           /l/leonard+cohen/hallelujah_20082898.html   \n",
       "9          /t/taylor+swift/all+too+well_21048507.html   \n",
       "10  /w/whitney+houston/i+will+always+love+you_2014...   \n",
       "11                   /d/drake/headlines_20977821.html   \n",
       "12                /k/kanye+west/runaway_20888526.html   \n",
       "13           /p/pharrell+williams/happy_21062630.html   \n",
       "\n",
       "                                                 text  \\\n",
       "0   Look,  \\nIf you had  \\nOne shot,  \\nOr one opp...   \n",
       "1   At first I was afraid  \\nI was petrified  \\nKe...   \n",
       "2   I heard, that you're settled down  \\nThat you ...   \n",
       "3   Cause you're a sky  \\nCause you're a sky full ...   \n",
       "4   It doesn't matter if you love him, or capital ...   \n",
       "5   \"Don't worry about a thing,  \\n'Cause every li...   \n",
       "6   Sun is shinin' in the sky  \\nThere ain't a clo...   \n",
       "7   When you try your best but you don't succeed  ...   \n",
       "8   Now I've heard there was a secret chord  \\nTha...   \n",
       "9   I walked through the door with you, the air wa...   \n",
       "10  If I should stay, I'll only be in your way  \\n...   \n",
       "11  I might be too strung out on compliments  \\nOv...   \n",
       "12  And I always find, yeah I always find somethin...   \n",
       "13  It might seem crazy what I'm about to say  \\nS...   \n",
       "\n",
       "                                            embedding  \\\n",
       "0   [0.009385927580296993, -0.01625148393213749, -...   \n",
       "1   [0.003166492562741041, -0.0008579716086387634,...   \n",
       "2   [-0.001011601067148149, 0.015197799541056156, ...   \n",
       "3   [-0.0010626889998093247, -0.003887535771355033...   \n",
       "4   [-0.034117475152015686, -0.01094469428062439, ...   \n",
       "5   [0.03456290066242218, 0.012554642744362354, -0...   \n",
       "6   [0.010506678372621536, -0.03418045863509178, 0...   \n",
       "7   [-0.0026855459436774254, 0.0014632658567279577...   \n",
       "8   [0.0684051588177681, 0.007501555606722832, -0....   \n",
       "9   [0.01707783341407776, -0.022243959829211235, -...   \n",
       "10  [0.010172651149332523, -0.01772145926952362, -...   \n",
       "11  [0.018836120143532753, -0.026189839467406273, ...   \n",
       "12  [-0.028336936607956886, -0.04977979511022568, ...   \n",
       "13  [-0.02772078663110733, -0.022948285564780235, ...   \n",
       "\n",
       "                                            theme  \n",
       "0                            Overcoming adversity  \n",
       "1                            Overcoming adversity  \n",
       "2                           Lost love and longing  \n",
       "3                             Unconventional love  \n",
       "4                             Unconventional love  \n",
       "5                  Celebrating life's simple joys  \n",
       "6                  Celebrating life's simple joys  \n",
       "7               Finding Hope in Unexpected Places  \n",
       "8               Finding Hope in Unexpected Places  \n",
       "9            The Beauty and Pain of Vulnerability  \n",
       "10      The Enduring Power of Love and Connection  \n",
       "11                            Hustle and Ambition  \n",
       "12            Vulnerability and Emotional Honesty  \n",
       "13  Finding Joy and Celebration in Life's Moments  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_filtered_with_theme = df_filtered.merge(all_themes_df, on=[\"artist\", \"title\"])\n",
    "df_filtered_with_theme"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "theme\n",
       "Overcoming adversity                             2\n",
       "Unconventional love                              2\n",
       "Celebrating life's simple joys                   2\n",
       "Finding Hope in Unexpected Places                2\n",
       "Lost love and longing                            1\n",
       "The Beauty and Pain of Vulnerability             1\n",
       "The Enduring Power of Love and Connection        1\n",
       "Hustle and Ambition                              1\n",
       "Vulnerability and Emotional Honesty              1\n",
       "Finding Joy and Celebration in Life's Moments    1\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_filtered_with_theme[\"theme\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(10,)"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_filtered_with_theme[\"theme\"].unique().shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_filtered_with_theme.drop(\"link\", axis=1).to_csv('data/test.json', index=False)\n",
    "#df_filtered_with_theme.drop(\"link\", axis=1).to_json('data/test.json', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "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>artist</th>\n",
       "      <th>title</th>\n",
       "      <th>text</th>\n",
       "      <th>embedding</th>\n",
       "      <th>theme</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Eminem</td>\n",
       "      <td>Lose Yourself</td>\n",
       "      <td>Look,  \\nIf you had  \\nOne shot,  \\nOr one opp...</td>\n",
       "      <td>[0.009385927580296993, -0.01625148393213749, -...</td>\n",
       "      <td>Overcoming adversity</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Gloria Gaynor</td>\n",
       "      <td>I Will Survive</td>\n",
       "      <td>At first I was afraid  \\nI was petrified  \\nKe...</td>\n",
       "      <td>[0.003166492562741041, -0.0008579716086387634,...</td>\n",
       "      <td>Overcoming adversity</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Adele</td>\n",
       "      <td>Someone Like You</td>\n",
       "      <td>I heard, that you're settled down  \\nThat you ...</td>\n",
       "      <td>[-0.001011601067148149, 0.015197799541056156, ...</td>\n",
       "      <td>Lost love and longing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Coldplay</td>\n",
       "      <td>A Sky Full Of Stars</td>\n",
       "      <td>Cause you're a sky  \\nCause you're a sky full ...</td>\n",
       "      <td>[-0.0010626889998093247, -0.003887535771355033...</td>\n",
       "      <td>Unconventional love</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Lady Gaga</td>\n",
       "      <td>Born This Way</td>\n",
       "      <td>It doesn't matter if you love him, or capital ...</td>\n",
       "      <td>[-0.034117475152015686, -0.01094469428062439, ...</td>\n",
       "      <td>Unconventional love</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Bob Marley</td>\n",
       "      <td>Three Little Birds</td>\n",
       "      <td>\"Don't worry about a thing,  \\n'Cause every li...</td>\n",
       "      <td>[0.03456290066242218, 0.012554642744362354, -0...</td>\n",
       "      <td>Celebrating life's simple joys</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Electric Light Orchestra</td>\n",
       "      <td>Mr. Blue Sky</td>\n",
       "      <td>Sun is shinin' in the sky  \\nThere ain't a clo...</td>\n",
       "      <td>[0.010506678372621536, -0.03418045863509178, 0...</td>\n",
       "      <td>Celebrating life's simple joys</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Coldplay</td>\n",
       "      <td>Fix You</td>\n",
       "      <td>When you try your best but you don't succeed  ...</td>\n",
       "      <td>[-0.0026855459436774254, 0.0014632658567279577...</td>\n",
       "      <td>Finding Hope in Unexpected Places</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Leonard Cohen</td>\n",
       "      <td>Hallelujah</td>\n",
       "      <td>Now I've heard there was a secret chord  \\nTha...</td>\n",
       "      <td>[0.0684051588177681, 0.007501555606722832, -0....</td>\n",
       "      <td>Finding Hope in Unexpected Places</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Taylor Swift</td>\n",
       "      <td>All Too Well</td>\n",
       "      <td>I walked through the door with you, the air wa...</td>\n",
       "      <td>[0.01707783341407776, -0.022243959829211235, -...</td>\n",
       "      <td>The Beauty and Pain of Vulnerability</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Whitney Houston</td>\n",
       "      <td>I Will Always Love You</td>\n",
       "      <td>If I should stay, I'll only be in your way  \\n...</td>\n",
       "      <td>[0.010172651149332523, -0.01772145926952362, -...</td>\n",
       "      <td>The Enduring Power of Love and Connection</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Drake</td>\n",
       "      <td>Headlines</td>\n",
       "      <td>I might be too strung out on compliments  \\nOv...</td>\n",
       "      <td>[0.018836120143532753, -0.026189839467406273, ...</td>\n",
       "      <td>Hustle and Ambition</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Kanye West</td>\n",
       "      <td>Runaway</td>\n",
       "      <td>And I always find, yeah I always find somethin...</td>\n",
       "      <td>[-0.028336936607956886, -0.04977979511022568, ...</td>\n",
       "      <td>Vulnerability and Emotional Honesty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Pharrell Williams</td>\n",
       "      <td>Happy</td>\n",
       "      <td>It might seem crazy what I'm about to say  \\nS...</td>\n",
       "      <td>[-0.02772078663110733, -0.022948285564780235, ...</td>\n",
       "      <td>Finding Joy and Celebration in Life's Moments</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      artist                   title  \\\n",
       "0                     Eminem           Lose Yourself   \n",
       "1              Gloria Gaynor          I Will Survive   \n",
       "2                      Adele        Someone Like You   \n",
       "3                   Coldplay     A Sky Full Of Stars   \n",
       "4                  Lady Gaga           Born This Way   \n",
       "5                 Bob Marley      Three Little Birds   \n",
       "6   Electric Light Orchestra            Mr. Blue Sky   \n",
       "7                   Coldplay                 Fix You   \n",
       "8              Leonard Cohen              Hallelujah   \n",
       "9               Taylor Swift            All Too Well   \n",
       "10           Whitney Houston  I Will Always Love You   \n",
       "11                     Drake               Headlines   \n",
       "12                Kanye West                 Runaway   \n",
       "13         Pharrell Williams                   Happy   \n",
       "\n",
       "                                                 text  \\\n",
       "0   Look,  \\nIf you had  \\nOne shot,  \\nOr one opp...   \n",
       "1   At first I was afraid  \\nI was petrified  \\nKe...   \n",
       "2   I heard, that you're settled down  \\nThat you ...   \n",
       "3   Cause you're a sky  \\nCause you're a sky full ...   \n",
       "4   It doesn't matter if you love him, or capital ...   \n",
       "5   \"Don't worry about a thing,  \\n'Cause every li...   \n",
       "6   Sun is shinin' in the sky  \\nThere ain't a clo...   \n",
       "7   When you try your best but you don't succeed  ...   \n",
       "8   Now I've heard there was a secret chord  \\nTha...   \n",
       "9   I walked through the door with you, the air wa...   \n",
       "10  If I should stay, I'll only be in your way  \\n...   \n",
       "11  I might be too strung out on compliments  \\nOv...   \n",
       "12  And I always find, yeah I always find somethin...   \n",
       "13  It might seem crazy what I'm about to say  \\nS...   \n",
       "\n",
       "                                            embedding  \\\n",
       "0   [0.009385927580296993, -0.01625148393213749, -...   \n",
       "1   [0.003166492562741041, -0.0008579716086387634,...   \n",
       "2   [-0.001011601067148149, 0.015197799541056156, ...   \n",
       "3   [-0.0010626889998093247, -0.003887535771355033...   \n",
       "4   [-0.034117475152015686, -0.01094469428062439, ...   \n",
       "5   [0.03456290066242218, 0.012554642744362354, -0...   \n",
       "6   [0.010506678372621536, -0.03418045863509178, 0...   \n",
       "7   [-0.0026855459436774254, 0.0014632658567279577...   \n",
       "8   [0.0684051588177681, 0.007501555606722832, -0....   \n",
       "9   [0.01707783341407776, -0.022243959829211235, -...   \n",
       "10  [0.010172651149332523, -0.01772145926952362, -...   \n",
       "11  [0.018836120143532753, -0.026189839467406273, ...   \n",
       "12  [-0.028336936607956886, -0.04977979511022568, ...   \n",
       "13  [-0.02772078663110733, -0.022948285564780235, ...   \n",
       "\n",
       "                                            theme  \n",
       "0                            Overcoming adversity  \n",
       "1                            Overcoming adversity  \n",
       "2                           Lost love and longing  \n",
       "3                             Unconventional love  \n",
       "4                             Unconventional love  \n",
       "5                  Celebrating life's simple joys  \n",
       "6                  Celebrating life's simple joys  \n",
       "7               Finding Hope in Unexpected Places  \n",
       "8               Finding Hope in Unexpected Places  \n",
       "9            The Beauty and Pain of Vulnerability  \n",
       "10      The Enduring Power of Love and Connection  \n",
       "11                            Hustle and Ambition  \n",
       "12            Vulnerability and Emotional Honesty  \n",
       "13  Finding Joy and Celebration in Life's Moments  "
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_filtered_with_theme.drop(\"link\", axis=1)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "venv",
   "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.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}