Skip to content

Latest commit

 

History

History
3864 lines (3760 loc) · 97.7 KB

2-get_subtitles_all.md

File metadata and controls

3864 lines (3760 loc) · 97.7 KB
Raw
import pandas as pd
pd.set_option('display.max_columns', 500)

import numpy as np
import requests
import gzip
url =' http://dl.opensubtitles.org/addons/export/subtitles_all.txt.gz'
raw_data = requests.get(url)
with open('subtitles_all.gz', 'wb+') as file:
    file.write(raw_data.content)
---------------------------------------------------------------------------

ParserError                               Traceback (most recent call last)

<ipython-input-4-4b2752d529cf> in <module>
      3 with open('subtitles_all.gz', 'wb+') as file:
      4     file.write(raw_data.content)
----> 5 df = pd.read_csv('subtitles_all.gz', compression='gzip', sep=r'\t', engine='python')
      6 df.to_pickle('subtitles_all.pickle')
      7 


~/.local/lib/python3.6/site-packages/pandas/io/parsers.py in parser_f(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)
    676                     skip_blank_lines=skip_blank_lines)
    677 
--> 678         return _read(filepath_or_buffer, kwds)
    679 
    680     parser_f.__name__ = name


~/.local/lib/python3.6/site-packages/pandas/io/parsers.py in _read(filepath_or_buffer, kwds)
    444 
    445     try:
--> 446         data = parser.read(nrows)
    447     finally:
    448         parser.close()


~/.local/lib/python3.6/site-packages/pandas/io/parsers.py in read(self, nrows)
   1034                 raise ValueError('skipfooter not supported for iteration')
   1035 
-> 1036         ret = self._engine.read(nrows)
   1037 
   1038         # May alter columns / col_dict


~/.local/lib/python3.6/site-packages/pandas/io/parsers.py in read(self, rows)
   2264             content = content[1:]
   2265 
-> 2266         alldata = self._rows_to_cols(content)
   2267         data = self._exclude_implicit_index(alldata)
   2268 


~/.local/lib/python3.6/site-packages/pandas/io/parsers.py in _rows_to_cols(self, content)
   2907                     msg += '. ' + reason
   2908 
-> 2909                 self._alert_malformed(msg, row_num + 1)
   2910 
   2911         # see gh-13320


~/.local/lib/python3.6/site-packages/pandas/io/parsers.py in _alert_malformed(self, msg, row_num)
   2674 
   2675         if self.error_bad_lines:
-> 2676             raise ParserError(msg)
   2677         elif self.warn_bad_lines:
   2678             base = 'Skipping line {row_num}: '.format(row_num=row_num)


ParserError: Expected 16 fields in line 2876, saw 17. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.

quotechar 
error_bad_lines 
warn_bad_lines 
def download_file(url,local_filename):
    #local_filename = url.split('/')[-1]
    # NOTE the stream=True parameter below
    with requests.get(url, stream=True) as r:
        with open(local_filename, 'wb') as f:
            for chunk in r.iter_content(chunk_size=8192): 
                if chunk: # filter out keep-alive new chunks
                    f.write(chunk)
                    f.flush()
    return local_filename
download_file(url,'subtitles_all.gz')
'subtitles_all2.gz'

df = pd.read_csv('subtitles_all.gz', compression='gzip', sep=r'\t', engine='python', 
                 quotechar='"', error_bad_lines=False, warn_bad_lines=True )
df.to_pickle('subtitles_all.pickle')
    
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.

df
<style scoped> .dataframe tbody tr th:only-of-type { vertical-align: middle; } 
.dataframe tbody tr th {
    vertical-align: top;
}

