2-get_subtitles_all.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "pd.set_option('display.max_columns', 500)\n",
    "\n",
    "import numpy as np\n",
    "import requests\n",
    "import gzip"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "ename": "ParserError",
     "evalue": "Expected 16 fields in line 2876, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mParserError\u001b[0m                               Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-4-4b2752d529cf>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[1;32m      3\u001b[0m \u001b[0;32mwith\u001b[0m \u001b[0mopen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'subtitles_all.gz'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m'wb+'\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0mfile\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      4\u001b[0m     \u001b[0mfile\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mwrite\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mraw_data\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcontent\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 5\u001b[0;31m \u001b[0mdf\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread_csv\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'subtitles_all.gz'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mcompression\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'gzip'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0msep\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34mr'\\t'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mengine\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'python'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      6\u001b[0m \u001b[0mdf\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mto_pickle\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'subtitles_all.pickle'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      7\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.6/site-packages/pandas/io/parsers.py\u001b[0m in \u001b[0;36mparser_f\u001b[0;34m(filepath_or_buffer, sep, delimiter, header, names, index_col, usecols, squeeze, prefix, mangle_dupe_cols, dtype, engine, converters, true_values, false_values, skipinitialspace, skiprows, nrows, na_values, keep_default_na, na_filter, verbose, skip_blank_lines, parse_dates, infer_datetime_format, keep_date_col, date_parser, dayfirst, iterator, chunksize, compression, thousands, decimal, lineterminator, quotechar, quoting, escapechar, comment, encoding, dialect, tupleize_cols, error_bad_lines, warn_bad_lines, skipfooter, doublequote, delim_whitespace, low_memory, memory_map, float_precision)\u001b[0m\n\u001b[1;32m    676\u001b[0m                     skip_blank_lines=skip_blank_lines)\n\u001b[1;32m    677\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 678\u001b[0;31m         \u001b[0;32mreturn\u001b[0m \u001b[0m_read\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mkwds\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    679\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    680\u001b[0m     \u001b[0mparser_f\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m__name__\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mname\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.6/site-packages/pandas/io/parsers.py\u001b[0m in \u001b[0;36m_read\u001b[0;34m(filepath_or_buffer, kwds)\u001b[0m\n\u001b[1;32m    444\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    445\u001b[0m     \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 446\u001b[0;31m         \u001b[0mdata\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mparser\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mnrows\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    447\u001b[0m     \u001b[0;32mfinally\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    448\u001b[0m         \u001b[0mparser\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mclose\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.6/site-packages/pandas/io/parsers.py\u001b[0m in \u001b[0;36mread\u001b[0;34m(self, nrows)\u001b[0m\n\u001b[1;32m   1034\u001b[0m                 \u001b[0;32mraise\u001b[0m \u001b[0mValueError\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'skipfooter not supported for iteration'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1035\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1036\u001b[0;31m         \u001b[0mret\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mnrows\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1037\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1038\u001b[0m         \u001b[0;31m# May alter columns / col_dict\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.6/site-packages/pandas/io/parsers.py\u001b[0m in \u001b[0;36mread\u001b[0;34m(self, rows)\u001b[0m\n\u001b[1;32m   2264\u001b[0m             \u001b[0mcontent\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mcontent\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2265\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2266\u001b[0;31m         \u001b[0malldata\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_rows_to_cols\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcontent\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2267\u001b[0m         \u001b[0mdata\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_exclude_implicit_index\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0malldata\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2268\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.6/site-packages/pandas/io/parsers.py\u001b[0m in \u001b[0;36m_rows_to_cols\u001b[0;34m(self, content)\u001b[0m\n\u001b[1;32m   2907\u001b[0m                     \u001b[0mmsg\u001b[0m \u001b[0;34m+=\u001b[0m \u001b[0;34m'. '\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0mreason\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2908\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2909\u001b[0;31m                 \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_alert_malformed\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mmsg\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mrow_num\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0;36m1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2910\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2911\u001b[0m         \u001b[0;31m# see gh-13320\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/.local/lib/python3.6/site-packages/pandas/io/parsers.py\u001b[0m in \u001b[0;36m_alert_malformed\u001b[0;34m(self, msg, row_num)\u001b[0m\n\u001b[1;32m   2674\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2675\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0merror_bad_lines\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2676\u001b[0;31m             \u001b[0;32mraise\u001b[0m \u001b[0mParserError\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mmsg\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2677\u001b[0m         \u001b[0;32melif\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mwarn_bad_lines\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2678\u001b[0m             \u001b[0mbase\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m'Skipping line {row_num}: '\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mformat\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mrow_num\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mrow_num\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mParserError\u001b[0m: Expected 16 fields in line 2876, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used."
     ]
    }
   ],
   "source": [
    "url =' http://dl.opensubtitles.org/addons/export/subtitles_all.txt.gz'\n",
    "raw_data = requests.get(url)\n",
    "with open('subtitles_all.gz', 'wb+') as file:\n",
    "    file.write(raw_data.content)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "quotechar \n",
    "error_bad_lines \n",
    "warn_bad_lines \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "def download_file(url,local_filename):\n",
    "    #local_filename = url.split('/')[-1]\n",
    "    # NOTE the stream=True parameter below\n",
    "    with requests.get(url, stream=True) as r:\n",
    "        with open(local_filename, 'wb') as f:\n",
    "            for chunk in r.iter_content(chunk_size=8192): \n",
    "                if chunk: # filter out keep-alive new chunks\n",
    "                    f.write(chunk)\n",
    "                    f.flush()\n",
    "    return local_filename"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'subtitles_all2.gz'"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "download_file(url,'subtitles_all.gz')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Skipping line 2876: Expected 16 fields in line 2876, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 85576: Expected 16 fields in line 85576, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 137448: Expected 16 fields in line 137448, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 145172: Expected 16 fields in line 145172, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 180188: Expected 16 fields in line 180188, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 184872: Expected 16 fields in line 184872, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 208605: Expected 16 fields in line 208605, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 209341: Expected 16 fields in line 209341, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 239464: Expected 16 fields in line 239464, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 279139: Expected 16 fields in line 279139, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 287216: Expected 16 fields in line 287216, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 287398: Expected 16 fields in line 287398, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 287478: Expected 16 fields in line 287478, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 288214: Expected 16 fields in line 288214, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 289989: Expected 16 fields in line 289989, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 382798: Expected 16 fields in line 382798, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 412726: Expected 16 fields in line 412726, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 415672: Expected 16 fields in line 415672, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 434659: Expected 16 fields in line 434659, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 740175: Expected 16 fields in line 740175, saw 18. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 748547: Expected 16 fields in line 748547, saw 20. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 753414: Expected 16 fields in line 753414, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 754510: Expected 16 fields in line 754510, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 1196810: Expected 16 fields in line 1196810, saw 19. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 1216901: Expected 16 fields in line 1216901, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 1261272: Expected 16 fields in line 1261272, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 1450388: Expected 16 fields in line 1450388, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 1466795: Expected 16 fields in line 1466795, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 1469780: Expected 16 fields in line 1469780, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 2606436: Expected 16 fields in line 2606436, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 2652168: Expected 16 fields in line 2652168, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 2732212: Expected 16 fields in line 2732212, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 2737447: Expected 16 fields in line 2737447, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 2966011: Expected 16 fields in line 2966011, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 2971634: Expected 16 fields in line 2971634, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 3127974: Expected 16 fields in line 3127974, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 3323098: Expected 16 fields in line 3323098, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 3330680: Expected 16 fields in line 3330680, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 3581929: Expected 16 fields in line 3581929, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 3714982: Expected 16 fields in line 3714982, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 3764745: Expected 16 fields in line 3764745, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 3815723: Expected 16 fields in line 3815723, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 3942565: Expected 16 fields in line 3942565, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 3989839: Expected 16 fields in line 3989839, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 4102840: Expected 16 fields in line 4102840, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 4176507: Expected 16 fields in line 4176507, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 4257937: Expected 16 fields in line 4257937, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n",
      "Skipping line 4303218: Expected 16 fields in line 4303218, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.\n"
     ]
    }
   ],
   "source": [
    "df = pd.read_csv('subtitles_all.gz', compression='gzip', sep=r'\\t', engine='python', \n",
    "                 quotechar='\"', error_bad_lines=False, warn_bad_lines=True )\n",
    "df.to_pickle('subtitles_all.pickle')\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>IDSubtitle</th>\n",
       "      <th>MovieName</th>\n",
       "      <th>MovieYear</th>\n",
       "      <th>LanguageName</th>\n",
       "      <th>ISO639</th>\n",
       "      <th>SubAddDate</th>\n",
       "      <th>ImdbID</th>\n",
       "      <th>SubFormat</th>\n",
       "      <th>SubSumCD</th>\n",
       "      <th>MovieReleaseName</th>\n",
       "      <th>MovieFPS</th>\n",
       "      <th>SeriesSeason</th>\n",
       "      <th>SeriesEpisode</th>\n",
       "      <th>SeriesIMDBParent</th>\n",
       "      <th>MovieKind</th>\n",
       "      <th>URL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Alien3</td>\n",
       "      <td>1992.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-10-31 23:54:23</td>\n",
       "      <td>103644</td>\n",
       "      <td>sub</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Alien.3</td>\n",
       "      <td>11.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/1/alien...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Identity</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>Slovenian</td>\n",
       "      <td>sl</td>\n",
       "      <td>2004-10-31 23:54:23</td>\n",
       "      <td>309698</td>\n",
       "      <td>sub</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Identity.DVDRiP.XViD</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/2/ident...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Ghost in the Shell 2: Innocence</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-10-31 23:54:23</td>\n",
       "      <td>347246</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Innocence.2004.DVDRip.XviD</td>\n",
       "      <td>23.980</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/3/ghost...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Planet of the Apes</td>\n",
       "      <td>2001.0</td>\n",
       "      <td>Slovenian</td>\n",
       "      <td>sl</td>\n",
       "      <td>2004-10-31 23:54:23</td>\n",
       "      <td>133152</td>\n",
       "      <td>sub</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Planet.Of.The. Apes.XviD</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/4/plane...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>The City of Lost Children</td>\n",
       "      <td>1995.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-11-01 20:11:53</td>\n",
       "      <td>112682</td>\n",
       "      <td>srt</td>\n",
       "      <td>2.0</td>\n",
       "      <td>The.City.Of.Lost.Children.1995.iNTERNAL.DVDRi...</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/5/the-c...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>Antitrust</td>\n",
       "      <td>2001.0</td>\n",
       "      <td>Slovenian</td>\n",
       "      <td>sl</td>\n",
       "      <td>2004-11-02 21:30:28</td>\n",
       "      <td>218817</td>\n",
       "      <td>sub</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/6/antit...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>Dirty Pretty Things</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>Slovenian</td>\n",
       "      <td>sl</td>\n",
       "      <td>2004-11-03 11:58:18</td>\n",
       "      <td>301199</td>\n",
       "      <td>sub</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7/dirty...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>Bringing Down the House</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>Slovenian</td>\n",
       "      <td>sl</td>\n",
       "      <td>2004-11-03 12:04:20</td>\n",
       "      <td>305669</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/8/bring...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>Cradle 2 the Grave</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>Slovenian</td>\n",
       "      <td>sl</td>\n",
       "      <td>2004-11-03 12:06:36</td>\n",
       "      <td>306685</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/9/cradl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>Death to Smoochy</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>Slovenian</td>\n",
       "      <td>sl</td>\n",
       "      <td>2004-11-03 12:09:01</td>\n",
       "      <td>266452</td>\n",
       "      <td>sub</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/10/deat...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>Hellboy</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>Hungarian</td>\n",
       "      <td>hu</td>\n",
       "      <td>2004-11-03 13:03:21</td>\n",
       "      <td>167190</td>\n",
       "      <td>srt</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Hellboy.2004.DVDRip.XviD-DVP</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/11/hell...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>American Gun</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>Slovenian</td>\n",
       "      <td>sl</td>\n",
       "      <td>2004-11-03 13:36:45</td>\n",
       "      <td>270197</td>\n",
       "      <td>sub</td>\n",
       "      <td>1.0</td>\n",
       "      <td>American Gun</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/12/amer...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>Jui kuen II</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-11-04 17:11:34</td>\n",
       "      <td>111512</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Drunken.Master.2.Uncut.DVD-Rip.By.Ghost</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/13/jui-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>4062580</td>\n",
       "      <td>\"Bones\" The Bodies in the Book</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>Portuguese (BR)</td>\n",
       "      <td>pb</td>\n",
       "      <td>2011-01-22 07:33:42</td>\n",
       "      <td>934029</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Bones.02x15</td>\n",
       "      <td>23.976</td>\n",
       "      <td>2.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>460627.0</td>\n",
       "      <td>tv</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/4062580...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>House of Flying Daggers</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-11-04 17:16:21</td>\n",
       "      <td>385004</td>\n",
       "      <td>srt</td>\n",
       "      <td>2.0</td>\n",
       "      <td>House.Of.Flying.Daggers.2004.RETAIL.DVDRip.XV...</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/14/hous...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>Femme Fatale</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>Hungarian</td>\n",
       "      <td>hu</td>\n",
       "      <td>2004-11-04 20:08:30</td>\n",
       "      <td>280665</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Femme.Fatale.DVDRip.XViD-ViTE</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/15/femm...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>Lu ding ji</td>\n",
       "      <td>1992.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-11-04 20:45:50</td>\n",
       "      <td>104770</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Stephen Chow - Royal Tramp 1</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/16/lu-d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>Rashomon</td>\n",
       "      <td>1950.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-11-04 20:52:44</td>\n",
       "      <td>42876</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>rashomon_(1950).earthling10480.sharereactor</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/17/rash...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>Rashomon</td>\n",
       "      <td>1950.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-11-04 20:52:44</td>\n",
       "      <td>42876</td>\n",
       "      <td>smi</td>\n",
       "      <td>1.0</td>\n",
       "      <td>rashomon_(1950).garandou.sharereactor</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/18/rash...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>4419719</td>\n",
       "      <td>The Valdemar Legacy</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Romanian</td>\n",
       "      <td>ro</td>\n",
       "      <td>2011-11-28 00:16:20</td>\n",
       "      <td>1242744</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>La.herencia.Valdemar.2010.720p.BluRay.x264-DON</td>\n",
       "      <td>24.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/4419719...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>4419721</td>\n",
       "      <td>\"The Big Bang Theory\" The Flaming Spittoon Acq...</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>Hungarian</td>\n",
       "      <td>hu</td>\n",
       "      <td>2011-11-28 00:20:11</td>\n",
       "      <td>2105978</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>The.Big.Bang.Theory.S05E10.HDTV.Swesub.XviD-Fl...</td>\n",
       "      <td>23.976</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>898266.0</td>\n",
       "      <td>tv</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/4419721...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>20</td>\n",
       "      <td>Hei kek ji wong</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-11-04 20:58:02</td>\n",
       "      <td>188766</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>King of Comedy</td>\n",
       "      <td>23.980</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/20/hei-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>21</td>\n",
       "      <td>Spirited Away</td>\n",
       "      <td>2001.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-11-04 21:04:23</td>\n",
       "      <td>245429</td>\n",
       "      <td>sub</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Spirited Away - DVDRip</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/21/spir...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>4420392</td>\n",
       "      <td>Atlas Shrugged: Part I</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>Dutch</td>\n",
       "      <td>nl</td>\n",
       "      <td>2011-11-29 00:16:57</td>\n",
       "      <td>480239</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Atlas.Shrugged.Part.1.LIMITED.2011.BRRip.XviD-...</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/4420392...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>4420394</td>\n",
       "      <td>The Pianist</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>Slovak</td>\n",
       "      <td>sk</td>\n",
       "      <td>2011-11-29 00:18:09</td>\n",
       "      <td>253474</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>The Pianist (moviesbyrizzo) HD</td>\n",
       "      <td>29.970</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/4420394...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>23</td>\n",
       "      <td>Back to the Future Part II</td>\n",
       "      <td>1989.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-11-04 21:15:46</td>\n",
       "      <td>96874</td>\n",
       "      <td>srt</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Back To The Future II - English</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/23/back...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>24</td>\n",
       "      <td>Ghost Ship</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-11-04 21:47:29</td>\n",
       "      <td>288477</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Ghost Ship.English</td>\n",
       "      <td>25.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/24/ghos...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>25</td>\n",
       "      <td>Ghost Ship</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>Hungarian</td>\n",
       "      <td>hu</td>\n",
       "      <td>2004-11-04 21:47:29</td>\n",
       "      <td>288477</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Ghost.Ship.DVDRip.XviD-ViTE</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/25/ghos...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>26</td>\n",
       "      <td>Lu ding ji II: Zhi shen long jiao</td>\n",
       "      <td>1992.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-11-04 21:55:18</td>\n",
       "      <td>104771</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Stephen Chow - Royal Tramp 2</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/26/lu-d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>4421144</td>\n",
       "      <td>\"Rome\" Death Mask</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>Polish</td>\n",
       "      <td>pl</td>\n",
       "      <td>2011-11-30 00:20:06</td>\n",
       "      <td>901366</td>\n",
       "      <td>mpl</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Rome.S02E07.720p.BluRay.x264-MAjUS</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>384766.0</td>\n",
       "      <td>tv</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/4421144...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336528</th>\n",
       "      <td>7678533</td>\n",
       "      <td>\"Supergirl\" Elseworlds, Part 3</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>Italian</td>\n",
       "      <td>it</td>\n",
       "      <td>2019-03-07 03:41:04</td>\n",
       "      <td>8883894</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>supergirl.s04e09.WEBRip.sub.ita.A7A</td>\n",
       "      <td>23.976</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>4016454.0</td>\n",
       "      <td>tv</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678533...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336529</th>\n",
       "      <td>7678534</td>\n",
       "      <td>\"American Dad!\" The Best Christmas Story Never</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>Greek</td>\n",
       "      <td>el</td>\n",
       "      <td>2019-03-07 03:46:58</td>\n",
       "      <td>920930</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>American Dad S02E09 The Best Christmas Story ...</td>\n",
       "      <td>25.000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>397306.0</td>\n",
       "      <td>tv</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678534...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336530</th>\n",
       "      <td>7678535</td>\n",
       "      <td>\"The Passage\" You Are Not That Girl Anymore</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>Spanish</td>\n",
       "      <td>es</td>\n",
       "      <td>2019-03-07 03:54:32</td>\n",
       "      <td>9252966</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>You are not that girl anymore</td>\n",
       "      <td>23.976</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1074206.0</td>\n",
       "      <td>tv</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678535...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336531</th>\n",
       "      <td>7678536</td>\n",
       "      <td>\"The Good Doctor\" Breakdown</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>Portuguese (BR)</td>\n",
       "      <td>pb</td>\n",
       "      <td>2019-03-07 03:56:09</td>\n",
       "      <td>9660060</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>The.Good.Doctor.S02E17.720p.HDTV.x264-KILLERS</td>\n",
       "      <td>23.976</td>\n",
       "      <td>2.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>6470478.0</td>\n",
       "      <td>tv</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678536...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336532</th>\n",
       "      <td>7678538</td>\n",
       "      <td>\"Narcos: Mexico\" Camelot</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>Croatian</td>\n",
       "      <td>hr</td>\n",
       "      <td>2019-03-07 04:16:56</td>\n",
       "      <td>6038978</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Narcos.Mexico.S01E01.720p.WEBRip.x265-HETeam</td>\n",
       "      <td>25.000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8714904.0</td>\n",
       "      <td>tv</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678538...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336533</th>\n",
       "      <td>7678544</td>\n",
       "      <td>Koi... Mil Gaya</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>Sinhalese</td>\n",
       "      <td>si</td>\n",
       "      <td>2019-03-07 05:52:29</td>\n",
       "      <td>254481</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>koi mil gaya full movie hd 1080p full movie i...</td>\n",
       "      <td>25.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678544...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336534</th>\n",
       "      <td>7678545</td>\n",
       "      <td>\"Grey's Anatomy\" Blood and Water</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-07 05:56:25</td>\n",
       "      <td>9611710</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Greys.Anatomy.S15E16.HDTV.x264-KILLERS</td>\n",
       "      <td>23.976</td>\n",
       "      <td>15.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>413573.0</td>\n",
       "      <td>tv</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678545...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336535</th>\n",
       "      <td>7678546</td>\n",
       "      <td>\"Grey's Anatomy\" Blood and Water</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-07 05:56:42</td>\n",
       "      <td>9611710</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Greys.Anatomy.S15E16.HDTV.x264-KILLERS</td>\n",
       "      <td>23.976</td>\n",
       "      <td>15.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>413573.0</td>\n",
       "      <td>tv</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678546...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336536</th>\n",
       "      <td>7678547</td>\n",
       "      <td>\"Miracle Workers\" Episode #1.3</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>Romanian</td>\n",
       "      <td>ro</td>\n",
       "      <td>2019-03-07 05:58:55</td>\n",
       "      <td>7793086</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>miracle.workers.2019.s01e03.720p.webrip.x264-tbs</td>\n",
       "      <td>23.976</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7529770.0</td>\n",
       "      <td>tv</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678547...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336537</th>\n",
       "      <td>7678550</td>\n",
       "      <td>\"Poirot\" The Theft of the Royal Ruby</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>Italian</td>\n",
       "      <td>it</td>\n",
       "      <td>2019-03-07 06:30:04</td>\n",
       "      <td>676187</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>The Theft of the Royal Ruby (1991)</td>\n",
       "      <td>25.000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>94525.0</td>\n",
       "      <td>tv</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678550...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336538</th>\n",
       "      <td>7678552</td>\n",
       "      <td>Scars of Xavier</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-07 06:30:39</td>\n",
       "      <td>7346786</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Scars.of.Xavier.2017.HDRip.AC3.X264-CMRG</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678552...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336539</th>\n",
       "      <td>7678556</td>\n",
       "      <td>\"I Am the Night\" Queen's Gambit, Accepted</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-07 06:46:50</td>\n",
       "      <td>7767664</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>I.Am.the.Night.S01E06.720p.AMZN.WEBRip.DDP5.1....</td>\n",
       "      <td>23.976</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7186588.0</td>\n",
       "      <td>tv</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678556...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336540</th>\n",
       "      <td>7678557</td>\n",
       "      <td>\"New Amsterdam\" Anima Sola</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>Finnish</td>\n",
       "      <td>fi</td>\n",
       "      <td>2019-03-07 06:48:56</td>\n",
       "      <td>9556974</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>New.Amsterdam.2018.S01E12.720p.HEVC.x265-MeGus...</td>\n",
       "      <td>23.976</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>7817340.0</td>\n",
       "      <td>tv</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678557...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336541</th>\n",
       "      <td>7678558</td>\n",
       "      <td>\"Ray Donovan\" Chinese Algebra</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Hebrew</td>\n",
       "      <td>he</td>\n",
       "      <td>2019-03-07 07:01:26</td>\n",
       "      <td>5347010</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Ray.Donovan.S04E11.720p.HDTV.x264-FLEET (1)</td>\n",
       "      <td>25.000</td>\n",
       "      <td>4.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2249007.0</td>\n",
       "      <td>tv</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678558...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336542</th>\n",
       "      <td>7678559</td>\n",
       "      <td>\"Documentary Now!\" Episode #3.4</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-07 07:11:11</td>\n",
       "      <td>8211428</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Documentary.Now.S03E04.480p.x264-mSD</td>\n",
       "      <td>0.000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4677934.0</td>\n",
       "      <td>tv</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678559...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336543</th>\n",
       "      <td>7678562</td>\n",
       "      <td>Mary Poppins Returns</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-07 07:22:17</td>\n",
       "      <td>5028340</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Mary.Poppins.Returns.2019.DVDRip.XviD.AC3-EVO</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678562...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336544</th>\n",
       "      <td>7678565</td>\n",
       "      <td>Ralph Breaks the Internet</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>Greek</td>\n",
       "      <td>el</td>\n",
       "      <td>2019-03-07 07:31:26</td>\n",
       "      <td>5848272</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Ralph.Breaks.The.Internet.2018.1080p.WEBRip.x2...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678565...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336545</th>\n",
       "      <td>7678566</td>\n",
       "      <td>\"New Amsterdam\" Croaklahoma</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>Danish</td>\n",
       "      <td>da</td>\n",
       "      <td>2019-03-07 07:33:09</td>\n",
       "      <td>9809748</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>New.Amsterdam.2018.S01E15.iNTERNAL.720p.WEB.h...</td>\n",
       "      <td>23.976</td>\n",
       "      <td>1.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>7817340.0</td>\n",
       "      <td>tv</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678566...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336546</th>\n",
       "      <td>7678567</td>\n",
       "      <td>\"New Amsterdam\" Croaklahoma</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>Finnish</td>\n",
       "      <td>fi</td>\n",
       "      <td>2019-03-07 07:33:23</td>\n",
       "      <td>9809748</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>New.Amsterdam.2018.S01E15.iNTERNAL.720p.WEB.h...</td>\n",
       "      <td>23.976</td>\n",
       "      <td>1.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>7817340.0</td>\n",
       "      <td>tv</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678567...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336547</th>\n",
       "      <td>7678569</td>\n",
       "      <td>La pelle</td>\n",
       "      <td>1981.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-07 07:35:10</td>\n",
       "      <td>82893</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>vsn: 2h13'22''; remestered</td>\n",
       "      <td>24.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678569...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336548</th>\n",
       "      <td>7678570</td>\n",
       "      <td>Aki tachinu</td>\n",
       "      <td>1960.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-07 07:35:46</td>\n",
       "      <td>53578</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Aki.Tachinu.1960.Naruse</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678570...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336549</th>\n",
       "      <td>7678573</td>\n",
       "      <td>Elephant White</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-07 07:39:45</td>\n",
       "      <td>1578882</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Elephant.White.2011.DUAL.COMPLETE.BLURAY-CLASH</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678573...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336550</th>\n",
       "      <td>7678574</td>\n",
       "      <td>\"Gotham\" Legend of the Dark Knight: Nothing's ...</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>Spanish</td>\n",
       "      <td>es</td>\n",
       "      <td>2019-03-07 07:42:54</td>\n",
       "      <td>8413462</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Gotham 5x08 - Nothing's Shocking</td>\n",
       "      <td>0.000</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3749900.0</td>\n",
       "      <td>tv</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678574...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336551</th>\n",
       "      <td>7678575</td>\n",
       "      <td>\"White Gold\" Episode #2.1</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-07 08:06:48</td>\n",
       "      <td>7082412</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>White.Gold.S02E01.HDTV.x264-RBB</td>\n",
       "      <td>25.000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6010920.0</td>\n",
       "      <td>tv</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678575...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336552</th>\n",
       "      <td>7678576</td>\n",
       "      <td>\"Ray Donovan\" Rattus Rattus</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Hebrew</td>\n",
       "      <td>he</td>\n",
       "      <td>2019-03-07 08:12:59</td>\n",
       "      <td>4937254</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Ray.Donovan.S04E12.720p.HDTV.x264-AVS</td>\n",
       "      <td>25.000</td>\n",
       "      <td>4.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>2249007.0</td>\n",
       "      <td>tv</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678576...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336553</th>\n",
       "      <td>7678582</td>\n",
       "      <td>\"Shameless\" BOOOOOOOOOOOONE!</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>Bosnian</td>\n",
       "      <td>bs</td>\n",
       "      <td>2019-03-07 08:32:19</td>\n",
       "      <td>8245474</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Shameless.US.S09E09.Boooooooooooone.720p.AMZN...</td>\n",
       "      <td>23.976</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1586680.0</td>\n",
       "      <td>tv</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678582...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336554</th>\n",
       "      <td>7678588</td>\n",
       "      <td>\"The Umbrella Academy\" I Heard a Rumor</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>Japanese</td>\n",
       "      <td>ja</td>\n",
       "      <td>2019-03-07 08:36:19</td>\n",
       "      <td>8407436</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>The.Umbrella.Academy.S01E08.I.Heard.a.Rumor.10...</td>\n",
       "      <td>23.976</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1312171.0</td>\n",
       "      <td>tv</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678588...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336555</th>\n",
       "      <td>7678591</td>\n",
       "      <td>\"ER\" Another Perfect Day</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>Polish</td>\n",
       "      <td>pl</td>\n",
       "      <td>2019-03-07 08:39:53</td>\n",
       "      <td>567926</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>ER.S01E07.Another.Perfect.Day.1080p.WEB-DL.DD+...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>108757.0</td>\n",
       "      <td>tv</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678591...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336556</th>\n",
       "      <td>7678594</td>\n",
       "      <td>Vacation</td>\n",
       "      <td>1983.0</td>\n",
       "      <td>Korean</td>\n",
       "      <td>ko</td>\n",
       "      <td>2019-03-07 08:59:28</td>\n",
       "      <td>85995</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>National Lampoon's Vacation</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678594...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336557</th>\n",
       "      <td>7678595</td>\n",
       "      <td>\"Suits\" Stalking Horse</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>Czech</td>\n",
       "      <td>cs</td>\n",
       "      <td>2019-03-07 09:00:04</td>\n",
       "      <td>9318636</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Suits.S08E15.720p.HDTV.x264-AVS</td>\n",
       "      <td>23.976</td>\n",
       "      <td>8.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1632701.0</td>\n",
       "      <td>tv</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678595...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4336558 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        IDSubtitle                                          MovieName  \\\n",
       "0                1                                             Alien3   \n",
       "1                2                                           Identity   \n",
       "2                3                    Ghost in the Shell 2: Innocence   \n",
       "3                4                                 Planet of the Apes   \n",
       "4                5                          The City of Lost Children   \n",
       "5                6                                          Antitrust   \n",
       "6                7                                Dirty Pretty Things   \n",
       "7                8                            Bringing Down the House   \n",
       "8                9                                 Cradle 2 the Grave   \n",
       "9               10                                   Death to Smoochy   \n",
       "10              11                                            Hellboy   \n",
       "11              12                                       American Gun   \n",
       "12              13                                        Jui kuen II   \n",
       "13         4062580                     \"Bones\" The Bodies in the Book   \n",
       "14              14                            House of Flying Daggers   \n",
       "15              15                                       Femme Fatale   \n",
       "16              16                                         Lu ding ji   \n",
       "17              17                                           Rashomon   \n",
       "18              18                                           Rashomon   \n",
       "19         4419719                                The Valdemar Legacy   \n",
       "20         4419721  \"The Big Bang Theory\" The Flaming Spittoon Acq...   \n",
       "21              20                                    Hei kek ji wong   \n",
       "22              21                                      Spirited Away   \n",
       "23         4420392                             Atlas Shrugged: Part I   \n",
       "24         4420394                                        The Pianist   \n",
       "25              23                         Back to the Future Part II   \n",
       "26              24                                         Ghost Ship   \n",
       "27              25                                         Ghost Ship   \n",
       "28              26                  Lu ding ji II: Zhi shen long jiao   \n",
       "29         4421144                                  \"Rome\" Death Mask   \n",
       "...            ...                                                ...   \n",
       "4336528    7678533                     \"Supergirl\" Elseworlds, Part 3   \n",
       "4336529    7678534     \"American Dad!\" The Best Christmas Story Never   \n",
       "4336530    7678535        \"The Passage\" You Are Not That Girl Anymore   \n",
       "4336531    7678536                        \"The Good Doctor\" Breakdown   \n",
       "4336532    7678538                           \"Narcos: Mexico\" Camelot   \n",
       "4336533    7678544                                    Koi... Mil Gaya   \n",
       "4336534    7678545                   \"Grey's Anatomy\" Blood and Water   \n",
       "4336535    7678546                   \"Grey's Anatomy\" Blood and Water   \n",
       "4336536    7678547                     \"Miracle Workers\" Episode #1.3   \n",
       "4336537    7678550               \"Poirot\" The Theft of the Royal Ruby   \n",
       "4336538    7678552                                    Scars of Xavier   \n",
       "4336539    7678556          \"I Am the Night\" Queen's Gambit, Accepted   \n",
       "4336540    7678557                         \"New Amsterdam\" Anima Sola   \n",
       "4336541    7678558                      \"Ray Donovan\" Chinese Algebra   \n",
       "4336542    7678559                    \"Documentary Now!\" Episode #3.4   \n",
       "4336543    7678562                               Mary Poppins Returns   \n",
       "4336544    7678565                          Ralph Breaks the Internet   \n",
       "4336545    7678566                        \"New Amsterdam\" Croaklahoma   \n",
       "4336546    7678567                        \"New Amsterdam\" Croaklahoma   \n",
       "4336547    7678569                                           La pelle   \n",
       "4336548    7678570                                        Aki tachinu   \n",
       "4336549    7678573                                     Elephant White   \n",
       "4336550    7678574  \"Gotham\" Legend of the Dark Knight: Nothing's ...   \n",
       "4336551    7678575                          \"White Gold\" Episode #2.1   \n",
       "4336552    7678576                        \"Ray Donovan\" Rattus Rattus   \n",
       "4336553    7678582                       \"Shameless\" BOOOOOOOOOOOONE!   \n",
       "4336554    7678588             \"The Umbrella Academy\" I Heard a Rumor   \n",
       "4336555    7678591                           \"ER\" Another Perfect Day   \n",
       "4336556    7678594                                           Vacation   \n",
       "4336557    7678595                             \"Suits\" Stalking Horse   \n",
       "\n",
       "         MovieYear     LanguageName ISO639           SubAddDate   ImdbID  \\\n",
       "0           1992.0          English     en  2004-10-31 23:54:23   103644   \n",
       "1           2003.0        Slovenian     sl  2004-10-31 23:54:23   309698   \n",
       "2           2004.0          English     en  2004-10-31 23:54:23   347246   \n",
       "3           2001.0        Slovenian     sl  2004-10-31 23:54:23   133152   \n",
       "4           1995.0          English     en  2004-11-01 20:11:53   112682   \n",
       "5           2001.0        Slovenian     sl  2004-11-02 21:30:28   218817   \n",
       "6           2002.0        Slovenian     sl  2004-11-03 11:58:18   301199   \n",
       "7           2003.0        Slovenian     sl  2004-11-03 12:04:20   305669   \n",
       "8           2003.0        Slovenian     sl  2004-11-03 12:06:36   306685   \n",
       "9           2002.0        Slovenian     sl  2004-11-03 12:09:01   266452   \n",
       "10          2004.0        Hungarian     hu  2004-11-03 13:03:21   167190   \n",
       "11          2002.0        Slovenian     sl  2004-11-03 13:36:45   270197   \n",
       "12          1994.0          English     en  2004-11-04 17:11:34   111512   \n",
       "13          2007.0  Portuguese (BR)     pb  2011-01-22 07:33:42   934029   \n",
       "14          2004.0          English     en  2004-11-04 17:16:21   385004   \n",
       "15          2002.0        Hungarian     hu  2004-11-04 20:08:30   280665   \n",
       "16          1992.0          English     en  2004-11-04 20:45:50   104770   \n",
       "17          1950.0          English     en  2004-11-04 20:52:44    42876   \n",
       "18          1950.0          English     en  2004-11-04 20:52:44    42876   \n",
       "19          2010.0         Romanian     ro  2011-11-28 00:16:20  1242744   \n",
       "20          2011.0        Hungarian     hu  2011-11-28 00:20:11  2105978   \n",
       "21          1999.0          English     en  2004-11-04 20:58:02   188766   \n",
       "22          2001.0          English     en  2004-11-04 21:04:23   245429   \n",
       "23          2011.0            Dutch     nl  2011-11-29 00:16:57   480239   \n",
       "24          2002.0           Slovak     sk  2011-11-29 00:18:09   253474   \n",
       "25          1989.0          English     en  2004-11-04 21:15:46    96874   \n",
       "26          2002.0          English     en  2004-11-04 21:47:29   288477   \n",
       "27          2002.0        Hungarian     hu  2004-11-04 21:47:29   288477   \n",
       "28          1992.0          English     en  2004-11-04 21:55:18   104771   \n",
       "29          2007.0           Polish     pl  2011-11-30 00:20:06   901366   \n",
       "...            ...              ...    ...                  ...      ...   \n",
       "4336528     2018.0          Italian     it  2019-03-07 03:41:04  8883894   \n",
       "4336529     2006.0            Greek     el  2019-03-07 03:46:58   920930   \n",
       "4336530     2019.0          Spanish     es  2019-03-07 03:54:32  9252966   \n",
       "4336531     2019.0  Portuguese (BR)     pb  2019-03-07 03:56:09  9660060   \n",
       "4336532     2018.0         Croatian     hr  2019-03-07 04:16:56  6038978   \n",
       "4336533     2003.0        Sinhalese     si  2019-03-07 05:52:29   254481   \n",
       "4336534     2019.0          English     en  2019-03-07 05:56:25  9611710   \n",
       "4336535     2019.0          English     en  2019-03-07 05:56:42  9611710   \n",
       "4336536     2019.0         Romanian     ro  2019-03-07 05:58:55  7793086   \n",
       "4336537     1991.0          Italian     it  2019-03-07 06:30:04   676187   \n",
       "4336538     2017.0          English     en  2019-03-07 06:30:39  7346786   \n",
       "4336539     2019.0          English     en  2019-03-07 06:46:50  7767664   \n",
       "4336540     2019.0          Finnish     fi  2019-03-07 06:48:56  9556974   \n",
       "4336541     2016.0           Hebrew     he  2019-03-07 07:01:26  5347010   \n",
       "4336542     2019.0          English     en  2019-03-07 07:11:11  8211428   \n",
       "4336543     2018.0          English     en  2019-03-07 07:22:17  5028340   \n",
       "4336544     2018.0            Greek     el  2019-03-07 07:31:26  5848272   \n",
       "4336545     2019.0           Danish     da  2019-03-07 07:33:09  9809748   \n",
       "4336546     2019.0          Finnish     fi  2019-03-07 07:33:23  9809748   \n",
       "4336547     1981.0          English     en  2019-03-07 07:35:10    82893   \n",
       "4336548     1960.0          English     en  2019-03-07 07:35:46    53578   \n",
       "4336549     2011.0          English     en  2019-03-07 07:39:45  1578882   \n",
       "4336550     2019.0          Spanish     es  2019-03-07 07:42:54  8413462   \n",
       "4336551     2018.0          English     en  2019-03-07 08:06:48  7082412   \n",
       "4336552     2016.0           Hebrew     he  2019-03-07 08:12:59  4937254   \n",
       "4336553     2019.0          Bosnian     bs  2019-03-07 08:32:19  8245474   \n",
       "4336554     2019.0         Japanese     ja  2019-03-07 08:36:19  8407436   \n",
       "4336555     1994.0           Polish     pl  2019-03-07 08:39:53   567926   \n",
       "4336556     1983.0           Korean     ko  2019-03-07 08:59:28    85995   \n",
       "4336557     2019.0            Czech     cs  2019-03-07 09:00:04  9318636   \n",
       "\n",
       "        SubFormat  SubSumCD  \\\n",
       "0             sub       2.0   \n",
       "1             sub       1.0   \n",
       "2             srt       1.0   \n",
       "3             sub       1.0   \n",
       "4             srt       2.0   \n",
       "5             sub       1.0   \n",
       "6             sub       1.0   \n",
       "7             srt       1.0   \n",
       "8             srt       1.0   \n",
       "9             sub       1.0   \n",
       "10            srt       2.0   \n",
       "11            sub       1.0   \n",
       "12            srt       1.0   \n",
       "13            srt       1.0   \n",
       "14            srt       2.0   \n",
       "15            srt       1.0   \n",
       "16            srt       1.0   \n",
       "17            srt       1.0   \n",
       "18            smi       1.0   \n",
       "19            srt       1.0   \n",
       "20            srt       1.0   \n",
       "21            srt       1.0   \n",
       "22            sub       2.0   \n",
       "23            srt       1.0   \n",
       "24            srt       1.0   \n",
       "25            srt       2.0   \n",
       "26            srt       1.0   \n",
       "27            srt       1.0   \n",
       "28            srt       1.0   \n",
       "29            mpl       1.0   \n",
       "...           ...       ...   \n",
       "4336528       srt       1.0   \n",
       "4336529       srt       1.0   \n",
       "4336530       srt       1.0   \n",
       "4336531       srt       1.0   \n",
       "4336532       srt       1.0   \n",
       "4336533       srt       1.0   \n",
       "4336534       srt       1.0   \n",
       "4336535       srt       1.0   \n",
       "4336536       srt       1.0   \n",
       "4336537       srt       1.0   \n",
       "4336538       srt       1.0   \n",
       "4336539       srt       1.0   \n",
       "4336540       srt       1.0   \n",
       "4336541       srt       1.0   \n",
       "4336542       srt       1.0   \n",
       "4336543       srt       1.0   \n",
       "4336544       srt       1.0   \n",
       "4336545       srt       1.0   \n",
       "4336546       srt       1.0   \n",
       "4336547       srt       1.0   \n",
       "4336548       srt       1.0   \n",
       "4336549       srt       1.0   \n",
       "4336550       srt       1.0   \n",
       "4336551       srt       1.0   \n",
       "4336552       srt       1.0   \n",
       "4336553       srt       1.0   \n",
       "4336554       srt       1.0   \n",
       "4336555       srt       1.0   \n",
       "4336556       srt       1.0   \n",
       "4336557       srt       1.0   \n",
       "\n",
       "                                          MovieReleaseName  MovieFPS  \\\n",
       "0                                                  Alien.3    11.000   \n",
       "1                                     Identity.DVDRiP.XViD     0.000   \n",
       "2                               Innocence.2004.DVDRip.XviD    23.980   \n",
       "3                                 Planet.Of.The. Apes.XviD     0.000   \n",
       "4         The.City.Of.Lost.Children.1995.iNTERNAL.DVDRi...    23.976   \n",
       "5                                                      NaN     0.000   \n",
       "6                                                      NaN     0.000   \n",
       "7                                                      NaN     0.000   \n",
       "8                                                      NaN    23.976   \n",
       "9                                                      NaN    23.976   \n",
       "10                            Hellboy.2004.DVDRip.XviD-DVP     0.000   \n",
       "11                                            American Gun     0.000   \n",
       "12                 Drunken.Master.2.Uncut.DVD-Rip.By.Ghost    23.976   \n",
       "13                                             Bones.02x15    23.976   \n",
       "14        House.Of.Flying.Daggers.2004.RETAIL.DVDRip.XV...    23.976   \n",
       "15                           Femme.Fatale.DVDRip.XViD-ViTE     0.000   \n",
       "16                            Stephen Chow - Royal Tramp 1     0.000   \n",
       "17             rashomon_(1950).earthling10480.sharereactor     0.000   \n",
       "18                   rashomon_(1950).garandou.sharereactor     0.000   \n",
       "19          La.herencia.Valdemar.2010.720p.BluRay.x264-DON    24.000   \n",
       "20       The.Big.Bang.Theory.S05E10.HDTV.Swesub.XviD-Fl...    23.976   \n",
       "21                                          King of Comedy    23.980   \n",
       "22                                  Spirited Away - DVDRip     0.000   \n",
       "23       Atlas.Shrugged.Part.1.LIMITED.2011.BRRip.XviD-...    23.976   \n",
       "24                          The Pianist (moviesbyrizzo) HD    29.970   \n",
       "25                         Back To The Future II - English     0.000   \n",
       "26                                      Ghost Ship.English    25.000   \n",
       "27                             Ghost.Ship.DVDRip.XviD-ViTE     0.000   \n",
       "28                            Stephen Chow - Royal Tramp 2     0.000   \n",
       "29                      Rome.S02E07.720p.BluRay.x264-MAjUS     0.000   \n",
       "...                                                    ...       ...   \n",
       "4336528                supergirl.s04e09.WEBRip.sub.ita.A7A    23.976   \n",
       "4336529   American Dad S02E09 The Best Christmas Story ...    25.000   \n",
       "4336530                      You are not that girl anymore    23.976   \n",
       "4336531      The.Good.Doctor.S02E17.720p.HDTV.x264-KILLERS    23.976   \n",
       "4336532       Narcos.Mexico.S01E01.720p.WEBRip.x265-HETeam    25.000   \n",
       "4336533   koi mil gaya full movie hd 1080p full movie i...    25.000   \n",
       "4336534             Greys.Anatomy.S15E16.HDTV.x264-KILLERS    23.976   \n",
       "4336535             Greys.Anatomy.S15E16.HDTV.x264-KILLERS    23.976   \n",
       "4336536   miracle.workers.2019.s01e03.720p.webrip.x264-tbs    23.976   \n",
       "4336537                 The Theft of the Royal Ruby (1991)    25.000   \n",
       "4336538           Scars.of.Xavier.2017.HDRip.AC3.X264-CMRG    23.976   \n",
       "4336539  I.Am.the.Night.S01E06.720p.AMZN.WEBRip.DDP5.1....    23.976   \n",
       "4336540  New.Amsterdam.2018.S01E12.720p.HEVC.x265-MeGus...    23.976   \n",
       "4336541        Ray.Donovan.S04E11.720p.HDTV.x264-FLEET (1)    25.000   \n",
       "4336542               Documentary.Now.S03E04.480p.x264-mSD     0.000   \n",
       "4336543      Mary.Poppins.Returns.2019.DVDRip.XviD.AC3-EVO    23.976   \n",
       "4336544  Ralph.Breaks.The.Internet.2018.1080p.WEBRip.x2...     0.000   \n",
       "4336545   New.Amsterdam.2018.S01E15.iNTERNAL.720p.WEB.h...    23.976   \n",
       "4336546   New.Amsterdam.2018.S01E15.iNTERNAL.720p.WEB.h...    23.976   \n",
       "4336547                         vsn: 2h13'22''; remestered    24.000   \n",
       "4336548                            Aki.Tachinu.1960.Naruse    23.976   \n",
       "4336549     Elephant.White.2011.DUAL.COMPLETE.BLURAY-CLASH    23.976   \n",
       "4336550                   Gotham 5x08 - Nothing's Shocking     0.000   \n",
       "4336551                    White.Gold.S02E01.HDTV.x264-RBB    25.000   \n",
       "4336552              Ray.Donovan.S04E12.720p.HDTV.x264-AVS    25.000   \n",
       "4336553   Shameless.US.S09E09.Boooooooooooone.720p.AMZN...    23.976   \n",
       "4336554  The.Umbrella.Academy.S01E08.I.Heard.a.Rumor.10...    23.976   \n",
       "4336555  ER.S01E07.Another.Perfect.Day.1080p.WEB-DL.DD+...     0.000   \n",
       "4336556                        National Lampoon's Vacation    23.976   \n",
       "4336557                    Suits.S08E15.720p.HDTV.x264-AVS    23.976   \n",
       "\n",
       "         SeriesSeason  SeriesEpisode  SeriesIMDBParent MovieKind  \\\n",
       "0                 0.0            0.0               0.0     movie   \n",
       "1                 0.0            0.0               0.0     movie   \n",
       "2                 0.0            0.0               0.0     movie   \n",
       "3                 0.0            0.0               0.0     movie   \n",
       "4                 0.0            0.0               0.0     movie   \n",
       "5                 0.0            0.0               0.0     movie   \n",
       "6                 0.0            0.0               0.0     movie   \n",
       "7                 0.0            0.0               0.0     movie   \n",
       "8                 0.0            0.0               0.0     movie   \n",
       "9                 0.0            0.0               0.0     movie   \n",
       "10                0.0            0.0               0.0     movie   \n",
       "11                0.0            0.0               0.0     movie   \n",
       "12                0.0            0.0               0.0     movie   \n",
       "13                2.0           15.0          460627.0        tv   \n",
       "14                0.0            0.0               0.0     movie   \n",
       "15                0.0            0.0               0.0     movie   \n",
       "16                0.0            0.0               0.0     movie   \n",
       "17                0.0            0.0               0.0     movie   \n",
       "18                0.0            0.0               0.0     movie   \n",
       "19                0.0            0.0               0.0     movie   \n",
       "20                5.0           10.0          898266.0        tv   \n",
       "21                0.0            0.0               0.0     movie   \n",
       "22                0.0            0.0               0.0     movie   \n",
       "23                0.0            0.0               0.0     movie   \n",
       "24                0.0            0.0               0.0     movie   \n",
       "25                0.0            0.0               0.0     movie   \n",
       "26                0.0            0.0               0.0     movie   \n",
       "27                0.0            0.0               0.0     movie   \n",
       "28                0.0            0.0               0.0     movie   \n",
       "29                2.0            7.0          384766.0        tv   \n",
       "...               ...            ...               ...       ...   \n",
       "4336528           4.0            9.0         4016454.0        tv   \n",
       "4336529           2.0            9.0          397306.0        tv   \n",
       "4336530           1.0            8.0         1074206.0        tv   \n",
       "4336531           2.0           17.0         6470478.0        tv   \n",
       "4336532           1.0            1.0         8714904.0        tv   \n",
       "4336533           0.0            0.0               0.0     movie   \n",
       "4336534          15.0           16.0          413573.0        tv   \n",
       "4336535          15.0           16.0          413573.0        tv   \n",
       "4336536           1.0            3.0         7529770.0        tv   \n",
       "4336537           3.0            9.0           94525.0        tv   \n",
       "4336538           0.0            0.0               0.0     movie   \n",
       "4336539           1.0            6.0         7186588.0        tv   \n",
       "4336540           1.0           12.0         7817340.0        tv   \n",
       "4336541           4.0           11.0         2249007.0        tv   \n",
       "4336542           3.0            4.0         4677934.0        tv   \n",
       "4336543           0.0            0.0               0.0     movie   \n",
       "4336544           0.0            0.0               0.0     movie   \n",
       "4336545           1.0           15.0         7817340.0        tv   \n",
       "4336546           1.0           15.0         7817340.0        tv   \n",
       "4336547           0.0            0.0               0.0     movie   \n",
       "4336548           0.0            0.0               0.0     movie   \n",
       "4336549           0.0            0.0               0.0     movie   \n",
       "4336550           5.0            8.0         3749900.0        tv   \n",
       "4336551           2.0            1.0         6010920.0        tv   \n",
       "4336552           4.0           12.0         2249007.0        tv   \n",
       "4336553           9.0            9.0         1586680.0        tv   \n",
       "4336554           1.0            8.0         1312171.0        tv   \n",
       "4336555           1.0            7.0          108757.0        tv   \n",
       "4336556           0.0            0.0               0.0     movie   \n",
       "4336557           8.0           15.0         1632701.0        tv   \n",
       "\n",
       "                                                       URL  \n",
       "0        http://www.opensubtitles.org/subtitles/1/alien...  \n",
       "1        http://www.opensubtitles.org/subtitles/2/ident...  \n",
       "2        http://www.opensubtitles.org/subtitles/3/ghost...  \n",
       "3        http://www.opensubtitles.org/subtitles/4/plane...  \n",
       "4        http://www.opensubtitles.org/subtitles/5/the-c...  \n",
       "5        http://www.opensubtitles.org/subtitles/6/antit...  \n",
       "6        http://www.opensubtitles.org/subtitles/7/dirty...  \n",
       "7        http://www.opensubtitles.org/subtitles/8/bring...  \n",
       "8        http://www.opensubtitles.org/subtitles/9/cradl...  \n",
       "9        http://www.opensubtitles.org/subtitles/10/deat...  \n",
       "10       http://www.opensubtitles.org/subtitles/11/hell...  \n",
       "11       http://www.opensubtitles.org/subtitles/12/amer...  \n",
       "12       http://www.opensubtitles.org/subtitles/13/jui-...  \n",
       "13       http://www.opensubtitles.org/subtitles/4062580...  \n",
       "14       http://www.opensubtitles.org/subtitles/14/hous...  \n",
       "15       http://www.opensubtitles.org/subtitles/15/femm...  \n",
       "16       http://www.opensubtitles.org/subtitles/16/lu-d...  \n",
       "17       http://www.opensubtitles.org/subtitles/17/rash...  \n",
       "18       http://www.opensubtitles.org/subtitles/18/rash...  \n",
       "19       http://www.opensubtitles.org/subtitles/4419719...  \n",
       "20       http://www.opensubtitles.org/subtitles/4419721...  \n",
       "21       http://www.opensubtitles.org/subtitles/20/hei-...  \n",
       "22       http://www.opensubtitles.org/subtitles/21/spir...  \n",
       "23       http://www.opensubtitles.org/subtitles/4420392...  \n",
       "24       http://www.opensubtitles.org/subtitles/4420394...  \n",
       "25       http://www.opensubtitles.org/subtitles/23/back...  \n",
       "26       http://www.opensubtitles.org/subtitles/24/ghos...  \n",
       "27       http://www.opensubtitles.org/subtitles/25/ghos...  \n",
       "28       http://www.opensubtitles.org/subtitles/26/lu-d...  \n",
       "29       http://www.opensubtitles.org/subtitles/4421144...  \n",
       "...                                                    ...  \n",
       "4336528  http://www.opensubtitles.org/subtitles/7678533...  \n",
       "4336529  http://www.opensubtitles.org/subtitles/7678534...  \n",
       "4336530  http://www.opensubtitles.org/subtitles/7678535...  \n",
       "4336531  http://www.opensubtitles.org/subtitles/7678536...  \n",
       "4336532  http://www.opensubtitles.org/subtitles/7678538...  \n",
       "4336533  http://www.opensubtitles.org/subtitles/7678544...  \n",
       "4336534  http://www.opensubtitles.org/subtitles/7678545...  \n",
       "4336535  http://www.opensubtitles.org/subtitles/7678546...  \n",
       "4336536  http://www.opensubtitles.org/subtitles/7678547...  \n",
       "4336537  http://www.opensubtitles.org/subtitles/7678550...  \n",
       "4336538  http://www.opensubtitles.org/subtitles/7678552...  \n",
       "4336539  http://www.opensubtitles.org/subtitles/7678556...  \n",
       "4336540  http://www.opensubtitles.org/subtitles/7678557...  \n",
       "4336541  http://www.opensubtitles.org/subtitles/7678558...  \n",
       "4336542  http://www.opensubtitles.org/subtitles/7678559...  \n",
       "4336543  http://www.opensubtitles.org/subtitles/7678562...  \n",
       "4336544  http://www.opensubtitles.org/subtitles/7678565...  \n",
       "4336545  http://www.opensubtitles.org/subtitles/7678566...  \n",
       "4336546  http://www.opensubtitles.org/subtitles/7678567...  \n",
       "4336547  http://www.opensubtitles.org/subtitles/7678569...  \n",
       "4336548  http://www.opensubtitles.org/subtitles/7678570...  \n",
       "4336549  http://www.opensubtitles.org/subtitles/7678573...  \n",
       "4336550  http://www.opensubtitles.org/subtitles/7678574...  \n",
       "4336551  http://www.opensubtitles.org/subtitles/7678575...  \n",
       "4336552  http://www.opensubtitles.org/subtitles/7678576...  \n",
       "4336553  http://www.opensubtitles.org/subtitles/7678582...  \n",
       "4336554  http://www.opensubtitles.org/subtitles/7678588...  \n",
       "4336555  http://www.opensubtitles.org/subtitles/7678591...  \n",
       "4336556  http://www.opensubtitles.org/subtitles/7678594...  \n",
       "4336557  http://www.opensubtitles.org/subtitles/7678595...  \n",
       "\n",
       "[4336558 rows x 16 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(4336558, 16)"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(228490, 16)"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2 = df[df.MovieKind == 'movie']\n",
    "df2 = df2[df2.ISO639 == 'en']\n",
    "df2.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>IDSubtitle</th>\n",
       "      <th>MovieName</th>\n",
       "      <th>MovieYear</th>\n",
       "      <th>LanguageName</th>\n",
       "      <th>ISO639</th>\n",
       "      <th>SubAddDate</th>\n",
       "      <th>ImdbID</th>\n",
       "      <th>SubFormat</th>\n",
       "      <th>SubSumCD</th>\n",
       "      <th>MovieReleaseName</th>\n",
       "      <th>MovieFPS</th>\n",
       "      <th>SeriesSeason</th>\n",
       "      <th>SeriesEpisode</th>\n",
       "      <th>SeriesIMDBParent</th>\n",
       "      <th>MovieKind</th>\n",
       "      <th>URL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Alien3</td>\n",
       "      <td>1992.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-10-31 23:54:23</td>\n",
       "      <td>103644</td>\n",
       "      <td>sub</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Alien.3</td>\n",
       "      <td>11.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/1/alien...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Ghost in the Shell 2: Innocence</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-10-31 23:54:23</td>\n",
       "      <td>347246</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Innocence.2004.DVDRip.XviD</td>\n",
       "      <td>23.980</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/3/ghost...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>The City of Lost Children</td>\n",
       "      <td>1995.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-11-01 20:11:53</td>\n",
       "      <td>112682</td>\n",
       "      <td>srt</td>\n",
       "      <td>2.0</td>\n",
       "      <td>The.City.Of.Lost.Children.1995.iNTERNAL.DVDRi...</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/5/the-c...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>Jui kuen II</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-11-04 17:11:34</td>\n",
       "      <td>111512</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Drunken.Master.2.Uncut.DVD-Rip.By.Ghost</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/13/jui-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>House of Flying Daggers</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-11-04 17:16:21</td>\n",
       "      <td>385004</td>\n",
       "      <td>srt</td>\n",
       "      <td>2.0</td>\n",
       "      <td>House.Of.Flying.Daggers.2004.RETAIL.DVDRip.XV...</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/14/hous...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>Lu ding ji</td>\n",
       "      <td>1992.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-11-04 20:45:50</td>\n",
       "      <td>104770</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Stephen Chow - Royal Tramp 1</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/16/lu-d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>Rashomon</td>\n",
       "      <td>1950.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-11-04 20:52:44</td>\n",
       "      <td>42876</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>rashomon_(1950).earthling10480.sharereactor</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/17/rash...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>Rashomon</td>\n",
       "      <td>1950.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-11-04 20:52:44</td>\n",
       "      <td>42876</td>\n",
       "      <td>smi</td>\n",
       "      <td>1.0</td>\n",
       "      <td>rashomon_(1950).garandou.sharereactor</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/18/rash...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>20</td>\n",
       "      <td>Hei kek ji wong</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-11-04 20:58:02</td>\n",
       "      <td>188766</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>King of Comedy</td>\n",
       "      <td>23.980</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/20/hei-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>21</td>\n",
       "      <td>Spirited Away</td>\n",
       "      <td>2001.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-11-04 21:04:23</td>\n",
       "      <td>245429</td>\n",
       "      <td>sub</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Spirited Away - DVDRip</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/21/spir...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>23</td>\n",
       "      <td>Back to the Future Part II</td>\n",
       "      <td>1989.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-11-04 21:15:46</td>\n",
       "      <td>96874</td>\n",
       "      <td>srt</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Back To The Future II - English</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/23/back...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>24</td>\n",
       "      <td>Ghost Ship</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-11-04 21:47:29</td>\n",
       "      <td>288477</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Ghost Ship.English</td>\n",
       "      <td>25.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/24/ghos...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>26</td>\n",
       "      <td>Lu ding ji II: Zhi shen long jiao</td>\n",
       "      <td>1992.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-11-04 21:55:18</td>\n",
       "      <td>104771</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Stephen Chow - Royal Tramp 2</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/26/lu-d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>28</td>\n",
       "      <td>I Spy</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-11-04 22:11:29</td>\n",
       "      <td>297181</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>I Spy.English</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/28/i-sp...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>29</td>\n",
       "      <td>Dead Ringers</td>\n",
       "      <td>1988.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-11-04 22:15:53</td>\n",
       "      <td>94964</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Dead.Ringers.(1988).DVDRip.DivX3LM</td>\n",
       "      <td>25.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/29/dead...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>32</td>\n",
       "      <td>Gojira X Mekagojira</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-12-12 17:45:41</td>\n",
       "      <td>314111</td>\n",
       "      <td>srt</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Godzilla X MechaGodzilla (Hand Made)</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/32/goji...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>65</td>\n",
       "      <td>Brainstorm</td>\n",
       "      <td>1983.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2005-01-30 15:24:05</td>\n",
       "      <td>85271</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Brainstorm (1983)</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/65/brai...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>67</td>\n",
       "      <td>A Boy and His Dog</td>\n",
       "      <td>1975.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2005-01-30 15:34:16</td>\n",
       "      <td>72730</td>\n",
       "      <td>sub</td>\n",
       "      <td>1.0</td>\n",
       "      <td>A Boy And His Dog (1975)</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/67/a-bo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>72</td>\n",
       "      <td>Reservoir Dogs</td>\n",
       "      <td>1992.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2005-02-01 00:44:58</td>\n",
       "      <td>105236</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Reservoir Dogs - 1992 - [TWB]</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/72/rese...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>74</td>\n",
       "      <td>A Tale of Two Sisters</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2005-02-01 01:06:07</td>\n",
       "      <td>365376</td>\n",
       "      <td>srt</td>\n",
       "      <td>2.0</td>\n",
       "      <td>A.Tale.of.Two.Sisters.BiFOS</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/74/a-ta...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>75</td>\n",
       "      <td>Audition</td>\n",
       "      <td>1997.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2005-02-01 01:24:58</td>\n",
       "      <td>295867</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Audition_(1999).Japanese.SAPHiRE.ShareReactor</td>\n",
       "      <td>25.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/75/audi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>76</td>\n",
       "      <td>Beautiful Creatures</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2005-02-01 01:34:07</td>\n",
       "      <td>221889</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Beautiful Creatures [dvdrip] [divx pro 5.0.5]</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/76/beau...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>80</td>\n",
       "      <td>Crumb</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2005-02-03 00:56:49</td>\n",
       "      <td>109508</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Crumb (1994) Kyprios.English</td>\n",
       "      <td>23.980</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/80/crum...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>81</td>\n",
       "      <td>Shao Lin si</td>\n",
       "      <td>1982.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2005-02-03 01:33:16</td>\n",
       "      <td>79891</td>\n",
       "      <td>srt</td>\n",
       "      <td>2.0</td>\n",
       "      <td>The.Shaolin.Temple.1979.DVDRip.XviD.AC3.TEAM ...</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/81/shao...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>86</td>\n",
       "      <td>Angel Heart</td>\n",
       "      <td>1987.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2005-02-04 08:53:58</td>\n",
       "      <td>92563</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23.980</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/86/ange...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>88</td>\n",
       "      <td>Hi no tori</td>\n",
       "      <td>1978.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2005-02-05 22:16:59</td>\n",
       "      <td>77673</td>\n",
       "      <td>srt</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Hi No Tori (The Phoenix) - (Kon Ichikawa, 197...</td>\n",
       "      <td>25.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/88/hi-n...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>97</td>\n",
       "      <td>La Grande Illusion</td>\n",
       "      <td>1937.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2005-02-12 21:16:08</td>\n",
       "      <td>28950</td>\n",
       "      <td>srt</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2_La.Grande.Illusion.(1937).Jean.Renoir</td>\n",
       "      <td>25.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/97/la-g...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>98</td>\n",
       "      <td>The Return</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2005-02-14 00:42:56</td>\n",
       "      <td>376968</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>The Return</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/98/the-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>101</td>\n",
       "      <td>Revenge of the Pink Panther</td>\n",
       "      <td>1978.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2005-02-16 00:52:29</td>\n",
       "      <td>78163</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Revenge.Of.The.Pink.Panther.(1978)</td>\n",
       "      <td>23.980</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/101/rev...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>109</td>\n",
       "      <td>Persona</td>\n",
       "      <td>1966.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2005-02-19 13:27:52</td>\n",
       "      <td>60827</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Persona</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/109/per...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336088</th>\n",
       "      <td>7677655</td>\n",
       "      <td>A Haunting on Finn Road: The Devil's Grove</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-06 07:27:41</td>\n",
       "      <td>9584192</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>DVDRip.x264-REGRET</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7677655...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336090</th>\n",
       "      <td>7677659</td>\n",
       "      <td>Holmes &amp; Watson</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-06 07:34:36</td>\n",
       "      <td>1255919</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Holmes.and.Watson.2018.HDCAM</td>\n",
       "      <td>29.970</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7677659...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336091</th>\n",
       "      <td>7677660</td>\n",
       "      <td>Holmes &amp; Watson</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-06 07:34:58</td>\n",
       "      <td>1255919</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Holmes.and.Watson.2018.HDCAM</td>\n",
       "      <td>29.970</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7677660...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336092</th>\n",
       "      <td>7677661</td>\n",
       "      <td>Polisse</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-06 07:35:21</td>\n",
       "      <td>1661420</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Polisse.2011.DVDRip.x264</td>\n",
       "      <td>29.970</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7677661...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336093</th>\n",
       "      <td>7677665</td>\n",
       "      <td>Glass</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-06 07:37:38</td>\n",
       "      <td>6823368</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Glass.2019.NEW.HDCAM.x264.AC3-ETRG</td>\n",
       "      <td>29.970</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7677665...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336094</th>\n",
       "      <td>7677668</td>\n",
       "      <td>Glass</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-06 07:38:53</td>\n",
       "      <td>6823368</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Glass.2019.NEW.HDCAM.x264.AC3-ETRG</td>\n",
       "      <td>29.970</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7677668...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336095</th>\n",
       "      <td>7677669</td>\n",
       "      <td>Apocalypse Now</td>\n",
       "      <td>1979.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-06 07:39:31</td>\n",
       "      <td>78788</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Apocalypse.Now.Redux.1979.1080p.BluRay.X264-Ja...</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7677669...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336106</th>\n",
       "      <td>7677699</td>\n",
       "      <td>Uri: The Surgical Strike</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-06 09:15:21</td>\n",
       "      <td>8291224</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>URI The Surgical Strike (2019) Hindi HDRip - 7...</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7677699...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336188</th>\n",
       "      <td>7677844</td>\n",
       "      <td>The Third Secret</td>\n",
       "      <td>1964.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-06 13:09:02</td>\n",
       "      <td>58649</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>The.Third.Secret.1964.720p.BluRay.x264-GHOULS</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7677844...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336189</th>\n",
       "      <td>7677845</td>\n",
       "      <td>The Third Secret</td>\n",
       "      <td>1964.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-06 13:09:12</td>\n",
       "      <td>58649</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>The.Third.Secret.1964.720p.BluRay.x264-GHOULS</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7677845...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336190</th>\n",
       "      <td>7677846</td>\n",
       "      <td>Las palabras de Max</td>\n",
       "      <td>1978.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-06 13:10:10</td>\n",
       "      <td>76520</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1080p.FO.WEB-DL.AAC2.0.H.264-CREATiVE</td>\n",
       "      <td>25.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7677846...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336238</th>\n",
       "      <td>7677942</td>\n",
       "      <td>A Charlie Brown Valentine</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-06 15:01:06</td>\n",
       "      <td>283987</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>A.Charlie.Brown.Valentine.2002.1080p.WEBRip.A...</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7677942...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336254</th>\n",
       "      <td>7677968</td>\n",
       "      <td>The Girl in the Spider's Web</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-06 15:30:28</td>\n",
       "      <td>5177088</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1080p.BluRay.x264-DRONES (Director Commentary ...</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7677968...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336255</th>\n",
       "      <td>7677970</td>\n",
       "      <td>Empire of the Sun</td>\n",
       "      <td>1987.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-06 15:33:47</td>\n",
       "      <td>92965</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Empire of the Sun (1987)23.976fps- 152.49 min...</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7677970...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336265</th>\n",
       "      <td>7678011</td>\n",
       "      <td>Thank You for Smoking</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-06 16:11:16</td>\n",
       "      <td>427944</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>thank.you.for.smoking.2005.1080p.hdtv.x264-re...</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678011...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336266</th>\n",
       "      <td>7678012</td>\n",
       "      <td>Thank You for Smoking</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-06 16:12:32</td>\n",
       "      <td>427944</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1080p.AMZN.WEB-DL.DD+5.1.H.264-SiGMA</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678012...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336299</th>\n",
       "      <td>7678088</td>\n",
       "      <td>Ying</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-06 17:44:52</td>\n",
       "      <td>6864046</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Shadow.2018.CHINESE.720p.BluRay.H264.AAC-VXT</td>\n",
       "      <td>24.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678088...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336300</th>\n",
       "      <td>7678092</td>\n",
       "      <td>The Intent 2: The Come Up</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-06 17:54:08</td>\n",
       "      <td>7613996</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1080p.WEB-DL.H264.AC3-EVO</td>\n",
       "      <td>24.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678092...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336417</th>\n",
       "      <td>7678314</td>\n",
       "      <td>City of Ember</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-06 21:00:04</td>\n",
       "      <td>970411</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>City.of.Ember.2008.1080p.BluRay.x264.Remux.VC...</td>\n",
       "      <td>24.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678314...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336438</th>\n",
       "      <td>7678347</td>\n",
       "      <td>Bad Boys</td>\n",
       "      <td>1995.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-06 21:41:38</td>\n",
       "      <td>112442</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>BdBys (1995) BRRip 550mb</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678347...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336452</th>\n",
       "      <td>7678374</td>\n",
       "      <td>Eloisa esta debajo de un almendro</td>\n",
       "      <td>1943.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-06 22:00:45</td>\n",
       "      <td>35840</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1080p.FO.WEB-DL.AAC2.0.H.264-CREATiVE</td>\n",
       "      <td>25.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678374...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336504</th>\n",
       "      <td>7678483</td>\n",
       "      <td>L'ordre</td>\n",
       "      <td>1973.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-07 01:15:57</td>\n",
       "      <td>234401</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>l'ordre.1973</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678483...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336519</th>\n",
       "      <td>7678517</td>\n",
       "      <td>Tangent Room</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-07 02:55:59</td>\n",
       "      <td>4230078</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Tangent.Room.2019.HDRip.XviD.AC3-EVO</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678517...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336521</th>\n",
       "      <td>7678519</td>\n",
       "      <td>Tangent Room</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-07 02:56:39</td>\n",
       "      <td>4230078</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Tangent.Room.2019.HDRip.XviD.AC3-EVO</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678519...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336525</th>\n",
       "      <td>7678525</td>\n",
       "      <td>100 Yards</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-07 03:12:33</td>\n",
       "      <td>5258106</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>100 Yards 2018.HDRip.XviD.AC3-EVO</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678525...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336538</th>\n",
       "      <td>7678552</td>\n",
       "      <td>Scars of Xavier</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-07 06:30:39</td>\n",
       "      <td>7346786</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Scars.of.Xavier.2017.HDRip.AC3.X264-CMRG</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678552...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336543</th>\n",
       "      <td>7678562</td>\n",
       "      <td>Mary Poppins Returns</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-07 07:22:17</td>\n",
       "      <td>5028340</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Mary.Poppins.Returns.2019.DVDRip.XviD.AC3-EVO</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678562...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336547</th>\n",
       "      <td>7678569</td>\n",
       "      <td>La pelle</td>\n",
       "      <td>1981.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-07 07:35:10</td>\n",
       "      <td>82893</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>vsn: 2h13'22''; remestered</td>\n",
       "      <td>24.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678569...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336548</th>\n",
       "      <td>7678570</td>\n",
       "      <td>Aki tachinu</td>\n",
       "      <td>1960.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-07 07:35:46</td>\n",
       "      <td>53578</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Aki.Tachinu.1960.Naruse</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678570...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4336549</th>\n",
       "      <td>7678573</td>\n",
       "      <td>Elephant White</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2019-03-07 07:39:45</td>\n",
       "      <td>1578882</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Elephant.White.2011.DUAL.COMPLETE.BLURAY-CLASH</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7678573...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>228490 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        IDSubtitle                                   MovieName  MovieYear  \\\n",
       "0                1                                      Alien3     1992.0   \n",
       "2                3             Ghost in the Shell 2: Innocence     2004.0   \n",
       "4                5                   The City of Lost Children     1995.0   \n",
       "12              13                                 Jui kuen II     1994.0   \n",
       "14              14                     House of Flying Daggers     2004.0   \n",
       "16              16                                  Lu ding ji     1992.0   \n",
       "17              17                                    Rashomon     1950.0   \n",
       "18              18                                    Rashomon     1950.0   \n",
       "21              20                             Hei kek ji wong     1999.0   \n",
       "22              21                               Spirited Away     2001.0   \n",
       "25              23                  Back to the Future Part II     1989.0   \n",
       "26              24                                  Ghost Ship     2002.0   \n",
       "28              26           Lu ding ji II: Zhi shen long jiao     1992.0   \n",
       "30              28                                       I Spy     2002.0   \n",
       "31              29                                Dead Ringers     1988.0   \n",
       "35              32                         Gojira X Mekagojira     2002.0   \n",
       "69              65                                  Brainstorm     1983.0   \n",
       "71              67                           A Boy and His Dog     1975.0   \n",
       "76              72                              Reservoir Dogs     1992.0   \n",
       "78              74                       A Tale of Two Sisters     2003.0   \n",
       "79              75                                    Audition     1997.0   \n",
       "80              76                         Beautiful Creatures     2000.0   \n",
       "84              80                                       Crumb     1994.0   \n",
       "85              81                                 Shao Lin si     1982.0   \n",
       "90              86                                 Angel Heart     1987.0   \n",
       "92              88                                  Hi no tori     1978.0   \n",
       "100             97                          La Grande Illusion     1937.0   \n",
       "101             98                                  The Return     2003.0   \n",
       "103            101                 Revenge of the Pink Panther     1978.0   \n",
       "117            109                                     Persona     1966.0   \n",
       "...            ...                                         ...        ...   \n",
       "4336088    7677655  A Haunting on Finn Road: The Devil's Grove     2018.0   \n",
       "4336090    7677659                             Holmes & Watson     2018.0   \n",
       "4336091    7677660                             Holmes & Watson     2018.0   \n",
       "4336092    7677661                                     Polisse     2011.0   \n",
       "4336093    7677665                                       Glass     2019.0   \n",
       "4336094    7677668                                       Glass     2019.0   \n",
       "4336095    7677669                              Apocalypse Now     1979.0   \n",
       "4336106    7677699                    Uri: The Surgical Strike     2019.0   \n",
       "4336188    7677844                            The Third Secret     1964.0   \n",
       "4336189    7677845                            The Third Secret     1964.0   \n",
       "4336190    7677846                         Las palabras de Max     1978.0   \n",
       "4336238    7677942                   A Charlie Brown Valentine     2002.0   \n",
       "4336254    7677968                The Girl in the Spider's Web     2018.0   \n",
       "4336255    7677970                           Empire of the Sun     1987.0   \n",
       "4336265    7678011                       Thank You for Smoking     2005.0   \n",
       "4336266    7678012                       Thank You for Smoking     2005.0   \n",
       "4336299    7678088                                        Ying     2018.0   \n",
       "4336300    7678092                   The Intent 2: The Come Up     2018.0   \n",
       "4336417    7678314                               City of Ember     2008.0   \n",
       "4336438    7678347                                    Bad Boys     1995.0   \n",
       "4336452    7678374           Eloisa esta debajo de un almendro     1943.0   \n",
       "4336504    7678483                                     L'ordre     1973.0   \n",
       "4336519    7678517                                Tangent Room     2017.0   \n",
       "4336521    7678519                                Tangent Room     2017.0   \n",
       "4336525    7678525                                   100 Yards     2018.0   \n",
       "4336538    7678552                             Scars of Xavier     2017.0   \n",
       "4336543    7678562                        Mary Poppins Returns     2018.0   \n",
       "4336547    7678569                                    La pelle     1981.0   \n",
       "4336548    7678570                                 Aki tachinu     1960.0   \n",
       "4336549    7678573                              Elephant White     2011.0   \n",
       "\n",
       "        LanguageName ISO639           SubAddDate   ImdbID SubFormat  SubSumCD  \\\n",
       "0            English     en  2004-10-31 23:54:23   103644       sub       2.0   \n",
       "2            English     en  2004-10-31 23:54:23   347246       srt       1.0   \n",
       "4            English     en  2004-11-01 20:11:53   112682       srt       2.0   \n",
       "12           English     en  2004-11-04 17:11:34   111512       srt       1.0   \n",
       "14           English     en  2004-11-04 17:16:21   385004       srt       2.0   \n",
       "16           English     en  2004-11-04 20:45:50   104770       srt       1.0   \n",
       "17           English     en  2004-11-04 20:52:44    42876       srt       1.0   \n",
       "18           English     en  2004-11-04 20:52:44    42876       smi       1.0   \n",
       "21           English     en  2004-11-04 20:58:02   188766       srt       1.0   \n",
       "22           English     en  2004-11-04 21:04:23   245429       sub       2.0   \n",
       "25           English     en  2004-11-04 21:15:46    96874       srt       2.0   \n",
       "26           English     en  2004-11-04 21:47:29   288477       srt       1.0   \n",
       "28           English     en  2004-11-04 21:55:18   104771       srt       1.0   \n",
       "30           English     en  2004-11-04 22:11:29   297181       srt       1.0   \n",
       "31           English     en  2004-11-04 22:15:53    94964       srt       1.0   \n",
       "35           English     en  2004-12-12 17:45:41   314111       srt       2.0   \n",
       "69           English     en  2005-01-30 15:24:05    85271       srt       1.0   \n",
       "71           English     en  2005-01-30 15:34:16    72730       sub       1.0   \n",
       "76           English     en  2005-02-01 00:44:58   105236       srt       1.0   \n",
       "78           English     en  2005-02-01 01:06:07   365376       srt       2.0   \n",
       "79           English     en  2005-02-01 01:24:58   295867       srt       1.0   \n",
       "80           English     en  2005-02-01 01:34:07   221889       srt       1.0   \n",
       "84           English     en  2005-02-03 00:56:49   109508       srt       1.0   \n",
       "85           English     en  2005-02-03 01:33:16    79891       srt       2.0   \n",
       "90           English     en  2005-02-04 08:53:58    92563       srt       1.0   \n",
       "92           English     en  2005-02-05 22:16:59    77673       srt       2.0   \n",
       "100          English     en  2005-02-12 21:16:08    28950       srt       2.0   \n",
       "101          English     en  2005-02-14 00:42:56   376968       srt       1.0   \n",
       "103          English     en  2005-02-16 00:52:29    78163       srt       1.0   \n",
       "117          English     en  2005-02-19 13:27:52    60827       srt       1.0   \n",
       "...              ...    ...                  ...      ...       ...       ...   \n",
       "4336088      English     en  2019-03-06 07:27:41  9584192       srt       1.0   \n",
       "4336090      English     en  2019-03-06 07:34:36  1255919       srt       1.0   \n",
       "4336091      English     en  2019-03-06 07:34:58  1255919       srt       1.0   \n",
       "4336092      English     en  2019-03-06 07:35:21  1661420       srt       1.0   \n",
       "4336093      English     en  2019-03-06 07:37:38  6823368       srt       1.0   \n",
       "4336094      English     en  2019-03-06 07:38:53  6823368       srt       1.0   \n",
       "4336095      English     en  2019-03-06 07:39:31    78788       srt       1.0   \n",
       "4336106      English     en  2019-03-06 09:15:21  8291224       srt       1.0   \n",
       "4336188      English     en  2019-03-06 13:09:02    58649       srt       1.0   \n",
       "4336189      English     en  2019-03-06 13:09:12    58649       srt       1.0   \n",
       "4336190      English     en  2019-03-06 13:10:10    76520       srt       1.0   \n",
       "4336238      English     en  2019-03-06 15:01:06   283987       srt       1.0   \n",
       "4336254      English     en  2019-03-06 15:30:28  5177088       srt       1.0   \n",
       "4336255      English     en  2019-03-06 15:33:47    92965       srt       1.0   \n",
       "4336265      English     en  2019-03-06 16:11:16   427944       srt       1.0   \n",
       "4336266      English     en  2019-03-06 16:12:32   427944       srt       1.0   \n",
       "4336299      English     en  2019-03-06 17:44:52  6864046       srt       1.0   \n",
       "4336300      English     en  2019-03-06 17:54:08  7613996       srt       1.0   \n",
       "4336417      English     en  2019-03-06 21:00:04   970411       srt       1.0   \n",
       "4336438      English     en  2019-03-06 21:41:38   112442       srt       1.0   \n",
       "4336452      English     en  2019-03-06 22:00:45    35840       srt       1.0   \n",
       "4336504      English     en  2019-03-07 01:15:57   234401       srt       1.0   \n",
       "4336519      English     en  2019-03-07 02:55:59  4230078       srt       1.0   \n",
       "4336521      English     en  2019-03-07 02:56:39  4230078       srt       1.0   \n",
       "4336525      English     en  2019-03-07 03:12:33  5258106       srt       1.0   \n",
       "4336538      English     en  2019-03-07 06:30:39  7346786       srt       1.0   \n",
       "4336543      English     en  2019-03-07 07:22:17  5028340       srt       1.0   \n",
       "4336547      English     en  2019-03-07 07:35:10    82893       srt       1.0   \n",
       "4336548      English     en  2019-03-07 07:35:46    53578       srt       1.0   \n",
       "4336549      English     en  2019-03-07 07:39:45  1578882       srt       1.0   \n",
       "\n",
       "                                          MovieReleaseName  MovieFPS  \\\n",
       "0                                                  Alien.3    11.000   \n",
       "2                               Innocence.2004.DVDRip.XviD    23.980   \n",
       "4         The.City.Of.Lost.Children.1995.iNTERNAL.DVDRi...    23.976   \n",
       "12                 Drunken.Master.2.Uncut.DVD-Rip.By.Ghost    23.976   \n",
       "14        House.Of.Flying.Daggers.2004.RETAIL.DVDRip.XV...    23.976   \n",
       "16                            Stephen Chow - Royal Tramp 1     0.000   \n",
       "17             rashomon_(1950).earthling10480.sharereactor     0.000   \n",
       "18                   rashomon_(1950).garandou.sharereactor     0.000   \n",
       "21                                          King of Comedy    23.980   \n",
       "22                                  Spirited Away - DVDRip     0.000   \n",
       "25                         Back To The Future II - English     0.000   \n",
       "26                                      Ghost Ship.English    25.000   \n",
       "28                            Stephen Chow - Royal Tramp 2     0.000   \n",
       "30                                           I Spy.English    23.976   \n",
       "31                      Dead.Ringers.(1988).DVDRip.DivX3LM    25.000   \n",
       "35                    Godzilla X MechaGodzilla (Hand Made)     0.000   \n",
       "69                                       Brainstorm (1983)     0.000   \n",
       "71                                A Boy And His Dog (1975)    23.976   \n",
       "76                           Reservoir Dogs - 1992 - [TWB]     0.000   \n",
       "78                             A.Tale.of.Two.Sisters.BiFOS     0.000   \n",
       "79           Audition_(1999).Japanese.SAPHiRE.ShareReactor    25.000   \n",
       "80           Beautiful Creatures [dvdrip] [divx pro 5.0.5]     0.000   \n",
       "84                            Crumb (1994) Kyprios.English    23.980   \n",
       "85        The.Shaolin.Temple.1979.DVDRip.XviD.AC3.TEAM ...    23.976   \n",
       "90                                                     NaN    23.980   \n",
       "92        Hi No Tori (The Phoenix) - (Kon Ichikawa, 197...    25.000   \n",
       "100                2_La.Grande.Illusion.(1937).Jean.Renoir    25.000   \n",
       "101                                             The Return    23.976   \n",
       "103                     Revenge.Of.The.Pink.Panther.(1978)    23.980   \n",
       "117                                                Persona     0.000   \n",
       "...                                                    ...       ...   \n",
       "4336088                                 DVDRip.x264-REGRET    23.976   \n",
       "4336090                       Holmes.and.Watson.2018.HDCAM    29.970   \n",
       "4336091                       Holmes.and.Watson.2018.HDCAM    29.970   \n",
       "4336092                           Polisse.2011.DVDRip.x264    29.970   \n",
       "4336093                 Glass.2019.NEW.HDCAM.x264.AC3-ETRG    29.970   \n",
       "4336094                 Glass.2019.NEW.HDCAM.x264.AC3-ETRG    29.970   \n",
       "4336095  Apocalypse.Now.Redux.1979.1080p.BluRay.X264-Ja...    23.976   \n",
       "4336106  URI The Surgical Strike (2019) Hindi HDRip - 7...    23.976   \n",
       "4336188      The.Third.Secret.1964.720p.BluRay.x264-GHOULS    23.976   \n",
       "4336189      The.Third.Secret.1964.720p.BluRay.x264-GHOULS    23.976   \n",
       "4336190              1080p.FO.WEB-DL.AAC2.0.H.264-CREATiVE    25.000   \n",
       "4336238   A.Charlie.Brown.Valentine.2002.1080p.WEBRip.A...    23.976   \n",
       "4336254  1080p.BluRay.x264-DRONES (Director Commentary ...    23.976   \n",
       "4336255   Empire of the Sun (1987)23.976fps- 152.49 min...    23.976   \n",
       "4336265   thank.you.for.smoking.2005.1080p.hdtv.x264-re...    23.976   \n",
       "4336266               1080p.AMZN.WEB-DL.DD+5.1.H.264-SiGMA    23.976   \n",
       "4336299       Shadow.2018.CHINESE.720p.BluRay.H264.AAC-VXT    24.000   \n",
       "4336300                          1080p.WEB-DL.H264.AC3-EVO    24.000   \n",
       "4336417   City.of.Ember.2008.1080p.BluRay.x264.Remux.VC...    24.000   \n",
       "4336438                           BdBys (1995) BRRip 550mb    23.976   \n",
       "4336452              1080p.FO.WEB-DL.AAC2.0.H.264-CREATiVE    25.000   \n",
       "4336504                                       l'ordre.1973     0.000   \n",
       "4336519               Tangent.Room.2019.HDRip.XviD.AC3-EVO    23.976   \n",
       "4336521               Tangent.Room.2019.HDRip.XviD.AC3-EVO    23.976   \n",
       "4336525                  100 Yards 2018.HDRip.XviD.AC3-EVO    23.976   \n",
       "4336538           Scars.of.Xavier.2017.HDRip.AC3.X264-CMRG    23.976   \n",
       "4336543      Mary.Poppins.Returns.2019.DVDRip.XviD.AC3-EVO    23.976   \n",
       "4336547                         vsn: 2h13'22''; remestered    24.000   \n",
       "4336548                            Aki.Tachinu.1960.Naruse    23.976   \n",
       "4336549     Elephant.White.2011.DUAL.COMPLETE.BLURAY-CLASH    23.976   \n",
       "\n",
       "         SeriesSeason  SeriesEpisode  SeriesIMDBParent MovieKind  \\\n",
       "0                 0.0            0.0               0.0     movie   \n",
       "2                 0.0            0.0               0.0     movie   \n",
       "4                 0.0            0.0               0.0     movie   \n",
       "12                0.0            0.0               0.0     movie   \n",
       "14                0.0            0.0               0.0     movie   \n",
       "16                0.0            0.0               0.0     movie   \n",
       "17                0.0            0.0               0.0     movie   \n",
       "18                0.0            0.0               0.0     movie   \n",
       "21                0.0            0.0               0.0     movie   \n",
       "22                0.0            0.0               0.0     movie   \n",
       "25                0.0            0.0               0.0     movie   \n",
       "26                0.0            0.0               0.0     movie   \n",
       "28                0.0            0.0               0.0     movie   \n",
       "30                0.0            0.0               0.0     movie   \n",
       "31                0.0            0.0               0.0     movie   \n",
       "35                0.0            0.0               0.0     movie   \n",
       "69                0.0            0.0               0.0     movie   \n",
       "71                0.0            0.0               0.0     movie   \n",
       "76                0.0            0.0               0.0     movie   \n",
       "78                0.0            0.0               0.0     movie   \n",
       "79                0.0            0.0               0.0     movie   \n",
       "80                0.0            0.0               0.0     movie   \n",
       "84                0.0            0.0               0.0     movie   \n",
       "85                0.0            0.0               0.0     movie   \n",
       "90                0.0            0.0               0.0     movie   \n",
       "92                0.0            0.0               0.0     movie   \n",
       "100               0.0            0.0               0.0     movie   \n",
       "101               0.0            0.0               0.0     movie   \n",
       "103               0.0            0.0               0.0     movie   \n",
       "117               0.0            0.0               0.0     movie   \n",
       "...               ...            ...               ...       ...   \n",
       "4336088           0.0            0.0               0.0     movie   \n",
       "4336090           0.0            0.0               0.0     movie   \n",
       "4336091           0.0            0.0               0.0     movie   \n",
       "4336092           0.0            0.0               0.0     movie   \n",
       "4336093           0.0            0.0               0.0     movie   \n",
       "4336094           0.0            0.0               0.0     movie   \n",
       "4336095           0.0            0.0               0.0     movie   \n",
       "4336106           0.0            0.0               0.0     movie   \n",
       "4336188           0.0            0.0               0.0     movie   \n",
       "4336189           0.0            0.0               0.0     movie   \n",
       "4336190           0.0            0.0               0.0     movie   \n",
       "4336238           0.0            0.0               0.0     movie   \n",
       "4336254           0.0            0.0               0.0     movie   \n",
       "4336255           0.0            0.0               0.0     movie   \n",
       "4336265           0.0            0.0               0.0     movie   \n",
       "4336266           0.0            0.0               0.0     movie   \n",
       "4336299           0.0            0.0               0.0     movie   \n",
       "4336300           0.0            0.0               0.0     movie   \n",
       "4336417           0.0            0.0               0.0     movie   \n",
       "4336438           0.0            0.0               0.0     movie   \n",
       "4336452           0.0            0.0               0.0     movie   \n",
       "4336504           0.0            0.0               0.0     movie   \n",
       "4336519           0.0            0.0               0.0     movie   \n",
       "4336521           0.0            0.0               0.0     movie   \n",
       "4336525           0.0            0.0               0.0     movie   \n",
       "4336538           0.0            0.0               0.0     movie   \n",
       "4336543           0.0            0.0               0.0     movie   \n",
       "4336547           0.0            0.0               0.0     movie   \n",
       "4336548           0.0            0.0               0.0     movie   \n",
       "4336549           0.0            0.0               0.0     movie   \n",
       "\n",
       "                                                       URL  \n",
       "0        http://www.opensubtitles.org/subtitles/1/alien...  \n",
       "2        http://www.opensubtitles.org/subtitles/3/ghost...  \n",
       "4        http://www.opensubtitles.org/subtitles/5/the-c...  \n",
       "12       http://www.opensubtitles.org/subtitles/13/jui-...  \n",
       "14       http://www.opensubtitles.org/subtitles/14/hous...  \n",
       "16       http://www.opensubtitles.org/subtitles/16/lu-d...  \n",
       "17       http://www.opensubtitles.org/subtitles/17/rash...  \n",
       "18       http://www.opensubtitles.org/subtitles/18/rash...  \n",
       "21       http://www.opensubtitles.org/subtitles/20/hei-...  \n",
       "22       http://www.opensubtitles.org/subtitles/21/spir...  \n",
       "25       http://www.opensubtitles.org/subtitles/23/back...  \n",
       "26       http://www.opensubtitles.org/subtitles/24/ghos...  \n",
       "28       http://www.opensubtitles.org/subtitles/26/lu-d...  \n",
       "30       http://www.opensubtitles.org/subtitles/28/i-sp...  \n",
       "31       http://www.opensubtitles.org/subtitles/29/dead...  \n",
       "35       http://www.opensubtitles.org/subtitles/32/goji...  \n",
       "69       http://www.opensubtitles.org/subtitles/65/brai...  \n",
       "71       http://www.opensubtitles.org/subtitles/67/a-bo...  \n",
       "76       http://www.opensubtitles.org/subtitles/72/rese...  \n",
       "78       http://www.opensubtitles.org/subtitles/74/a-ta...  \n",
       "79       http://www.opensubtitles.org/subtitles/75/audi...  \n",
       "80       http://www.opensubtitles.org/subtitles/76/beau...  \n",
       "84       http://www.opensubtitles.org/subtitles/80/crum...  \n",
       "85       http://www.opensubtitles.org/subtitles/81/shao...  \n",
       "90       http://www.opensubtitles.org/subtitles/86/ange...  \n",
       "92       http://www.opensubtitles.org/subtitles/88/hi-n...  \n",
       "100      http://www.opensubtitles.org/subtitles/97/la-g...  \n",
       "101      http://www.opensubtitles.org/subtitles/98/the-...  \n",
       "103      http://www.opensubtitles.org/subtitles/101/rev...  \n",
       "117      http://www.opensubtitles.org/subtitles/109/per...  \n",
       "...                                                    ...  \n",
       "4336088  http://www.opensubtitles.org/subtitles/7677655...  \n",
       "4336090  http://www.opensubtitles.org/subtitles/7677659...  \n",
       "4336091  http://www.opensubtitles.org/subtitles/7677660...  \n",
       "4336092  http://www.opensubtitles.org/subtitles/7677661...  \n",
       "4336093  http://www.opensubtitles.org/subtitles/7677665...  \n",
       "4336094  http://www.opensubtitles.org/subtitles/7677668...  \n",
       "4336095  http://www.opensubtitles.org/subtitles/7677669...  \n",
       "4336106  http://www.opensubtitles.org/subtitles/7677699...  \n",
       "4336188  http://www.opensubtitles.org/subtitles/7677844...  \n",
       "4336189  http://www.opensubtitles.org/subtitles/7677845...  \n",
       "4336190  http://www.opensubtitles.org/subtitles/7677846...  \n",
       "4336238  http://www.opensubtitles.org/subtitles/7677942...  \n",
       "4336254  http://www.opensubtitles.org/subtitles/7677968...  \n",
       "4336255  http://www.opensubtitles.org/subtitles/7677970...  \n",
       "4336265  http://www.opensubtitles.org/subtitles/7678011...  \n",
       "4336266  http://www.opensubtitles.org/subtitles/7678012...  \n",
       "4336299  http://www.opensubtitles.org/subtitles/7678088...  \n",
       "4336300  http://www.opensubtitles.org/subtitles/7678092...  \n",
       "4336417  http://www.opensubtitles.org/subtitles/7678314...  \n",
       "4336438  http://www.opensubtitles.org/subtitles/7678347...  \n",
       "4336452  http://www.opensubtitles.org/subtitles/7678374...  \n",
       "4336504  http://www.opensubtitles.org/subtitles/7678483...  \n",
       "4336519  http://www.opensubtitles.org/subtitles/7678517...  \n",
       "4336521  http://www.opensubtitles.org/subtitles/7678519...  \n",
       "4336525  http://www.opensubtitles.org/subtitles/7678525...  \n",
       "4336538  http://www.opensubtitles.org/subtitles/7678552...  \n",
       "4336543  http://www.opensubtitles.org/subtitles/7678562...  \n",
       "4336547  http://www.opensubtitles.org/subtitles/7678569...  \n",
       "4336548  http://www.opensubtitles.org/subtitles/7678570...  \n",
       "4336549  http://www.opensubtitles.org/subtitles/7678573...  \n",
       "\n",
       "[228490 rows x 16 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    http://www.opensubtitles.org/subtitles/1/alien...\n",
       "2    http://www.opensubtitles.org/subtitles/3/ghost...\n",
       "Name: URL, dtype: object"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2.URL[:2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>IDSubtitle</th>\n",
       "      <th>MovieName</th>\n",
       "      <th>MovieYear</th>\n",
       "      <th>LanguageName</th>\n",
       "      <th>ISO639</th>\n",
       "      <th>SubAddDate</th>\n",
       "      <th>ImdbID</th>\n",
       "      <th>SubFormat</th>\n",
       "      <th>SubSumCD</th>\n",
       "      <th>MovieReleaseName</th>\n",
       "      <th>MovieFPS</th>\n",
       "      <th>SeriesSeason</th>\n",
       "      <th>SeriesEpisode</th>\n",
       "      <th>SeriesIMDBParent</th>\n",
       "      <th>MovieKind</th>\n",
       "      <th>URL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3960657</th>\n",
       "      <td>7270681</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2011-12-29 23:14:13</td>\n",
       "      <td>0</td>\n",
       "      <td>srt</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Itineraire d'un cine-fils 2</td>\n",
       "      <td>25.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7270681...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4224585</th>\n",
       "      <td>7550945</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2018-11-23 07:12:11</td>\n",
       "      <td>0</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>One Direction: I Want</td>\n",
       "      <td>25.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7550945...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2759683</th>\n",
       "      <td>5924110</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2014-12-10 05:38:47</td>\n",
       "      <td>0</td>\n",
       "      <td>srt</td>\n",
       "      <td>112.0</td>\n",
       "      <td>MOOC Video Collection [ml-class] [Stanford Mac...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/5924110...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3958932</th>\n",
       "      <td>7268820</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2005-03-01 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>sub</td>\n",
       "      <td>1.0</td>\n",
       "      <td>the.sounds.of.soul eng</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7268820...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188072</th>\n",
       "      <td>7268819</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2005-03-01 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>sub</td>\n",
       "      <td>1.0</td>\n",
       "      <td>britan.invades.america.fights.back en</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7268819...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92669</th>\n",
       "      <td>7270951</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2005-03-31 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>srt</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Prologo</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7270951...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3419513</th>\n",
       "      <td>6686908</td>\n",
       "      <td>Rocco Ravishes St. Petersburg</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2016-07-17 16:39:46</td>\n",
       "      <td>1000000</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Joseph Stiglitz - Can we make a gobalization t...</td>\n",
       "      <td>24.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/6686908...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254106</th>\n",
       "      <td>3102632</td>\n",
       "      <td>Painful Deceptions</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2007-02-12 19:13:45</td>\n",
       "      <td>10000011</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Painful Deceptions</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/3102632...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378932</th>\n",
       "      <td>3251921</td>\n",
       "      <td>Himekishi Lilia</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2008-02-21 13:15:53</td>\n",
       "      <td>10000020</td>\n",
       "      <td>ssa</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Himekishi Lilia Vol.3</td>\n",
       "      <td>23.976</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/3251921...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378930</th>\n",
       "      <td>3251919</td>\n",
       "      <td>Himekishi Lilia</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2008-02-21 13:11:46</td>\n",
       "      <td>10000020</td>\n",
       "      <td>ssa</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[X-SASG] Himekishi Lilia 1.mkv</td>\n",
       "      <td>23.976</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/3251919...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378931</th>\n",
       "      <td>3251920</td>\n",
       "      <td>Himekishi Lilia</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2008-02-21 13:13:26</td>\n",
       "      <td>10000020</td>\n",
       "      <td>ssa</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Himekishi Lilia Vol.2</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/3251920...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>380267</th>\n",
       "      <td>3253382</td>\n",
       "      <td>Swishahouse feat. Webbie Lil' Keke &amp; Yung Redd...</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2008-02-25 15:43:18</td>\n",
       "      <td>10000023</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Swishahouse feat. Webbie Lil' Keke &amp; Yung Redd...</td>\n",
       "      <td>29.970</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/3253382...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>320839</th>\n",
       "      <td>3174545</td>\n",
       "      <td>Billy &amp; Mandy's Big Boogey Adventure</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2008-01-05 15:38:58</td>\n",
       "      <td>1000070</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>wpi</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/3174545...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>788904</th>\n",
       "      <td>3694495</td>\n",
       "      <td>Bulletproof</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2010-06-29 03:38:25</td>\n",
       "      <td>1000072</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>bulletproof [A Release-lounge H264]</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/3694495...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128246</th>\n",
       "      <td>130493</td>\n",
       "      <td>Liu jai yim taam</td>\n",
       "      <td>1987.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2003-01-14 00:00:00</td>\n",
       "      <td>100014</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>EROTIC GHOST STORY</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/130493/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212312</th>\n",
       "      <td>215629</td>\n",
       "      <td>Liu jai yim taam</td>\n",
       "      <td>1987.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2005-03-01 00:00:00</td>\n",
       "      <td>100014</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Erotic ghost story dvdrip engsub</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/215629/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>296045</th>\n",
       "      <td>3147544</td>\n",
       "      <td>Sing kung chok tse sup yut tam</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2007-09-17 20:41:41</td>\n",
       "      <td>1000158</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Whispers and Moans</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/3147544...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284088</th>\n",
       "      <td>3134963</td>\n",
       "      <td>Sing kung chok tse sup yut tam</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2007-07-15 13:24:29</td>\n",
       "      <td>1000158</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Whipsers.And.Moans.2007.DVDRip.XViD-BiEN</td>\n",
       "      <td>23.980</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/3134963...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2647307</th>\n",
       "      <td>5804779</td>\n",
       "      <td>Life Is Sweet</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2014-08-29 04:37:47</td>\n",
       "      <td>100024</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Life.Is.Sweet.1990.Criterion.Collection.720p.B...</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/5804779...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1815895</th>\n",
       "      <td>4865410</td>\n",
       "      <td>Life Is Sweet</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2013-03-14 13:41:03</td>\n",
       "      <td>100024</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Life is Sweet (1990).DVDRip.XviD</td>\n",
       "      <td>25.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/4865410...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276455</th>\n",
       "      <td>3127013</td>\n",
       "      <td>Life Is Sweet</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2007-05-29 22:24:38</td>\n",
       "      <td>100024</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/3127013...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2086238</th>\n",
       "      <td>5177500</td>\n",
       "      <td>Life Is Sweet</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2013-09-15 07:20:28</td>\n",
       "      <td>100024</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Life.is.Sweet.1990.1080p.Criterion.Bluray.X264...</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/5177500...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2031495</th>\n",
       "      <td>5118353</td>\n",
       "      <td>Life Is Sweet</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2013-08-03 18:25:04</td>\n",
       "      <td>100024</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>life.is.sweet.1990.720p.bluray.x264-unveil</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/5118353...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2981350</th>\n",
       "      <td>6168489</td>\n",
       "      <td>Life Is Sweet</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2015-05-10 21:05:34</td>\n",
       "      <td>100024</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Life.Is.Sweet.1990.Proper.1080p.x264-SONiDO</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/6168489...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2981349</th>\n",
       "      <td>6168488</td>\n",
       "      <td>Life Is Sweet</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2015-05-10 21:05:16</td>\n",
       "      <td>100024</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Life.Is.Sweet.1990.Proper.1080p.x264-SONiDO</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/6168488...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1010961</th>\n",
       "      <td>3903773</td>\n",
       "      <td>Lionheart</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2010-10-21 01:03:05</td>\n",
       "      <td>100029</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>lh-vh</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/3903773...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3521897</th>\n",
       "      <td>6796695</td>\n",
       "      <td>Lionheart</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2016-11-14 22:49:25</td>\n",
       "      <td>100029</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Lionheart.1990.THEATRICAL.CUT.1080p.BluRay.H2...</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/6796695...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2835153</th>\n",
       "      <td>6002071</td>\n",
       "      <td>Lionheart</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2015-01-14 01:13:23</td>\n",
       "      <td>100029</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Lionheart 1990.srt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/6002071...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2970012</th>\n",
       "      <td>6171434</td>\n",
       "      <td>Lionheart</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2015-05-13 11:33:46</td>\n",
       "      <td>100029</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Lionheart.1990.1080p.BluRay.x264.YIFY</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/6171434...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3688126</th>\n",
       "      <td>7063608</td>\n",
       "      <td>Lisa</td>\n",
       "      <td>1989.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2017-08-11 09:56:01</td>\n",
       "      <td>100031</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>lisa.1989.dsr.x264-regret</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7063608...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204502</th>\n",
       "      <td>6436947</td>\n",
       "      <td>Korczak</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2015-12-25 21:54:06</td>\n",
       "      <td>99949</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Dottor Korczak</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/6436947...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1215995</th>\n",
       "      <td>4182738</td>\n",
       "      <td>Korczak</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2011-05-23 21:26:09</td>\n",
       "      <td>99949</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/4182738...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048595</th>\n",
       "      <td>3938092</td>\n",
       "      <td>Kracht</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2010-11-06 13:38:02</td>\n",
       "      <td>99950</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Kracht.1990.DVDRIP</td>\n",
       "      <td>25.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/3938092...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3065518</th>\n",
       "      <td>6267685</td>\n",
       "      <td>The Krays</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2015-08-11 15:42:36</td>\n",
       "      <td>99951</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>The.Krays 1990 HDRip-BONE en</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/6267685...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>388855</th>\n",
       "      <td>4198503</td>\n",
       "      <td>The Krays</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2011-06-26 17:20:28</td>\n",
       "      <td>99951</td>\n",
       "      <td>srt</td>\n",
       "      <td>2.0</td>\n",
       "      <td>The.Krays.1990.WS.DVDRip.XviD-FiCO</td>\n",
       "      <td>25.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/4198503...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258712</th>\n",
       "      <td>3108125</td>\n",
       "      <td>The Krays</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2007-03-01 20:58:30</td>\n",
       "      <td>99951</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>The Krays.1990.LIMITED.DVDRip.MeSSiaah</td>\n",
       "      <td>25.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/3108125...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>402547</th>\n",
       "      <td>4198500</td>\n",
       "      <td>The Krays</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2011-06-26 17:15:09</td>\n",
       "      <td>99951</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>The Krays-[1990]-Demonuk[NIKONRG]</td>\n",
       "      <td>25.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/4198500...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246276</th>\n",
       "      <td>3094153</td>\n",
       "      <td>The Krays</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2007-01-07 03:48:20</td>\n",
       "      <td>99951</td>\n",
       "      <td>srt</td>\n",
       "      <td>2.0</td>\n",
       "      <td>The.Krays.1990.WS.DVDRip.XviD-FiCO</td>\n",
       "      <td>25.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/3094153...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3743939</th>\n",
       "      <td>7001208</td>\n",
       "      <td>The Krays</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2017-06-03 05:56:40</td>\n",
       "      <td>99951</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>The.Krays.1990.720p.WEB-DL.AAC2.0.H264-FGT</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7001208...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1229603</th>\n",
       "      <td>4198499</td>\n",
       "      <td>The Krays</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2011-06-26 17:15:06</td>\n",
       "      <td>99951</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>The Krays-[1990]-Demonuk[NIKONRG]</td>\n",
       "      <td>25.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/4198499...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3743938</th>\n",
       "      <td>7001207</td>\n",
       "      <td>The Krays</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2017-06-03 05:56:10</td>\n",
       "      <td>99951</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>The.Krays.1990.720p.WEB-DL.AAC2.0.H264-FGT</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7001207...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3109202</th>\n",
       "      <td>6315316</td>\n",
       "      <td>Kuai le de xiao ji</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2015-09-24 09:19:43</td>\n",
       "      <td>99956</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Kuai.le.de.xiao.ji.1990.D5.x264.2Audio.AAC.480...</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/6315316...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1808272</th>\n",
       "      <td>4857252</td>\n",
       "      <td>Il 7 e l'8</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2013-03-10 19:24:56</td>\n",
       "      <td>999864</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>IL.7.E.L.8-Ficarra_Picone.2007.iTALiAN.DVDRip-...</td>\n",
       "      <td>25.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/4857252...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>462737</th>\n",
       "      <td>3365225</td>\n",
       "      <td>Thomas Kinkade's Christmas Cottage</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2008-11-07 19:15:31</td>\n",
       "      <td>999872</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Thomas.Kinkades.Christmas.Cottage-BULLDOZER (a...</td>\n",
       "      <td>23.980</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/3365225...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1235633</th>\n",
       "      <td>4206645</td>\n",
       "      <td>Heart of a Soul Surfer</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2011-07-13 15:47:42</td>\n",
       "      <td>999890</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/4206645...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1467473</th>\n",
       "      <td>4475967</td>\n",
       "      <td>Straw Dogs</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2012-02-23 01:05:48</td>\n",
       "      <td>999913</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Straw.Dogs.2011.x264.DTS-WAF</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/4475967...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421973</th>\n",
       "      <td>4423154</td>\n",
       "      <td>Straw Dogs</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2011-12-03 16:54:14</td>\n",
       "      <td>999913</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Straw.Dogs.2011.DVDRip.XviD-ViP3R</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/4423154...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421250</th>\n",
       "      <td>4422075</td>\n",
       "      <td>Straw Dogs</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2011-12-01 22:00:37</td>\n",
       "      <td>999913</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Straw.Dogs.2011.720p.BluRay.x264-Felony</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/4422075...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>993363</th>\n",
       "      <td>4422412</td>\n",
       "      <td>Straw Dogs</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2011-12-02 12:37:27</td>\n",
       "      <td>999913</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Straw.Dogs.2011.BDRip.XviD-Larceny</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/4422412...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421972</th>\n",
       "      <td>4423153</td>\n",
       "      <td>Straw Dogs</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2011-12-03 16:54:11</td>\n",
       "      <td>999913</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Straw.Dogs.2011.DVDRip.XviD-ViP3R</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/4423153...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>993365</th>\n",
       "      <td>4422414</td>\n",
       "      <td>Straw Dogs</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2011-12-02 12:38:31</td>\n",
       "      <td>999913</td>\n",
       "      <td>srt</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Straw.Dogs.2011.BDRip.XviD-Larceny</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/4422414...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3880705</th>\n",
       "      <td>7184584</td>\n",
       "      <td>Straw Dogs</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2017-12-08 11:50:12</td>\n",
       "      <td>999913</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Straw Dogs (2011)</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7184584...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3503267</th>\n",
       "      <td>6775710</td>\n",
       "      <td>Leatherface: Texas Chainsaw Massacre III</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2016-10-27 07:31:17</td>\n",
       "      <td>99994</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1080p.WEB-DL.AAC2.0.H264-FGT</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/6775710...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3954287</th>\n",
       "      <td>7264736</td>\n",
       "      <td>Leatherface: Texas Chainsaw Massacre III</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2018-02-22 18:46:32</td>\n",
       "      <td>99994</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Leatherface.Texas.Chainsaw.Massacre.III.1990.7...</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7264736...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3600164</th>\n",
       "      <td>7264737</td>\n",
       "      <td>Leatherface: Texas Chainsaw Massacre III</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2018-02-22 18:46:49</td>\n",
       "      <td>99994</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Leatherface.Texas.Chainsaw.Massacre.III.1990.7...</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7264737...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>630745</th>\n",
       "      <td>3537308</td>\n",
       "      <td>Leatherface: Texas Chainsaw Massacre III</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2009-07-20 12:33:01</td>\n",
       "      <td>99994</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Leatherface: Texas Chainsaw Massacre III</td>\n",
       "      <td>25.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/3537308...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72741</th>\n",
       "      <td>72459</td>\n",
       "      <td>Leatherface: Texas Chainsaw Massacre III</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2004-05-24 00:00:00</td>\n",
       "      <td>99994</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Leatherface: Texas Chainsaw Massacre III (1990)</td>\n",
       "      <td>29.970</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/72459/l...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4108930</th>\n",
       "      <td>7425616</td>\n",
       "      <td>Leatherface: Texas Chainsaw Massacre III</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2018-07-21 10:27:01</td>\n",
       "      <td>99994</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>LEATHERFACE (TEXAS CHAINSAW MASSACRE 3) (1990)</td>\n",
       "      <td>23.976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/7425616...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2003116</th>\n",
       "      <td>5086910</td>\n",
       "      <td>Lebedyne ozero-zona</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2013-07-14 09:09:23</td>\n",
       "      <td>99995</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Lebedyne ozero-zona</td>\n",
       "      <td>25.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/5086910...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>407840</th>\n",
       "      <td>3289866</td>\n",
       "      <td>The Fear Chamber</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>English</td>\n",
       "      <td>en</td>\n",
       "      <td>2008-05-29 14:17:13</td>\n",
       "      <td>999972</td>\n",
       "      <td>srt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>The.Fear.Chamber.FS.DVDRip.XviD-ARiSCO</td>\n",
       "      <td>23.980</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>movie</td>\n",
       "      <td>http://www.opensubtitles.org/subtitles/3289866...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>228490 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        IDSubtitle                                          MovieName  \\\n",
       "3960657    7270681                                                NaN   \n",
       "4224585    7550945                                                NaN   \n",
       "2759683    5924110                                                NaN   \n",
       "3958932    7268820                                                NaN   \n",
       "188072     7268819                                                NaN   \n",
       "92669      7270951                                                NaN   \n",
       "3419513    6686908                      Rocco Ravishes St. Petersburg   \n",
       "254106     3102632                                 Painful Deceptions   \n",
       "378932     3251921                                    Himekishi Lilia   \n",
       "378930     3251919                                    Himekishi Lilia   \n",
       "378931     3251920                                    Himekishi Lilia   \n",
       "380267     3253382  Swishahouse feat. Webbie Lil' Keke & Yung Redd...   \n",
       "320839     3174545               Billy & Mandy's Big Boogey Adventure   \n",
       "788904     3694495                                        Bulletproof   \n",
       "128246      130493                                   Liu jai yim taam   \n",
       "212312      215629                                   Liu jai yim taam   \n",
       "296045     3147544                     Sing kung chok tse sup yut tam   \n",
       "284088     3134963                     Sing kung chok tse sup yut tam   \n",
       "2647307    5804779                                      Life Is Sweet   \n",
       "1815895    4865410                                      Life Is Sweet   \n",
       "276455     3127013                                      Life Is Sweet   \n",
       "2086238    5177500                                      Life Is Sweet   \n",
       "2031495    5118353                                      Life Is Sweet   \n",
       "2981350    6168489                                      Life Is Sweet   \n",
       "2981349    6168488                                      Life Is Sweet   \n",
       "1010961    3903773                                          Lionheart   \n",
       "3521897    6796695                                          Lionheart   \n",
       "2835153    6002071                                          Lionheart   \n",
       "2970012    6171434                                          Lionheart   \n",
       "3688126    7063608                                               Lisa   \n",
       "...            ...                                                ...   \n",
       "204502     6436947                                            Korczak   \n",
       "1215995    4182738                                            Korczak   \n",
       "1048595    3938092                                             Kracht   \n",
       "3065518    6267685                                          The Krays   \n",
       "388855     4198503                                          The Krays   \n",
       "258712     3108125                                          The Krays   \n",
       "402547     4198500                                          The Krays   \n",
       "246276     3094153                                          The Krays   \n",
       "3743939    7001208                                          The Krays   \n",
       "1229603    4198499                                          The Krays   \n",
       "3743938    7001207                                          The Krays   \n",
       "3109202    6315316                                 Kuai le de xiao ji   \n",
       "1808272    4857252                                         Il 7 e l'8   \n",
       "462737     3365225                 Thomas Kinkade's Christmas Cottage   \n",
       "1235633    4206645                             Heart of a Soul Surfer   \n",
       "1467473    4475967                                         Straw Dogs   \n",
       "1421973    4423154                                         Straw Dogs   \n",
       "1421250    4422075                                         Straw Dogs   \n",
       "993363     4422412                                         Straw Dogs   \n",
       "1421972    4423153                                         Straw Dogs   \n",
       "993365     4422414                                         Straw Dogs   \n",
       "3880705    7184584                                         Straw Dogs   \n",
       "3503267    6775710           Leatherface: Texas Chainsaw Massacre III   \n",
       "3954287    7264736           Leatherface: Texas Chainsaw Massacre III   \n",
       "3600164    7264737           Leatherface: Texas Chainsaw Massacre III   \n",
       "630745     3537308           Leatherface: Texas Chainsaw Massacre III   \n",
       "72741        72459           Leatherface: Texas Chainsaw Massacre III   \n",
       "4108930    7425616           Leatherface: Texas Chainsaw Massacre III   \n",
       "2003116    5086910                                Lebedyne ozero-zona   \n",
       "407840     3289866                                   The Fear Chamber   \n",
       "\n",
       "         MovieYear LanguageName ISO639           SubAddDate    ImdbID  \\\n",
       "3960657        NaN      English     en  2011-12-29 23:14:13         0   \n",
       "4224585        NaN      English     en  2018-11-23 07:12:11         0   \n",
       "2759683        NaN      English     en  2014-12-10 05:38:47         0   \n",
       "3958932        NaN      English     en  2005-03-01 00:00:00         0   \n",
       "188072         NaN      English     en  2005-03-01 00:00:00         0   \n",
       "92669          NaN      English     en  2005-03-31 00:00:00         0   \n",
       "3419513     2007.0      English     en  2016-07-17 16:39:46   1000000   \n",
       "254106      2006.0      English     en  2007-02-12 19:13:45  10000011   \n",
       "378932      2006.0      English     en  2008-02-21 13:15:53  10000020   \n",
       "378930      2006.0      English     en  2008-02-21 13:11:46  10000020   \n",
       "378931      2006.0      English     en  2008-02-21 13:13:26  10000020   \n",
       "380267      2008.0      English     en  2008-02-25 15:43:18  10000023   \n",
       "320839      2007.0      English     en  2008-01-05 15:38:58   1000070   \n",
       "788904      2006.0      English     en  2010-06-29 03:38:25   1000072   \n",
       "128246      1987.0      English     en  2003-01-14 00:00:00    100014   \n",
       "212312      1987.0      English     en  2005-03-01 00:00:00    100014   \n",
       "296045      2007.0      English     en  2007-09-17 20:41:41   1000158   \n",
       "284088      2007.0      English     en  2007-07-15 13:24:29   1000158   \n",
       "2647307     1990.0      English     en  2014-08-29 04:37:47    100024   \n",
       "1815895     1990.0      English     en  2013-03-14 13:41:03    100024   \n",
       "276455      1990.0      English     en  2007-05-29 22:24:38    100024   \n",
       "2086238     1990.0      English     en  2013-09-15 07:20:28    100024   \n",
       "2031495     1990.0      English     en  2013-08-03 18:25:04    100024   \n",
       "2981350     1990.0      English     en  2015-05-10 21:05:34    100024   \n",
       "2981349     1990.0      English     en  2015-05-10 21:05:16    100024   \n",
       "1010961     1990.0      English     en  2010-10-21 01:03:05    100029   \n",
       "3521897     1990.0      English     en  2016-11-14 22:49:25    100029   \n",
       "2835153     1990.0      English     en  2015-01-14 01:13:23    100029   \n",
       "2970012     1990.0      English     en  2015-05-13 11:33:46    100029   \n",
       "3688126     1989.0      English     en  2017-08-11 09:56:01    100031   \n",
       "...            ...          ...    ...                  ...       ...   \n",
       "204502      1990.0      English     en  2015-12-25 21:54:06     99949   \n",
       "1215995     1990.0      English     en  2011-05-23 21:26:09     99949   \n",
       "1048595     1990.0      English     en  2010-11-06 13:38:02     99950   \n",
       "3065518     1990.0      English     en  2015-08-11 15:42:36     99951   \n",
       "388855      1990.0      English     en  2011-06-26 17:20:28     99951   \n",
       "258712      1990.0      English     en  2007-03-01 20:58:30     99951   \n",
       "402547      1990.0      English     en  2011-06-26 17:15:09     99951   \n",
       "246276      1990.0      English     en  2007-01-07 03:48:20     99951   \n",
       "3743939     1990.0      English     en  2017-06-03 05:56:40     99951   \n",
       "1229603     1990.0      English     en  2011-06-26 17:15:06     99951   \n",
       "3743938     1990.0      English     en  2017-06-03 05:56:10     99951   \n",
       "3109202     1990.0      English     en  2015-09-24 09:19:43     99956   \n",
       "1808272     2007.0      English     en  2013-03-10 19:24:56    999864   \n",
       "462737      2008.0      English     en  2008-11-07 19:15:31    999872   \n",
       "1235633     2007.0      English     en  2011-07-13 15:47:42    999890   \n",
       "1467473     2011.0      English     en  2012-02-23 01:05:48    999913   \n",
       "1421973     2011.0      English     en  2011-12-03 16:54:14    999913   \n",
       "1421250     2011.0      English     en  2011-12-01 22:00:37    999913   \n",
       "993363      2011.0      English     en  2011-12-02 12:37:27    999913   \n",
       "1421972     2011.0      English     en  2011-12-03 16:54:11    999913   \n",
       "993365      2011.0      English     en  2011-12-02 12:38:31    999913   \n",
       "3880705     2011.0      English     en  2017-12-08 11:50:12    999913   \n",
       "3503267     1990.0      English     en  2016-10-27 07:31:17     99994   \n",
       "3954287     1990.0      English     en  2018-02-22 18:46:32     99994   \n",
       "3600164     1990.0      English     en  2018-02-22 18:46:49     99994   \n",
       "630745      1990.0      English     en  2009-07-20 12:33:01     99994   \n",
       "72741       1990.0      English     en  2004-05-24 00:00:00     99994   \n",
       "4108930     1990.0      English     en  2018-07-21 10:27:01     99994   \n",
       "2003116     1990.0      English     en  2013-07-14 09:09:23     99995   \n",
       "407840      2009.0      English     en  2008-05-29 14:17:13    999972   \n",
       "\n",
       "        SubFormat  SubSumCD  \\\n",
       "3960657       srt       3.0   \n",
       "4224585       srt       1.0   \n",
       "2759683       srt     112.0   \n",
       "3958932       sub       1.0   \n",
       "188072        sub       1.0   \n",
       "92669         srt       4.0   \n",
       "3419513       srt       1.0   \n",
       "254106        srt       1.0   \n",
       "378932        ssa       1.0   \n",
       "378930        ssa       1.0   \n",
       "378931        ssa       1.0   \n",
       "380267        srt       1.0   \n",
       "320839        srt       1.0   \n",
       "788904        srt       1.0   \n",
       "128246        srt       1.0   \n",
       "212312        srt       1.0   \n",
       "296045        srt       1.0   \n",
       "284088        srt       1.0   \n",
       "2647307       srt       1.0   \n",
       "1815895       srt       1.0   \n",
       "276455        srt       1.0   \n",
       "2086238       srt       1.0   \n",
       "2031495       srt       1.0   \n",
       "2981350       srt       1.0   \n",
       "2981349       srt       1.0   \n",
       "1010961       srt       1.0   \n",
       "3521897       srt       1.0   \n",
       "2835153       srt       1.0   \n",
       "2970012       srt       1.0   \n",
       "3688126       srt       1.0   \n",
       "...           ...       ...   \n",
       "204502        srt       1.0   \n",
       "1215995       srt       1.0   \n",
       "1048595       srt       1.0   \n",
       "3065518       srt       1.0   \n",
       "388855        srt       2.0   \n",
       "258712        srt       1.0   \n",
       "402547        srt       1.0   \n",
       "246276        srt       2.0   \n",
       "3743939       srt       1.0   \n",
       "1229603       srt       1.0   \n",
       "3743938       srt       1.0   \n",
       "3109202       srt       1.0   \n",
       "1808272       srt       1.0   \n",
       "462737        srt       1.0   \n",
       "1235633       srt       1.0   \n",
       "1467473       srt       1.0   \n",
       "1421973       srt       1.0   \n",
       "1421250       srt       1.0   \n",
       "993363        srt       1.0   \n",
       "1421972       srt       1.0   \n",
       "993365        srt       2.0   \n",
       "3880705       srt       1.0   \n",
       "3503267       srt       1.0   \n",
       "3954287       srt       1.0   \n",
       "3600164       srt       1.0   \n",
       "630745        srt       1.0   \n",
       "72741         srt       1.0   \n",
       "4108930       srt       1.0   \n",
       "2003116       srt       1.0   \n",
       "407840        srt       1.0   \n",
       "\n",
       "                                          MovieReleaseName  MovieFPS  \\\n",
       "3960657                        Itineraire d'un cine-fils 2    25.000   \n",
       "4224585                              One Direction: I Want    25.000   \n",
       "2759683  MOOC Video Collection [ml-class] [Stanford Mac...     0.000   \n",
       "3958932                             the.sounds.of.soul eng     0.000   \n",
       "188072               britan.invades.america.fights.back en     0.000   \n",
       "92669                                              Prologo     0.000   \n",
       "3419513  Joseph Stiglitz - Can we make a gobalization t...    24.000   \n",
       "254106                                  Painful Deceptions     0.000   \n",
       "378932                               Himekishi Lilia Vol.3    23.976   \n",
       "378930                      [X-SASG] Himekishi Lilia 1.mkv    23.976   \n",
       "378931                               Himekishi Lilia Vol.2     0.000   \n",
       "380267   Swishahouse feat. Webbie Lil' Keke & Yung Redd...    29.970   \n",
       "320839                                                 wpi     0.000   \n",
       "788904                 bulletproof [A Release-lounge H264]     0.000   \n",
       "128246                                  EROTIC GHOST STORY     0.000   \n",
       "212312                   Erotic ghost story dvdrip engsub     23.976   \n",
       "296045                                  Whispers and Moans     0.000   \n",
       "284088            Whipsers.And.Moans.2007.DVDRip.XViD-BiEN    23.980   \n",
       "2647307  Life.Is.Sweet.1990.Criterion.Collection.720p.B...    23.976   \n",
       "1815895                   Life is Sweet (1990).DVDRip.XviD    25.000   \n",
       "276455                                                 NaN    25.000   \n",
       "2086238  Life.is.Sweet.1990.1080p.Criterion.Bluray.X264...    23.976   \n",
       "2031495         life.is.sweet.1990.720p.bluray.x264-unveil     0.000   \n",
       "2981350        Life.Is.Sweet.1990.Proper.1080p.x264-SONiDO    23.976   \n",
       "2981349        Life.Is.Sweet.1990.Proper.1080p.x264-SONiDO    23.976   \n",
       "1010961                                              lh-vh    23.976   \n",
       "3521897   Lionheart.1990.THEATRICAL.CUT.1080p.BluRay.H2...    23.976   \n",
       "2835153                                 Lionheart 1990.srt     0.000   \n",
       "2970012              Lionheart.1990.1080p.BluRay.x264.YIFY    23.976   \n",
       "3688126                          lisa.1989.dsr.x264-regret    23.976   \n",
       "...                                                    ...       ...   \n",
       "204502                                      Dottor Korczak     0.000   \n",
       "1215995                                                NaN    25.000   \n",
       "1048595                                 Kracht.1990.DVDRIP    25.000   \n",
       "3065518                       The.Krays 1990 HDRip-BONE en    23.976   \n",
       "388855                  The.Krays.1990.WS.DVDRip.XviD-FiCO    25.000   \n",
       "258712              The Krays.1990.LIMITED.DVDRip.MeSSiaah    25.000   \n",
       "402547                   The Krays-[1990]-Demonuk[NIKONRG]    25.000   \n",
       "246276                  The.Krays.1990.WS.DVDRip.XviD-FiCO    25.000   \n",
       "3743939         The.Krays.1990.720p.WEB-DL.AAC2.0.H264-FGT    23.976   \n",
       "1229603                  The Krays-[1990]-Demonuk[NIKONRG]    25.000   \n",
       "3743938         The.Krays.1990.720p.WEB-DL.AAC2.0.H264-FGT    23.976   \n",
       "3109202  Kuai.le.de.xiao.ji.1990.D5.x264.2Audio.AAC.480...    23.976   \n",
       "1808272  IL.7.E.L.8-Ficarra_Picone.2007.iTALiAN.DVDRip-...    25.000   \n",
       "462737   Thomas.Kinkades.Christmas.Cottage-BULLDOZER (a...    23.980   \n",
       "1235633                                                NaN    23.976   \n",
       "1467473                       Straw.Dogs.2011.x264.DTS-WAF    23.976   \n",
       "1421973                  Straw.Dogs.2011.DVDRip.XviD-ViP3R    23.976   \n",
       "1421250            Straw.Dogs.2011.720p.BluRay.x264-Felony    23.976   \n",
       "993363                  Straw.Dogs.2011.BDRip.XviD-Larceny    23.976   \n",
       "1421972                  Straw.Dogs.2011.DVDRip.XviD-ViP3R    23.976   \n",
       "993365                  Straw.Dogs.2011.BDRip.XviD-Larceny    23.976   \n",
       "3880705                                  Straw Dogs (2011)    23.976   \n",
       "3503267                       1080p.WEB-DL.AAC2.0.H264-FGT    23.976   \n",
       "3954287  Leatherface.Texas.Chainsaw.Massacre.III.1990.7...    23.976   \n",
       "3600164  Leatherface.Texas.Chainsaw.Massacre.III.1990.7...    23.976   \n",
       "630745            Leatherface: Texas Chainsaw Massacre III    25.000   \n",
       "72741      Leatherface: Texas Chainsaw Massacre III (1990)    29.970   \n",
       "4108930     LEATHERFACE (TEXAS CHAINSAW MASSACRE 3) (1990)    23.976   \n",
       "2003116                                Lebedyne ozero-zona    25.000   \n",
       "407840              The.Fear.Chamber.FS.DVDRip.XviD-ARiSCO    23.980   \n",
       "\n",
       "         SeriesSeason  SeriesEpisode  SeriesIMDBParent MovieKind  \\\n",
       "3960657           NaN            NaN               NaN     movie   \n",
       "4224585           NaN            NaN               NaN     movie   \n",
       "2759683           NaN            NaN               NaN     movie   \n",
       "3958932           NaN            NaN               NaN     movie   \n",
       "188072            NaN            NaN               NaN     movie   \n",
       "92669             NaN            NaN               NaN     movie   \n",
       "3419513           0.0            0.0               0.0     movie   \n",
       "254106            NaN            NaN               0.0     movie   \n",
       "378932            NaN            NaN               0.0     movie   \n",
       "378930            NaN            NaN               0.0     movie   \n",
       "378931            NaN            NaN               0.0     movie   \n",
       "380267            NaN            NaN               0.0     movie   \n",
       "320839            0.0            0.0               0.0     movie   \n",
       "788904            0.0            0.0               0.0     movie   \n",
       "128246            0.0            0.0               0.0     movie   \n",
       "212312            0.0            0.0               0.0     movie   \n",
       "296045            0.0            0.0               0.0     movie   \n",
       "284088            0.0            0.0               0.0     movie   \n",
       "2647307           0.0            0.0               0.0     movie   \n",
       "1815895           0.0            0.0               0.0     movie   \n",
       "276455            0.0            0.0               0.0     movie   \n",
       "2086238           0.0            0.0               0.0     movie   \n",
       "2031495           0.0            0.0               0.0     movie   \n",
       "2981350           0.0            0.0               0.0     movie   \n",
       "2981349           0.0            0.0               0.0     movie   \n",
       "1010961           0.0            0.0               0.0     movie   \n",
       "3521897           0.0            0.0               0.0     movie   \n",
       "2835153           0.0            0.0               0.0     movie   \n",
       "2970012           0.0            0.0               0.0     movie   \n",
       "3688126           0.0            0.0               0.0     movie   \n",
       "...               ...            ...               ...       ...   \n",
       "204502            0.0            0.0               0.0     movie   \n",
       "1215995           0.0            0.0               0.0     movie   \n",
       "1048595           0.0            0.0               0.0     movie   \n",
       "3065518           0.0            0.0               0.0     movie   \n",
       "388855            0.0            0.0               0.0     movie   \n",
       "258712            0.0            0.0               0.0     movie   \n",
       "402547            0.0            0.0               0.0     movie   \n",
       "246276            0.0            0.0               0.0     movie   \n",
       "3743939           0.0            0.0               0.0     movie   \n",
       "1229603           0.0            0.0               0.0     movie   \n",
       "3743938           0.0            0.0               0.0     movie   \n",
       "3109202           0.0            0.0               0.0     movie   \n",
       "1808272           0.0            0.0               0.0     movie   \n",
       "462737            0.0            0.0               0.0     movie   \n",
       "1235633           0.0            0.0               0.0     movie   \n",
       "1467473           0.0            0.0               0.0     movie   \n",
       "1421973           0.0            0.0               0.0     movie   \n",
       "1421250           0.0            0.0               0.0     movie   \n",
       "993363            0.0            0.0               0.0     movie   \n",
       "1421972           0.0            0.0               0.0     movie   \n",
       "993365            0.0            0.0               0.0     movie   \n",
       "3880705           0.0            0.0               0.0     movie   \n",
       "3503267           0.0            0.0               0.0     movie   \n",
       "3954287           0.0            0.0               0.0     movie   \n",
       "3600164           0.0            0.0               0.0     movie   \n",
       "630745            0.0            0.0               0.0     movie   \n",
       "72741             0.0            0.0               0.0     movie   \n",
       "4108930           0.0            0.0               0.0     movie   \n",
       "2003116           0.0            0.0               0.0     movie   \n",
       "407840            0.0            0.0               0.0     movie   \n",
       "\n",
       "                                                       URL  \n",
       "3960657  http://www.opensubtitles.org/subtitles/7270681...  \n",
       "4224585  http://www.opensubtitles.org/subtitles/7550945...  \n",
       "2759683  http://www.opensubtitles.org/subtitles/5924110...  \n",
       "3958932  http://www.opensubtitles.org/subtitles/7268820...  \n",
       "188072   http://www.opensubtitles.org/subtitles/7268819...  \n",
       "92669    http://www.opensubtitles.org/subtitles/7270951...  \n",
       "3419513  http://www.opensubtitles.org/subtitles/6686908...  \n",
       "254106   http://www.opensubtitles.org/subtitles/3102632...  \n",
       "378932   http://www.opensubtitles.org/subtitles/3251921...  \n",
       "378930   http://www.opensubtitles.org/subtitles/3251919...  \n",
       "378931   http://www.opensubtitles.org/subtitles/3251920...  \n",
       "380267   http://www.opensubtitles.org/subtitles/3253382...  \n",
       "320839   http://www.opensubtitles.org/subtitles/3174545...  \n",
       "788904   http://www.opensubtitles.org/subtitles/3694495...  \n",
       "128246   http://www.opensubtitles.org/subtitles/130493/...  \n",
       "212312   http://www.opensubtitles.org/subtitles/215629/...  \n",
       "296045   http://www.opensubtitles.org/subtitles/3147544...  \n",
       "284088   http://www.opensubtitles.org/subtitles/3134963...  \n",
       "2647307  http://www.opensubtitles.org/subtitles/5804779...  \n",
       "1815895  http://www.opensubtitles.org/subtitles/4865410...  \n",
       "276455   http://www.opensubtitles.org/subtitles/3127013...  \n",
       "2086238  http://www.opensubtitles.org/subtitles/5177500...  \n",
       "2031495  http://www.opensubtitles.org/subtitles/5118353...  \n",
       "2981350  http://www.opensubtitles.org/subtitles/6168489...  \n",
       "2981349  http://www.opensubtitles.org/subtitles/6168488...  \n",
       "1010961  http://www.opensubtitles.org/subtitles/3903773...  \n",
       "3521897  http://www.opensubtitles.org/subtitles/6796695...  \n",
       "2835153  http://www.opensubtitles.org/subtitles/6002071...  \n",
       "2970012  http://www.opensubtitles.org/subtitles/6171434...  \n",
       "3688126  http://www.opensubtitles.org/subtitles/7063608...  \n",
       "...                                                    ...  \n",
       "204502   http://www.opensubtitles.org/subtitles/6436947...  \n",
       "1215995  http://www.opensubtitles.org/subtitles/4182738...  \n",
       "1048595  http://www.opensubtitles.org/subtitles/3938092...  \n",
       "3065518  http://www.opensubtitles.org/subtitles/6267685...  \n",
       "388855   http://www.opensubtitles.org/subtitles/4198503...  \n",
       "258712   http://www.opensubtitles.org/subtitles/3108125...  \n",
       "402547   http://www.opensubtitles.org/subtitles/4198500...  \n",
       "246276   http://www.opensubtitles.org/subtitles/3094153...  \n",
       "3743939  http://www.opensubtitles.org/subtitles/7001208...  \n",
       "1229603  http://www.opensubtitles.org/subtitles/4198499...  \n",
       "3743938  http://www.opensubtitles.org/subtitles/7001207...  \n",
       "3109202  http://www.opensubtitles.org/subtitles/6315316...  \n",
       "1808272  http://www.opensubtitles.org/subtitles/4857252...  \n",
       "462737   http://www.opensubtitles.org/subtitles/3365225...  \n",
       "1235633  http://www.opensubtitles.org/subtitles/4206645...  \n",
       "1467473  http://www.opensubtitles.org/subtitles/4475967...  \n",
       "1421973  http://www.opensubtitles.org/subtitles/4423154...  \n",
       "1421250  http://www.opensubtitles.org/subtitles/4422075...  \n",
       "993363   http://www.opensubtitles.org/subtitles/4422412...  \n",
       "1421972  http://www.opensubtitles.org/subtitles/4423153...  \n",
       "993365   http://www.opensubtitles.org/subtitles/4422414...  \n",
       "3880705  http://www.opensubtitles.org/subtitles/7184584...  \n",
       "3503267  http://www.opensubtitles.org/subtitles/6775710...  \n",
       "3954287  http://www.opensubtitles.org/subtitles/7264736...  \n",
       "3600164  http://www.opensubtitles.org/subtitles/7264737...  \n",
       "630745   http://www.opensubtitles.org/subtitles/3537308...  \n",
       "72741    http://www.opensubtitles.org/subtitles/72459/l...  \n",
       "4108930  http://www.opensubtitles.org/subtitles/7425616...  \n",
       "2003116  http://www.opensubtitles.org/subtitles/5086910...  \n",
       "407840   http://www.opensubtitles.org/subtitles/3289866...  \n",
       "\n",
       "[228490 rows x 16 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2.sort_values('ImdbID')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "http://www.opensubtitles.org/subtitles/1/alien3-en\n",
      "http://www.opensubtitles.org/subtitles/2/identity-sl\n",
      "http://www.opensubtitles.org/subtitles/3/ghost-in-the-shell-2-innocence-en\n"
     ]
    }
   ],
   "source": [
    "for d in df.URL[:3]:\n",
    "    print(d)"
   ]
  },
  {
   "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.6.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}