#Pelicualas sin el NAN
library(dslabs)
data("movielens")
vLogico <-is.nan(movielens$year)
dfMovie <-data.frame(title=movielens$title,year=movielens$year[!vLogico],
genres=movielens$genres,userid=movielens$userId,rating=movielens$rating,stringsAsFactors = FALSE)
head(dfMovie,100)## title year
## 1 Dangerous Minds 1995
## 2 Dumbo 1941
## 3 Sleepers 1996
## 4 Escape from New York 1981
## 5 Cinema Paradiso (Nuovo cinema Paradiso) 1989
## 6 Deer Hunter, The 1978
## 7 Ben-Hur 1959
## 8 Gandhi 1982
## 9 Dracula (Bram Stoker's Dracula) 1992
## 10 Cape Fear 1991
## 11 Star Trek: The Motion Picture 1979
## 12 Beavis and Butt-Head Do America 1996
## 13 French Connection, The 1971
## 14 Tron 1982
## 15 Gods Must Be Crazy, The 1980
## 16 Willow 1988
## 17 Antz 1998
## 18 Fly, The 1986
## 19 Time Bandits 1981
## 20 Blazing Saddles 1974
## 21 GoldenEye 1995
## 22 Sense and Sensibility 1995
## 23 Clueless 1995
## 24 Seven (a.k.a. Se7en) 1995
## 25 Usual Suspects, The 1995
## 26 Mighty Aphrodite 1995
## 27 Mr. Holland's Opus 1995
## 28 Braveheart 1995
## 29 Brothers McMullen, The 1995
## 30 Apollo 13 1995
## 31 Batman Forever 1995
## 32 Crimson Tide 1995
## 33 Die Hard: With a Vengeance 1995
## 34 First Knight 1995
## 35 Net, The 1995
## 36 Nine Months 1995
## 37 Waterworld 1995
## 38 Circle of Friends 1995
## 39 Clerks 1994
## 40 Disclosure 1994
## 41 Ed Wood 1994
## 42 Houseguest 1994
## 43 Interview with the Vampire: The Vampire Chronicles 1994
## 44 Little Women 1994
## 45 Like Water for Chocolate (Como agua para chocolate) 1992
## 46 Legends of the Fall 1994
## 47 Madness of King George, The 1994
## 48 Mary Shelley's Frankenstein (Frankenstein) 1994
## 49 Outbreak 1995
## 50 Pulp Fiction 1994
## 51 Quiz Show 1994
## 52 Secret of Roan Inish, The 1994
## 53 Santa Clause, The 1994
## 54 Shallow Grave 1994
## 55 While You Were Sleeping 1995
## 56 Clear and Present Danger 1994
## 57 Client, The 1994
## 58 Forrest Gump 1994
## 59 Four Weddings and a Funeral 1994
## 60 Lion King, The 1994
## 61 Mask, The 1994
## 62 Naked Gun 33 1/3: The Final Insult 1994
## 63 Paper, The 1994
## 64 Reality Bites 1994
## 65 Speed 1994
## 66 Wolf 1994
## 67 Highlander III: The Sorcerer (a.k.a. Highlander: The Final Dimension) 1994
## 68 Addams Family Values 1993
## 69 Firm, The 1993
## 70 Fugitive, The 1993
## 71 Englishman Who Went Up a Hill But Came Down a Mountain, The 1995
## 72 In the Line of Fire 1993
## 73 Jurassic Park 1993
## 74 Last Action Hero 1993
## 75 Much Ado About Nothing 1993
## 76 Mrs. Doubtfire 1993
## 77 Philadelphia 1993
## 78 Piano, The 1993
## 79 Remains of the Day, The 1993
## 80 Schindler's List 1993
## 81 Sirens 1994
## 82 Sleepless in Seattle 1993
## 83 Threesome 1994
## 84 Nightmare Before Christmas, The 1993
## 85 Three Musketeers, The 1993
## 86 Brady Bunch Movie, The 1995
## 87 Home Alone 1990
## 88 Ghost 1990
## 89 Aladdin 1992
## 90 Terminator 2: Judgment Day 1991
## 91 Dances with Wolves 1990
## 92 Batman 1989
## 93 Silence of the Lambs, The 1991
## 94 Aristocats, The 1970
## 95 James and the Giant Peach 1996
## 96 Wallace & Gromit: The Best of Aardman Animation 1996
## 97 Indian in the Cupboard, The 1995
## 98 Braveheart 1995
## 99 Heavenly Creatures 1994
## 100 Major Payne 1995
## genres userid rating
## 1 Drama 1 2.5
## 2 Animation|Children|Drama|Musical 1 3.0
## 3 Thriller 1 3.0
## 4 Action|Adventure|Sci-Fi|Thriller 1 2.0
## 5 Drama 1 4.0
## 6 Drama|War 1 2.0
## 7 Action|Adventure|Drama 1 2.0
## 8 Drama 1 2.0
## 9 Fantasy|Horror|Romance|Thriller 1 3.5
## 10 Thriller 1 2.0
## 11 Adventure|Sci-Fi 1 2.5
## 12 Adventure|Animation|Comedy|Crime 1 1.0
## 13 Action|Crime|Thriller 1 4.0
## 14 Action|Adventure|Sci-Fi 1 4.0
## 15 Adventure|Comedy 1 3.0
## 16 Action|Adventure|Fantasy 1 2.0
## 17 Adventure|Animation|Children|Comedy|Fantasy 1 2.0
## 18 Drama|Horror|Sci-Fi|Thriller 1 2.5
## 19 Adventure|Comedy|Fantasy|Sci-Fi 1 1.0
## 20 Comedy|Western 1 3.0
## 21 Action|Adventure|Thriller 2 4.0
## 22 Drama|Romance 2 5.0
## 23 Comedy|Romance 2 5.0
## 24 Mystery|Thriller 2 4.0
## 25 Crime|Mystery|Thriller 2 4.0
## 26 Comedy|Drama|Romance 2 3.0
## 27 Drama 2 3.0
## 28 Action|Drama|War 2 4.0
## 29 Comedy 2 3.0
## 30 Adventure|Drama|IMAX 2 5.0
## 31 Action|Adventure|Comedy|Crime 2 4.0
## 32 Drama|Thriller|War 2 3.0
## 33 Action|Crime|Thriller 2 3.0
## 34 Action|Drama|Romance 2 3.0
## 35 Action|Crime|Thriller 2 3.0
## 36 Comedy|Romance 2 3.0
## 37 Action|Adventure|Sci-Fi 2 3.0
## 38 Drama|Romance 2 5.0
## 39 Comedy 2 1.0
## 40 Drama|Thriller 2 3.0
## 41 Comedy|Drama 2 3.0
## 42 Comedy 2 3.0
## 43 Drama|Horror 2 4.0
## 44 Drama 2 4.0
## 45 Drama|Fantasy|Romance 2 5.0
## 46 Drama|Romance|War|Western 2 5.0
## 47 Comedy|Drama 2 3.0
## 48 Drama|Horror|Sci-Fi 2 4.0
## 49 Action|Drama|Sci-Fi|Thriller 2 3.0
## 50 Comedy|Crime|Drama|Thriller 2 4.0
## 51 Drama 2 3.0
## 52 Children|Drama|Fantasy|Mystery 2 4.0
## 53 Comedy|Drama|Fantasy 2 2.0
## 54 Comedy|Drama|Thriller 2 1.0
## 55 Comedy|Romance 2 3.0
## 56 Action|Crime|Drama|Thriller 2 4.0
## 57 Drama|Mystery|Thriller 2 4.0
## 58 Comedy|Drama|Romance|War 2 3.0
## 59 Comedy|Romance 2 3.0
## 60 Adventure|Animation|Children|Drama|Musical|IMAX 2 3.0
## 61 Action|Comedy|Crime|Fantasy 2 3.0
## 62 Action|Comedy 2 2.0
## 63 Comedy|Drama 2 3.0
## 64 Comedy|Drama|Romance 2 3.0
## 65 Action|Romance|Thriller 2 3.0
## 66 Drama|Horror|Romance|Thriller 2 3.0
## 67 Action|Fantasy 2 2.0
## 68 Children|Comedy|Fantasy 2 3.0
## 69 Drama|Thriller 2 4.0
## 70 Thriller 2 3.0
## 71 Comedy|Romance 2 4.0
## 72 Action|Thriller 2 2.0
## 73 Action|Adventure|Sci-Fi|Thriller 2 4.0
## 74 Action|Adventure|Comedy|Fantasy 2 3.0
## 75 Comedy|Romance 2 3.0
## 76 Comedy|Drama 2 4.0
## 77 Drama 2 4.0
## 78 Drama|Romance 2 4.0
## 79 Drama|Romance 2 4.0
## 80 Drama|War 2 4.0
## 81 Drama 2 4.0
## 82 Comedy|Drama|Romance 2 3.0
## 83 Comedy|Romance 2 3.0
## 84 Animation|Children|Fantasy|Musical 2 5.0
## 85 Action|Adventure|Comedy|Romance 2 3.0
## 86 Comedy 2 5.0
## 87 Children|Comedy 2 3.0
## 88 Comedy|Drama|Fantasy|Romance|Thriller 2 3.0
## 89 Adventure|Animation|Children|Comedy|Musical 2 3.0
## 90 Action|Sci-Fi 2 5.0
## 91 Adventure|Drama|Western 2 5.0
## 92 Action|Crime|Thriller 2 5.0
## 93 Crime|Horror|Thriller 2 3.0
## 94 Animation|Children 2 3.0
## 95 Adventure|Animation|Children|Fantasy|Musical 2 4.0
## 96 Adventure|Animation|Comedy 2 4.0
## 97 Adventure|Children|Fantasy 3 3.0
## 98 Action|Drama|War 3 4.0
## 99 Crime|Drama 3 3.5
## 100 Comedy 3 3.0#Peores peliculas
library(dslabs)
data("movielens")
peores_ratings <- movielens[order(movielens$rating), ]
head(peores_ratings,100)## movieId
## 467 1876
## 616 1358
## 985 70
## 1002 160
## 1054 355
## 1081 485
## 1102 588
## 1131 786
## 1280 1391
## 1339 1735
## 1430 2282
## 1448 2353
## 1475 2505
## 1481 2568
## 1618 3275
## 1648 3484
## 1891 5171
## 1900 5279
## 1906 5299
## 1930 5464
## 1948 5620
## 1980 6155
## 1981 6157
## 1985 6218
## 1989 6287
## 2020 6754
## 2061 7173
## 2068 7325
## 2075 7438
## 2109 8781
## 2144 30812
## 2146 31685
## 2149 33004
## 2155 34048
## 2161 34405
## 2189 45517
## 2194 45728
## 2196 46530
## 2204 48043
## 2262 60037
## 2278 63082
## 2286 65802
## 2292 66934
## 2310 69436
## 2332 74458
## 2335 74851
## 2354 79695
## 2372 82854
## 2376 83613
## 2391 86911
## 2394 87304
## 2396 87430
## 2407 88950
## 2417 90439
## 2424 90870
## 2425 91500
## 2454 95199
## 2456 95443
## 2472 98122
## 2473 98154
## 2474 98809
## 2483 100083
## 2492 101112
## 2500 102880
## 2504 103249
## 2522 107348
## 2526 108190
## 2527 108689
## 2531 109187
## 2538 110127
## 2539 110553
## 2560 113345
## 2562 113378
## 2572 116797
## 2573 116799
## 2574 116823
## 2591 122902
## 2599 130490
## 2603 132046
## 2611 135133
## 2629 140928
## 2640 152057
## 2645 156607
## 2656 159972
## 2662 161155
## 2716 377
## 2718 480
## 2719 482
## 2771 1241
## 2804 1721
## 2900 4246
## 2912 4896
## 2922 5060
## 2929 5299
## 2936 5502
## 2960 6294
## 2965 6383
## 2968 6503
## 3015 7991
## 3028 8783
## title
## 467 Deep Impact
## 616 Sling Blade
## 985 From Dusk Till Dawn
## 1002 Congo
## 1054 Flintstones, The
## 1081 Last Action Hero
## 1102 Aladdin
## 1131 Eraser
## 1280 Mars Attacks!
## 1339 Great Expectations
## 1430 Pecker
## 1448 Enemy of the State
## 1475 8MM
## 1481 Mod Squad, The
## 1618 Boondock Saints, The
## 1648 Skulls, The
## 1891 Time Machine, The
## 1900 Impromptu
## 1906 My Big Fat Greek Wedding
## 1930 Road to Perdition
## 1948 Sweet Home Alabama
## 1980 How to Lose a Guy in 10 Days
## 1981 Daredevil
## 1985 Bend It Like Beckham
## 1989 Anger Management
## 2020 Underworld
## 2061 Along Came Polly
## 2068 Starsky & Hutch
## 2075 Kill Bill: Vol. 2
## 2109 Manchurian Candidate, The
## 2144 Aviator, The
## 2146 Hitch
## 2149 Hitchhiker's Guide to the Galaxy, The
## 2155 War of the Worlds
## 2161 Serenity
## 2189 Cars
## 2194 Clerks II
## 2196 Superman Returns
## 2204 Fountain, The
## 2262 Happening, The
## 2278 Slumdog Millionaire
## 2286 Paul Blart: Mall Cop
## 2292 Dr. Horrible's Sing-Along Blog
## 2310 Year One
## 2332 Shutter Island
## 2335 From Paris with Love
## 2354 Expendables, The
## 2372 Gulliver's Travels
## 2376 Cowboys & Aliens
## 2391 Hangover Part II, The
## 2394 Beginners
## 2396 Green Lantern
## 2407 Conspirator, The
## 2417 Margin Call
## 2424 Trespass
## 2425 The Hunger Games
## 2454 What to Expect When You're Expecting
## 2456 Giant Mechanical Man, The
## 2472 Indie Game: The Movie
## 2473 Lincoln
## 2474 Hobbit: An Unexpected Journey, The
## 2483 Movie 43
## 2492 Oz the Great and Powerful
## 2500 After Earth
## 2504 World War Z
## 2522 Anchorman 2: The Legend Continues
## 2526 Divergent
## 2527 I, Frankenstein
## 2531 Zero Theorem, The
## 2538 Noah
## 2539 The Amazing Spider-Man 2
## 2560 Jupiter Ascending
## 2562 Giver, The
## 2572 The Imitation Game
## 2573 Inherent Vice
## 2574 The Hunger Games: Mockingjay - Part 1
## 2591 Fantastic Four
## 2599 Insurgent
## 2603 Tomorrowland
## 2611 The Hunger Games: Mockingjay - Part 2
## 2629 Joy
## 2640 Miles Ahead
## 2645 The Huntsman Winter's War
## 2656 Approaching the Unknown
## 2662 Sunspring
## 2716 Speed
## 2718 Jurassic Park
## 2719 Killing Zoe
## 2771 Dead Alive (Braindead)
## 2804 Titanic
## 2900 Bridget Jones's Diary
## 2912 Harry Potter and the Sorcerer's Stone (a.k.a. Harry Potter and the Philosopher's Stone)
## 2922 M*A*S*H (a.k.a. MASH)
## 2929 My Big Fat Greek Wedding
## 2936 Signs
## 2960 Bulletproof Monk
## 2965 2 Fast 2 Furious (Fast and the Furious 2, The)
## 2968 Charlie's Angels: Full Throttle
## 3015 Death Race 2000
## 3028 Village, The
## year genres userId rating timestamp
## 467 1998 Drama|Sci-Fi|Thriller 6 0.5 1108134334
## 616 1996 Drama 8 0.5 1154474527
## 985 1996 Action|Comedy|Horror|Thriller 15 0.5 1093070467
## 1002 1995 Action|Adventure|Mystery|Sci-Fi 15 0.5 1093028411
## 1054 1994 Children|Comedy|Fantasy 15 0.5 1122576667
## 1081 1993 Action|Adventure|Comedy|Fantasy 15 0.5 1093070332
## 1102 1992 Adventure|Animation|Children|Comedy|Musical 15 0.5 1093028161
## 1131 1996 Action|Drama|Thriller 15 0.5 1093028395
## 1280 1996 Action|Comedy|Sci-Fi 15 0.5 1093070145
## 1339 1998 Drama|Romance 15 0.5 1166981862
## 1430 1998 Comedy|Drama 15 0.5 1469330645
## 1448 1998 Action|Thriller 15 0.5 1134521484
## 1475 1999 Drama|Mystery|Thriller 15 0.5 1122576701
## 1481 1999 Action|Crime 15 0.5 1469330735
## 1618 2000 Action|Crime|Drama|Thriller 15 0.5 1347936677
## 1648 2000 Thriller 15 0.5 1465880417
## 1891 2002 Action|Adventure|Sci-Fi 15 0.5 1416119747
## 1900 1991 Comedy|Romance 15 0.5 1054449705
## 1906 2002 Comedy|Romance 15 0.5 1416119542
## 1930 2002 Crime|Drama 15 0.5 1166586482
## 1948 2002 Comedy|Romance 15 0.5 1425876082
## 1980 2003 Comedy|Romance 15 0.5 1416119753
## 1981 2003 Action|Crime 15 0.5 1416119690
## 1985 2002 Comedy|Drama|Romance 15 0.5 1096005101
## 1989 2003 Comedy 15 0.5 1425876025
## 2020 2003 Action|Fantasy|Horror 15 0.5 1425876028
## 2061 2004 Comedy|Romance 15 0.5 1416119886
## 2068 2004 Action|Comedy|Crime|Thriller 15 0.5 1416119755
## 2075 2004 Action|Drama|Thriller 15 0.5 1093981610
## 2109 2004 Thriller 15 0.5 1416119915
## 2144 2004 Drama 15 0.5 1416119604
## 2146 2005 Comedy|Romance 15 0.5 1361831527
## 2149 2005 Adventure|Comedy|Sci-Fi 15 0.5 1127035016
## 2155 2005 Action|Adventure|Sci-Fi|Thriller 15 0.5 1316395912
## 2161 2005 Action|Adventure|Sci-Fi 15 0.5 1357110418
## 2189 2006 Animation|Children|Comedy 15 0.5 1416119707
## 2194 2006 Comedy 15 0.5 1416119889
## 2196 2006 Action|Adventure|Sci-Fi|IMAX 15 0.5 1338699292
## 2204 2006 Drama|Fantasy|Romance 15 0.5 1416119898
## 2262 2008 Drama|Sci-Fi|Thriller 15 0.5 1216576611
## 2278 2008 Crime|Drama|Romance 15 0.5 1357110411
## 2286 2009 Action|Comedy|Crime 15 0.5 1465880993
## 2292 2008 Comedy|Drama|Musical|Sci-Fi 15 0.5 1338698623
## 2310 2009 Adventure|Comedy 15 0.5 1465880996
## 2332 2010 Drama|Mystery|Thriller 15 0.5 1338698316
## 2335 2010 Action|Crime 15 0.5 1361831555
## 2354 2010 Action|Adventure|Thriller 15 0.5 1367765181
## 2372 2010 Adventure|Comedy|Fantasy 15 0.5 1465880518
## 2376 2011 Action|Sci-Fi|Thriller|Western|IMAX 15 0.5 1367765123
## 2391 2011 Comedy 15 0.5 1458505901
## 2394 2010 Drama 15 0.5 1374638031
## 2396 2011 Action|Adventure|Sci-Fi 15 0.5 1338698810
## 2407 2010 Drama 15 0.5 1316395783
## 2417 2011 Drama|Thriller 15 0.5 1361078276
## 2424 2011 Crime|Drama|Thriller 15 0.5 1465880427
## 2425 2012 Action|Adventure|Drama|Sci-Fi|Thriller 15 0.5 1338697915
## 2454 2012 Comedy|Drama|Romance 15 0.5 1465880715
## 2456 2012 Comedy|Drama|Romance 15 0.5 1357109952
## 2472 2012 Documentary 15 0.5 1465793928
## 2473 2012 Drama|War 15 0.5 1425876388
## 2474 2012 Adventure|Fantasy|IMAX 15 0.5 1416119923
## 2483 2013 Comedy 15 0.5 1465880648
## 2492 2013 Action|Adventure|Fantasy|IMAX 15 0.5 1465880292
## 2500 2013 Action|Adventure|Sci-Fi|IMAX 15 0.5 1400818394
## 2504 2013 Action|Drama|Horror|IMAX 15 0.5 1465794267
## 2522 2013 Comedy 15 0.5 1465881258
## 2526 2014 Adventure|Romance|Sci-Fi|IMAX 15 0.5 1458506323
## 2527 2014 Action|Fantasy|Sci-Fi|IMAX 15 0.5 1465954590
## 2531 2013 Drama|Fantasy|Sci-Fi 15 0.5 1465794437
## 2538 2014 Adventure|Drama|IMAX 15 0.5 1416120162
## 2539 2014 Action|Sci-Fi|IMAX 15 0.5 1416120149
## 2560 2015 Action|Adventure|Sci-Fi 15 0.5 1465794105
## 2562 2014 Drama|Sci-Fi 15 0.5 1425875497
## 2572 2014 Drama|Thriller|War 15 0.5 1425875401
## 2573 2014 Comedy|Crime|Drama|Mystery|Romance 15 0.5 1465794406
## 2574 2014 Adventure|Sci-Fi|Thriller 15 0.5 1425875449
## 2591 2015 Action|Adventure|Fantasy|Sci-Fi 15 0.5 1443384352
## 2599 2015 Action|Sci-Fi|Thriller 15 0.5 1465794100
## 2603 2015 Action|Adventure|Children|Mystery|Sci-Fi 15 0.5 1465794103
## 2611 2015 Adventure|Sci-Fi 15 0.5 1465794150
## 2629 2015 Comedy|Drama 15 0.5 1465793205
## 2640 2016 Drama 15 0.5 1465793700
## 2645 2016 Action|Adventure|Drama|Fantasy 15 0.5 1465793691
## 2656 2016 Drama|Sci-Fi|Thriller 15 0.5 1469330481
## 2662 2016 Sci-Fi 15 0.5 1469330307
## 2716 1994 Action|Romance|Thriller 17 0.5 1127469444
## 2718 1993 Action|Adventure|Sci-Fi|Thriller 17 0.5 1127469407
## 2719 1994 Crime|Drama|Thriller 17 0.5 1127475344
## 2771 1992 Comedy|Fantasy|Horror 17 0.5 1127472490
## 2804 1997 Drama|Romance 17 0.5 1127472770
## 2900 2001 Comedy|Drama|Romance 17 0.5 1127470119
## 2912 2001 Adventure|Children|Fantasy 17 0.5 1127470004
## 2922 1970 Comedy|Drama|War 17 0.5 1127469827
## 2929 2002 Comedy|Romance 17 0.5 1127470247
## 2936 2002 Horror|Sci-Fi|Thriller 17 0.5 1127470299
## 2960 2003 Action|Adventure|Sci-Fi 17 0.5 1127472976
## 2965 2003 Action|Crime|Thriller 17 0.5 1127472979
## 2968 2003 Action|Adventure|Comedy|Crime|Thriller 17 0.5 1127473548
## 3015 1975 Action|Sci-Fi 17 0.5 1127475448
## 3028 2004 Drama|Mystery|Thriller 17 0.5 1127473349