.dataframe thead th {
    text-align: right;
}
</style>
IDSubtitle MovieName MovieYear LanguageName ISO639 SubAddDate ImdbID SubFormat SubSumCD MovieReleaseName MovieFPS SeriesSeason SeriesEpisode SeriesIMDBParent MovieKind URL
0 1 Alien3 1992.0 English en 2004-10-31 23:54:23 103644 sub 2.0 Alien.3 11.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/1/alien...
1 2 Identity 2003.0 Slovenian sl 2004-10-31 23:54:23 309698 sub 1.0 Identity.DVDRiP.XViD 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/2/ident...
2 3 Ghost in the Shell 2: Innocence 2004.0 English en 2004-10-31 23:54:23 347246 srt 1.0 Innocence.2004.DVDRip.XviD 23.980 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/3/ghost...
3 4 Planet of the Apes 2001.0 Slovenian sl 2004-10-31 23:54:23 133152 sub 1.0 Planet.Of.The. Apes.XviD 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/4/plane...
4 5 The City of Lost Children 1995.0 English en 2004-11-01 20:11:53 112682 srt 2.0 The.City.Of.Lost.Children.1995.iNTERNAL.DVDRi... 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/5/the-c...
5 6 Antitrust 2001.0 Slovenian sl 2004-11-02 21:30:28 218817 sub 1.0 NaN 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/6/antit...
6 7 Dirty Pretty Things 2002.0 Slovenian sl 2004-11-03 11:58:18 301199 sub 1.0 NaN 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7/dirty...
7 8 Bringing Down the House 2003.0 Slovenian sl 2004-11-03 12:04:20 305669 srt 1.0 NaN 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/8/bring...
8 9 Cradle 2 the Grave 2003.0 Slovenian sl 2004-11-03 12:06:36 306685 srt 1.0 NaN 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/9/cradl...
9 10 Death to Smoochy 2002.0 Slovenian sl 2004-11-03 12:09:01 266452 sub 1.0 NaN 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/10/deat...
10 11 Hellboy 2004.0 Hungarian hu 2004-11-03 13:03:21 167190 srt 2.0 Hellboy.2004.DVDRip.XviD-DVP 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/11/hell...
11 12 American Gun 2002.0 Slovenian sl 2004-11-03 13:36:45 270197 sub 1.0 American Gun 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/12/amer...
12 13 Jui kuen II 1994.0 English en 2004-11-04 17:11:34 111512 srt 1.0 Drunken.Master.2.Uncut.DVD-Rip.By.Ghost 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/13/jui-...
13 4062580 "Bones" The Bodies in the Book 2007.0 Portuguese (BR) pb 2011-01-22 07:33:42 934029 srt 1.0 Bones.02x15 23.976 2.0 15.0 460627.0 tv http://www.opensubtitles.org/subtitles/4062580...
14 14 House of Flying Daggers 2004.0 English en 2004-11-04 17:16:21 385004 srt 2.0 House.Of.Flying.Daggers.2004.RETAIL.DVDRip.XV... 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/14/hous...
15 15 Femme Fatale 2002.0 Hungarian hu 2004-11-04 20:08:30 280665 srt 1.0 Femme.Fatale.DVDRip.XViD-ViTE 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/15/femm...
16 16 Lu ding ji 1992.0 English en 2004-11-04 20:45:50 104770 srt 1.0 Stephen Chow - Royal Tramp 1 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/16/lu-d...
17 17 Rashomon 1950.0 English en 2004-11-04 20:52:44 42876 srt 1.0 rashomon_(1950).earthling10480.sharereactor 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/17/rash...
18 18 Rashomon 1950.0 English en 2004-11-04 20:52:44 42876 smi 1.0 rashomon_(1950).garandou.sharereactor 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/18/rash...
19 4419719 The Valdemar Legacy 2010.0 Romanian ro 2011-11-28 00:16:20 1242744 srt 1.0 La.herencia.Valdemar.2010.720p.BluRay.x264-DON 24.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/4419719...
20 4419721 "The Big Bang Theory" The Flaming Spittoon Acq... 2011.0 Hungarian hu 2011-11-28 00:20:11 2105978 srt 1.0 The.Big.Bang.Theory.S05E10.HDTV.Swesub.XviD-Fl... 23.976 5.0 10.0 898266.0 tv http://www.opensubtitles.org/subtitles/4419721...
21 20 Hei kek ji wong 1999.0 English en 2004-11-04 20:58:02 188766 srt 1.0 King of Comedy 23.980 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/20/hei-...
22 21 Spirited Away 2001.0 English en 2004-11-04 21:04:23 245429 sub 2.0 Spirited Away - DVDRip 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/21/spir...
23 4420392 Atlas Shrugged: Part I 2011.0 Dutch nl 2011-11-29 00:16:57 480239 srt 1.0 Atlas.Shrugged.Part.1.LIMITED.2011.BRRip.XviD-... 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/4420392...
24 4420394 The Pianist 2002.0 Slovak sk 2011-11-29 00:18:09 253474 srt 1.0 The Pianist (moviesbyrizzo) HD 29.970 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/4420394...
25 23 Back to the Future Part II 1989.0 English en 2004-11-04 21:15:46 96874 srt 2.0 Back To The Future II - English 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/23/back...
26 24 Ghost Ship 2002.0 English en 2004-11-04 21:47:29 288477 srt 1.0 Ghost Ship.English 25.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/24/ghos...
27 25 Ghost Ship 2002.0 Hungarian hu 2004-11-04 21:47:29 288477 srt 1.0 Ghost.Ship.DVDRip.XviD-ViTE 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/25/ghos...
28 26 Lu ding ji II: Zhi shen long jiao 1992.0 English en 2004-11-04 21:55:18 104771 srt 1.0 Stephen Chow - Royal Tramp 2 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/26/lu-d...
29 4421144 "Rome" Death Mask 2007.0 Polish pl 2011-11-30 00:20:06 901366 mpl 1.0 Rome.S02E07.720p.BluRay.x264-MAjUS 0.000 2.0 7.0 384766.0 tv http://www.opensubtitles.org/subtitles/4421144...
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
4336528 7678533 "Supergirl" Elseworlds, Part 3 2018.0 Italian it 2019-03-07 03:41:04 8883894 srt 1.0 supergirl.s04e09.WEBRip.sub.ita.A7A 23.976 4.0 9.0 4016454.0 tv http://www.opensubtitles.org/subtitles/7678533...
4336529 7678534 "American Dad!" The Best Christmas Story Never 2006.0 Greek el 2019-03-07 03:46:58 920930 srt 1.0 American Dad S02E09 The Best Christmas Story ... 25.000 2.0 9.0 397306.0 tv http://www.opensubtitles.org/subtitles/7678534...
4336530 7678535 "The Passage" You Are Not That Girl Anymore 2019.0 Spanish es 2019-03-07 03:54:32 9252966 srt 1.0 You are not that girl anymore 23.976 1.0 8.0 1074206.0 tv http://www.opensubtitles.org/subtitles/7678535...
4336531 7678536 "The Good Doctor" Breakdown 2019.0 Portuguese (BR) pb 2019-03-07 03:56:09 9660060 srt 1.0 The.Good.Doctor.S02E17.720p.HDTV.x264-KILLERS 23.976 2.0 17.0 6470478.0 tv http://www.opensubtitles.org/subtitles/7678536...
4336532 7678538 "Narcos: Mexico" Camelot 2018.0 Croatian hr 2019-03-07 04:16:56 6038978 srt 1.0 Narcos.Mexico.S01E01.720p.WEBRip.x265-HETeam 25.000 1.0 1.0 8714904.0 tv http://www.opensubtitles.org/subtitles/7678538...
4336533 7678544 Koi... Mil Gaya 2003.0 Sinhalese si 2019-03-07 05:52:29 254481 srt 1.0 koi mil gaya full movie hd 1080p full movie i... 25.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7678544...
4336534 7678545 "Grey's Anatomy" Blood and Water 2019.0 English en 2019-03-07 05:56:25 9611710 srt 1.0 Greys.Anatomy.S15E16.HDTV.x264-KILLERS 23.976 15.0 16.0 413573.0 tv http://www.opensubtitles.org/subtitles/7678545...
4336535 7678546 "Grey's Anatomy" Blood and Water 2019.0 English en 2019-03-07 05:56:42 9611710 srt 1.0 Greys.Anatomy.S15E16.HDTV.x264-KILLERS 23.976 15.0 16.0 413573.0 tv http://www.opensubtitles.org/subtitles/7678546...
4336536 7678547 "Miracle Workers" Episode #1.3 2019.0 Romanian ro 2019-03-07 05:58:55 7793086 srt 1.0 miracle.workers.2019.s01e03.720p.webrip.x264-tbs 23.976 1.0 3.0 7529770.0 tv http://www.opensubtitles.org/subtitles/7678547...
4336537 7678550 "Poirot" The Theft of the Royal Ruby 1991.0 Italian it 2019-03-07 06:30:04 676187 srt 1.0 The Theft of the Royal Ruby (1991) 25.000 3.0 9.0 94525.0 tv http://www.opensubtitles.org/subtitles/7678550...
4336538 7678552 Scars of Xavier 2017.0 English en 2019-03-07 06:30:39 7346786 srt 1.0 Scars.of.Xavier.2017.HDRip.AC3.X264-CMRG 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7678552...
4336539 7678556 "I Am the Night" Queen's Gambit, Accepted 2019.0 English en 2019-03-07 06:46:50 7767664 srt 1.0 I.Am.the.Night.S01E06.720p.AMZN.WEBRip.DDP5.1.... 23.976 1.0 6.0 7186588.0 tv http://www.opensubtitles.org/subtitles/7678556...
4336540 7678557 "New Amsterdam" Anima Sola 2019.0 Finnish fi 2019-03-07 06:48:56 9556974 srt 1.0 New.Amsterdam.2018.S01E12.720p.HEVC.x265-MeGus... 23.976 1.0 12.0 7817340.0 tv http://www.opensubtitles.org/subtitles/7678557...
4336541 7678558 "Ray Donovan" Chinese Algebra 2016.0 Hebrew he 2019-03-07 07:01:26 5347010 srt 1.0 Ray.Donovan.S04E11.720p.HDTV.x264-FLEET (1) 25.000 4.0 11.0 2249007.0 tv http://www.opensubtitles.org/subtitles/7678558...
4336542 7678559 "Documentary Now!" Episode #3.4 2019.0 English en 2019-03-07 07:11:11 8211428 srt 1.0 Documentary.Now.S03E04.480p.x264-mSD 0.000 3.0 4.0 4677934.0 tv http://www.opensubtitles.org/subtitles/7678559...
4336543 7678562 Mary Poppins Returns 2018.0 English en 2019-03-07 07:22:17 5028340 srt 1.0 Mary.Poppins.Returns.2019.DVDRip.XviD.AC3-EVO 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7678562...
4336544 7678565 Ralph Breaks the Internet 2018.0 Greek el 2019-03-07 07:31:26 5848272 srt 1.0 Ralph.Breaks.The.Internet.2018.1080p.WEBRip.x2... 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7678565...
4336545 7678566 "New Amsterdam" Croaklahoma 2019.0 Danish da 2019-03-07 07:33:09 9809748 srt 1.0 New.Amsterdam.2018.S01E15.iNTERNAL.720p.WEB.h... 23.976 1.0 15.0 7817340.0 tv http://www.opensubtitles.org/subtitles/7678566...
4336546 7678567 "New Amsterdam" Croaklahoma 2019.0 Finnish fi 2019-03-07 07:33:23 9809748 srt 1.0 New.Amsterdam.2018.S01E15.iNTERNAL.720p.WEB.h... 23.976 1.0 15.0 7817340.0 tv http://www.opensubtitles.org/subtitles/7678567...
4336547 7678569 La pelle 1981.0 English en 2019-03-07 07:35:10 82893 srt 1.0 vsn: 2h13'22''; remestered 24.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7678569...
4336548 7678570 Aki tachinu 1960.0 English en 2019-03-07 07:35:46 53578 srt 1.0 Aki.Tachinu.1960.Naruse 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7678570...
4336549 7678573 Elephant White 2011.0 English en 2019-03-07 07:39:45 1578882 srt 1.0 Elephant.White.2011.DUAL.COMPLETE.BLURAY-CLASH 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7678573...
4336550 7678574 "Gotham" Legend of the Dark Knight: Nothing's ... 2019.0 Spanish es 2019-03-07 07:42:54 8413462 srt 1.0 Gotham 5x08 - Nothing's Shocking 0.000 5.0 8.0 3749900.0 tv http://www.opensubtitles.org/subtitles/7678574...
4336551 7678575 "White Gold" Episode #2.1 2018.0 English en 2019-03-07 08:06:48 7082412 srt 1.0 White.Gold.S02E01.HDTV.x264-RBB 25.000 2.0 1.0 6010920.0 tv http://www.opensubtitles.org/subtitles/7678575...
4336552 7678576 "Ray Donovan" Rattus Rattus 2016.0 Hebrew he 2019-03-07 08:12:59 4937254 srt 1.0 Ray.Donovan.S04E12.720p.HDTV.x264-AVS 25.000 4.0 12.0 2249007.0 tv http://www.opensubtitles.org/subtitles/7678576...
4336553 7678582 "Shameless" BOOOOOOOOOOOONE! 2019.0 Bosnian bs 2019-03-07 08:32:19 8245474 srt 1.0 Shameless.US.S09E09.Boooooooooooone.720p.AMZN... 23.976 9.0 9.0 1586680.0 tv http://www.opensubtitles.org/subtitles/7678582...
4336554 7678588 "The Umbrella Academy" I Heard a Rumor 2019.0 Japanese ja 2019-03-07 08:36:19 8407436 srt 1.0 The.Umbrella.Academy.S01E08.I.Heard.a.Rumor.10... 23.976 1.0 8.0 1312171.0 tv http://www.opensubtitles.org/subtitles/7678588...
4336555 7678591 "ER" Another Perfect Day 1994.0 Polish pl 2019-03-07 08:39:53 567926 srt 1.0 ER.S01E07.Another.Perfect.Day.1080p.WEB-DL.DD+... 0.000 1.0 7.0 108757.0 tv http://www.opensubtitles.org/subtitles/7678591...
4336556 7678594 Vacation 1983.0 Korean ko 2019-03-07 08:59:28 85995 srt 1.0 National Lampoon's Vacation 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7678594...
4336557 7678595 "Suits" Stalking Horse 2019.0 Czech cs 2019-03-07 09:00:04 9318636 srt 1.0 Suits.S08E15.720p.HDTV.x264-AVS 23.976 8.0 15.0 1632701.0 tv http://www.opensubtitles.org/subtitles/7678595...

