{"cells":[{"cell_type":"markdown","source":["In Cmd 2, the AWS_ACCESS_KEY and AWS_SECRET_KEY variables are set and kept hidden."],"metadata":{}},{"cell_type":"code","source":["AWS_ACCESS_KEY = \"AA\"\nAWS_SECRET_KEY = \"BB\""],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["\n
"]}}],"execution_count":2},{"cell_type":"code","source":["sc._jsc.hadoopConfiguration().set(\"fs.s3n.awsAccessKeyId\", AWS_ACCESS_KEY)\nsc._jsc.hadoopConfiguration().set(\"fs.s3n.awsSecretAccessKey\", AWS_SECRET_KEY)"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["\n
"]}}],"execution_count":3},{"cell_type":"code","source":["df = spark.read.csv(\"s3://databricks-recsys/u.data\",header=True, sep=\"\\t\",inferSchema = True)\ndisplay(df)"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["
uidiidratingtimestamp
1962423881250949
1863023891717742
223771878887116
244512880606923
1663461886397596
2984744884182806
1152652881171488
2534655891628467
3054513886324817
6863883603013
622572879372434
28610145879781125
2002225876042340
210403891035994
224293888104457
3037853879485318
1223875879270459
1942742879539794
29110424874834944
23411842892079237
1193924886176814
1674864892738452
2991444877881320
2911182874833878
30814887736532
955462879196566
38955892430094
1027682883748450
632774875747401
1602345876861185
502463877052329
301984882075827
2251934879539727
290884880731963
971943884238860
1572744886890835
18110811878962623
2786035891295330
2767961874791932
7324891350932
10164877888877
2843044885329322
2019792884114233
2765643874791805
2873275875333916
2462015884921594
24211375879741196
2492415879641194
9945886519097
1783323882823437
2511004886271884
814322876535131
2603224890618898
251815885853415
591965888205088
726792880037164
873844879877127
2901435880474293
424235881107687
2925154881103977
115203881171009
202881879667584
2012194884112673
135263882141053
2469194884920949
138265879024232
1672321892738341
604275883326620
573045883698581
2232744891550094
1895124893277702
243153879987440
9210491890251826
2464163884923047
1941654879546723
2416902887249482
1782484882823954
25414443886475558
29353888906576
1272295884364867
2252375879539643
2992293878192429
2254805879540748
276543874791025
2911445874835091
2223664878183381
2675185878971773
424033881108684
111114891903862
956254888954412
83384879361873
162254877635573
8710164879876194
2791545875296291
1452752885557505
11911535874781198
624984879373848
623823879375537
282094881961214
135234879857765
322943883709863
903825891383835
2862084877531942
2936853888905170
2161444880234639
1663285886397722
2504964878090499
2711325885848672
1601745876860807
2651184875320714
1984983884207492
42965881107178
1681515884288058
1103074886987260
581444884304936
906484891384754
2713464885844430
62213879373460
2798323881375854
2375144879376641
947894891720887
1284853879966895
2983174884182806
441955878347874
2642005886122352
1943852879524643
721955880037702
2227505883815120
2502643878089182
412653890687042
2242453888082216
821353878769629
26211474879791710
2934713888904884
2166583880245029
2501403878092059
59235888205300
2863795877533771
2448154880605185
74794891352010
1743681886434402
872744879876734
19412112879551380
8211342884714402
138362882139746
132724884538403
2447562880605157
3054275886323090
957872888954930
43142883955745
2999554889502823
574193883698454
844053883452363
2695044891449922
2991113877878184
1944664879525876
1601354876860807
992683885678247
104864877886846
2591174874724988
854273879456350
3039194879467295
2132735878870987
1215143891387947
90985891383204
495592888067405
427943881108425
1553232879371261
681174876973939
1721774875537965
1944885412840
2682314875744136
523875636053
3051172886324028
442944883612356
431374875975656
27913361875298353
804665887401701
2541644886472768
2982813884183336
27912401892174404
662984883601324
184433880130193
26810352875542174
99794885680138
13984881515011
262583891347949
74554891353086
2227554878183481
2006735884128554
1193284876923913
2131725878955442
2763223874786392
9412173891723086
1303794875801662
383284892428688
1607193876857977
29312673888906966
269302891385985
1302164875216545
9210793886443455
2564524882164999
1614878542420
72484880036718
567553892910207
133604882140926
154052879455957
92773875654637
2074762884386343
2921745881105481
2324835888549622
2517482886272175
224263888104153
1812204878962392
2592554874724710
3054714886323648
522803882922806
1612025891170769
1484085877399018
1252352892838559
972285884238860
5810984884304936
832344887665548
903474891383319
2721785879455113
1941813879521396
1254784879454628
1106881886987605
299144877877775
151105879524921
2691274891446165
6145883599249
541063880937882
303695879467542
169441877727122
3017904882078621
27610913874793035
3052142886323068
19410282879541148
913232891438397
875544879875940
2941094877819599
2861714877531791
2003185884128458
2293281891632142
1785684882826555
3038422879484804
62654879374686
2075913876018608
921724875653271
3014014882078040
363395882157581
707463884150257
632423875747190
282013881961671
279684875307407
25074878089716
14983890881335
29910183889502324
194543879525876
3038153879485532
1192375874775038
2952185879966498
2689302875742942
26822875744173
662584883601089
2332025879394264
836234880308578
2143343891542540
1924762881368243
1003444891374868
2681451875744501
301564882076587
307895879283786
2341413892334609
835764880308755
1812642878961624
2971334875240090
381535892430369
73824891352093
2648134886122952
1818721878961814
2011461884140579
855074879456199
2693673891450023
594683888205855
2861434889651549
193961889124507
1135955875936424
292115881104093
13010143876250718
275984875155140
1895205893265380
219821889452455
2182095877488546
1234273879873020
1192225874775311
1581774880134407
2221184877563802
3023222879436875
2795013875308843
301795882076403
18132878963441
2016951884140115
131983881515193
11893888732928
1452375875270570
233854874786462
2017674884114505
2967055884197193
425463881105817
338723891964230
3015543882078830
16645877720297
951353879197562
1543574879138713
774845884733766
2965085884196584
3023032879436785
2446733880606667
222774878183616
132155882140588
167055877722736
2704524876956264
145152875270655
187645879465631
2003045876041644
1707495887646170
1018293877136138
1842183889909840
1282044879967478
18112951878961781
1841533889911285
1334878542699
11604875072547
1843215889906967
545953880937813
943434891725009
1285084879967767
233232874784266
3012273882077222
3011913882075672
1129031892440172
821833878769848
2227243878181976
2184303877488316
30811974887739521
3031345879467959
1337513890588547
2152122891435680
692565882126156
2546624887347350
27624874792436
1049841888442575
6310673875747514
2674104878970785
13565881515011
2408793885775745
2862372875806800
2942715889241426
9010864891384424
18264880129731
922293875656201
3086494887739292
144893888105691
1913024891560253
599513888206409
200965884129409
161975877726146
616783892302309
2711994885848448
2717093885849325
1421695888640356
2755973876197678
2221513878182109
87403879876917
2072584877879172
27213932879454663
1773334880130397
20711152879664906
2995773889503806
2713784885849447
3054254886324486
499592888068912
9412243891722802
13010173874953895
101753877888677
2033213880433418
1912864891560842
433233875975110
215585874951695
197965891409839
133442888073635
194663879527264
2342064892334543
3084024887740700
3086404887737036
2695225891447773
942654891721889
268623875310824
272125879455254
1212913891390477
296205884196921
1342863891732334
1804625877544218
2346123892079140
1041172888465972
387581892434626
2698451891456255
71634891353444
23414513892078343
2754052876197645
522503882922661
1028233888801465
131864890704999
1787314882827532
236713890116671
2567815882165296
2631765891299752
2441863880605697
27911814875314001
438154883956189
83782880309089
1511975879528710
2544362886474216
1096313880579371
2977163875239422
2491884879641067
1446994888106106
3016044882075994
643923889737542
925012875653665
222974878181739
2684363875310745
2931355888905550
2131735878955442
1604602876861185
134984882139901
597155888205921
5174875636198
1251635879454956
1743155886432749
1145053881260203
2135154878870518
231962874786926
128154879968827
239564889179478
1812791878962955
291804875086354
2502384878089963
2016493884114275
60605883327734
1813252878961814
1194073887038665
28715875334088
2162283880245642
2165314880233810
2034714880434463
925873875660408
138923882774224
2131764878956338
2862885875806672
11710472881009697
991111885678886
115583891904214
65472879216672
2951944879517412
2692172891451610
852592881705026
2505965878089921
1371445881433689
2019602884112077
2571374882049932
1113284891679939
914804891438875
2152114891436202
1819381878961586
18910605893264301
1204887431883
3034044879468375
2993053879737314
1872104879465242
2222782877563913
2145684892668197
2937703888906655
2851914890595859
3032523879544791
961564884402860
7211103880037334
11510674881171009
74303891352178
1163503886977926
734804888625753
2692465891457067
2634195891299514
704313884150257
2214754875244204
721825880036515
253574885852757
290505880473582
1895264893266205
2993033877618584
2642943886121516
2003655884129962
1871354879465653
1841874889909024
632892875746985
132294882397650
2984863884183063
2351854889655435
627124879376178
246942884923505
547425880934806
637623875747688
117323891904596
921684875653723
85503879362356
3071744879283480
3032004879468459
2568492882164603
72543880036854
1644062889402389
1171504880125101
224774888103872
1938693889127811
941842891720862
2813382881200457
1301093874953794
1283711879966954
947201891723593
1828453885613067
1298731883245452
2542294886474580
643814879365491
1511762879524293
45254881014015
1938793889123257
2769224889174849
276573874787526
2341874892079140
1813061878962006
213701874951293
2932493888905229
2647215886123656
106115877886722
1973463891409070
2761423874792945
3084274887736584
2219434875246759
1311264883681514
2688242876518557
10983880572642
198583884208173
2306804880484286
1817411878962918
19210614881368891
2344483892335501
909004891382309
1939414889124890
1286035879966839
1269052887855283
2442654880606634
902893891382310
157253886890787
305713886323684
1193825874781742
212222874951382
2311814888605273
2805083891700453
2881323886374129
27914972890780576
301334882078228
726993880036783
902592891382392
308553887738760
597423888203053
947444891721462
1306424875216933
2610153891352136
561215892679480
825082884714249
62124879373613
276403874791871
18110151878963121
1523013880147407
1788454882824291
2175974889070087
793034891271203
1384844879024127
308815887737293
752842884050393
2691984891447062
307943877122695
2227813881059677
1217403891390544
269221891448072
138644882141924
2307425880485043
2695074891448800
23910995889179253
24510285888513447
565463892679460
2959615879519556
27110282885848102
2228122881059117
692403882126156
1074877892210
223763878887112
2949313889242857
827171884714492
2793994875313859
2692341891449406
6985883600680
24310394879988184
2981814884125629
2823251881703044
783231879633567
1182005875384647
28311145879297545
1712924891034835
702174884151119
101005877891747
2451814888513664
1073333891264267
2465611884923445
139011883670672
276704874790826
244172880607205
189565893265263
2262425883888671
6210164879373008
2764174874792907
2144784891544052
3062354876504354
222263878183043
2806315891700751
604305883326122
56714892683275
422745881105817
12025875072442
138094882397582
1732894877556988
157491879455311
185234883524249
2805403891702304
2443814880604077
1502934878746946
74974891352134
1783174882826915
1787423882823833
9512173880572658
23414623892333865
972225884238887
1091272880563471
1172685880124306
2697052891448850
13012463876252497
2646554886123530
207133875506839
425885881108147
2464092884923372
873674879876702
1013043877135677
2561274882164406
927943875654798
1817622878963418
2132351878955115
927392876175582
2926615881105561
2466654884922831
2748455878945579
1886925875072583
18864880129731
54391878844423
2366323890116254
1934074889127921
1447094888105940
9011985891383866
486094879434819
52252875635723
221285878887983
3114324884365485
8225879362183
2761884874792547
2221735878183043
728664880035887
2991344878192311
11715889751711
3082953887741461
1652164879525778
222493878183512
1811214878962623
200115884129542
2346264892336358
2447074880606243
90255891384789
2082165883108324
263964891298336
1343234891732335
2795864892864663
22924888550774
2885932886892127
493024888065432
2861535877531406
2053043888284313
22804878887227
2343184892078890
2233283891548959
15253879456204
2681474876514002
9412203891722678
2744054878945840
74925891352010
2682172875744501
16555877717956
1646203889402298
2901614880474293
925154875640800
23910705889179032
564495892679308
2482344884534968
234103891227851
28010492891702486
3081875887738760
276645874787441
1929483881368302
1225094879270511
855883880838306
2629312879790874
2012723886013700
1818702878962623
2957394879518319
2635684891299387
295394879518279
20111004884112800
938203888705966
15910285880557539
1586652880134532
2934233888906070
825973878768882
2761815874786488
138235882397833
21723889069782
836604880308256
189205893264466
2227964878183684
14610225891458193
2671213878970681
1262943887855087
18110601878962675
125804892838865
431204884029430
137801882142057
2532592891628883
42443881108548
775184884753202
2916865874835165
268213875742822
262283879792220
234813892334680
292453882820803
236575890116575
1587293880133116
1566614888185947
232525888550130
1688665884287927
372884880915258
1412453884584426
2352304889655162
102703888803537
771723884752562
905065891383319
1865665879023663
446605878347915
1187745875385198
76615891351624
4910032888068651
62681879374969
4210284881106072
1784334882827834
85512879454782
774745884732407
5810992892243079
5610474892911290
1976881891409564
286994878141681
902583891382121
18112881878962349
2951904879517062
224694888082495
2723174879454977
22110103875246662
668771883601089
2073185877124871
2344873892079237
76485891351653
87825879875774
19510521877835102
444495883613334
3062874876504442
1941723879521474
94623891722933
1676594892738277
1081004879879720
2303045880484286
1819271878962675
543024880928519
90224891384357
1816962878962997
2863574877531537
142694892242403
3111792884365357
921215875640679
214401874951798
2445501880602264
1814054878962919
658064879216529
375402880916070
444435878348289
2441834880606043
12654878542441
270255876954456
2993872889502756
945723891723883
2867464877533058
2392725889181247
216555880245145
2541213886472369
626652879376483
1783854882826982
194234879522819
2689553875745160
1881435875072674
2762944874786366
15810984880135069
2078453881681663
161481891170745
3056544886323937
473243879439078
647364889739212
1917513891560753
73785891353011
59925888204997
692685882027109
104613877888944
211294874951382
5894884304328
1941523879549996
72005891353543
1131265875076827
1733285877557028
952334879196354
161945877720733
593234888206809
3116543884365075
2925894881105516
432034883955224
79504891271545
235705889655619
1251905892836309
2843223885329671
3031615879468547
2543783886474396
25510341883217030
1043012888442275
909235891383912
64634883601713
2791221875297433
2862984875807004
2224483878183565
297575875239383
426253881108873
13012174875801778
2543573886472466
1094751880563641
23014442880485726
2443103880601905
63012883600406
367484882157285
2564433882164727
1025151888801316
1042854888465201
214475874951695
1113014891680028
184085880129628
252224885852817
1109443886989501
270985876955868
682375876974133
832154880307940
62582883268278
892165879459859
1283174879968029
3055124886323525
1844122889912691
2861755877532470
27914283888465209
256865882165103
221485875245462
1403323879013617
1909772891042938
112273891905896
2012035884114471
1501815878746685
1262453887854726
202082879669401
1447424888104122
1819301878963275
1095664880578814
8510653879455021
2131333878955973
2223791878184290
223113891550649
2154214891435704
2182083877488366
1749375886432989
2751863880314383
687421876974198
2685834876513830
1604624876858346
1952734878019342
2241784888082468
51101875636493
9910165885678724
22515888552084
29294881104148
725684880037203
852283882813248
832815880307072
928312886443708
75433891351772
874012879876813
2879264875334340
11552878542201
2346322892079538
222535878184113
24645875322758
75543891354639
82563878769410
1613183891170824
1963934881251863
56914892683275
824773876311344
74722891353357
2567614882164644
226564883889102
2797415875296891
30812863887738151
1685877722736
1802023877128388
203934880434940
145565875271896
2883054886372527
847423883450643
446443878347818
17133885272654
3131174891015319
14814877019411
1973474891409070
211645874951695
2799823875298314
2394915889181015
1852875883526288
297894875239125
303684879467361
1862501879023607
732063888625754
1047562888465739
942163885870665
2391945889178833
1975115891409839
28014891700426
11173874965739
2245831888103729
3033971879543831
601624883327734
1982584884204501
2395135889178887
6693883601277
2333754876374419
856424882995615
110383886988574
1845223889908462
998731885678436
134182882398763
2015184884112201
138581882397068
2141313891544465
2962284884197264
222873878182589
2797254875314144
2171822889070109
854333879828720
2392343889178762
13724882141727
194773879527421
2086635883108476
1091783880572950
2301724880484523
594852888204466
Showing the first 1000 rows.
"]}}],"execution_count":4},{"cell_type":"code","source":["movies_sdf = spark.read.csv(\"s3://databricks-recsys/movies_raw.dat\",header=False, sep=\"|\",inferSchema = True)\ndisplay(movies_sdf)"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["
_c0_c1
1Toy Story (1995)
2GoldenEye (1995)
3Four Rooms (1995)
4Get Shorty (1995)
5Copycat (1995)
6Shanghai Triad (Yao a yao yao dao waipo qiao) (1995)
7Twelve Monkeys (1995)
8Babe (1995)
9Dead Man Walking (1995)
10Richard III (1995)
11Seven (Se7en) (1995)
12Usual Suspects, The (1995)
13Mighty Aphrodite (1995)
14Postino, Il (1994)
15Mr. Holland's Opus (1995)
16French Twist (Gazon maudit) (1995)
17From Dusk Till Dawn (1996)
18White Balloon, The (1995)
19Antonia's Line (1995)
20Angels and Insects (1995)
21Muppet Treasure Island (1996)
22Braveheart (1995)
23Taxi Driver (1976)
24Rumble in the Bronx (1995)
25Birdcage, The (1996)
26Brothers McMullen, The (1995)
27Bad Boys (1995)
28Apollo 13 (1995)
29Batman Forever (1995)
30Belle de jour (1967)
31Crimson Tide (1995)
32Crumb (1994)
33Desperado (1995)
34Doom Generation, The (1995)
35Free Willy 2: The Adventure Home (1995)
36Mad Love (1995)
37Nadja (1994)
38Net, The (1995)
39Strange Days (1995)
40To Wong Foo, Thanks for Everything! Julie Newmar (1995)
41Billy Madison (1995)
42Clerks (1994)
43Disclosure (1994)
44Dolores Claiborne (1994)
45Eat Drink Man Woman (1994)
46Exotica (1994)
47Ed Wood (1994)
48Hoop Dreams (1994)
49I.Q. (1994)
50Star Wars (1977)
51Legends of the Fall (1994)
52Madness of King George, The (1994)
53Natural Born Killers (1994)
54Outbreak (1995)
55Professional, The (1994)
56Pulp Fiction (1994)
57Priest (1994)
58Quiz Show (1994)
59Three Colors: Red (1994)
60Three Colors: Blue (1993)
61Three Colors: White (1994)
62Stargate (1994)
63Santa Clause, The (1994)
64Shawshank Redemption, The (1994)
65What's Eating Gilbert Grape (1993)
66While You Were Sleeping (1995)
67Ace Ventura: Pet Detective (1994)
68Crow, The (1994)
69Forrest Gump (1994)
70Four Weddings and a Funeral (1994)
71Lion King, The (1994)
72Mask, The (1994)
73Maverick (1994)
74Faster Pussycat! Kill! Kill! (1965)
75Brother Minister: The Assassination of Malcolm X (1994)
76Carlito's Way (1993)
77Firm, The (1993)
78Free Willy (1993)
79Fugitive, The (1993)
80Hot Shots! Part Deux (1993)
81Hudsucker Proxy, The (1994)
82Jurassic Park (1993)
83Much Ado About Nothing (1993)
84Robert A. Heinlein's The Puppet Masters (1994)
85Ref, The (1994)
86Remains of the Day, The (1993)
87Searching for Bobby Fischer (1993)
88Sleepless in Seattle (1993)
89Blade Runner (1982)
90So I Married an Axe Murderer (1993)
91Nightmare Before Christmas, The (1993)
92True Romance (1993)
93Welcome to the Dollhouse (1995)
94Home Alone (1990)
95Aladdin (1992)
96Terminator 2: Judgment Day (1991)
97Dances with Wolves (1990)
98Silence of the Lambs, The (1991)
99Snow White and the Seven Dwarfs (1937)
100Fargo (1996)
101Heavy Metal (1981)
102Aristocats, The (1970)
103All Dogs Go to Heaven 2 (1996)
104Theodore Rex (1995)
105Sgt. Bilko (1996)
106Diabolique (1996)
107Moll Flanders (1996)
108Kids in the Hall: Brain Candy (1996)
109Mystery Science Theater 3000: The Movie (1996)
110Operation Dumbo Drop (1995)
111Truth About Cats & Dogs, The (1996)
112Flipper (1996)
113Horseman on the Roof, The (Hussard sur le toit, Le) (1995)
114Wallace & Gromit: The Best of Aardman Animation (1996)
115Haunted World of Edward D. Wood Jr., The (1995)
116Cold Comfort Farm (1995)
117Rock, The (1996)
118Twister (1996)
119Maya Lin: A Strong Clear Vision (1994)
120Striptease (1996)
121Independence Day (ID4) (1996)
122Cable Guy, The (1996)
123Frighteners, The (1996)
124Lone Star (1996)
125Phenomenon (1996)
126Spitfire Grill, The (1996)
127Godfather, The (1972)
128Supercop (1992)
129Bound (1996)
130Kansas City (1996)
131Breakfast at Tiffany's (1961)
132Wizard of Oz, The (1939)
133Gone with the Wind (1939)
134Citizen Kane (1941)
1352001: A Space Odyssey (1968)
136Mr. Smith Goes to Washington (1939)
137Big Night (1996)
138D3: The Mighty Ducks (1996)
139Love Bug, The (1969)
140Homeward Bound: The Incredible Journey (1993)
14120,000 Leagues Under the Sea (1954)
142Bedknobs and Broomsticks (1971)
143Sound of Music, The (1965)
144Die Hard (1988)
145Lawnmower Man, The (1992)
146Unhook the Stars (1996)
147Long Kiss Goodnight, The (1996)
148Ghost and the Darkness, The (1996)
149Jude (1996)
150Swingers (1996)
151Willy Wonka and the Chocolate Factory (1971)
152Sleeper (1973)
153Fish Called Wanda, A (1988)
154Monty Python's Life of Brian (1979)
155Dirty Dancing (1987)
156Reservoir Dogs (1992)
157Platoon (1986)
158Weekend at Bernie's (1989)
159Basic Instinct (1992)
160Glengarry Glen Ross (1992)
161Top Gun (1986)
162On Golden Pond (1981)
163Return of the Pink Panther, The (1974)
164Abyss, The (1989)
165Jean de Florette (1986)
166Manon of the Spring (Manon des sources) (1986)
167Private Benjamin (1980)
168Monty Python and the Holy Grail (1974)
169Wrong Trousers, The (1993)
170Cinema Paradiso (1988)
171Delicatessen (1991)
172Empire Strikes Back, The (1980)
173Princess Bride, The (1987)
174Raiders of the Lost Ark (1981)
175Brazil (1985)
176Aliens (1986)
177Good, The Bad and The Ugly, The (1966)
17812 Angry Men (1957)
179Clockwork Orange, A (1971)
180Apocalypse Now (1979)
181Return of the Jedi (1983)
182GoodFellas (1990)
183Alien (1979)
184Army of Darkness (1993)
185Psycho (1960)
186Blues Brothers, The (1980)
187Godfather: Part II, The (1974)
188Full Metal Jacket (1987)
189Grand Day Out, A (1992)
190Henry V (1989)
191Amadeus (1984)
192Raging Bull (1980)
193Right Stuff, The (1983)
194Sting, The (1973)
195Terminator, The (1984)
196Dead Poets Society (1989)
197Graduate, The (1967)
198Nikita (La Femme Nikita) (1990)
199Bridge on the River Kwai, The (1957)
200Shining, The (1980)
201Evil Dead II (1987)
202Groundhog Day (1993)
203Unforgiven (1992)
204Back to the Future (1985)
205Patton (1970)
206Akira (1988)
207Cyrano de Bergerac (1990)
208Young Frankenstein (1974)
209This Is Spinal Tap (1984)
210Indiana Jones and the Last Crusade (1989)
211M*A*S*H (1970)
212Unbearable Lightness of Being, The (1988)
213Room with a View, A (1986)
214Pink Floyd - The Wall (1982)
215Field of Dreams (1989)
216When Harry Met Sally... (1989)
217Bram Stoker's Dracula (1992)
218Cape Fear (1991)
219Nightmare on Elm Street, A (1984)
220Mirror Has Two Faces, The (1996)
221Breaking the Waves (1996)
222Star Trek: First Contact (1996)
223Sling Blade (1996)
224Ridicule (1996)
225101 Dalmatians (1996)
226Die Hard 2 (1990)
227Star Trek VI: The Undiscovered Country (1991)
228Star Trek: The Wrath of Khan (1982)
229Star Trek III: The Search for Spock (1984)
230Star Trek IV: The Voyage Home (1986)
231Batman Returns (1992)
232Young Guns (1988)
233Under Siege (1992)
234Jaws (1975)
235Mars Attacks! (1996)
236Citizen Ruth (1996)
237Jerry Maguire (1996)
238Raising Arizona (1987)
239Sneakers (1992)
240Beavis and Butt-head Do America (1996)
241Last of the Mohicans, The (1992)
242Kolya (1996)
243Jungle2Jungle (1997)
244Smilla's Sense of Snow (1997)
245Devil's Own, The (1997)
246Chasing Amy (1997)
247Turbo: A Power Rangers Movie (1997)
248Grosse Pointe Blank (1997)
249Austin Powers: International Man of Mystery (1997)
250Fifth Element, The (1997)
251Shall We Dance? (1996)
252Lost World: Jurassic Park, The (1997)
253Pillow Book, The (1995)
254Batman & Robin (1997)
255My Best Friend's Wedding (1997)
256When the Cats Away (Chacun cherche son chat) (1996)
257Men in Black (1997)
258Contact (1997)
259George of the Jungle (1997)
260Event Horizon (1997)
261Air Bud (1997)
262In the Company of Men (1997)
263Steel (1997)
264Mimic (1997)
265Hunt for Red October, The (1990)
266Kull the Conqueror (1997)
267unknown
268Chasing Amy (1997)
269Full Monty, The (1997)
270Gattaca (1997)
271Starship Troopers (1997)
272Good Will Hunting (1997)
273Heat (1995)
274Sabrina (1995)
275Sense and Sensibility (1995)
276Leaving Las Vegas (1995)
277Restoration (1995)
278Bed of Roses (1996)
279Once Upon a Time... When We Were Colored (1995)
280Up Close and Personal (1996)
281River Wild, The (1994)
282Time to Kill, A (1996)
283Emma (1996)
284Tin Cup (1996)
285Secrets & Lies (1996)
286English Patient, The (1996)
287Marvin's Room (1996)
288Scream (1996)
289Evita (1996)
290Fierce Creatures (1997)
291Absolute Power (1997)
292Rosewood (1997)
293Donnie Brasco (1997)
294Liar Liar (1997)
295Breakdown (1997)
296Promesse, La (1996)
297Ulee's Gold (1997)
298Face/Off (1997)
299Hoodlum (1997)
300Air Force One (1997)
301In & Out (1997)
302L.A. Confidential (1997)
303Ulee's Gold (1997)
304Fly Away Home (1996)
305Ice Storm, The (1997)
306Mrs. Brown (Her Majesty, Mrs. Brown) (1997)
307Devil's Advocate, The (1997)
308FairyTale: A True Story (1997)
309Deceiver (1997)
310Rainmaker, The (1997)
311Wings of the Dove, The (1997)
312Midnight in the Garden of Good and Evil (1997)
313Titanic (1997)
3143 Ninjas: High Noon At Mega Mountain (1998)
315Apt Pupil (1998)
316As Good As It Gets (1997)
317In the Name of the Father (1993)
318Schindler's List (1993)
319Everyone Says I Love You (1996)
320Paradise Lost: The Child Murders at Robin Hood Hills (1996)
321Mother (1996)
322Murder at 1600 (1997)
323Dante's Peak (1997)
324Lost Highway (1997)
325Crash (1996)
326G.I. Jane (1997)
327Cop Land (1997)
328Conspiracy Theory (1997)
329Desperate Measures (1998)
330187 (1997)
331Edge, The (1997)
332Kiss the Girls (1997)
333Game, The (1997)
334U Turn (1997)
335How to Be a Player (1997)
336Playing God (1997)
337House of Yes, The (1997)
338Bean (1997)
339Mad City (1997)
340Boogie Nights (1997)
341Critical Care (1997)
342Man Who Knew Too Little, The (1997)
343Alien: Resurrection (1997)
344Apostle, The (1997)
345Deconstructing Harry (1997)
346Jackie Brown (1997)
347Wag the Dog (1997)
348Desperate Measures (1998)
349Hard Rain (1998)
350Fallen (1998)
351Prophecy II, The (1998)
352Spice World (1997)
353Deep Rising (1998)
354Wedding Singer, The (1998)
355Sphere (1998)
356Client, The (1994)
357One Flew Over the Cuckoo's Nest (1975)
358Spawn (1997)
359Assignment, The (1997)
360Wonderland (1997)
361Incognito (1997)
362Blues Brothers 2000 (1998)
363Sudden Death (1995)
364Ace Ventura: When Nature Calls (1995)
365Powder (1995)
366Dangerous Minds (1995)
367Clueless (1995)
368Bio-Dome (1996)
369Black Sheep (1996)
370Mary Reilly (1996)
371Bridges of Madison County, The (1995)
372Jeffrey (1995)
373Judge Dredd (1995)
374Mighty Morphin Power Rangers: The Movie (1995)
375Showgirls (1995)
376Houseguest (1994)
377Heavyweights (1994)
378Miracle on 34th Street (1994)
379Tales From the Crypt Presents: Demon Knight (1995)
380Star Trek: Generations (1994)
381Muriel's Wedding (1994)
382Adventures of Priscilla, Queen of the Desert, The (1994)
383Flintstones, The (1994)
384Naked Gun 33 1/3: The Final Insult (1994)
385True Lies (1994)
386Addams Family Values (1993)
387Age of Innocence, The (1993)
388Beverly Hills Cop III (1994)
389Black Beauty (1994)
390Fear of a Black Hat (1993)
391Last Action Hero (1993)
392Man Without a Face, The (1993)
393Mrs. Doubtfire (1993)
394Radioland Murders (1994)
395Robin Hood: Men in Tights (1993)
396Serial Mom (1994)
397Striking Distance (1993)
398Super Mario Bros. (1993)
399Three Musketeers, The (1993)
400Little Rascals, The (1994)
401Brady Bunch Movie, The (1995)
402Ghost (1990)
403Batman (1989)
404Pinocchio (1940)
405Mission: Impossible (1996)
406Thinner (1996)
407Spy Hard (1996)
408Close Shave, A (1995)
409Jack (1996)
410Kingpin (1996)
411Nutty Professor, The (1996)
412Very Brady Sequel, A (1996)
413Tales from the Crypt Presents: Bordello of Blood (1996)
414My Favorite Year (1982)
415Apple Dumpling Gang, The (1975)
416Old Yeller (1957)
417Parent Trap, The (1961)
418Cinderella (1950)
419Mary Poppins (1964)
420Alice in Wonderland (1951)
421William Shakespeare's Romeo and Juliet (1996)
422Aladdin and the King of Thieves (1996)
423E.T. the Extra-Terrestrial (1982)
424Children of the Corn: The Gathering (1996)
425Bob Roberts (1992)
426Transformers: The Movie, The (1986)
427To Kill a Mockingbird (1962)
428Harold and Maude (1971)
429Day the Earth Stood Still, The (1951)
430Duck Soup (1933)
431Highlander (1986)
432Fantasia (1940)
433Heathers (1989)
434Forbidden Planet (1956)
435Butch Cassidy and the Sundance Kid (1969)
436American Werewolf in London, An (1981)
437Amityville 1992: It's About Time (1992)
438Amityville 3-D (1983)
439Amityville: A New Generation (1993)
440Amityville II: The Possession (1982)
441Amityville Horror, The (1979)
442Amityville Curse, The (1990)
443Birds, The (1963)
444Blob, The (1958)
445Body Snatcher, The (1945)
446Burnt Offerings (1976)
447Carrie (1976)
448Omen, The (1976)
449Star Trek: The Motion Picture (1979)
450Star Trek V: The Final Frontier (1989)
451Grease (1978)
452Jaws 2 (1978)
453Jaws 3-D (1983)
454Bastard Out of Carolina (1996)
455Jackie Chan's First Strike (1996)
456Beverly Hills Ninja (1997)
457Free Willy 3: The Rescue (1997)
458Nixon (1995)
459Cry, the Beloved Country (1995)
460Crossing Guard, The (1995)
461Smoke (1995)
462Like Water For Chocolate (Como agua para chocolate) (1992)
463Secret of Roan Inish, The (1994)
464Vanya on 42nd Street (1994)
465Jungle Book, The (1994)
466Red Rock West (1992)
467Bronx Tale, A (1993)
468Rudy (1993)
469Short Cuts (1993)
470Tombstone (1993)
471Courage Under Fire (1996)
472Dragonheart (1996)
473James and the Giant Peach (1996)
474Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb (1963)
475Trainspotting (1996)
476First Wives Club, The (1996)
477Matilda (1996)
478Philadelphia Story, The (1940)
479Vertigo (1958)
480North by Northwest (1959)
481Apartment, The (1960)
482Some Like It Hot (1959)
483Casablanca (1942)
484Maltese Falcon, The (1941)
485My Fair Lady (1964)
486Sabrina (1954)
487Roman Holiday (1953)
488Sunset Blvd. (1950)
489Notorious (1946)
490To Catch a Thief (1955)
491Adventures of Robin Hood, The (1938)
492East of Eden (1955)
493Thin Man, The (1934)
494His Girl Friday (1940)
495Around the World in 80 Days (1956)
496It's a Wonderful Life (1946)
497Bringing Up Baby (1938)
498African Queen, The (1951)
499Cat on a Hot Tin Roof (1958)
500Fly Away Home (1996)
501Dumbo (1941)
502Bananas (1971)
503Candidate, The (1972)
504Bonnie and Clyde (1967)
505Dial M for Murder (1954)
506Rebel Without a Cause (1955)
507Streetcar Named Desire, A (1951)
508People vs. Larry Flynt, The (1996)
509My Left Foot (1989)
510Magnificent Seven, The (1954)
511Lawrence of Arabia (1962)
512Wings of Desire (1987)
513Third Man, The (1949)
514Annie Hall (1977)
515Boot, Das (1981)
516Local Hero (1983)
517Manhattan (1979)
518Miller's Crossing (1990)
519Treasure of the Sierra Madre, The (1948)
520Great Escape, The (1963)
521Deer Hunter, The (1978)
522Down by Law (1986)
523Cool Hand Luke (1967)
524Great Dictator, The (1940)
525Big Sleep, The (1946)
526Ben-Hur (1959)
527Gandhi (1982)
528Killing Fields, The (1984)
529My Life as a Dog (Mitt liv som hund) (1985)
530Man Who Would Be King, The (1975)
531Shine (1996)
532Kama Sutra: A Tale of Love (1996)
533Daytrippers, The (1996)
534Traveller (1997)
535Addicted to Love (1997)
536Ponette (1996)
537My Own Private Idaho (1991)
538Anastasia (1997)
539Mouse Hunt (1997)
540Money Train (1995)
541Mortal Kombat (1995)
542Pocahontas (1995)
543Mis�rables, Les (1995)
544Things to Do in Denver when You're Dead (1995)
545Vampire in Brooklyn (1995)
546Broken Arrow (1996)
547Young Poisoner's Handbook, The (1995)
548NeverEnding Story III, The (1994)
549Rob Roy (1995)
550Die Hard: With a Vengeance (1995)
551Lord of Illusions (1995)
552Species (1995)
553Walk in the Clouds, A (1995)
554Waterworld (1995)
555White Man's Burden (1995)
556Wild Bill (1995)
557Farinelli: il castrato (1994)
558Heavenly Creatures (1994)
559Interview with the Vampire (1994)
560Kid in King Arthur's Court, A (1995)
561Mary Shelley's Frankenstein (1994)
562Quick and the Dead, The (1995)
563Stephen King's The Langoliers (1995)
564Tales from the Hood (1995)
565Village of the Damned (1995)
566Clear and Present Danger (1994)
567Wes Craven's New Nightmare (1994)
568Speed (1994)
569Wolf (1994)
570Wyatt Earp (1994)
571Another Stakeout (1993)
572Blown Away (1994)
573Body Snatchers (1993)
574Boxing Helena (1993)
575City Slickers II: The Legend of Curly's Gold (1994)
576Cliffhanger (1993)
577Coneheads (1993)
578Demolition Man (1993)
579Fatal Instinct (1993)
580Englishman Who Went Up a Hill, But Came Down a Mountain, The (1995)
581Kalifornia (1993)
582Piano, The (1993)
583Romeo Is Bleeding (1993)
584Secret Garden, The (1993)
585Son in Law (1993)
586Terminal Velocity (1994)
587Hour of the Pig, The (1993)
588Beauty and the Beast (1991)
589Wild Bunch, The (1969)
590Hellraiser: Bloodline (1996)
591Primal Fear (1996)
592True Crime (1995)
593Stalingrad (1993)
594Heavy (1995)
595Fan, The (1996)
596Hunchback of Notre Dame, The (1996)
597Eraser (1996)
598Big Squeeze, The (1996)
599Police Story 4: Project S (Chao ji ji hua) (1993)
600Daniel Defoe's Robinson Crusoe (1996)
601For Whom the Bell Tolls (1943)
602American in Paris, An (1951)
603Rear Window (1954)
604It Happened One Night (1934)
605Meet Me in St. Louis (1944)
606All About Eve (1950)
607Rebecca (1940)
608Spellbound (1945)
609Father of the Bride (1950)
610Gigi (1958)
611Laura (1944)
612Lost Horizon (1937)
613My Man Godfrey (1936)
614Giant (1956)
61539 Steps, The (1935)
616Night of the Living Dead (1968)
617Blue Angel, The (Blaue Engel, Der) (1930)
618Picnic (1955)
619Extreme Measures (1996)
620Chamber, The (1996)
621Davy Crockett, King of the Wild Frontier (1955)
622Swiss Family Robinson (1960)
623Angels in the Outfield (1994)
624Three Caballeros, The (1945)
625Sword in the Stone, The (1963)
626So Dear to My Heart (1949)
627Robin Hood: Prince of Thieves (1991)
628Sleepers (1996)
629Victor/Victoria (1982)
630Great Race, The (1965)
631Crying Game, The (1992)
632Sophie's Choice (1982)
633Christmas Carol, A (1938)
634Microcosmos: Le peuple de l'herbe (1996)
635Fog, The (1980)
636Escape from New York (1981)
637Howling, The (1981)
638Return of Martin Guerre, The (Retour de Martin Guerre, Le) (1982)
639Tin Drum, The (Blechtrommel, Die) (1979)
640Cook the Thief His Wife & Her Lover, The (1989)
641Paths of Glory (1957)
642Grifters, The (1990)
643The Innocent (1994)
644Thin Blue Line, The (1988)
645Paris Is Burning (1990)
646Once Upon a Time in the West (1969)
647Ran (1985)
648Quiet Man, The (1952)
649Once Upon a Time in America (1984)
650Seventh Seal, The (Sjunde inseglet, Det) (1957)
651Glory (1989)
652Rosencrantz and Guildenstern Are Dead (1990)
653Touch of Evil (1958)
654Chinatown (1974)
655Stand by Me (1986)
656M (1931)
657Manchurian Candidate, The (1962)
658Pump Up the Volume (1990)
659Arsenic and Old Lace (1944)
660Fried Green Tomatoes (1991)
661High Noon (1952)
662Somewhere in Time (1980)
663Being There (1979)
664Paris, Texas (1984)
665Alien 3 (1992)
666Blood For Dracula (Andy Warhol's Dracula) (1974)
667Audrey Rose (1977)
668Blood Beach (1981)
669Body Parts (1991)
670Body Snatchers (1993)
671Bride of Frankenstein (1935)
672Candyman (1992)
673Cape Fear (1962)
674Cat People (1982)
675Nosferatu (Nosferatu, eine Symphonie des Grauens) (1922)
676Crucible, The (1996)
677Fire on the Mountain (1996)
678Volcano (1997)
679Conan the Barbarian (1981)
680Kull the Conqueror (1997)
681Wishmaster (1997)
682I Know What You Did Last Summer (1997)
683Rocket Man (1997)
684In the Line of Fire (1993)
685Executive Decision (1996)
686Perfect World, A (1993)
687McHale's Navy (1997)
688Leave It to Beaver (1997)
689Jackal, The (1997)
690Seven Years in Tibet (1997)
691Dark City (1998)
692American President, The (1995)
693Casino (1995)
694Persuasion (1995)
695Kicking and Screaming (1995)
696City Hall (1996)
697Basketball Diaries, The (1995)
698Browning Version, The (1994)
699Little Women (1994)
700Miami Rhapsody (1995)
701Wonderful, Horrible Life of Leni Riefenstahl, The (1993)
702Barcelona (1994)
703Widows' Peak (1994)
704House of the Spirits, The (1993)
705Singin' in the Rain (1952)
706Bad Moon (1996)
707Enchanted April (1991)
708Sex, Lies, and Videotape (1989)
709Strictly Ballroom (1992)
710Better Off Dead... (1985)
711Substance of Fire, The (1996)
712Tin Men (1987)
713Othello (1995)
714Carrington (1995)
715To Die For (1995)
716Home for the Holidays (1995)
717Juror, The (1996)
718In the Bleak Midwinter (1995)
719Canadian Bacon (1994)
720First Knight (1995)
721Mallrats (1995)
722Nine Months (1995)
723Boys on the Side (1995)
724Circle of Friends (1995)
725Exit to Eden (1994)
726Fluke (1995)
727Immortal Beloved (1994)
728Junior (1994)
729Nell (1994)
730Queen Margot (Reine Margot, La) (1994)
731Corrina, Corrina (1994)
732Dave (1993)
733Go Fish (1994)
734Made in America (1993)
735Philadelphia (1993)
736Shadowlands (1993)
737Sirens (1994)
738Threesome (1994)
739Pretty Woman (1990)
740Jane Eyre (1996)
741Last Supper, The (1995)
742Ransom (1996)
743Crow: City of Angels, The (1996)
744Michael Collins (1996)
745Ruling Class, The (1972)
746Real Genius (1985)
747Benny & Joon (1993)
748Saint, The (1997)
749MatchMaker, The (1997)
750Amistad (1997)
751Tomorrow Never Dies (1997)
752Replacement Killers, The (1998)
753Burnt By the Sun (1994)
754Red Corner (1997)
755Jumanji (1995)
756Father of the Bride Part II (1995)
757Across the Sea of Time (1995)
758Lawnmower Man 2: Beyond Cyberspace (1996)
759Fair Game (1995)
760Screamers (1995)
761Nick of Time (1995)
762Beautiful Girls (1996)
763Happy Gilmore (1996)
764If Lucy Fell (1996)
765Boomerang (1992)
766Man of the Year (1995)
767Addiction, The (1995)
768Casper (1995)
769Congo (1995)
770Devil in a Blue Dress (1995)
771Johnny Mnemonic (1995)
772Kids (1995)
773Mute Witness (1994)
774Prophecy, The (1995)
775Something to Talk About (1995)
776Three Wishes (1995)
777Castle Freak (1995)
778Don Juan DeMarco (1995)
779Drop Zone (1994)
780Dumb & Dumber (1994)
781French Kiss (1995)
782Little Odessa (1994)
783Milk Money (1994)
784Beyond Bedlam (1993)
785Only You (1994)
786Perez Family, The (1995)
787Roommates (1995)
788Relative Fear (1994)
789Swimming with Sharks (1995)
790Tommy Boy (1995)
791Baby-Sitters Club, The (1995)
792Bullets Over Broadway (1994)
793Crooklyn (1994)
794It Could Happen to You (1994)
795Richie Rich (1994)
796Speechless (1994)
797Timecop (1994)
798Bad Company (1995)
799Boys Life (1995)
800In the Mouth of Madness (1995)
801Air Up There, The (1994)
802Hard Target (1993)
803Heaven & Earth (1993)
804Jimmy Hollywood (1994)
805Manhattan Murder Mystery (1993)
806Menace II Society (1993)
807Poetic Justice (1993)
808Program, The (1993)
809Rising Sun (1993)
810Shadow, The (1994)
811Thirty-Two Short Films About Glenn Gould (1993)
812Andre (1994)
813Celluloid Closet, The (1995)
814Great Day in Harlem, A (1994)
815One Fine Day (1996)
816Candyman: Farewell to the Flesh (1995)
817Frisk (1995)
818Girl 6 (1996)
819Eddie (1996)
820Space Jam (1996)
821Mrs. Winterbourne (1996)
822Faces (1968)
823Mulholland Falls (1996)
824Great White Hype, The (1996)
825Arrival, The (1996)
826Phantom, The (1996)
827Daylight (1996)
828Alaska (1996)
829Fled (1996)
830Power 98 (1995)
831Escape from L.A. (1996)
832Bogus (1996)
833Bulletproof (1996)
834Halloween: The Curse of Michael Myers (1995)
835Gay Divorcee, The (1934)
836Ninotchka (1939)
837Meet John Doe (1941)
838In the Line of Duty 2 (1987)
839Loch Ness (1995)
840Last Man Standing (1996)
841Glimmer Man, The (1996)
842Pollyanna (1960)
843Shaggy Dog, The (1959)
844Freeway (1996)
845That Thing You Do! (1996)
846To Gillian on Her 37th Birthday (1996)
847Looking for Richard (1996)
848Murder, My Sweet (1944)
849Days of Thunder (1990)
850Perfect Candidate, A (1996)
851Two or Three Things I Know About Her (1966)
852Bloody Child, The (1996)
853Braindead (1992)
854Bad Taste (1987)
855Diva (1981)
856Night on Earth (1991)
857Paris Was a Woman (1995)
858Amityville: Dollhouse (1996)
859April Fool's Day (1986)
860Believers, The (1987)
861Nosferatu a Venezia (1986)
862Jingle All the Way (1996)
863Garden of Finzi-Contini, The (Giardino dei Finzi-Contini, Il) (1970)
864My Fellow Americans (1996)
865Ice Storm, The (1997)
866Michael (1996)
867Whole Wide World, The (1996)
868Hearts and Minds (1996)
869Fools Rush In (1997)
870Touch (1997)
871Vegas Vacation (1997)
872Love Jones (1997)
873Picture Perfect (1997)
874Career Girls (1997)
875She's So Lovely (1997)
876Money Talks (1997)
877Excess Baggage (1997)
878That Darn Cat! (1997)
879Peacemaker, The (1997)
880Soul Food (1997)
881Money Talks (1997)
882Washington Square (1997)
883Telling Lies in America (1997)
884Year of the Horse (1997)
885Phantoms (1998)
886Life Less Ordinary, A (1997)
887Eve's Bayou (1997)
888One Night Stand (1997)
889Tango Lesson, The (1997)
890Mortal Kombat: Annihilation (1997)
891Bent (1997)
892Flubber (1997)
893For Richer or Poorer (1997)
894Home Alone 3 (1997)
895Scream 2 (1997)
896Sweet Hereafter, The (1997)
897Time Tracers (1995)
898Postman, The (1997)
899Winter Guest, The (1997)
900Kundun (1997)
901Mr. Magoo (1997)
902Big Lebowski, The (1998)
903Afterglow (1997)
904Ma vie en rose (My Life in Pink) (1997)
905Great Expectations (1998)
906Oscar & Lucinda (1997)
907Vermin (1998)
908Half Baked (1998)
909Dangerous Beauty (1998)
910Nil By Mouth (1997)
911Twilight (1998)
912U.S. Marshalls (1998)
913Love and Death on Long Island (1997)
914Wild Things (1998)
915Primary Colors (1998)
916Lost in Space (1998)
917Mercury Rising (1998)
918City of Angels (1998)
919City of Lost Children, The (1995)
920Two Bits (1995)
921Farewell My Concubine (1993)
922Dead Man (1995)
923Raise the Red Lantern (1991)
924White Squall (1996)
925Unforgettable (1996)
926Down Periscope (1996)
927Flower of My Secret, The (Flor de mi secreto, La) (1995)
928Craft, The (1996)
929Harriet the Spy (1996)
930Chain Reaction (1996)
931Island of Dr. Moreau, The (1996)
932First Kid (1996)
933Funeral, The (1996)
934Preacher's Wife, The (1996)
935Paradise Road (1997)
936Brassed Off (1996)
937Thousand Acres, A (1997)
938Smile Like Yours, A (1997)
939Murder in the First (1995)
940Airheads (1994)
941With Honors (1994)
942What's Love Got to Do with It (1993)
943Killing Zoe (1994)
944Renaissance Man (1994)
945Charade (1963)
946Fox and the Hound, The (1981)
947Big Blue, The (Grand bleu, Le) (1988)
948Booty Call (1997)
949How to Make an American Quilt (1995)
950Georgia (1995)
951Indian in the Cupboard, The (1995)
952Blue in the Face (1995)
953Unstrung Heroes (1995)
954Unzipped (1995)
955Before Sunrise (1995)
956Nobody's Fool (1994)
957Pushing Hands (1992)
958To Live (Huozhe) (1994)
959Dazed and Confused (1993)
960Naked (1993)
961Orlando (1993)
962Ruby in Paradise (1993)
963Some Folks Call It a Sling Blade (1993)
964Month by the Lake, A (1995)
965Funny Face (1957)
966Affair to Remember, An (1957)
967Little Lord Fauntleroy (1936)
968Inspector General, The (1949)
969Winnie the Pooh and the Blustery Day (1968)
970Hear My Song (1991)
971Mediterraneo (1991)
972Passion Fish (1992)
973Grateful Dead (1995)
974Eye for an Eye (1996)
975Fear (1996)
976Solo (1996)
977Substitute, The (1996)
978Heaven's Prisoners (1996)
979Trigger Effect, The (1996)
980Mother Night (1996)
981Dangerous Ground (1997)
982Maximum Risk (1996)
983Rich Man's Wife, The (1996)
984Shadow Conspiracy (1997)
985Blood & Wine (1997)
986Turbulence (1997)
987Underworld (1997)
988Beautician and the Beast, The (1997)
989Cats Don't Dance (1997)
990Anna Karenina (1997)
991Keys to Tulsa (1997)
992Head Above Water (1996)
993Hercules (1997)
994Last Time I Committed Suicide, The (1997)
995Kiss Me, Guido (1997)
996Big Green, The (1995)
997Stuart Saves His Family (1995)
998Cabin Boy (1994)
999Clean Slate (1994)
1000Lightning Jack (1994)
Showing the first 1000 rows.
"]}}],"execution_count":5},{"cell_type":"code","source":["ratings = df.rdd\n\nnumRatings = ratings.count()\nnumUsers = ratings.map(lambda r: r[0]).distinct().count()\nnumMovies = ratings.map(lambda r: r[1]).distinct().count()\n\nprint(\"Got %d ratings from %d users on %d movies.\" % (numRatings, numUsers, numMovies))"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["\n
Got 100000 ratings from 943 users on 1682 movies.\n
"]}}],"execution_count":6},{"cell_type":"code","source":["from pyspark.sql import functions as F\nfrom pyspark.sql import DataFrameNaFunctions as DFna\nfrom pyspark.sql.functions import udf, col, when\n\nmovies_counts = df.groupBy(col(\"iid\")).agg(F.count(col(\"rating\")).alias(\"counts\"))\nmovies_counts.show()"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["\n
+----+------+\n iid|counts|\n+----+------+\n 496| 231|\n 471| 221|\n 463| 71|\n 148| 128|\n1342| 2|\n 833| 49|\n1088| 13|\n1591| 6|\n1238| 8|\n1580| 1|\n1645| 1|\n 392| 68|\n 623| 39|\n 540| 43|\n 858| 3|\n 737| 59|\n 243| 132|\n1025| 44|\n1084| 21|\n1127| 11|\n+----+------+\nonly showing top 20 rows\n\n
"]}}],"execution_count":7},{"cell_type":"code","source":["training_df, validation_df, test_df = df.randomSplit([.6, .2, .2], seed=594)"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["\n
"]}}],"execution_count":8},{"cell_type":"code","source":["df.randomSplit?"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["\n
Signature: df.randomSplit(weights, seed=None)\nDocstring:\nRandomly splits this :class:`DataFrame` with the provided weights.\n\n:param weights: list of doubles as weights with which to split the :class:`DataFrame`.\n Weights will be normalized if they don't sum up to 1.0.\n:param seed: The seed for sampling.\n\n>>> splits = df4.randomSplit([1.0, 2.0], 24)\n>>> splits[0].count()\n2\n\n>>> splits[1].count()\n2\n\n.. versionadded:: 1.4\nFile: /databricks/spark/python/pyspark/sql/dataframe.py\nType: method\n
"]}}],"execution_count":9},{"cell_type":"code","source":["from pyspark.ml.evaluation import RegressionEvaluator\nfrom pyspark.ml.recommendation import ALS\nfrom pyspark.ml.tuning import CrossValidator, ParamGridBuilder\nfrom pyspark.ml import Pipeline\nfrom pyspark.sql import Row\nimport numpy as np\nimport math"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["\n
"]}}],"execution_count":10},{"cell_type":"code","source":["seed = 594\niterations = 10\nregularization_parameter = 0.1\nranks = range(4, 12)\nerrors = []\nerr = 0\ntolerance = 0.02"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["\n
"]}}],"execution_count":11},{"cell_type":"code","source":["min_error = float('inf')\nbest_rank = -1\nbest_iteration = -1\n\nfor rank in ranks:\n als = ALS(maxIter=iterations, regParam=regularization_parameter, rank=rank, userCol=\"uid\", itemCol=\"iid\", ratingCol=\"rating\")\n model = als.fit(training_df)\n predictions = model.transform(validation_df)\n new_predictions = predictions.filter(col('prediction') != np.nan)\n evaluator = RegressionEvaluator(metricName=\"rmse\", labelCol=\"rating\", predictionCol=\"prediction\")\n rmse = evaluator.evaluate(new_predictions)\n errors.append(rmse)\n\n print('For rank %s the RMSE is %s' % (rank, rmse))\n if rmse < min_error:\n min_error = rmse\n best_rank = rank\nprint('The best model was trained with rank %s' % best_rank)"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["\n
For rank 4 the RMSE is 0.9473092189714923\nFor rank 5 the RMSE is 0.9507455673868448\nFor rank 6 the RMSE is 0.9434540735745667\nFor rank 7 the RMSE is 0.9530972289687596\nFor rank 8 the RMSE is 0.9530093430454498\nFor rank 9 the RMSE is 0.9549296825504305\nFor rank 10 the RMSE is 0.9583507143674425\nFor rank 11 the RMSE is 0.9521052467665101\nThe best model was trained with rank 6\n
"]}}],"execution_count":12},{"cell_type":"code","source":["training_df.take(3)"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["\n
Out[20]: [Row(uid=1, iid=1, rating=5, timestamp=874965758),\n Row(uid=1, iid=3, rating=4, timestamp=878542960),\n Row(uid=1, iid=5, rating=3, timestamp=889751712)]
"]}}],"execution_count":13},{"cell_type":"code","source":["validation_df.take(3)"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["\n
Out[21]: [Row(uid=1, iid=2, rating=3, timestamp=876893171),\n Row(uid=1, iid=6, rating=5, timestamp=887431973),\n Row(uid=1, iid=9, rating=5, timestamp=878543541)]
"]}}],"execution_count":14},{"cell_type":"code","source":["all_except_test_df = training_df.union(validation_df)"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["\n
"]}}],"execution_count":15},{"cell_type":"code","source":["final_als = ALS(maxIter=10, regParam=0.1, rank=6, userCol=\"uid\", itemCol=\"iid\", ratingCol=\"rating\")\nfinal_model = final_als.fit(all_except_test_df)\nfinal_pred = final_model.transform(test_df)\nfinal_pred = final_pred.filter(col('prediction') != np.nan)\nrmse = evaluator.evaluate(final_pred)\nprint(\"the one time final rmse (this is an internal metric) for our model is: {}\".format(rmse))"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["\n
the one time final rmse (this is an internal metric) for our model is: 0.9167468436151646\n
"]}}],"execution_count":16},{"cell_type":"code","source":["np.random.seed(594)\nuser_id = np.random.choice(numUsers)"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["\n
"]}}],"execution_count":17},{"cell_type":"code","source":["new_user_ratings = df.filter(df.uid == user_id)\nnew_user_ratings.sort('rating', ascending=True).take(10) # top rated movies for this user"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["\n
Out[27]: [Row(uid=577, iid=693, rating=1, timestamp=880475408),\n Row(uid=577, iid=1336, rating=1, timestamp=880472018),\n Row(uid=577, iid=425, rating=2, timestamp=880474808),\n Row(uid=577, iid=11, rating=2, timestamp=880474293),\n Row(uid=577, iid=38, rating=2, timestamp=880475453),\n Row(uid=577, iid=7, rating=2, timestamp=880470447),\n Row(uid=577, iid=179, rating=2, timestamp=880474829),\n Row(uid=577, iid=949, rating=2, timestamp=880475408),\n Row(uid=577, iid=795, rating=3, timestamp=880476630),\n Row(uid=577, iid=996, rating=3, timestamp=880475094)]
"]}}],"execution_count":18},{"cell_type":"code","source":["new_user_ratings.describe('rating').show()"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["\n
+-------+------------------+\nsummary| rating|\n+-------+------------------+\n count| 188|\n mean|3.8031914893617023|\n stddev|0.8392703894843124|\n min| 1|\n max| 5|\n+-------+------------------+\n\n
"]}}],"execution_count":19},{"cell_type":"code","source":["display(new_user_ratings)"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["
uidiidratingtimestamp
5774713880471640
5772294880475094
5772844880470732
5779963880475094
5772044880474338
5776624880474933
5771174880471359
5776844880474394
577955880474747
5771883880474715
577153880470350
5771864880472153
5773934880475363
577382880475453
5777204880475043
5772183880475269
5771104880475581
57712913880471954
5773803880474991
5774434880475269
577404880475435
5773655880475504
5778454880471578
5779323880471287
5777275880474747
577124880474257
5773855880474530
5776235880475149
5775614880474955
5777953880476630
57710323880475561
5775954880471170
5772813880470447
5772254880470827
5772303880474357
5778083880475094
5776554880474394
57715314880475408
5771685880472124
5772415880474766
577112880474293
5774234880472124
5772033880474455
5773383880469983
577584880474414
5775453880476578
5778665880470570
57712094880476578
57744880474635
577254880470504
5775603880475363
57712713880475581
577993880474674
577443880474934
577875880474216
5776515880475043
5771324880472153
57710334880471170
5778293880470884
577563880474934
5779395880474933
5774473880475226
577634880476606
5774074880471271
57715880470282
5772084880474556
5776733880474851
5772103880474715
5779492880475408
5775314890089749
5772655880474851
5775824880475540
5771004880470350
577853880475170
577694880474829
5772175880475363
5772283880474338
5771404880475043
57784880474257
5771914880472055
5771944880474216
577715880474433
5771474880470604
5775495880475539
5777283880475226
577655880475539
5775664880474216
577285880472077
5771183880471658
5777393880474871
5776654880475644
5771514880470604
577773880475561
5772264880475094
577553880474694
5771114880470604
5775794880475602
5774252880474808
577293880474903
5774364880475339
577314880474216
5774683880474766
5773073890089564
5773994880475269
5771433880474635
577544880474903
577824880474433
5771735880472055
577645880474394
57772880470447
577794880474530
5771615880475561
57715173880475644
5776275880475339
5777355880474338
5774053880470282
5776635880474612
5772984884819086
5777424880470504
5772374880470323
5771724880472124
5773134890089462
5771024880475043
5775683880475021
57710444880475504
577623880475504
5772403880470884
5774705880475245
5774103880471170
577964880474257
5776931880475408
5777083880475067
5771965880474357
5771745880475043
5777683880474787
5774724880470570
577485880474530
5775463880470483
5774654880474851
5774095880470682
5771792880474829
5772155880474556
5772024880474787
5773175880474871
5774034880475187
57710543880471823
5775503880475130
577494880474955
57712193880475067
5774965880474455
5775593880474903
5772343880474257
5771835880474747
5778233880471304
5773185880472055
57710424880475286
5771334880474694
577504880474394
5777633880470638
577984880474530
5774274880474715
57713361880472018
5775884880474808
57710353880475130
57711474880474394
577225880472153
5772944880469903
5772164880472124
5779414880475435
5771215880470258
5778193880470604
5774523880475644
5773564880474903
5772003880475226
5774024880475318
5777704880475149
57710284880470764
5777324880474414
577975880472153
577684880475021
57754880475318
5771254880470604
5776603880474613
5778264880470852
577883880475226
57710464880475226
5771815880474612
5771765880474311
"]}}],"execution_count":20},{"cell_type":"code","source":["new_user_rated_iids = [i.iid for i in new_user_ratings.select('iid').distinct().collect()]\nmovies_of_interest = [i.iid for i in movies_counts.filter(movies_counts.counts > 25).select('iid').distinct().collect()]\nnew_user_unrated_iids = list(set(movies_of_interest) - set(new_user_rated_iids))"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["\n
"]}}],"execution_count":21},{"cell_type":"code","source":["import time\ncols = ('uid', 'iid', 'timestamp')\nnew_user_preds = sqlContext.createDataFrame(zip([user_id] * len(new_user_unrated_iids), new_user_unrated_iids, [int(time.time())] * len(new_user_unrated_iids)), cols)\nnew_user_preds = final_model.transform(new_user_preds).filter(col('prediction') != np.nan)"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["\n
"]}}],"execution_count":22},{"cell_type":"code","source":["new_user_preds.join(movies_sdf,new_user_preds.iid == movies_sdf._c0,\"left\").sort('prediction', ascending=False).take(10)"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["\n
Out[35]: [Row(uid=577, iid=613, timestamp=1601567162, prediction=4.730799198150635, _c0=613, _c1='My Man Godfrey (1936)'),\n Row(uid=577, iid=169, timestamp=1601567162, prediction=4.477397441864014, _c0=169, _c1='Wrong Trousers, The (1993)'),\n Row(uid=577, iid=963, timestamp=1601567162, prediction=4.4612321853637695, _c0=963, _c1='Some Folks Call It a Sling Blade (1993)'),\n Row(uid=577, iid=966, timestamp=1601567162, prediction=4.45092248916626, _c0=966, _c1='Affair to Remember, An (1957)'),\n Row(uid=577, iid=316, timestamp=1601567162, prediction=4.449735164642334, _c0=316, _c1='As Good As It Gets (1997)'),\n Row(uid=577, iid=483, timestamp=1601567162, prediction=4.435473918914795, _c0=483, _c1='Casablanca (1942)'),\n Row(uid=577, iid=83, timestamp=1601567162, prediction=4.3526611328125, _c0=83, _c1='Much Ado About Nothing (1993)'),\n Row(uid=577, iid=408, timestamp=1601567162, prediction=4.3512749671936035, _c0=408, _c1='Close Shave, A (1995)'),\n Row(uid=577, iid=520, timestamp=1601567162, prediction=4.335349082946777, _c0=520, _c1='Great Escape, The (1963)'),\n Row(uid=577, iid=478, timestamp=1601567162, prediction=4.331514835357666, _c0=478, _c1='Philadelphia Story, The (1940)')]
"]}}],"execution_count":23},{"cell_type":"code","source":["display(new_user_preds)"],"metadata":{},"outputs":[{"metadata":{},"output_type":"display_data","data":{"text/html":["
uidiidtimestampprediction
57714816015671623.7349138
57713716015671623.452837
5775316015671622.6230783
5777816015671622.6354327
57710816015671622.6505985
57715516015671623.7758074
57710116015671623.1562262
57712616015671624.2304254
5778116015671623.4848535
5777616015671623.232955
5772616015671623.456955
5772716015671623.3496583
5779116015671623.5127306
57712816015671623.2317798
57712216015671621.9745321
5779316015671622.980314
57715716015671623.768892
5774716015671622.9676847
57715216015671623.8228
5775216015671623.497819
5771316015671623.2846882
577616015671623.6136034
5771616015671623.2533998
5778616015671623.663897
577316015671623.1772454
57714216015671623.6373813
5772016015671622.7910204
57713916015671623.1400595
5779416015671623.3727624
5775716015671624.0368547
57712016015671622.4723022
5771916015671623.6876194
5779216015671623.1343336
5774116015671622.9884877
57715416015671623.5896666
5774316015671623.1789644
5776116015671623.6450453
57712716015671623.9208107
57710716015671623.842248
577916015671623.5442939
5771716015671623.0160644
5777216015671623.6011186
57711416015671624.175839
5775916015671623.8166497
5772316015671623.473093
5773916015671623.104479
57713616015671624.166356
5775116015671623.956842
57712916015671623.7700055
5771016015671623.730876
5774516015671623.748002
5778016015671623.1641006
5777316015671623.7090516
5772416015671623.341721
5777016015671623.7374487
57715616015671623.263679
5772116015671623.2623842
5773216015671622.745503
5776016015671623.4420652
5779016015671623.2384198
57714116015671623.5622506
57714516015671622.6489835
57710916015671623.3290167
57710516015671622.7727118
5773316015671623.5165453
5778316015671624.352661
57715016015671623.8187828
57710616015671623.0234084
57711616015671623.5778325
5771416015671623.552068
57712316015671623.1052542
57715816015671623.062732
57713516015671623.5728033
5774216015671623.4810994
577216015671623.585717
57713116015671623.4642496
57712416015671623.714766
5773016015671623.6477404
5776616015671623.9985378
5774616015671622.8619697
5776716015671623.3006852
57714416015671623.8065968
57715316015671623.937158
57713416015671623.739754
5778916015671623.8171191
57724316015671622.5875096
57725116015671623.956649
57725516015671623.6116235
57719316015671623.8507953
57721116015671623.9078047
57715916015671623.4714627
57719216015671623.4296818
57727116015671623.004578
57725316015671623.0145674
57723616015671623.6113605
57722316015671624.1052446
57722216015671623.9322038
57720916015671623.333107
57719016015671624.2999325
57723216015671623.4417574
57723316015671623.3146298
57724616015671624.1257324
57722416015671624.007897
57717716015671623.6678386
57718516015671623.8525271
57725916015671622.9007914
57720616015671623.4386492
57721216015671623.015236
57727416015671624.026753
57718216015671623.3987653
57728016015671623.457409
57720516015671623.6450784
57717816015671624.1991096
57716416015671624.064994
57716916015671624.4773974
57725016015671623.2316985
57723516015671622.7207355
57726616015671622.8267488
57716316015671623.8500385
57726816015671623.947246
57725816015671624.1572466
57727916015671623.8389373
57725716015671623.9922693
57722716015671623.503086
57726216015671623.400873
57726916015671623.7790504
57716516015671623.798262
57718916015671624.1584387
57720716015671623.7811716
57719716015671623.9227896
57723116015671622.8557732
57717516015671623.1882658
57722016015671623.8952715
57727816015671623.703743
57716216015671623.7107363
57723816015671623.4916115
57724416015671623.1962516
57717116015671623.5745225
57727316015671623.4562268
57727716015671623.3824496
57716616015671624.1113057
57723916015671623.955223
57726416015671623.1001053
57726116015671622.5400174
57724916015671623.245626
57716716015671623.3136957
57724516015671623.302598
57716016015671622.811526
57721916015671622.9513197
57721416015671623.3561194
57719516015671623.7743049
57722116015671623.2500873
57727216015671624.315445
57725416015671622.93678
57721316015671624.003095
57717016015671624.2313094
57726016015671622.2562804
57719816015671623.8606272
57719916015671624.116412
57724216015671623.6274781
57727016015671623.8632169
57724816015671623.6826568
57720116015671623.4427037
57727616015671623.3857563
57718416015671623.0926938
57727516015671624.0694885
57728216015671624.043614
57725216015671623.306243
57718016015671623.4959495
57718716015671623.752205
57739216015671623.8856678
57732216015671623.3196313
57732116015671623.3795917
57736216015671622.832314
57736816015671622.0436614
57730016015671623.8730383
57733216015671623.4499912
57738416015671622.967403
57732916015671622.8177495
57733616015671622.842483
57735016015671622.8248036
57738816015671622.8695612
57733316015671623.7327409
57728516015671623.6215127
57733016015671623.0345342
57737216015671623.6187575
57731916015671623.5990028
57734616015671623.038837
57736716015671623.456652
57730516015671623.1012263
57735516015671623.2674785
57729116015671623.5508966
57732516015671622.5291317
57738616015671623.0188262
57729716015671623.687904
57736316015671622.9576778
57734816015671622.9998124
57730816015671623.295679
57732816015671623.8438778
57728316015671623.7824507
57729516015671623.6904316
57734016015671622.9405453
57729216015671623.747388
57730616015671623.8817234
57733916015671623.2416632
57729916015671622.5201893
57730916015671623.1476026
57734716015671623.997172
57732716015671623.1986914
57735816015671622.768694
57736616015671623.8529816
57738316015671622.4317646
57731616015671624.449735
57732416015671622.3323398
57728616015671623.5897694
57739816015671622.420562
57738716015671623.274987
57738116015671623.224213
57731016015671624.0809174
57729016015671623.4712038
57732616015671623.833541
57730116015671623.435178
57734316015671622.7451026
57733116015671623.4528284
57739116015671622.872729
57731216015671623.3604383
57738916015671624.0296054
57739516015671623.086611
57729316015671623.6164136
57736416015671623.26308
57728816015671623.4912348
57728916015671623.6464138
57739616015671622.2836986
57732316015671623.1653516
57735216015671622.0642292
57728716015671623.551552
57734516015671624.115505
57737116015671623.6875877
57738216015671623.3348796
57733416015671622.8177893
57737816015671624.0333123
57730316015671623.6894455
57735416015671623.5875897
57730416015671623.764547
57737016015671623.3857818
57736916015671622.664054
57734416015671623.3649635
57734916015671622.968232
57734216015671623.2528422
57737316015671623.1288211
57737916015671623.1053858
57735716015671624.1738653
57730216015671623.785349
57731116015671623.1718402
57731516015671624.1681113
57746316015671623.666542
57751616015671623.822973
57745116015671623.8580983
57745816015671623.0614722
57748116015671623.4510608
57751316015671623.9595053
57749716015671623.7452857
57740616015671622.689051
57741216015671622.2782352
57750116015671623.4552548
57746016015671623.3014224
57741716015671623.6316838
57749316015671623.9147139
57747616015671623.3051925
57741616015671623.7632527
57744416015671622.5626838
57743516015671624.051382
57747316015671622.9256856
57751216015671623.1443307
57747416015671623.7664142
57742916015671624.024608
57750016015671624.0556736
57747916015671624.0503755
57743116015671623.6395783
57743216015671623.5102987
57749116015671623.8558817
57750716015671623.5057948
57743016015671623.962387
57741916015671623.8976774
57750416015671623.643397
57745516015671623.3343809
57748416015671623.9160376
57751116015671623.9765651
57748916015671623.7872899
57746116015671623.368856
57750216015671623.7654562
57748616015671623.92186
57746216015671623.8056865
57750516015671623.6783066
57749816015671624.141324
57750316015671623.3851233
57748516015671624.034527
57745616015671622.359958
57744116015671622.6422539
57749416015671623.7748663
57744916015671623.5681047
57745016015671622.8094099
57749516015671623.7009811
57751416015671623.4686248
57743416015671623.5632544
57742816015671623.730521
57744816015671623.3047574
57746716015671623.821679
57750916015671623.6509273
57740416015671623.4971697
57741816015671623.8970175
57751016015671623.775739
57740816015671624.351275
57748016015671623.9944863
57741116015671623.0905402
57747716015671623.6148436
57748216015671623.7910042
57746416015671624.134389
57749216015671623.520435
57749016015671623.9596138
57746916015671623.7820947
57745716015671622.2531338
57741416015671623.084982
57743316015671623.556552
57748816015671623.3327973
57751516015671624.33148
57748716015671623.9048724
57747816015671624.331515
57742616015671623.0591145
57742116015671623.988637
57741316015671622.4189856
57750816015671623.3066015
57749916015671623.7252512
57746616015671623.6205387
57750616015671623.8641634
57742016015671623.708222
57747516015671623.2080977
57748316015671624.435474
57740116015671622.8378992
57742216015671622.7267408
57754016015671622.996083
57758016015671622.8560905
57761316015671624.730799
57763316015671624.0392623
57759716015671623.4113028
57753016015671623.6822186
57764216015671623.183212
57759616015671623.700729
57757716015671622.5822852
57760616015671623.8689964
57760216015671623.729096
57757816015671623.5292194
57760416015671623.7527428
57762516015671623.617259
57753916015671622.3841746
57751916015671623.876633
57758116015671623.1512856
57760316015671624.166873
57763116015671623.6411576
57763616015671623.1256852
57757216015671622.741505
57757016015671623.298703
57764616015671623.460957
57762016015671623.2293515
57754416015671623.1497316
57754216015671622.6659324
57755316015671623.7334945
57764116015671623.3354578
57764416015671623.1226463
57755416015671623.0499773
57760716015671623.737942
57756316015671622.8487966
57761516015671623.5877674
57752316015671623.8688881
57754716015671622.6400702
57756416015671622.1117718
57761916015671623.3598127
57755216015671622.5456433
57758616015671622.7313313
57760916015671623.7027164
57753816015671623.6590242
57758316015671622.884684
57761016015671623.5483885
57761416015671623.8341084
57753716015671623.4433126
57752016015671624.335349
57762916015671623.5300045
57763716015671622.6921687
57758516015671623.1941164
57752416015671623.77781
57758916015671623.3617058
57751816015671623.5697224
57752716015671624.105485
57756916015671623.1010728
57757616015671623.3420177
57759116015671623.761727
57764516015671623.9977174
57752616015671623.5796716
57752816015671623.943419
57755816015671623.0587482
57762216015671623.5887947
57763016015671623.636026
57764016015671622.6021667
57760816015671623.8824599
57763916015671623.435916
57761116015671623.9514976
57761216015671624.06528
57757516015671622.8276024
57754116015671622.813262
57756716015671622.6208324
57752516015671623.7114701
57763816015671623.67565
57752216015671623.2848208
57752916015671623.641605
57757316015671622.9832947
57757116015671622.3941102
57760516015671623.1767907
57753516015671623.1380343
57761616015671622.661368
57762816015671623.6244717
57763216015671623.6523745
57756216015671623.2578533
57758416015671623.5701368
57752116015671623.6043777
57751716015671623.3260987
57773716015671622.6937046
57768316015671622.345525
57774416015671623.6628754
57775616015671623.177516
57777216015671622.9973094
57776216015671623.4937813
57773116015671623.5608509
57768816015671621.9752197
57772316015671623.4687138
57774316015671621.8926723
57773816015671623.3268309
57770716015671623.6986952
57768516015671623.5691824
57768616015671623.9980688
57765416015671623.6603036
57767116015671622.7676435
57769416015671624.182815
57769616015671623.4652526
57774716015671623.7197156
57774816015671623.5047011
57777416015671623.512638
57767416015671622.8493557
57771516015671622.9853826
57768916015671623.2240815
57769916015671623.9356494
57773416015671622.906793
57776016015671622.3201525
57769216015671624.2009478
57764716015671623.3993092
57767616015671623.6772099
57765016015671623.2648742
57770916015671624.167737
57772916015671623.7250912
57775416015671623.8650873
57778016015671622.9045312
57776416015671623.4784162
57777516015671623.2089374
57767516015671622.5209007
57765916015671624.109344
57774616015671624.0358663
57772116015671623.2696917
57776116015671623.0449047
57771316015671623.676576
57771716015671623.1286035
57768716015671622.495021
57767916015671622.8241906
57771916015671622.592332
57767216015671622.379169
57773616015671623.881259
57764816015671624.0783224
57766416015671623.0379922
57764916015671623.3801098
57766116015671623.7318113
57777916015671623.2939937
57765816015671623.5943835
57775016015671624.1478024
57777116015671622.7801468
57776916015671623.014618
57769716015671623.780296
57774016015671623.773751
57774116015671623.5030153
57765316015671623.211106
57771016015671623.5556598
57767816015671622.8776014
57775216015671623.7799132
57771216015671623.4066715
57772416015671623.6389818
57775116015671623.6231618
57768016015671622.9904392
57774916015671623.7878704
57770216015671623.02093
57778116015671623.5811222
57765716015671624.142658
57769016015671623.3141177
57776516015671623.1008153
57777816015671623.732685
57772216015671623.2418578
57765216015671623.5388815
57768216015671623.0247502
57768116015671622.6315954
57771616015671623.6419268
57770516015671624.0228057
57767016015671623.196446
57775516015671623.6378524
57765616015671623.3089204
57783316015671623.1401129
57787916015671623.3147314
57789816015671623.079263
57796116015671623.1801147
57787616015671622.4072084
57795016015671622.6735353
57779616015671623.4734542
57784716015671623.654999
57787416015671623.215847
57784216015671623.2149537
57783116015671622.3706834
57784416015671622.800603
57780616015671623.5189548
57792616015671622.939883
57787516015671622.770468
57792416015671623.9428566
57785516015671623.417997
57782716015671623.1168814
57788216015671623.4881182
57795516015671623.1215491
57779716015671623.4386976
57789616015671623.1185074
57779216015671623.1185164
57788716015671623.4010396
57792516015671623.602367
57788116015671622.2588859
57791916015671623.311588
57792316015671623.849684
57794416015671623.4584966
57784616015671623.3441706
57787116015671622.676867
57784016015671623.123662
57795916015671623.175903
57783616015671623.5408216
57788616015671623.5352252
57793616015671624.009689
57793116015671622.315149
57792916015671622.91579
57784916015671622.8600588
57784316015671623.1399457
57793716015671623.727657
57788016015671623.6027732
57790016015671624.0503354
57780016015671622.7690759
57794816015671622.053209
57781016015671623.4094248
57781316015671623.2447863
57789016015671621.6380632
57793016015671622.977629
57792216015671623.1550999
57787716015671622.0754757
57785616015671623.3248627
57782416015671622.7407281
57795616015671623.2890396
57779416015671623.943799
57792816015671623.1191697
57795116015671623.1153817
57795216015671622.7001421
57794616015671623.600659
57794516015671624.124577
57789516015671623.04914
57792116015671623.8407521
57778916015671623.3837924
57779016015671623.4326062
57780916015671623.5548086
57794316015671623.0504668
57794016015671622.0781891
57778316015671623.2233295
57787216015671623.3427207
57782516015671623.2386408
57780516015671623.9704447
57790216015671623.4826586
57789216015671622.8617299
57782016015671622.8535125
57790516015671623.5111392
57794216015671623.7463293
57781516015671623.7194495
57780216015671622.9988894
57787316015671623.0283976
57786416015671623.5163982
57778516015671623.54805
57793416015671623.1098676
57784116015671622.994052
57787816015671622.7646701
57796316015671624.461232
577102516015671622.3834746
577113916015671622.8824391
577101616015671623.8607118
577113316015671623.1106207
57797416015671623.0128686
577116016015671623.6427999
577122616015671623.327926
577105116015671623.563748
577103416015671622.327015
57798816015671622.857348
577101916015671623.3612566
577113516015671623.0220332
577121016015671623.2500837
57798416015671622.6470609
577121516015671621.8726363
57799516015671623.1701453
577106516015671623.3243682
577106116015671623.4833715
577119716015671624.0793104
577124416015671622.8967772
577117016015671622.538267
577100816015671623.077716
577104716015671623.0230017
577113716015671624.3119555
577108916015671622.7058656
577126716015671623.2484636
57797216015671623.0602596
577121816015671623.4666164
577102116015671622.4048216
57796616015671624.4509225
577107416015671623.452332
57796916015671624.267146
577101016015671623.6277328
57798916015671622.7598572
577122016015671624.00241
577104816015671623.006929
577105016015671623.6969275
577113616015671623.9078956
577119416015671624.1702023
577109116015671623.308952
577113216015671622.6406572
577124016015671623.7297435
577107316015671623.5066576
577111916015671623.9509444
57797916015671623.3720243
57799316015671623.814421
577101716015671622.7068515
577111816015671623.0148916
577105916015671622.8213954
577114216015671624.1528206
577102216015671622.9720078
577106016015671623.4004657
577104116015671623.5034072
577102016015671623.7236302
577113416015671623.6670249
577100716015671624.256356
577109816015671623.5129213
57797716015671622.9386933
577103916015671624.0654984
577111016015671622.9521184
577112616015671622.9555042
577122116015671623.8930871
577107916015671622.5820084
577118816015671623.0443957
57799016015671622.740136
577128416015671622.7302516
577101416015671623.1855834
577111516015671623.4671082
57797816015671622.8587153
577102316015671622.9221823
577114916015671623.8345618
577115216015671623.906551
577112916015671623.636402
577122816015671622.68634
57797516015671623.2669725
57797116015671623.0006914
577101816015671623.2065296
577109516015671622.5542836
577107016015671622.8652575
577101116015671623.3324885
577109016015671622.6447725
577101216015671623.3325675
577110116015671623.7467215
577106316015671623.985658
577106716015671623.4355252
577141116015671622.0136662
577101316015671622.2987149
577110916015671623.2367516
577100916015671623.354474
577121716015671623.4660048
"]}}],"execution_count":24},{"cell_type":"code","source":[""],"metadata":{},"outputs":[],"execution_count":25}],"metadata":{"name":"recommendation_system_MLLib","notebookId":2102833272923202},"nbformat":4,"nbformat_minor":0}