final 3_scraper-step1(get_url_by_selenium).ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import re\n",
    "import time\n",
    "import urllib\n",
    "import json\n",
    "import xlrd\n",
    "from bs4 import BeautifulSoup\n",
    "from selenium import webdriver\n",
    "from selenium.webdriver.common.action_chains import ActionChains\n",
    "from selenium.webdriver.chrome.options import Options\n",
    "import math\n",
    "import random\n",
    "os.chdir(\"D:/数据/美国data\")\n",
    "from fake_useragent import UserAgent\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 164,
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_excel(\"wholesoap.xlsx\",Sheet=\"sheet1\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 165,
   "metadata": {},
   "outputs": [],
   "source": [
    "namedf=pd.DataFrame(columns=['show','role','times'])\n",
    "for i in set(list(df['show'])):\n",
    "    df0=df[df['show']==i]\n",
    "    names=[]\n",
    "    namedict = {}\n",
    "    for j in list(df0['content']):\n",
    "        if str(j)!='nan':\n",
    "            newname=re.findall('@!(.*?) ',j)\n",
    "            newname=[x.strip(':') for x in newname]\n",
    "            for key in newname:\n",
    "                namedict[key] = namedict.get(key, 0) + 1\n",
    "        else:\n",
    "            continue\n",
    "    for key in namedict.keys():\n",
    "        newrow={'show':i,'role':key,'times':namedict[key]}\n",
    "        namedf=namedf.append(newrow,ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 166,
   "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>show</th>\n",
       "      <th>role</th>\n",
       "      <th>times</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Luke</td>\n",
       "      <td>22941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Lucy</td>\n",
       "      <td>59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Edward</td>\n",
       "      <td>7656</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Bobbie</td>\n",
       "      <td>3890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Zander</td>\n",
       "      <td>5212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Scott</td>\n",
       "      <td>5886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Serena</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Laura</td>\n",
       "      <td>4286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Stavros</td>\n",
       "      <td>513</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Helena</td>\n",
       "      <td>2446</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Nikolas</td>\n",
       "      <td>27655</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Gia</td>\n",
       "      <td>3499</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Lucky</td>\n",
       "      <td>25944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Lee</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Gail</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Melissa</td>\n",
       "      <td>817</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Audrey</td>\n",
       "      <td>362</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Woman</td>\n",
       "      <td>1608</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Alan</td>\n",
       "      <td>4622</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Paramedic</td>\n",
       "      <td>247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Emily</td>\n",
       "      <td>17726</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Monica</td>\n",
       "      <td>6506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Amy</td>\n",
       "      <td>123</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Felicia</td>\n",
       "      <td>2778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Mac</td>\n",
       "      <td>6773</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Taggert</td>\n",
       "      <td>1864</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Lucky-and-Gia</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Stefan</td>\n",
       "      <td>1479</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Chloe</td>\n",
       "      <td>143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Dara</td>\n",
       "      <td>311</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14134</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Paco</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14135</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Carlyle</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14136</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Moderator</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14137</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Voter</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14138</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Neil</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14139</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Walsh</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14140</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Male-singer</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14141</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Martin</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14142</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Serge</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14143</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Wilhelm</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14144</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Francisco</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14145</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Francesco</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14146</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Actor</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14147</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Actress</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14148</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Doctor-Yu</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14149</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Harmon</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14150</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Young-Stefano</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14151</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Radio-Reporter</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14152</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Vladimir</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14153</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Newman</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14154</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Chambers</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14155</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Austin-and-Carrie</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14156</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Andrew</td>\n",
       "      <td>105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14157</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Martine</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14158</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Felicia</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14159</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Mac</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14160</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Helena</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14161</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Lucky</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14162</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Gia</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14163</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Nikolas</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>14164 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    show               role  times\n",
       "0       General Hospital               Luke  22941\n",
       "1       General Hospital               Lucy     59\n",
       "2       General Hospital             Edward   7656\n",
       "3       General Hospital             Bobbie   3890\n",
       "4       General Hospital             Zander   5212\n",
       "5       General Hospital              Scott   5886\n",
       "6       General Hospital             Serena     13\n",
       "7       General Hospital              Laura   4286\n",
       "8       General Hospital            Stavros    513\n",
       "9       General Hospital             Helena   2446\n",
       "10      General Hospital            Nikolas  27655\n",
       "11      General Hospital                Gia   3499\n",
       "12      General Hospital              Lucky  25944\n",
       "13      General Hospital                Lee      6\n",
       "14      General Hospital               Gail      9\n",
       "15      General Hospital            Melissa    817\n",
       "16      General Hospital             Audrey    362\n",
       "17      General Hospital              Woman   1608\n",
       "18      General Hospital               Alan   4622\n",
       "19      General Hospital          Paramedic    247\n",
       "20      General Hospital              Emily  17726\n",
       "21      General Hospital             Monica   6506\n",
       "22      General Hospital                Amy    123\n",
       "23      General Hospital            Felicia   2778\n",
       "24      General Hospital                Mac   6773\n",
       "25      General Hospital            Taggert   1864\n",
       "26      General Hospital      Lucky-and-Gia      1\n",
       "27      General Hospital             Stefan   1479\n",
       "28      General Hospital              Chloe    143\n",
       "29      General Hospital               Dara    311\n",
       "...                  ...                ...    ...\n",
       "14134  Days of Our Lives               Paco     13\n",
       "14135  Days of Our Lives            Carlyle     16\n",
       "14136  Days of Our Lives          Moderator     10\n",
       "14137  Days of Our Lives              Voter      2\n",
       "14138  Days of Our Lives               Neil     31\n",
       "14139  Days of Our Lives              Walsh      3\n",
       "14140  Days of Our Lives        Male-singer      1\n",
       "14141  Days of Our Lives             Martin      3\n",
       "14142  Days of Our Lives              Serge     25\n",
       "14143  Days of Our Lives            Wilhelm     18\n",
       "14144  Days of Our Lives          Francisco     15\n",
       "14145  Days of Our Lives          Francesco      7\n",
       "14146  Days of Our Lives              Actor      4\n",
       "14147  Days of Our Lives            Actress      5\n",
       "14148  Days of Our Lives          Doctor-Yu     17\n",
       "14149  Days of Our Lives             Harmon     61\n",
       "14150  Days of Our Lives      Young-Stefano      2\n",
       "14151  Days of Our Lives     Radio-Reporter      1\n",
       "14152  Days of Our Lives           Vladimir     36\n",
       "14153  Days of Our Lives             Newman     16\n",
       "14154  Days of Our Lives           Chambers      2\n",
       "14155  Days of Our Lives  Austin-and-Carrie      1\n",
       "14156  Days of Our Lives             Andrew    105\n",
       "14157  Days of Our Lives            Martine     11\n",
       "14158  Days of Our Lives            Felicia      4\n",
       "14159  Days of Our Lives                Mac      2\n",
       "14160  Days of Our Lives             Helena      2\n",
       "14161  Days of Our Lives              Lucky      4\n",
       "14162  Days of Our Lives                Gia      1\n",
       "14163  Days of Our Lives            Nikolas      1\n",
       "\n",
       "[14164 rows x 3 columns]"
      ]
     },
     "execution_count": 166,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "namedf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 168,
   "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>show</th>\n",
       "      <th>role</th>\n",
       "      <th>times</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Luke</td>\n",
       "      <td>22941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Edward</td>\n",
       "      <td>7656</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Bobbie</td>\n",
       "      <td>3890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Zander</td>\n",
       "      <td>5212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Scott</td>\n",
       "      <td>5886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Laura</td>\n",
       "      <td>4286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Helena</td>\n",
       "      <td>2446</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Nikolas</td>\n",
       "      <td>27655</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Gia</td>\n",
       "      <td>3499</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Lucky</td>\n",
       "      <td>25944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Woman</td>\n",
       "      <td>1608</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Alan</td>\n",
       "      <td>4622</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Emily</td>\n",
       "      <td>17726</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Monica</td>\n",
       "      <td>6506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Felicia</td>\n",
       "      <td>2778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Mac</td>\n",
       "      <td>6773</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Taggert</td>\n",
       "      <td>1864</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Stefan</td>\n",
       "      <td>1479</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Roy</td>\n",
       "      <td>2321</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Man</td>\n",
       "      <td>3312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>A.J.</td>\n",
       "      <td>4945</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Skye</td>\n",
       "      <td>14553</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Carly</td>\n",
       "      <td>57668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Elizabeth</td>\n",
       "      <td>27388</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Jax</td>\n",
       "      <td>30135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Sonny</td>\n",
       "      <td>64994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Alexis</td>\n",
       "      <td>29218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Mike</td>\n",
       "      <td>3168</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Ned</td>\n",
       "      <td>5915</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Max</td>\n",
       "      <td>3610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13406</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Chelsea</td>\n",
       "      <td>14146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13437</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Chad</td>\n",
       "      <td>4481</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13459</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Frankie</td>\n",
       "      <td>2482</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13461</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Alex</td>\n",
       "      <td>2157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13485</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Carrie</td>\n",
       "      <td>5627</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13558</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>E.J.</td>\n",
       "      <td>16323</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13563</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Kayla</td>\n",
       "      <td>8254</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13564</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Nick</td>\n",
       "      <td>6193</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13565</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Steve</td>\n",
       "      <td>7687</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13571</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Stephanie</td>\n",
       "      <td>13513</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13582</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Anna</td>\n",
       "      <td>2071</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13591</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Willow</td>\n",
       "      <td>1351</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13637</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>EJ</td>\n",
       "      <td>14292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13655</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Adrienne</td>\n",
       "      <td>1511</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13657</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Jeremy</td>\n",
       "      <td>1129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13689</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Morgan</td>\n",
       "      <td>1903</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13714</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Justin</td>\n",
       "      <td>2087</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13744</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Ava</td>\n",
       "      <td>1930</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13747</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Daniel</td>\n",
       "      <td>14751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13782</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Melanie</td>\n",
       "      <td>15231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13810</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Rafe</td>\n",
       "      <td>15714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13841</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Nathan</td>\n",
       "      <td>4074</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13848</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Arianna</td>\n",
       "      <td>4966</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13895</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Carly</td>\n",
       "      <td>6878</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13899</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Vivian</td>\n",
       "      <td>4245</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13908</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Gabi</td>\n",
       "      <td>2775</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14027</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Taylor</td>\n",
       "      <td>3205</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14038</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Dario</td>\n",
       "      <td>1070</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14053</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Quinn</td>\n",
       "      <td>1428</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14059</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Sonny</td>\n",
       "      <td>1075</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>747 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    show       role  times\n",
       "0       General Hospital       Luke  22941\n",
       "2       General Hospital     Edward   7656\n",
       "3       General Hospital     Bobbie   3890\n",
       "4       General Hospital     Zander   5212\n",
       "5       General Hospital      Scott   5886\n",
       "7       General Hospital      Laura   4286\n",
       "9       General Hospital     Helena   2446\n",
       "10      General Hospital    Nikolas  27655\n",
       "11      General Hospital        Gia   3499\n",
       "12      General Hospital      Lucky  25944\n",
       "17      General Hospital      Woman   1608\n",
       "18      General Hospital       Alan   4622\n",
       "20      General Hospital      Emily  17726\n",
       "21      General Hospital     Monica   6506\n",
       "23      General Hospital    Felicia   2778\n",
       "24      General Hospital        Mac   6773\n",
       "25      General Hospital    Taggert   1864\n",
       "27      General Hospital     Stefan   1479\n",
       "30      General Hospital        Roy   2321\n",
       "37      General Hospital        Man   3312\n",
       "39      General Hospital       A.J.   4945\n",
       "40      General Hospital       Skye  14553\n",
       "41      General Hospital      Carly  57668\n",
       "43      General Hospital  Elizabeth  27388\n",
       "44      General Hospital        Jax  30135\n",
       "45      General Hospital      Sonny  64994\n",
       "46      General Hospital     Alexis  29218\n",
       "55      General Hospital       Mike   3168\n",
       "57      General Hospital        Ned   5915\n",
       "60      General Hospital        Max   3610\n",
       "...                  ...        ...    ...\n",
       "13406  Days of Our Lives    Chelsea  14146\n",
       "13437  Days of Our Lives       Chad   4481\n",
       "13459  Days of Our Lives    Frankie   2482\n",
       "13461  Days of Our Lives       Alex   2157\n",
       "13485  Days of Our Lives     Carrie   5627\n",
       "13558  Days of Our Lives       E.J.  16323\n",
       "13563  Days of Our Lives      Kayla   8254\n",
       "13564  Days of Our Lives       Nick   6193\n",
       "13565  Days of Our Lives      Steve   7687\n",
       "13571  Days of Our Lives  Stephanie  13513\n",
       "13582  Days of Our Lives       Anna   2071\n",
       "13591  Days of Our Lives     Willow   1351\n",
       "13637  Days of Our Lives         EJ  14292\n",
       "13655  Days of Our Lives   Adrienne   1511\n",
       "13657  Days of Our Lives     Jeremy   1129\n",
       "13689  Days of Our Lives     Morgan   1903\n",
       "13714  Days of Our Lives     Justin   2087\n",
       "13744  Days of Our Lives        Ava   1930\n",
       "13747  Days of Our Lives     Daniel  14751\n",
       "13782  Days of Our Lives    Melanie  15231\n",
       "13810  Days of Our Lives       Rafe  15714\n",
       "13841  Days of Our Lives     Nathan   4074\n",
       "13848  Days of Our Lives    Arianna   4966\n",
       "13895  Days of Our Lives      Carly   6878\n",
       "13899  Days of Our Lives     Vivian   4245\n",
       "13908  Days of Our Lives       Gabi   2775\n",
       "14027  Days of Our Lives     Taylor   3205\n",
       "14038  Days of Our Lives      Dario   1070\n",
       "14053  Days of Our Lives      Quinn   1428\n",
       "14059  Days of Our Lives      Sonny   1075\n",
       "\n",
       "[747 rows x 3 columns]"
      ]
     },
     "execution_count": 168,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "namedf1=namedf[namedf['times']>1000]\n",
    "namedf1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 172,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "E:\\software\\Anaconda\\lib\\site-packages\\ipykernel_launcher.py:27: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n"
     ]
    }
   ],
   "source": [
    "wrong=[]\n",
    "for item in range(0,len(namedf1)):\n",
    "    if len(str(namedf1['url'][item]))<=3:\n",
    "        i=list(namedf1['show'])[item]\n",
    "        j=list(namedf1['role'])[item]\n",
    "        i=i.replace(\"All My Childen\",'All My Children')\n",
    "        i=i.replace(\"General Hospital\",'General-Hospital')\n",
    "        i=i.replace(\"As the World Turns\",'CBS As the world turns')\n",
    "        i=i.replace(\"Bold and Beautiful\",'the Bold and the Beautiful')\n",
    "        i=i.replace(\"Young and Restless\",'the Young and the Restless')\n",
    "        i=i.replace(\"Port Charles\" ,'Port-Charles')\n",
    "        url='https://'+i.lower().replace(\" \",\"\")+'.fandom.com/wiki/'+str(j)\n",
    "        options = webdriver.ChromeOptions()\n",
    "        options.add_argument('headless')\n",
    "        ua = UserAgent()\n",
    "        driver=webdriver.Chrome(chrome_options=options)\n",
    "        driver.get(url)\n",
    "        time.sleep(np.random.randint(6))\n",
    "        try:\n",
    "            driver.find_element_by_css_selector(\"span[class='alternative-suggestion']\").click()\n",
    "            roleurl=driver.current_url\n",
    "            namedf1['url'][item]=roleurl\n",
    "            driver.quit()\n",
    "        except:\n",
    "            newurl=driver.current_url\n",
    "            if newurl!=url:\n",
    "                namedf1['url'][item]=newurl\n",
    "            else:\n",
    "                namedf1['url'][item]=newurl\n",
    "            driver.quit()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 173,
   "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>Unnamed: 0</th>\n",
       "      <th>show</th>\n",
       "      <th>role</th>\n",
       "      <th>times</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Luke</td>\n",
       "      <td>22941</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Luke_...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Edward</td>\n",
       "      <td>7656</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Edward</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Bobbie</td>\n",
       "      <td>3890</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Bobbie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Zander</td>\n",
       "      <td>5212</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Zande...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Scott</td>\n",
       "      <td>5886</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Scott</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Laura</td>\n",
       "      <td>4286</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Laura</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Helena</td>\n",
       "      <td>2446</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Helena</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Nikolas</td>\n",
       "      <td>27655</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Nikolas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Gia</td>\n",
       "      <td>3499</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Gia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Lucky</td>\n",
       "      <td>25944</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Lucky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Woman</td>\n",
       "      <td>1608</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Woman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Alan</td>\n",
       "      <td>4622</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Alan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Emily</td>\n",
       "      <td>17726</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Emily</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Monica</td>\n",
       "      <td>6506</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Monica</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Felicia</td>\n",
       "      <td>2778</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Felicia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Mac</td>\n",
       "      <td>6773</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Mac</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Taggert</td>\n",
       "      <td>1864</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Taggert</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Stefan</td>\n",
       "      <td>1479</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Stefan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Roy</td>\n",
       "      <td>2321</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Roy_D...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Man</td>\n",
       "      <td>3312</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Man</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>A.J.</td>\n",
       "      <td>4945</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/A.J.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Skye</td>\n",
       "      <td>14553</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Skye</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Carly</td>\n",
       "      <td>57668</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Carly</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Elizabeth</td>\n",
       "      <td>27388</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Eliza...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Jax</td>\n",
       "      <td>30135</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Jax</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Sonny</td>\n",
       "      <td>64994</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Sonny</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Alexis</td>\n",
       "      <td>29218</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Alexis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Mike</td>\n",
       "      <td>3168</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Mike</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Ned</td>\n",
       "      <td>5915</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Ned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Max</td>\n",
       "      <td>3610</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Max</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>717</th>\n",
       "      <td>717</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Chelsea</td>\n",
       "      <td>14146</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Chelsea...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>718</th>\n",
       "      <td>718</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Chad</td>\n",
       "      <td>4481</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Chad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>719</th>\n",
       "      <td>719</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Frankie</td>\n",
       "      <td>2482</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Frankie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>720</th>\n",
       "      <td>720</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Alex</td>\n",
       "      <td>2157</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Alex</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>721</th>\n",
       "      <td>721</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Carrie</td>\n",
       "      <td>5627</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Carrie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>722</th>\n",
       "      <td>722</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>E.J.</td>\n",
       "      <td>16323</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/E.J.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>723</th>\n",
       "      <td>723</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Kayla</td>\n",
       "      <td>8254</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Kayla_B...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>724</th>\n",
       "      <td>724</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Nick</td>\n",
       "      <td>6193</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Nick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>725</th>\n",
       "      <td>725</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Steve</td>\n",
       "      <td>7687</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Steve</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>726</th>\n",
       "      <td>726</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Stephanie</td>\n",
       "      <td>13513</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Stephanie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>727</th>\n",
       "      <td>727</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Anna</td>\n",
       "      <td>2071</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Anna_Di...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>728</th>\n",
       "      <td>728</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Willow</td>\n",
       "      <td>1351</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Willow_...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>729</th>\n",
       "      <td>729</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>EJ</td>\n",
       "      <td>14292</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/EJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>730</th>\n",
       "      <td>730</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Adrienne</td>\n",
       "      <td>1511</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Adrienne</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>731</th>\n",
       "      <td>731</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Jeremy</td>\n",
       "      <td>1129</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Jeremy_...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>732</th>\n",
       "      <td>732</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Morgan</td>\n",
       "      <td>1903</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Morgan_...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>733</th>\n",
       "      <td>733</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Justin</td>\n",
       "      <td>2087</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Justin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>734</th>\n",
       "      <td>734</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Ava</td>\n",
       "      <td>1930</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Ava_Vitali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>735</th>\n",
       "      <td>735</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Daniel</td>\n",
       "      <td>14751</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Daniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>736</th>\n",
       "      <td>736</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Melanie</td>\n",
       "      <td>15231</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Melanie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>737</th>\n",
       "      <td>737</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Rafe</td>\n",
       "      <td>15714</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Rafe_He...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>738</th>\n",
       "      <td>738</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Nathan</td>\n",
       "      <td>4074</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Nathan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>739</th>\n",
       "      <td>739</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Arianna</td>\n",
       "      <td>4966</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Arianna</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>740</th>\n",
       "      <td>740</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Carly</td>\n",
       "      <td>6878</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Carly_M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>741</th>\n",
       "      <td>741</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Vivian</td>\n",
       "      <td>4245</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Vivian</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>742</th>\n",
       "      <td>742</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Gabi</td>\n",
       "      <td>2775</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Gabi_He...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>743</th>\n",
       "      <td>743</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Taylor</td>\n",
       "      <td>3205</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Taylor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>744</th>\n",
       "      <td>744</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Dario</td>\n",
       "      <td>1070</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Dario_H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>745</th>\n",
       "      <td>745</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Quinn</td>\n",
       "      <td>1428</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Quinn_H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>746</th>\n",
       "      <td>746</td>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Sonny</td>\n",
       "      <td>1075</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Jackson...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>747 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Unnamed: 0               show       role  times  \\\n",
       "0             0   General Hospital       Luke  22941   \n",
       "1             1   General Hospital     Edward   7656   \n",
       "2             2   General Hospital     Bobbie   3890   \n",
       "3             3   General Hospital     Zander   5212   \n",
       "4             4   General Hospital      Scott   5886   \n",
       "5             5   General Hospital      Laura   4286   \n",
       "6             6   General Hospital     Helena   2446   \n",
       "7             7   General Hospital    Nikolas  27655   \n",
       "8             8   General Hospital        Gia   3499   \n",
       "9             9   General Hospital      Lucky  25944   \n",
       "10           10   General Hospital      Woman   1608   \n",
       "11           11   General Hospital       Alan   4622   \n",
       "12           12   General Hospital      Emily  17726   \n",
       "13           13   General Hospital     Monica   6506   \n",
       "14           14   General Hospital    Felicia   2778   \n",
       "15           15   General Hospital        Mac   6773   \n",
       "16           16   General Hospital    Taggert   1864   \n",
       "17           17   General Hospital     Stefan   1479   \n",
       "18           18   General Hospital        Roy   2321   \n",
       "19           19   General Hospital        Man   3312   \n",
       "20           20   General Hospital       A.J.   4945   \n",
       "21           21   General Hospital       Skye  14553   \n",
       "22           22   General Hospital      Carly  57668   \n",
       "23           23   General Hospital  Elizabeth  27388   \n",
       "24           24   General Hospital        Jax  30135   \n",
       "25           25   General Hospital      Sonny  64994   \n",
       "26           26   General Hospital     Alexis  29218   \n",
       "27           27   General Hospital       Mike   3168   \n",
       "28           28   General Hospital        Ned   5915   \n",
       "29           29   General Hospital        Max   3610   \n",
       "..          ...                ...        ...    ...   \n",
       "717         717  Days of Our Lives    Chelsea  14146   \n",
       "718         718  Days of Our Lives       Chad   4481   \n",
       "719         719  Days of Our Lives    Frankie   2482   \n",
       "720         720  Days of Our Lives       Alex   2157   \n",
       "721         721  Days of Our Lives     Carrie   5627   \n",
       "722         722  Days of Our Lives       E.J.  16323   \n",
       "723         723  Days of Our Lives      Kayla   8254   \n",
       "724         724  Days of Our Lives       Nick   6193   \n",
       "725         725  Days of Our Lives      Steve   7687   \n",
       "726         726  Days of Our Lives  Stephanie  13513   \n",
       "727         727  Days of Our Lives       Anna   2071   \n",
       "728         728  Days of Our Lives     Willow   1351   \n",
       "729         729  Days of Our Lives         EJ  14292   \n",
       "730         730  Days of Our Lives   Adrienne   1511   \n",
       "731         731  Days of Our Lives     Jeremy   1129   \n",
       "732         732  Days of Our Lives     Morgan   1903   \n",
       "733         733  Days of Our Lives     Justin   2087   \n",
       "734         734  Days of Our Lives        Ava   1930   \n",
       "735         735  Days of Our Lives     Daniel  14751   \n",
       "736         736  Days of Our Lives    Melanie  15231   \n",
       "737         737  Days of Our Lives       Rafe  15714   \n",
       "738         738  Days of Our Lives     Nathan   4074   \n",
       "739         739  Days of Our Lives    Arianna   4966   \n",
       "740         740  Days of Our Lives      Carly   6878   \n",
       "741         741  Days of Our Lives     Vivian   4245   \n",
       "742         742  Days of Our Lives       Gabi   2775   \n",
       "743         743  Days of Our Lives     Taylor   3205   \n",
       "744         744  Days of Our Lives      Dario   1070   \n",
       "745         745  Days of Our Lives      Quinn   1428   \n",
       "746         746  Days of Our Lives      Sonny   1075   \n",
       "\n",
       "                                                   url  \n",
       "0    https://general-hospital.fandom.com/wiki/Luke_...  \n",
       "1      https://general-hospital.fandom.com/wiki/Edward  \n",
       "2      https://general-hospital.fandom.com/wiki/Bobbie  \n",
       "3    https://general-hospital.fandom.com/wiki/Zande...  \n",
       "4       https://general-hospital.fandom.com/wiki/Scott  \n",
       "5       https://general-hospital.fandom.com/wiki/Laura  \n",
       "6      https://general-hospital.fandom.com/wiki/Helena  \n",
       "7     https://general-hospital.fandom.com/wiki/Nikolas  \n",
       "8         https://general-hospital.fandom.com/wiki/Gia  \n",
       "9       https://general-hospital.fandom.com/wiki/Lucky  \n",
       "10      https://general-hospital.fandom.com/wiki/Woman  \n",
       "11       https://general-hospital.fandom.com/wiki/Alan  \n",
       "12      https://general-hospital.fandom.com/wiki/Emily  \n",
       "13     https://general-hospital.fandom.com/wiki/Monica  \n",
       "14    https://general-hospital.fandom.com/wiki/Felicia  \n",
       "15        https://general-hospital.fandom.com/wiki/Mac  \n",
       "16    https://general-hospital.fandom.com/wiki/Taggert  \n",
       "17     https://general-hospital.fandom.com/wiki/Stefan  \n",
       "18   https://general-hospital.fandom.com/wiki/Roy_D...  \n",
       "19        https://general-hospital.fandom.com/wiki/Man  \n",
       "20       https://general-hospital.fandom.com/wiki/A.J.  \n",
       "21       https://general-hospital.fandom.com/wiki/Skye  \n",
       "22      https://general-hospital.fandom.com/wiki/Carly  \n",
       "23   https://general-hospital.fandom.com/wiki/Eliza...  \n",
       "24        https://general-hospital.fandom.com/wiki/Jax  \n",
       "25      https://general-hospital.fandom.com/wiki/Sonny  \n",
       "26     https://general-hospital.fandom.com/wiki/Alexis  \n",
       "27       https://general-hospital.fandom.com/wiki/Mike  \n",
       "28        https://general-hospital.fandom.com/wiki/Ned  \n",
       "29        https://general-hospital.fandom.com/wiki/Max  \n",
       "..                                                 ...  \n",
       "717  https://daysofourlives.fandom.com/wiki/Chelsea...  \n",
       "718        https://daysofourlives.fandom.com/wiki/Chad  \n",
       "719     https://daysofourlives.fandom.com/wiki/Frankie  \n",
       "720        https://daysofourlives.fandom.com/wiki/Alex  \n",
       "721      https://daysofourlives.fandom.com/wiki/Carrie  \n",
       "722        https://daysofourlives.fandom.com/wiki/E.J.  \n",
       "723  https://daysofourlives.fandom.com/wiki/Kayla_B...  \n",
       "724        https://daysofourlives.fandom.com/wiki/Nick  \n",
       "725       https://daysofourlives.fandom.com/wiki/Steve  \n",
       "726   https://daysofourlives.fandom.com/wiki/Stephanie  \n",
       "727  https://daysofourlives.fandom.com/wiki/Anna_Di...  \n",
       "728  https://daysofourlives.fandom.com/wiki/Willow_...  \n",
       "729          https://daysofourlives.fandom.com/wiki/EJ  \n",
       "730    https://daysofourlives.fandom.com/wiki/Adrienne  \n",
       "731  https://daysofourlives.fandom.com/wiki/Jeremy_...  \n",
       "732  https://daysofourlives.fandom.com/wiki/Morgan_...  \n",
       "733      https://daysofourlives.fandom.com/wiki/Justin  \n",
       "734  https://daysofourlives.fandom.com/wiki/Ava_Vitali  \n",
       "735      https://daysofourlives.fandom.com/wiki/Daniel  \n",
       "736     https://daysofourlives.fandom.com/wiki/Melanie  \n",
       "737  https://daysofourlives.fandom.com/wiki/Rafe_He...  \n",
       "738      https://daysofourlives.fandom.com/wiki/Nathan  \n",
       "739     https://daysofourlives.fandom.com/wiki/Arianna  \n",
       "740  https://daysofourlives.fandom.com/wiki/Carly_M...  \n",
       "741      https://daysofourlives.fandom.com/wiki/Vivian  \n",
       "742  https://daysofourlives.fandom.com/wiki/Gabi_He...  \n",
       "743      https://daysofourlives.fandom.com/wiki/Taylor  \n",
       "744  https://daysofourlives.fandom.com/wiki/Dario_H...  \n",
       "745  https://daysofourlives.fandom.com/wiki/Quinn_H...  \n",
       "746  https://daysofourlives.fandom.com/wiki/Jackson...  \n",
       "\n",
       "[747 rows x 5 columns]"
      ]
     },
     "execution_count": 173,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "namedf1[namedf1['url']!=0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 174,
   "metadata": {},
   "outputs": [],
   "source": [
    "namedf1.to_excel(\"namedf1.xlsx\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>show</th>\n",
       "      <th>role</th>\n",
       "      <th>times</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Luke</td>\n",
       "      <td>22941</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Luke_...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Edward</td>\n",
       "      <td>7656</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Edward</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Bobbie</td>\n",
       "      <td>3890</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Bobbie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Zander</td>\n",
       "      <td>5212</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Zande...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Scott</td>\n",
       "      <td>5886</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Scott</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Laura</td>\n",
       "      <td>4286</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Laura</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Helena</td>\n",
       "      <td>2446</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Helena</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Nikolas</td>\n",
       "      <td>27655</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Nikolas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Gia</td>\n",
       "      <td>3499</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Gia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Lucky</td>\n",
       "      <td>25944</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Lucky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Woman</td>\n",
       "      <td>1608</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Woman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Alan</td>\n",
       "      <td>4622</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Alan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Emily</td>\n",
       "      <td>17726</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Emily</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Monica</td>\n",
       "      <td>6506</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Monica</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Felicia</td>\n",
       "      <td>2778</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Felicia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Mac</td>\n",
       "      <td>6773</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Mac</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Taggert</td>\n",
       "      <td>1864</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Taggert</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Stefan</td>\n",
       "      <td>1479</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Stefan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Roy</td>\n",
       "      <td>2321</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Roy_D...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Man</td>\n",
       "      <td>3312</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Man</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>A.J.</td>\n",
       "      <td>4945</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/A.J.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Skye</td>\n",
       "      <td>14553</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Skye</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Carly</td>\n",
       "      <td>57668</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Carly</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Elizabeth</td>\n",
       "      <td>27388</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Eliza...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Jax</td>\n",
       "      <td>30135</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Jax</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Sonny</td>\n",
       "      <td>64994</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Sonny</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Alexis</td>\n",
       "      <td>29218</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Alexis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Mike</td>\n",
       "      <td>3168</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Mike</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Ned</td>\n",
       "      <td>5915</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Ned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>General Hospital</td>\n",
       "      <td>Max</td>\n",
       "      <td>3610</td>\n",
       "      <td>https://general-hospital.fandom.com/wiki/Max</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>717</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Chelsea</td>\n",
       "      <td>14146</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Chelsea...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>718</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Chad</td>\n",
       "      <td>4481</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Chad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>719</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Frankie</td>\n",
       "      <td>2482</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Frankie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>720</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Alex</td>\n",
       "      <td>2157</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Alex</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>721</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Carrie</td>\n",
       "      <td>5627</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Carrie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>722</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>E.J.</td>\n",
       "      <td>16323</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/E.J.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>723</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Kayla</td>\n",
       "      <td>8254</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Kayla_B...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>724</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Nick</td>\n",
       "      <td>6193</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Nick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>725</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Steve</td>\n",
       "      <td>7687</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Steve</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>726</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Stephanie</td>\n",
       "      <td>13513</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Stephanie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>727</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Anna</td>\n",
       "      <td>2071</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Anna_Di...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>728</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Willow</td>\n",
       "      <td>1351</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Willow_...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>729</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>EJ</td>\n",
       "      <td>14292</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/EJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>730</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Adrienne</td>\n",
       "      <td>1511</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Adrienne</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>731</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Jeremy</td>\n",
       "      <td>1129</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Jeremy_...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>732</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Morgan</td>\n",
       "      <td>1903</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Morgan_...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>733</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Justin</td>\n",
       "      <td>2087</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Justin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>734</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Ava</td>\n",
       "      <td>1930</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Ava_Vitali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>735</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Daniel</td>\n",
       "      <td>14751</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Daniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>736</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Melanie</td>\n",
       "      <td>15231</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Melanie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>737</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Rafe</td>\n",
       "      <td>15714</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Rafe_He...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>738</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Nathan</td>\n",
       "      <td>4074</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Nathan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>739</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Arianna</td>\n",
       "      <td>4966</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Arianna</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>740</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Carly</td>\n",
       "      <td>6878</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Carly_M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>741</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Vivian</td>\n",
       "      <td>4245</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Vivian</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>742</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Gabi</td>\n",
       "      <td>2775</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Gabi_He...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>743</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Taylor</td>\n",
       "      <td>3205</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Taylor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>744</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Dario</td>\n",
       "      <td>1070</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Dario_H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>745</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Quinn</td>\n",
       "      <td>1428</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Quinn_H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>746</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Sonny</td>\n",
       "      <td>1075</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Jackson...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>747 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  show       role  times  \\\n",
       "0     General Hospital       Luke  22941   \n",
       "1     General Hospital     Edward   7656   \n",
       "2     General Hospital     Bobbie   3890   \n",
       "3     General Hospital     Zander   5212   \n",
       "4     General Hospital      Scott   5886   \n",
       "5     General Hospital      Laura   4286   \n",
       "6     General Hospital     Helena   2446   \n",
       "7     General Hospital    Nikolas  27655   \n",
       "8     General Hospital        Gia   3499   \n",
       "9     General Hospital      Lucky  25944   \n",
       "10    General Hospital      Woman   1608   \n",
       "11    General Hospital       Alan   4622   \n",
       "12    General Hospital      Emily  17726   \n",
       "13    General Hospital     Monica   6506   \n",
       "14    General Hospital    Felicia   2778   \n",
       "15    General Hospital        Mac   6773   \n",
       "16    General Hospital    Taggert   1864   \n",
       "17    General Hospital     Stefan   1479   \n",
       "18    General Hospital        Roy   2321   \n",
       "19    General Hospital        Man   3312   \n",
       "20    General Hospital       A.J.   4945   \n",
       "21    General Hospital       Skye  14553   \n",
       "22    General Hospital      Carly  57668   \n",
       "23    General Hospital  Elizabeth  27388   \n",
       "24    General Hospital        Jax  30135   \n",
       "25    General Hospital      Sonny  64994   \n",
       "26    General Hospital     Alexis  29218   \n",
       "27    General Hospital       Mike   3168   \n",
       "28    General Hospital        Ned   5915   \n",
       "29    General Hospital        Max   3610   \n",
       "..                 ...        ...    ...   \n",
       "717  Days of Our Lives    Chelsea  14146   \n",
       "718  Days of Our Lives       Chad   4481   \n",
       "719  Days of Our Lives    Frankie   2482   \n",
       "720  Days of Our Lives       Alex   2157   \n",
       "721  Days of Our Lives     Carrie   5627   \n",
       "722  Days of Our Lives       E.J.  16323   \n",
       "723  Days of Our Lives      Kayla   8254   \n",
       "724  Days of Our Lives       Nick   6193   \n",
       "725  Days of Our Lives      Steve   7687   \n",
       "726  Days of Our Lives  Stephanie  13513   \n",
       "727  Days of Our Lives       Anna   2071   \n",
       "728  Days of Our Lives     Willow   1351   \n",
       "729  Days of Our Lives         EJ  14292   \n",
       "730  Days of Our Lives   Adrienne   1511   \n",
       "731  Days of Our Lives     Jeremy   1129   \n",
       "732  Days of Our Lives     Morgan   1903   \n",
       "733  Days of Our Lives     Justin   2087   \n",
       "734  Days of Our Lives        Ava   1930   \n",
       "735  Days of Our Lives     Daniel  14751   \n",
       "736  Days of Our Lives    Melanie  15231   \n",
       "737  Days of Our Lives       Rafe  15714   \n",
       "738  Days of Our Lives     Nathan   4074   \n",
       "739  Days of Our Lives    Arianna   4966   \n",
       "740  Days of Our Lives      Carly   6878   \n",
       "741  Days of Our Lives     Vivian   4245   \n",
       "742  Days of Our Lives       Gabi   2775   \n",
       "743  Days of Our Lives     Taylor   3205   \n",
       "744  Days of Our Lives      Dario   1070   \n",
       "745  Days of Our Lives      Quinn   1428   \n",
       "746  Days of Our Lives      Sonny   1075   \n",
       "\n",
       "                                                   url  \n",
       "0    https://general-hospital.fandom.com/wiki/Luke_...  \n",
       "1      https://general-hospital.fandom.com/wiki/Edward  \n",
       "2      https://general-hospital.fandom.com/wiki/Bobbie  \n",
       "3    https://general-hospital.fandom.com/wiki/Zande...  \n",
       "4       https://general-hospital.fandom.com/wiki/Scott  \n",
       "5       https://general-hospital.fandom.com/wiki/Laura  \n",
       "6      https://general-hospital.fandom.com/wiki/Helena  \n",
       "7     https://general-hospital.fandom.com/wiki/Nikolas  \n",
       "8         https://general-hospital.fandom.com/wiki/Gia  \n",
       "9       https://general-hospital.fandom.com/wiki/Lucky  \n",
       "10      https://general-hospital.fandom.com/wiki/Woman  \n",
       "11       https://general-hospital.fandom.com/wiki/Alan  \n",
       "12      https://general-hospital.fandom.com/wiki/Emily  \n",
       "13     https://general-hospital.fandom.com/wiki/Monica  \n",
       "14    https://general-hospital.fandom.com/wiki/Felicia  \n",
       "15        https://general-hospital.fandom.com/wiki/Mac  \n",
       "16    https://general-hospital.fandom.com/wiki/Taggert  \n",
       "17     https://general-hospital.fandom.com/wiki/Stefan  \n",
       "18   https://general-hospital.fandom.com/wiki/Roy_D...  \n",
       "19        https://general-hospital.fandom.com/wiki/Man  \n",
       "20       https://general-hospital.fandom.com/wiki/A.J.  \n",
       "21       https://general-hospital.fandom.com/wiki/Skye  \n",
       "22      https://general-hospital.fandom.com/wiki/Carly  \n",
       "23   https://general-hospital.fandom.com/wiki/Eliza...  \n",
       "24        https://general-hospital.fandom.com/wiki/Jax  \n",
       "25      https://general-hospital.fandom.com/wiki/Sonny  \n",
       "26     https://general-hospital.fandom.com/wiki/Alexis  \n",
       "27       https://general-hospital.fandom.com/wiki/Mike  \n",
       "28        https://general-hospital.fandom.com/wiki/Ned  \n",
       "29        https://general-hospital.fandom.com/wiki/Max  \n",
       "..                                                 ...  \n",
       "717  https://daysofourlives.fandom.com/wiki/Chelsea...  \n",
       "718        https://daysofourlives.fandom.com/wiki/Chad  \n",
       "719     https://daysofourlives.fandom.com/wiki/Frankie  \n",
       "720        https://daysofourlives.fandom.com/wiki/Alex  \n",
       "721      https://daysofourlives.fandom.com/wiki/Carrie  \n",
       "722        https://daysofourlives.fandom.com/wiki/E.J.  \n",
       "723  https://daysofourlives.fandom.com/wiki/Kayla_B...  \n",
       "724        https://daysofourlives.fandom.com/wiki/Nick  \n",
       "725       https://daysofourlives.fandom.com/wiki/Steve  \n",
       "726   https://daysofourlives.fandom.com/wiki/Stephanie  \n",
       "727  https://daysofourlives.fandom.com/wiki/Anna_Di...  \n",
       "728  https://daysofourlives.fandom.com/wiki/Willow_...  \n",
       "729          https://daysofourlives.fandom.com/wiki/EJ  \n",
       "730    https://daysofourlives.fandom.com/wiki/Adrienne  \n",
       "731  https://daysofourlives.fandom.com/wiki/Jeremy_...  \n",
       "732  https://daysofourlives.fandom.com/wiki/Morgan_...  \n",
       "733      https://daysofourlives.fandom.com/wiki/Justin  \n",
       "734  https://daysofourlives.fandom.com/wiki/Ava_Vitali  \n",
       "735      https://daysofourlives.fandom.com/wiki/Daniel  \n",
       "736     https://daysofourlives.fandom.com/wiki/Melanie  \n",
       "737  https://daysofourlives.fandom.com/wiki/Rafe_He...  \n",
       "738      https://daysofourlives.fandom.com/wiki/Nathan  \n",
       "739     https://daysofourlives.fandom.com/wiki/Arianna  \n",
       "740  https://daysofourlives.fandom.com/wiki/Carly_M...  \n",
       "741      https://daysofourlives.fandom.com/wiki/Vivian  \n",
       "742  https://daysofourlives.fandom.com/wiki/Gabi_He...  \n",
       "743      https://daysofourlives.fandom.com/wiki/Taylor  \n",
       "744  https://daysofourlives.fandom.com/wiki/Dario_H...  \n",
       "745  https://daysofourlives.fandom.com/wiki/Quinn_H...  \n",
       "746  https://daysofourlives.fandom.com/wiki/Jackson...  \n",
       "\n",
       "[747 rows x 4 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "namedf1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Exception ignored in: <function Service.__del__ at 0x000001D607564D90>\n",
      "Traceback (most recent call last):\n",
      "  File \"E:\\software\\Anaconda\\lib\\site-packages\\selenium\\webdriver\\common\\service.py\", line 163, in __del__\n",
      "    self.stop()\n",
      "  File \"E:\\software\\Anaconda\\lib\\site-packages\\selenium\\webdriver\\common\\service.py\", line 135, in stop\n",
      "    if self.process is None:\n",
      "AttributeError: 'Service' object has no attribute 'process'\n",
      "E:\\software\\Anaconda\\lib\\site-packages\\ipykernel_launcher.py:25: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2\n",
      "3\n",
      "4\n",
      "5\n",
      "6\n",
      "7\n",
      "8\n",
      "9\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "E:\\software\\Anaconda\\lib\\site-packages\\ipykernel_launcher.py:19: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "10\n",
      "11\n",
      "12\n",
      "13\n",
      "14\n",
      "15\n",
      "16\n",
      "17\n",
      "18\n",
      "19\n",
      "20\n",
      "21\n",
      "22\n",
      "23\n",
      "24\n",
      "25\n",
      "26\n",
      "27\n",
      "28\n",
      "29\n",
      "30\n",
      "31\n",
      "32\n",
      "33\n",
      "34\n",
      "35\n",
      "36\n",
      "37\n",
      "38\n",
      "39\n",
      "40\n",
      "41\n",
      "42\n",
      "43\n",
      "44\n",
      "45\n",
      "46\n",
      "47\n",
      "48\n",
      "49\n",
      "50\n",
      "51\n",
      "52\n",
      "53\n",
      "54\n",
      "55\n",
      "56\n",
      "57\n",
      "58\n",
      "59\n",
      "60\n",
      "61\n",
      "62\n",
      "63\n",
      "64\n",
      "65\n",
      "66\n",
      "67\n",
      "68\n",
      "69\n",
      "70\n",
      "71\n",
      "72\n",
      "73\n",
      "74\n",
      "75\n",
      "76\n",
      "77\n",
      "78\n",
      "79\n",
      "80\n",
      "81\n",
      "82\n",
      "83\n",
      "84\n",
      "85\n",
      "86\n",
      "87\n",
      "88\n",
      "89\n",
      "90\n",
      "91\n",
      "92\n",
      "93\n",
      "94\n",
      "95\n",
      "96\n",
      "97\n",
      "98\n",
      "99\n",
      "100\n",
      "101\n",
      "102\n",
      "103\n",
      "104\n",
      "105\n",
      "106\n",
      "107\n",
      "108\n",
      "109\n",
      "110\n",
      "111\n",
      "112\n",
      "113\n",
      "114\n",
      "115\n",
      "116\n",
      "117\n",
      "118\n",
      "119\n",
      "120\n",
      "121\n",
      "122\n",
      "123\n",
      "124\n",
      "125\n",
      "126\n",
      "127\n",
      "128\n",
      "129\n",
      "130\n",
      "131\n",
      "132\n",
      "133\n",
      "134\n",
      "135\n",
      "136\n",
      "137\n",
      "138\n",
      "139\n",
      "140\n",
      "141\n",
      "142\n",
      "143\n",
      "144\n",
      "145\n",
      "146\n",
      "147\n",
      "148\n",
      "149\n",
      "150\n",
      "151\n",
      "152\n",
      "153\n",
      "154\n",
      "155\n",
      "156\n",
      "157\n",
      "158\n",
      "159\n",
      "160\n",
      "161\n",
      "162\n",
      "163\n",
      "164\n",
      "165\n",
      "166\n",
      "167\n",
      "168\n",
      "169\n",
      "170\n",
      "171\n",
      "172\n",
      "173\n",
      "174\n",
      "175\n",
      "176\n",
      "177\n",
      "178\n",
      "179\n",
      "180\n",
      "181\n",
      "182\n",
      "183\n",
      "184\n",
      "185\n",
      "186\n",
      "187\n",
      "188\n",
      "189\n",
      "190\n",
      "191\n",
      "192\n",
      "193\n",
      "194\n",
      "195\n",
      "196\n",
      "197\n",
      "198\n",
      "199\n",
      "200\n",
      "201\n",
      "202\n",
      "203\n",
      "204\n",
      "205\n",
      "206\n",
      "207\n",
      "208\n",
      "209\n",
      "210\n",
      "211\n",
      "212\n",
      "213\n",
      "214\n",
      "215\n",
      "216\n",
      "217\n",
      "218\n",
      "219\n",
      "220\n",
      "221\n",
      "222\n",
      "223\n",
      "224\n",
      "225\n",
      "226\n",
      "227\n",
      "228\n",
      "229\n",
      "230\n",
      "231\n",
      "232\n",
      "233\n",
      "234\n",
      "235\n",
      "236\n",
      "237\n",
      "238\n",
      "239\n",
      "240\n",
      "241\n",
      "242\n",
      "243\n",
      "244\n",
      "245\n",
      "246\n",
      "247\n",
      "248\n",
      "249\n",
      "250\n",
      "251\n",
      "252\n",
      "253\n",
      "254\n",
      "255\n",
      "256\n",
      "257\n",
      "258\n",
      "259\n",
      "260\n",
      "261\n",
      "262\n",
      "263\n",
      "264\n",
      "265\n",
      "266\n",
      "267\n",
      "268\n",
      "269\n",
      "270\n",
      "271\n",
      "272\n",
      "273\n",
      "274\n",
      "275\n",
      "276\n",
      "277\n",
      "278\n",
      "279\n",
      "280\n",
      "281\n",
      "282\n",
      "283\n",
      "284\n",
      "285\n",
      "286\n",
      "287\n"
     ]
    }
   ],
   "source": [
    "number=0\n",
    "tnumber=0\n",
    "for item in range(460,len(namedf1)):\n",
    "    tnumber+=1\n",
    "    print(tnumber)\n",
    "    url=str(namedf1['url'][item])\n",
    "    url=url.replace(\"port-charles\",'general-hospital')\n",
    "    if len(re.findall('/wiki/(.*)',namedf1['url'][item]))<12:\n",
    "        options = webdriver.ChromeOptions()\n",
    "        ua = UserAgent()\n",
    "        options.add_argument('headless')\n",
    "        driver=webdriver.Chrome(chrome_options=options)\n",
    "        driver.get(url)\n",
    "        time.sleep(np.random.randint(3))\n",
    "        try:\n",
    "            driver.find_element_by_css_selector(\"span[class='alternative-suggestion']\").click()\n",
    "            time.sleep(1)\n",
    "            roleurl=driver.current_url\n",
    "            namedf1['url'][item]=roleurl\n",
    "            driver.quit()\n",
    "            time.sleep(1)\n",
    "            number+=1\n",
    "        except:\n",
    "            roleurl=driver.current_url\n",
    "            namedf1['url'][item]=roleurl\n",
    "            driver.quit()\n",
    "            continue\n",
    "    else:\n",
    "        continue"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "namedf1.to_excel(\"namedf1.xlsx\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "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>show</th>\n",
       "      <th>role</th>\n",
       "      <th>times</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>600</th>\n",
       "      <td>As the World Turns</td>\n",
       "      <td>B.J.</td>\n",
       "      <td>1149</td>\n",
       "      <td>https://cbsastheworldturns.fandom.com/wiki/B.J.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601</th>\n",
       "      <td>As the World Turns</td>\n",
       "      <td>Sage</td>\n",
       "      <td>1701</td>\n",
       "      <td>https://cbsastheworldturns.fandom.com/wiki/Sag...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>602</th>\n",
       "      <td>As the World Turns</td>\n",
       "      <td>Jade</td>\n",
       "      <td>5196</td>\n",
       "      <td>https://cbsastheworldturns.fandom.com/wiki/Jade</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603</th>\n",
       "      <td>As the World Turns</td>\n",
       "      <td>Vienna</td>\n",
       "      <td>7482</td>\n",
       "      <td>https://cbsastheworldturns.fandom.com/wiki/Vienna</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>604</th>\n",
       "      <td>As the World Turns</td>\n",
       "      <td>Dallas</td>\n",
       "      <td>1124</td>\n",
       "      <td>https://cbsastheworldturns.fandom.com/wiki/Dallas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>605</th>\n",
       "      <td>As the World Turns</td>\n",
       "      <td>Cleo</td>\n",
       "      <td>1232</td>\n",
       "      <td>https://cbsastheworldturns.fandom.com/wiki/Cleo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>606</th>\n",
       "      <td>As the World Turns</td>\n",
       "      <td>Noah</td>\n",
       "      <td>6122</td>\n",
       "      <td>https://cbsastheworldturns.fandom.com/wiki/Noa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>607</th>\n",
       "      <td>As the World Turns</td>\n",
       "      <td>Sofie</td>\n",
       "      <td>2437</td>\n",
       "      <td>https://cbsastheworldturns.fandom.com/wiki/Sofie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>608</th>\n",
       "      <td>As the World Turns</td>\n",
       "      <td>Audrey</td>\n",
       "      <td>1112</td>\n",
       "      <td>https://cbsastheworldturns.fandom.com/wiki/Aud...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>609</th>\n",
       "      <td>As the World Turns</td>\n",
       "      <td>Liberty</td>\n",
       "      <td>6892</td>\n",
       "      <td>https://cbsastheworldturns.fandom.com/wiki/Lib...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>610</th>\n",
       "      <td>As the World Turns</td>\n",
       "      <td>Josie</td>\n",
       "      <td>1441</td>\n",
       "      <td>https://cbsastheworldturns.fandom.com/wiki/Josie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>611</th>\n",
       "      <td>As the World Turns</td>\n",
       "      <td>Teri</td>\n",
       "      <td>1531</td>\n",
       "      <td>https://cbsastheworldturns.fandom.com/wiki/Teri</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>612</th>\n",
       "      <td>As the World Turns</td>\n",
       "      <td>Mick</td>\n",
       "      <td>1271</td>\n",
       "      <td>https://cbsastheworldturns.fandom.com/wiki/Mick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>613</th>\n",
       "      <td>As the World Turns</td>\n",
       "      <td>Gabriel</td>\n",
       "      <td>1113</td>\n",
       "      <td>https://cbsastheworldturns.fandom.com/wiki/Gab...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>614</th>\n",
       "      <td>Bold and Beautiful</td>\n",
       "      <td>Eric</td>\n",
       "      <td>18465</td>\n",
       "      <td>https://theboldandthebeautiful.fandom.com/wiki...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>615</th>\n",
       "      <td>Bold and Beautiful</td>\n",
       "      <td>Deacon</td>\n",
       "      <td>7710</td>\n",
       "      <td>https://theboldandthebeautiful.fandom.com/wiki...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>616</th>\n",
       "      <td>Bold and Beautiful</td>\n",
       "      <td>Thorne</td>\n",
       "      <td>8483</td>\n",
       "      <td>https://theboldandthebeautiful.fandom.com/wiki...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>617</th>\n",
       "      <td>Bold and Beautiful</td>\n",
       "      <td>Bridget</td>\n",
       "      <td>21025</td>\n",
       "      <td>https://theboldandthebeautiful.fandom.com/wiki...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>618</th>\n",
       "      <td>Bold and Beautiful</td>\n",
       "      <td>Ridge</td>\n",
       "      <td>35379</td>\n",
       "      <td>https://theboldandthebeautiful.fandom.com/wiki...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>619</th>\n",
       "      <td>Bold and Beautiful</td>\n",
       "      <td>Thomas</td>\n",
       "      <td>8792</td>\n",
       "      <td>https://theboldandthebeautiful.fandom.com/wiki...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>620</th>\n",
       "      <td>Bold and Beautiful</td>\n",
       "      <td>Amber</td>\n",
       "      <td>9912</td>\n",
       "      <td>https://theboldandthebeautiful.fandom.com/wiki...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>621</th>\n",
       "      <td>Bold and Beautiful</td>\n",
       "      <td>Megan</td>\n",
       "      <td>1243</td>\n",
       "      <td>https://theboldandthebeautiful.fandom.com/wiki...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>622</th>\n",
       "      <td>Bold and Beautiful</td>\n",
       "      <td>Brooke</td>\n",
       "      <td>45730</td>\n",
       "      <td>https://theboldandthebeautiful.fandom.com/wiki...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>623</th>\n",
       "      <td>Bold and Beautiful</td>\n",
       "      <td>Taylor</td>\n",
       "      <td>18486</td>\n",
       "      <td>https://theboldandthebeautiful.fandom.com/wiki...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>624</th>\n",
       "      <td>Bold and Beautiful</td>\n",
       "      <td>Stephanie</td>\n",
       "      <td>30594</td>\n",
       "      <td>https://theboldandthebeautiful.fandom.com/wiki...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>625</th>\n",
       "      <td>Bold and Beautiful</td>\n",
       "      <td>Rick</td>\n",
       "      <td>14842</td>\n",
       "      <td>https://theboldandthebeautiful.fandom.com/wiki...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>626</th>\n",
       "      <td>Bold and Beautiful</td>\n",
       "      <td>Steffy</td>\n",
       "      <td>13365</td>\n",
       "      <td>https://theboldandthebeautiful.fandom.com/wiki...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>627</th>\n",
       "      <td>Bold and Beautiful</td>\n",
       "      <td>Sally</td>\n",
       "      <td>4100</td>\n",
       "      <td>https://theboldandthebeautiful.fandom.com/wiki...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>628</th>\n",
       "      <td>Bold and Beautiful</td>\n",
       "      <td>Clarke</td>\n",
       "      <td>2219</td>\n",
       "      <td>https://theboldandthebeautiful.fandom.com/wiki...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>629</th>\n",
       "      <td>Bold and Beautiful</td>\n",
       "      <td>Darla</td>\n",
       "      <td>2772</td>\n",
       "      <td>https://theboldandthebeautiful.fandom.com/wiki...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>717</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Chelsea</td>\n",
       "      <td>14146</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Chelsea...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>718</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Chad</td>\n",
       "      <td>4481</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Chad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>719</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Frankie</td>\n",
       "      <td>2482</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Frankie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>720</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Alex</td>\n",
       "      <td>2157</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Alex</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>721</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Carrie</td>\n",
       "      <td>5627</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Carrie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>722</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>E.J.</td>\n",
       "      <td>16323</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/E.J.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>723</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Kayla</td>\n",
       "      <td>8254</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Kayla_B...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>724</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Nick</td>\n",
       "      <td>6193</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Nick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>725</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Steve</td>\n",
       "      <td>7687</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Steve</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>726</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Stephanie</td>\n",
       "      <td>13513</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Stephanie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>727</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Anna</td>\n",
       "      <td>2071</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Anna_Di...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>728</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Willow</td>\n",
       "      <td>1351</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Willow_...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>729</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>EJ</td>\n",
       "      <td>14292</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/EJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>730</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Adrienne</td>\n",
       "      <td>1511</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Adrienne</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>731</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Jeremy</td>\n",
       "      <td>1129</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Jeremy_...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>732</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Morgan</td>\n",
       "      <td>1903</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Morgan_...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>733</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Justin</td>\n",
       "      <td>2087</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Justin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>734</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Ava</td>\n",
       "      <td>1930</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Ava_Vitali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>735</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Daniel</td>\n",
       "      <td>14751</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Daniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>736</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Melanie</td>\n",
       "      <td>15231</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Melanie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>737</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Rafe</td>\n",
       "      <td>15714</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Rafe_He...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>738</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Nathan</td>\n",
       "      <td>4074</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Nathan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>739</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Arianna</td>\n",
       "      <td>4966</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Arianna</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>740</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Carly</td>\n",
       "      <td>6878</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Carly_M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>741</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Vivian</td>\n",
       "      <td>4245</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Vivian</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>742</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Gabi</td>\n",
       "      <td>2775</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Gabi_He...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>743</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Taylor</td>\n",
       "      <td>3205</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Taylor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>744</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Dario</td>\n",
       "      <td>1070</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Dario_H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>745</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Quinn</td>\n",
       "      <td>1428</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Quinn_H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>746</th>\n",
       "      <td>Days of Our Lives</td>\n",
       "      <td>Sonny</td>\n",
       "      <td>1075</td>\n",
       "      <td>https://daysofourlives.fandom.com/wiki/Jackson...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>147 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   show       role  times  \\\n",
       "600  As the World Turns       B.J.   1149   \n",
       "601  As the World Turns       Sage   1701   \n",
       "602  As the World Turns       Jade   5196   \n",
       "603  As the World Turns     Vienna   7482   \n",
       "604  As the World Turns     Dallas   1124   \n",
       "605  As the World Turns       Cleo   1232   \n",
       "606  As the World Turns       Noah   6122   \n",
       "607  As the World Turns      Sofie   2437   \n",
       "608  As the World Turns     Audrey   1112   \n",
       "609  As the World Turns    Liberty   6892   \n",
       "610  As the World Turns      Josie   1441   \n",
       "611  As the World Turns       Teri   1531   \n",
       "612  As the World Turns       Mick   1271   \n",
       "613  As the World Turns    Gabriel   1113   \n",
       "614  Bold and Beautiful       Eric  18465   \n",
       "615  Bold and Beautiful     Deacon   7710   \n",
       "616  Bold and Beautiful     Thorne   8483   \n",
       "617  Bold and Beautiful    Bridget  21025   \n",
       "618  Bold and Beautiful      Ridge  35379   \n",
       "619  Bold and Beautiful     Thomas   8792   \n",
       "620  Bold and Beautiful      Amber   9912   \n",
       "621  Bold and Beautiful      Megan   1243   \n",
       "622  Bold and Beautiful     Brooke  45730   \n",
       "623  Bold and Beautiful     Taylor  18486   \n",
       "624  Bold and Beautiful  Stephanie  30594   \n",
       "625  Bold and Beautiful       Rick  14842   \n",
       "626  Bold and Beautiful     Steffy  13365   \n",
       "627  Bold and Beautiful      Sally   4100   \n",
       "628  Bold and Beautiful     Clarke   2219   \n",
       "629  Bold and Beautiful      Darla   2772   \n",
       "..                  ...        ...    ...   \n",
       "717   Days of Our Lives    Chelsea  14146   \n",
       "718   Days of Our Lives       Chad   4481   \n",
       "719   Days of Our Lives    Frankie   2482   \n",
       "720   Days of Our Lives       Alex   2157   \n",
       "721   Days of Our Lives     Carrie   5627   \n",
       "722   Days of Our Lives       E.J.  16323   \n",
       "723   Days of Our Lives      Kayla   8254   \n",
       "724   Days of Our Lives       Nick   6193   \n",
       "725   Days of Our Lives      Steve   7687   \n",
       "726   Days of Our Lives  Stephanie  13513   \n",
       "727   Days of Our Lives       Anna   2071   \n",
       "728   Days of Our Lives     Willow   1351   \n",
       "729   Days of Our Lives         EJ  14292   \n",
       "730   Days of Our Lives   Adrienne   1511   \n",
       "731   Days of Our Lives     Jeremy   1129   \n",
       "732   Days of Our Lives     Morgan   1903   \n",
       "733   Days of Our Lives     Justin   2087   \n",
       "734   Days of Our Lives        Ava   1930   \n",
       "735   Days of Our Lives     Daniel  14751   \n",
       "736   Days of Our Lives    Melanie  15231   \n",
       "737   Days of Our Lives       Rafe  15714   \n",
       "738   Days of Our Lives     Nathan   4074   \n",
       "739   Days of Our Lives    Arianna   4966   \n",
       "740   Days of Our Lives      Carly   6878   \n",
       "741   Days of Our Lives     Vivian   4245   \n",
       "742   Days of Our Lives       Gabi   2775   \n",
       "743   Days of Our Lives     Taylor   3205   \n",
       "744   Days of Our Lives      Dario   1070   \n",
       "745   Days of Our Lives      Quinn   1428   \n",
       "746   Days of Our Lives      Sonny   1075   \n",
       "\n",
       "                                                   url  \n",
       "600    https://cbsastheworldturns.fandom.com/wiki/B.J.  \n",
       "601  https://cbsastheworldturns.fandom.com/wiki/Sag...  \n",
       "602    https://cbsastheworldturns.fandom.com/wiki/Jade  \n",
       "603  https://cbsastheworldturns.fandom.com/wiki/Vienna  \n",
       "604  https://cbsastheworldturns.fandom.com/wiki/Dallas  \n",
       "605    https://cbsastheworldturns.fandom.com/wiki/Cleo  \n",
       "606  https://cbsastheworldturns.fandom.com/wiki/Noa...  \n",
       "607   https://cbsastheworldturns.fandom.com/wiki/Sofie  \n",
       "608  https://cbsastheworldturns.fandom.com/wiki/Aud...  \n",
       "609  https://cbsastheworldturns.fandom.com/wiki/Lib...  \n",
       "610   https://cbsastheworldturns.fandom.com/wiki/Josie  \n",
       "611    https://cbsastheworldturns.fandom.com/wiki/Teri  \n",
       "612    https://cbsastheworldturns.fandom.com/wiki/Mick  \n",
       "613  https://cbsastheworldturns.fandom.com/wiki/Gab...  \n",
       "614  https://theboldandthebeautiful.fandom.com/wiki...  \n",
       "615  https://theboldandthebeautiful.fandom.com/wiki...  \n",
       "616  https://theboldandthebeautiful.fandom.com/wiki...  \n",
       "617  https://theboldandthebeautiful.fandom.com/wiki...  \n",
       "618  https://theboldandthebeautiful.fandom.com/wiki...  \n",
       "619  https://theboldandthebeautiful.fandom.com/wiki...  \n",
       "620  https://theboldandthebeautiful.fandom.com/wiki...  \n",
       "621  https://theboldandthebeautiful.fandom.com/wiki...  \n",
       "622  https://theboldandthebeautiful.fandom.com/wiki...  \n",
       "623  https://theboldandthebeautiful.fandom.com/wiki...  \n",
       "624  https://theboldandthebeautiful.fandom.com/wiki...  \n",
       "625  https://theboldandthebeautiful.fandom.com/wiki...  \n",
       "626  https://theboldandthebeautiful.fandom.com/wiki...  \n",
       "627  https://theboldandthebeautiful.fandom.com/wiki...  \n",
       "628  https://theboldandthebeautiful.fandom.com/wiki...  \n",
       "629  https://theboldandthebeautiful.fandom.com/wiki...  \n",
       "..                                                 ...  \n",
       "717  https://daysofourlives.fandom.com/wiki/Chelsea...  \n",
       "718        https://daysofourlives.fandom.com/wiki/Chad  \n",
       "719     https://daysofourlives.fandom.com/wiki/Frankie  \n",
       "720        https://daysofourlives.fandom.com/wiki/Alex  \n",
       "721      https://daysofourlives.fandom.com/wiki/Carrie  \n",
       "722        https://daysofourlives.fandom.com/wiki/E.J.  \n",
       "723  https://daysofourlives.fandom.com/wiki/Kayla_B...  \n",
       "724        https://daysofourlives.fandom.com/wiki/Nick  \n",
       "725       https://daysofourlives.fandom.com/wiki/Steve  \n",
       "726   https://daysofourlives.fandom.com/wiki/Stephanie  \n",
       "727  https://daysofourlives.fandom.com/wiki/Anna_Di...  \n",
       "728  https://daysofourlives.fandom.com/wiki/Willow_...  \n",
       "729          https://daysofourlives.fandom.com/wiki/EJ  \n",
       "730    https://daysofourlives.fandom.com/wiki/Adrienne  \n",
       "731  https://daysofourlives.fandom.com/wiki/Jeremy_...  \n",
       "732  https://daysofourlives.fandom.com/wiki/Morgan_...  \n",
       "733      https://daysofourlives.fandom.com/wiki/Justin  \n",
       "734  https://daysofourlives.fandom.com/wiki/Ava_Vitali  \n",
       "735      https://daysofourlives.fandom.com/wiki/Daniel  \n",
       "736     https://daysofourlives.fandom.com/wiki/Melanie  \n",
       "737  https://daysofourlives.fandom.com/wiki/Rafe_He...  \n",
       "738      https://daysofourlives.fandom.com/wiki/Nathan  \n",
       "739     https://daysofourlives.fandom.com/wiki/Arianna  \n",
       "740  https://daysofourlives.fandom.com/wiki/Carly_M...  \n",
       "741      https://daysofourlives.fandom.com/wiki/Vivian  \n",
       "742  https://daysofourlives.fandom.com/wiki/Gabi_He...  \n",
       "743      https://daysofourlives.fandom.com/wiki/Taylor  \n",
       "744  https://daysofourlives.fandom.com/wiki/Dario_H...  \n",
       "745  https://daysofourlives.fandom.com/wiki/Quinn_H...  \n",
       "746  https://daysofourlives.fandom.com/wiki/Jackson...  \n",
       "\n",
       "[147 rows x 4 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "namedf1[600:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}