4336558 rows × 16 columns

df.shape
(4336558, 16)

df2 = df[df.MovieKind == 'movie']
df2 = df2[df2.ISO639 == 'en']
df2.shape
(228490, 16)

df2
<style scoped> .dataframe tbody tr th:only-of-type { vertical-align: middle; } 
.dataframe tbody tr th {
    vertical-align: top;
}

.dataframe thead th {
    text-align: right;
}
</style>
IDSubtitle MovieName MovieYear LanguageName ISO639 SubAddDate ImdbID SubFormat SubSumCD MovieReleaseName MovieFPS SeriesSeason SeriesEpisode SeriesIMDBParent MovieKind URL
0 1 Alien3 1992.0 English en 2004-10-31 23:54:23 103644 sub 2.0 Alien.3 11.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/1/alien...
2 3 Ghost in the Shell 2: Innocence 2004.0 English en 2004-10-31 23:54:23 347246 srt 1.0 Innocence.2004.DVDRip.XviD 23.980 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/3/ghost...
4 5 The City of Lost Children 1995.0 English en 2004-11-01 20:11:53 112682 srt 2.0 The.City.Of.Lost.Children.1995.iNTERNAL.DVDRi... 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/5/the-c...
12 13 Jui kuen II 1994.0 English en 2004-11-04 17:11:34 111512 srt 1.0 Drunken.Master.2.Uncut.DVD-Rip.By.Ghost 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/13/jui-...
14 14 House of Flying Daggers 2004.0 English en 2004-11-04 17:16:21 385004 srt 2.0 House.Of.Flying.Daggers.2004.RETAIL.DVDRip.XV... 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/14/hous...
16 16 Lu ding ji 1992.0 English en 2004-11-04 20:45:50 104770 srt 1.0 Stephen Chow - Royal Tramp 1 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/16/lu-d...
17 17 Rashomon 1950.0 English en 2004-11-04 20:52:44 42876 srt 1.0 rashomon_(1950).earthling10480.sharereactor 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/17/rash...
18 18 Rashomon 1950.0 English en 2004-11-04 20:52:44 42876 smi 1.0 rashomon_(1950).garandou.sharereactor 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/18/rash...
21 20 Hei kek ji wong 1999.0 English en 2004-11-04 20:58:02 188766 srt 1.0 King of Comedy 23.980 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/20/hei-...
22 21 Spirited Away 2001.0 English en 2004-11-04 21:04:23 245429 sub 2.0 Spirited Away - DVDRip 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/21/spir...
25 23 Back to the Future Part II 1989.0 English en 2004-11-04 21:15:46 96874 srt 2.0 Back To The Future II - English 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/23/back...
26 24 Ghost Ship 2002.0 English en 2004-11-04 21:47:29 288477 srt 1.0 Ghost Ship.English 25.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/24/ghos...
28 26 Lu ding ji II: Zhi shen long jiao 1992.0 English en 2004-11-04 21:55:18 104771 srt 1.0 Stephen Chow - Royal Tramp 2 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/26/lu-d...
30 28 I Spy 2002.0 English en 2004-11-04 22:11:29 297181 srt 1.0 I Spy.English 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/28/i-sp...
31 29 Dead Ringers 1988.0 English en 2004-11-04 22:15:53 94964 srt 1.0 Dead.Ringers.(1988).DVDRip.DivX3LM 25.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/29/dead...
35 32 Gojira X Mekagojira 2002.0 English en 2004-12-12 17:45:41 314111 srt 2.0 Godzilla X MechaGodzilla (Hand Made) 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/32/goji...
69 65 Brainstorm 1983.0 English en 2005-01-30 15:24:05 85271 srt 1.0 Brainstorm (1983) 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/65/brai...
71 67 A Boy and His Dog 1975.0 English en 2005-01-30 15:34:16 72730 sub 1.0 A Boy And His Dog (1975) 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/67/a-bo...
76 72 Reservoir Dogs 1992.0 English en 2005-02-01 00:44:58 105236 srt 1.0 Reservoir Dogs - 1992 - [TWB] 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/72/rese...
78 74 A Tale of Two Sisters 2003.0 English en 2005-02-01 01:06:07 365376 srt 2.0 A.Tale.of.Two.Sisters.BiFOS 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/74/a-ta...
79 75 Audition 1997.0 English en 2005-02-01 01:24:58 295867 srt 1.0 Audition_(1999).Japanese.SAPHiRE.ShareReactor 25.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/75/audi...
80 76 Beautiful Creatures 2000.0 English en 2005-02-01 01:34:07 221889 srt 1.0 Beautiful Creatures [dvdrip] [divx pro 5.0.5] 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/76/beau...
84 80 Crumb 1994.0 English en 2005-02-03 00:56:49 109508 srt 1.0 Crumb (1994) Kyprios.English 23.980 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/80/crum...
85 81 Shao Lin si 1982.0 English en 2005-02-03 01:33:16 79891 srt 2.0 The.Shaolin.Temple.1979.DVDRip.XviD.AC3.TEAM ... 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/81/shao...
90 86 Angel Heart 1987.0 English en 2005-02-04 08:53:58 92563 srt 1.0 NaN 23.980 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/86/ange...
92 88 Hi no tori 1978.0 English en 2005-02-05 22:16:59 77673 srt 2.0 Hi No Tori (The Phoenix) - (Kon Ichikawa, 197... 25.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/88/hi-n...
100 97 La Grande Illusion 1937.0 English en 2005-02-12 21:16:08 28950 srt 2.0 2_La.Grande.Illusion.(1937).Jean.Renoir 25.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/97/la-g...
101 98 The Return 2003.0 English en 2005-02-14 00:42:56 376968 srt 1.0 The Return 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/98/the-...
103 101 Revenge of the Pink Panther 1978.0 English en 2005-02-16 00:52:29 78163 srt 1.0 Revenge.Of.The.Pink.Panther.(1978) 23.980 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/101/rev...
117 109 Persona 1966.0 English en 2005-02-19 13:27:52 60827 srt 1.0 Persona 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/109/per...
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
4336088 7677655 A Haunting on Finn Road: The Devil's Grove 2018.0 English en 2019-03-06 07:27:41 9584192 srt 1.0 DVDRip.x264-REGRET 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7677655...
4336090 7677659 Holmes & Watson 2018.0 English en 2019-03-06 07:34:36 1255919 srt 1.0 Holmes.and.Watson.2018.HDCAM 29.970 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7677659...
4336091 7677660 Holmes & Watson 2018.0 English en 2019-03-06 07:34:58 1255919 srt 1.0 Holmes.and.Watson.2018.HDCAM 29.970 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7677660...
4336092 7677661 Polisse 2011.0 English en 2019-03-06 07:35:21 1661420 srt 1.0 Polisse.2011.DVDRip.x264 29.970 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7677661...
4336093 7677665 Glass 2019.0 English en 2019-03-06 07:37:38 6823368 srt 1.0 Glass.2019.NEW.HDCAM.x264.AC3-ETRG 29.970 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7677665...
4336094 7677668 Glass 2019.0 English en 2019-03-06 07:38:53 6823368 srt 1.0 Glass.2019.NEW.HDCAM.x264.AC3-ETRG 29.970 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7677668...
4336095 7677669 Apocalypse Now 1979.0 English en 2019-03-06 07:39:31 78788 srt 1.0 Apocalypse.Now.Redux.1979.1080p.BluRay.X264-Ja... 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7677669...
4336106 7677699 Uri: The Surgical Strike 2019.0 English en 2019-03-06 09:15:21 8291224 srt 1.0 URI The Surgical Strike (2019) Hindi HDRip - 7... 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7677699...
4336188 7677844 The Third Secret 1964.0 English en 2019-03-06 13:09:02 58649 srt 1.0 The.Third.Secret.1964.720p.BluRay.x264-GHOULS 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7677844...
4336189 7677845 The Third Secret 1964.0 English en 2019-03-06 13:09:12 58649 srt 1.0 The.Third.Secret.1964.720p.BluRay.x264-GHOULS 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7677845...
4336190 7677846 Las palabras de Max 1978.0 English en 2019-03-06 13:10:10 76520 srt 1.0 1080p.FO.WEB-DL.AAC2.0.H.264-CREATiVE 25.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7677846...
4336238 7677942 A Charlie Brown Valentine 2002.0 English en 2019-03-06 15:01:06 283987 srt 1.0 A.Charlie.Brown.Valentine.2002.1080p.WEBRip.A... 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7677942...
4336254 7677968 The Girl in the Spider's Web 2018.0 English en 2019-03-06 15:30:28 5177088 srt 1.0 1080p.BluRay.x264-DRONES (Director Commentary ... 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7677968...
4336255 7677970 Empire of the Sun 1987.0 English en 2019-03-06 15:33:47 92965 srt 1.0 Empire of the Sun (1987)23.976fps- 152.49 min... 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7677970...
4336265 7678011 Thank You for Smoking 2005.0 English en 2019-03-06 16:11:16 427944 srt 1.0 thank.you.for.smoking.2005.1080p.hdtv.x264-re... 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7678011...
4336266 7678012 Thank You for Smoking 2005.0 English en 2019-03-06 16:12:32 427944 srt 1.0 1080p.AMZN.WEB-DL.DD+5.1.H.264-SiGMA 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7678012...
4336299 7678088 Ying 2018.0 English en 2019-03-06 17:44:52 6864046 srt 1.0 Shadow.2018.CHINESE.720p.BluRay.H264.AAC-VXT 24.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7678088...
4336300 7678092 The Intent 2: The Come Up 2018.0 English en 2019-03-06 17:54:08 7613996 srt 1.0 1080p.WEB-DL.H264.AC3-EVO 24.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7678092...
4336417 7678314 City of Ember 2008.0 English en 2019-03-06 21:00:04 970411 srt 1.0 City.of.Ember.2008.1080p.BluRay.x264.Remux.VC... 24.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7678314...
4336438 7678347 Bad Boys 1995.0 English en 2019-03-06 21:41:38 112442 srt 1.0 BdBys (1995) BRRip 550mb 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7678347...
4336452 7678374 Eloisa esta debajo de un almendro 1943.0 English en 2019-03-06 22:00:45 35840 srt 1.0 1080p.FO.WEB-DL.AAC2.0.H.264-CREATiVE 25.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7678374...
4336504 7678483 L'ordre 1973.0 English en 2019-03-07 01:15:57 234401 srt 1.0 l'ordre.1973 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7678483...
4336519 7678517 Tangent Room 2017.0 English en 2019-03-07 02:55:59 4230078 srt 1.0 Tangent.Room.2019.HDRip.XviD.AC3-EVO 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7678517...
4336521 7678519 Tangent Room 2017.0 English en 2019-03-07 02:56:39 4230078 srt 1.0 Tangent.Room.2019.HDRip.XviD.AC3-EVO 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7678519...
4336525 7678525 100 Yards 2018.0 English en 2019-03-07 03:12:33 5258106 srt 1.0 100 Yards 2018.HDRip.XviD.AC3-EVO 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7678525...
4336538 7678552 Scars of Xavier 2017.0 English en 2019-03-07 06:30:39 7346786 srt 1.0 Scars.of.Xavier.2017.HDRip.AC3.X264-CMRG 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7678552...
4336543 7678562 Mary Poppins Returns 2018.0 English en 2019-03-07 07:22:17 5028340 srt 1.0 Mary.Poppins.Returns.2019.DVDRip.XviD.AC3-EVO 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7678562...
4336547 7678569 La pelle 1981.0 English en 2019-03-07 07:35:10 82893 srt 1.0 vsn: 2h13'22''; remestered 24.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7678569...
4336548 7678570 Aki tachinu 1960.0 English en 2019-03-07 07:35:46 53578 srt 1.0 Aki.Tachinu.1960.Naruse 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7678570...
4336549 7678573 Elephant White 2011.0 English en 2019-03-07 07:39:45 1578882 srt 1.0 Elephant.White.2011.DUAL.COMPLETE.BLURAY-CLASH 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7678573...

228490 rows × 16 columns

df2.URL[:2]
0    http://www.opensubtitles.org/subtitles/1/alien...
2    http://www.opensubtitles.org/subtitles/3/ghost...
Name: URL, dtype: object

df2.sort_values('ImdbID')
<style scoped> .dataframe tbody tr th:only-of-type { vertical-align: middle; } 
.dataframe tbody tr th {
    vertical-align: top;
}

.dataframe thead th {
    text-align: right;
}
</style>
IDSubtitle MovieName MovieYear LanguageName ISO639 SubAddDate ImdbID SubFormat SubSumCD MovieReleaseName MovieFPS SeriesSeason SeriesEpisode SeriesIMDBParent MovieKind URL
3960657 7270681 NaN NaN English en 2011-12-29 23:14:13 0 srt 3.0 Itineraire d'un cine-fils 2 25.000 NaN NaN NaN movie http://www.opensubtitles.org/subtitles/7270681...
4224585 7550945 NaN NaN English en 2018-11-23 07:12:11 0 srt 1.0 One Direction: I Want 25.000 NaN NaN NaN movie http://www.opensubtitles.org/subtitles/7550945...
2759683 5924110 NaN NaN English en 2014-12-10 05:38:47 0 srt 112.0 MOOC Video Collection [ml-class] [Stanford Mac... 0.000 NaN NaN NaN movie http://www.opensubtitles.org/subtitles/5924110...
3958932 7268820 NaN NaN English en 2005-03-01 00:00:00 0 sub 1.0 the.sounds.of.soul eng 0.000 NaN NaN NaN movie http://www.opensubtitles.org/subtitles/7268820...
188072 7268819 NaN NaN English en 2005-03-01 00:00:00 0 sub 1.0 britan.invades.america.fights.back en 0.000 NaN NaN NaN movie http://www.opensubtitles.org/subtitles/7268819...
92669 7270951 NaN NaN English en 2005-03-31 00:00:00 0 srt 4.0 Prologo 0.000 NaN NaN NaN movie http://www.opensubtitles.org/subtitles/7270951...
3419513 6686908 Rocco Ravishes St. Petersburg 2007.0 English en 2016-07-17 16:39:46 1000000 srt 1.0 Joseph Stiglitz - Can we make a gobalization t... 24.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/6686908...
254106 3102632 Painful Deceptions 2006.0 English en 2007-02-12 19:13:45 10000011 srt 1.0 Painful Deceptions 0.000 NaN NaN 0.0 movie http://www.opensubtitles.org/subtitles/3102632...
378932 3251921 Himekishi Lilia 2006.0 English en 2008-02-21 13:15:53 10000020 ssa 1.0 Himekishi Lilia Vol.3 23.976 NaN NaN 0.0 movie http://www.opensubtitles.org/subtitles/3251921...
378930 3251919 Himekishi Lilia 2006.0 English en 2008-02-21 13:11:46 10000020 ssa 1.0 [X-SASG] Himekishi Lilia 1.mkv 23.976 NaN NaN 0.0 movie http://www.opensubtitles.org/subtitles/3251919...
378931 3251920 Himekishi Lilia 2006.0 English en 2008-02-21 13:13:26 10000020 ssa 1.0 Himekishi Lilia Vol.2 0.000 NaN NaN 0.0 movie http://www.opensubtitles.org/subtitles/3251920...
380267 3253382 Swishahouse feat. Webbie Lil' Keke & Yung Redd... 2008.0 English en 2008-02-25 15:43:18 10000023 srt 1.0 Swishahouse feat. Webbie Lil' Keke & Yung Redd... 29.970 NaN NaN 0.0 movie http://www.opensubtitles.org/subtitles/3253382...
320839 3174545 Billy & Mandy's Big Boogey Adventure 2007.0 English en 2008-01-05 15:38:58 1000070 srt 1.0 wpi 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/3174545...
788904 3694495 Bulletproof 2006.0 English en 2010-06-29 03:38:25 1000072 srt 1.0 bulletproof [A Release-lounge H264] 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/3694495...
128246 130493 Liu jai yim taam 1987.0 English en 2003-01-14 00:00:00 100014 srt 1.0 EROTIC GHOST STORY 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/130493/...
212312 215629 Liu jai yim taam 1987.0 English en 2005-03-01 00:00:00 100014 srt 1.0 Erotic ghost story dvdrip engsub 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/215629/...
296045 3147544 Sing kung chok tse sup yut tam 2007.0 English en 2007-09-17 20:41:41 1000158 srt 1.0 Whispers and Moans 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/3147544...
284088 3134963 Sing kung chok tse sup yut tam 2007.0 English en 2007-07-15 13:24:29 1000158 srt 1.0 Whipsers.And.Moans.2007.DVDRip.XViD-BiEN 23.980 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/3134963...
2647307 5804779 Life Is Sweet 1990.0 English en 2014-08-29 04:37:47 100024 srt 1.0 Life.Is.Sweet.1990.Criterion.Collection.720p.B... 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/5804779...
1815895 4865410 Life Is Sweet 1990.0 English en 2013-03-14 13:41:03 100024 srt 1.0 Life is Sweet (1990).DVDRip.XviD 25.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/4865410...
276455 3127013 Life Is Sweet 1990.0 English en 2007-05-29 22:24:38 100024 srt 1.0 NaN 25.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/3127013...
2086238 5177500 Life Is Sweet 1990.0 English en 2013-09-15 07:20:28 100024 srt 1.0 Life.is.Sweet.1990.1080p.Criterion.Bluray.X264... 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/5177500...
2031495 5118353 Life Is Sweet 1990.0 English en 2013-08-03 18:25:04 100024 srt 1.0 life.is.sweet.1990.720p.bluray.x264-unveil 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/5118353...
2981350 6168489 Life Is Sweet 1990.0 English en 2015-05-10 21:05:34 100024 srt 1.0 Life.Is.Sweet.1990.Proper.1080p.x264-SONiDO 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/6168489...
2981349 6168488 Life Is Sweet 1990.0 English en 2015-05-10 21:05:16 100024 srt 1.0 Life.Is.Sweet.1990.Proper.1080p.x264-SONiDO 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/6168488...
1010961 3903773 Lionheart 1990.0 English en 2010-10-21 01:03:05 100029 srt 1.0 lh-vh 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/3903773...
3521897 6796695 Lionheart 1990.0 English en 2016-11-14 22:49:25 100029 srt 1.0 Lionheart.1990.THEATRICAL.CUT.1080p.BluRay.H2... 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/6796695...
2835153 6002071 Lionheart 1990.0 English en 2015-01-14 01:13:23 100029 srt 1.0 Lionheart 1990.srt 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/6002071...
2970012 6171434 Lionheart 1990.0 English en 2015-05-13 11:33:46 100029 srt 1.0 Lionheart.1990.1080p.BluRay.x264.YIFY 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/6171434...
3688126 7063608 Lisa 1989.0 English en 2017-08-11 09:56:01 100031 srt 1.0 lisa.1989.dsr.x264-regret 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7063608...
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
204502 6436947 Korczak 1990.0 English en 2015-12-25 21:54:06 99949 srt 1.0 Dottor Korczak 0.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/6436947...
1215995 4182738 Korczak 1990.0 English en 2011-05-23 21:26:09 99949 srt 1.0 NaN 25.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/4182738...
1048595 3938092 Kracht 1990.0 English en 2010-11-06 13:38:02 99950 srt 1.0 Kracht.1990.DVDRIP 25.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/3938092...
3065518 6267685 The Krays 1990.0 English en 2015-08-11 15:42:36 99951 srt 1.0 The.Krays 1990 HDRip-BONE en 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/6267685...
388855 4198503 The Krays 1990.0 English en 2011-06-26 17:20:28 99951 srt 2.0 The.Krays.1990.WS.DVDRip.XviD-FiCO 25.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/4198503...
258712 3108125 The Krays 1990.0 English en 2007-03-01 20:58:30 99951 srt 1.0 The Krays.1990.LIMITED.DVDRip.MeSSiaah 25.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/3108125...
402547 4198500 The Krays 1990.0 English en 2011-06-26 17:15:09 99951 srt 1.0 The Krays-[1990]-Demonuk[NIKONRG] 25.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/4198500...
246276 3094153 The Krays 1990.0 English en 2007-01-07 03:48:20 99951 srt 2.0 The.Krays.1990.WS.DVDRip.XviD-FiCO 25.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/3094153...
3743939 7001208 The Krays 1990.0 English en 2017-06-03 05:56:40 99951 srt 1.0 The.Krays.1990.720p.WEB-DL.AAC2.0.H264-FGT 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7001208...
1229603 4198499 The Krays 1990.0 English en 2011-06-26 17:15:06 99951 srt 1.0 The Krays-[1990]-Demonuk[NIKONRG] 25.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/4198499...
3743938 7001207 The Krays 1990.0 English en 2017-06-03 05:56:10 99951 srt 1.0 The.Krays.1990.720p.WEB-DL.AAC2.0.H264-FGT 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7001207...
3109202 6315316 Kuai le de xiao ji 1990.0 English en 2015-09-24 09:19:43 99956 srt 1.0 Kuai.le.de.xiao.ji.1990.D5.x264.2Audio.AAC.480... 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/6315316...
1808272 4857252 Il 7 e l'8 2007.0 English en 2013-03-10 19:24:56 999864 srt 1.0 IL.7.E.L.8-Ficarra_Picone.2007.iTALiAN.DVDRip-... 25.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/4857252...
462737 3365225 Thomas Kinkade's Christmas Cottage 2008.0 English en 2008-11-07 19:15:31 999872 srt 1.0 Thomas.Kinkades.Christmas.Cottage-BULLDOZER (a... 23.980 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/3365225...
1235633 4206645 Heart of a Soul Surfer 2007.0 English en 2011-07-13 15:47:42 999890 srt 1.0 NaN 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/4206645...
1467473 4475967 Straw Dogs 2011.0 English en 2012-02-23 01:05:48 999913 srt 1.0 Straw.Dogs.2011.x264.DTS-WAF 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/4475967...
1421973 4423154 Straw Dogs 2011.0 English en 2011-12-03 16:54:14 999913 srt 1.0 Straw.Dogs.2011.DVDRip.XviD-ViP3R 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/4423154...
1421250 4422075 Straw Dogs 2011.0 English en 2011-12-01 22:00:37 999913 srt 1.0 Straw.Dogs.2011.720p.BluRay.x264-Felony 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/4422075...
993363 4422412 Straw Dogs 2011.0 English en 2011-12-02 12:37:27 999913 srt 1.0 Straw.Dogs.2011.BDRip.XviD-Larceny 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/4422412...
1421972 4423153 Straw Dogs 2011.0 English en 2011-12-03 16:54:11 999913 srt 1.0 Straw.Dogs.2011.DVDRip.XviD-ViP3R 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/4423153...
993365 4422414 Straw Dogs 2011.0 English en 2011-12-02 12:38:31 999913 srt 2.0 Straw.Dogs.2011.BDRip.XviD-Larceny 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/4422414...
3880705 7184584 Straw Dogs 2011.0 English en 2017-12-08 11:50:12 999913 srt 1.0 Straw Dogs (2011) 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7184584...
3503267 6775710 Leatherface: Texas Chainsaw Massacre III 1990.0 English en 2016-10-27 07:31:17 99994 srt 1.0 1080p.WEB-DL.AAC2.0.H264-FGT 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/6775710...
3954287 7264736 Leatherface: Texas Chainsaw Massacre III 1990.0 English en 2018-02-22 18:46:32 99994 srt 1.0 Leatherface.Texas.Chainsaw.Massacre.III.1990.7... 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7264736...
3600164 7264737 Leatherface: Texas Chainsaw Massacre III 1990.0 English en 2018-02-22 18:46:49 99994 srt 1.0 Leatherface.Texas.Chainsaw.Massacre.III.1990.7... 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7264737...
630745 3537308 Leatherface: Texas Chainsaw Massacre III 1990.0 English en 2009-07-20 12:33:01 99994 srt 1.0 Leatherface: Texas Chainsaw Massacre III 25.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/3537308...
72741 72459 Leatherface: Texas Chainsaw Massacre III 1990.0 English en 2004-05-24 00:00:00 99994 srt 1.0 Leatherface: Texas Chainsaw Massacre III (1990) 29.970 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/72459/l...
4108930 7425616 Leatherface: Texas Chainsaw Massacre III 1990.0 English en 2018-07-21 10:27:01 99994 srt 1.0 LEATHERFACE (TEXAS CHAINSAW MASSACRE 3) (1990) 23.976 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/7425616...
2003116 5086910 Lebedyne ozero-zona 1990.0 English en 2013-07-14 09:09:23 99995 srt 1.0 Lebedyne ozero-zona 25.000 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/5086910...
407840 3289866 The Fear Chamber 2009.0 English en 2008-05-29 14:17:13 999972 srt 1.0 The.Fear.Chamber.FS.DVDRip.XviD-ARiSCO 23.980 0.0 0.0 0.0 movie http://www.opensubtitles.org/subtitles/3289866...

228490 rows × 16 columns

for d in df.URL[:3]:
    print(d)
http://www.opensubtitles.org/subtitles/1/alien3-en
http://www.opensubtitles.org/subtitles/2/identity-sl
http://www.opensubtitles.org/subtitles/3/ghost-in-the-shell-2-innocence-en