2018年のmust see drama, anime, moviesをIMDBスコア、メタスコア、投票数を参考にして探し出します。日本のアニメは世界的に評価が高いので、何かしらのアニメ作品が出てくるのではないかと期待していますが、評価が高いのは宮崎アニメだけなのも確かなので、あまり期待しない方がいいかもしれません。
import pandas as pd
import requests
df = pd.read_csv('2018movies_10000.csv',encoding='utf-8')
データの中身をチラ見する。
df.head()
| タイトル | ジャンル | IMDBスコア | メタスコア | 投票数 | 興行収入 | あらすじ | 監督 | 出演者 | 上映時間 | 公開年 | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Úsmevy smutných muzu | [‘Comedy’, ‘ Drama’] | 6.6 | NaN | 174 | NaN | Add a Plot\n | Dan Svátek | [‘David Svehlík’, ‘Jaroslav Dusek’, ‘Marika So… | NaN | 2018 |
| 1 | Ölümlü Dünya | [‘Action’, ‘ Comedy’] | 7.8 | NaN | 12,217 | NaN | Mermer Family lives a double life working at t… | Ali Atay | [‘Ahmet Mümtaz Taylan’, ‘Alper Kul’, ‘Sarp Apa… | 107.0 | 2018 |
| 2 | Çocuklar Sana Emanet | [‘Drama’, ‘ Mystery’, ‘ Thriller’] | 5.4 | NaN | 494 | NaN | ‘Çocuklar Sana Emanet’ meaning ‘Children’s Saf… | Çagan Irmak | [‘Engin Akyürek’, ‘Hilal Altinbilek’, ‘Serif S… | 105.0 | 2018 |
| 3 | Çarpisma | [‘Action’, ‘ Drama’, ‘ Thriller’] | 7.9 | NaN | 2,209 | NaN | It is about life that intersects with the coll… | NaN | [‘Stars:Kivanç Tatlitug’, ‘Elçin Sangu’, ‘Alpe… | 120.0 | 20182019 |
| 4 | Çakallarla Dans 5 | [‘Comedy’] | 4.2 | NaN | 380 | NaN | Add a Plot\n | Murat Seker | [‘Sevket Çoruh’, ‘Ilker Ayrik’, ‘Murat Akkoyun… | 102.0 | 2018 |
投票数からコンマを除去してデータ型をobjectからintに変換する。
df['投票数'] = df['投票数'].str.replace(',','')
df['投票数'] = df['投票数'].apply(pd.to_numeric, errors="coerce").astype(int)
df[(df['IMDBスコア'] > 9.6)].sort_values(by='投票数',ascending=False)
| タイトル | ジャンル | IMDBスコア | メタスコア | 投票数 | 興行収入 | あらすじ | 監督 | 出演者 | 上映時間 | 公開年 | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1607 | Red Dead Redemption II | [‘Action’, ‘ Adventure’, ‘ Crime’] | 9.7 | NaN | 12136 | NaN | Amidst the decline of the Wild West at the tur… | NaN | [‘Stars:Benjamin Byron Davis’, ‘Roger Clark’, … | NaN | 2018 Video Game |
| 3188 | God of War | [‘Action’, ‘ Adventure’, ‘ Drama’] | 9.7 | NaN | 10586 | NaN | After wiping out the gods of Mount Olympus, Kr… | Cory Barlog | [‘Christopher Judge’, ‘Sunny Suljic’, ‘Jeremy … | NaN | 2018 Video Game |
| 5120 | Lucifer | [‘Crime’, ‘ Drama’, ‘ Fantasy’] | 9.8 | NaN | 8545 | NaN | Shocked by someone’s death, Chloe, Lucifer and… | Eagle Egilsson | [‘Tom Ellis’, ‘Lauren German’, ‘Kevin Alejandr… | 43.0 | 2018 |
| 5341 | BoJack Horseman | [‘Animation’, ‘ Comedy’, ‘ Drama’] | 9.8 | NaN | 6248 | NaN | BoJack delivers a eulogy at a funeral. | Amy Winfrey | [‘Will Arnett’, ‘Amy Sedaris’, ‘Alison Brie’, … | 26.0 | 2018 |
| 1774 | Pew News | [‘Comedy’, ‘ News’] | 10.0 | NaN | 4223 | NaN | The Pew News team reports unbiased news in whi… | NaN | [‘Stars:Mary Katherine Ham’, ‘Poppy Gloria’, ‘… | 15.0 | 2018 |
| 5365 | Atlanta | [‘Comedy’, ‘ Drama’, ‘ Music’] | 9.7 | NaN | 3945 | NaN | When Darius goes to pick up a piano, he meets … | Hiro Murai | [‘Donald Glover’, ‘Brian Tyree Henry’, ‘LaKeit… | 35.0 | 2018 |
| 4944 | The 100 | [‘Drama’, ‘ Mystery’, ‘ Sci-Fi’] | 9.7 | NaN | 3895 | NaN | Clarke and her friends must risk everything to… | Dean White | [‘Eliza Taylor’, ‘Paige Turco’, ‘Bob Morley’, … | 42.0 | 2018 |
| 5364 | Attack on Titan | [‘Animation’, ‘ Action’, ‘ Adventure’] | 9.7 | NaN | 2805 | NaN | As battle breaks out to prevent the ritual, Hi… | Directors:Takashi Andô, Tetsurô Araki, Masashi… | [‘Yûki Kaji’, ‘Shiori Mikami’, ‘Yûsaku Yara’, … | 24.0 | 2018 |
| 4940 | The Americans | [‘Crime’, ‘ Drama’, ‘ Mystery’] | 9.7 | NaN | 2404 | NaN | The Jennings family face a choice that will ch… | Chris Long | [‘Keri Russell’, ‘Matthew Rhys’, ‘Brandon J. D… | 69.0 | 2018 |
| 5389 | Adventure Time | [‘Animation’, ‘ Action’, ‘ Adventure’] | 9.7 | NaN | 1269 | NaN | BMO narrates “The Great Gum War” in which Finn… | Directors:Diana Lafyatis, Cole Sanchez | [‘Jeremy Shada’, ‘John DiMaggio’, ‘Hynden Walc… | 44.0 | 2018 |
| 5403 | 12 Monkeys | [‘Adventure’, ‘ Drama’, ‘ Mystery’] | 9.7 | NaN | 1034 | NaN | When all hope is lost, Cole must complete his … | Terry Matalas | [‘Aaron Stanford’, ‘Amanda Schull’, ‘Todd Stas… | 48.0 | 2018 |
| 4370 | Arupu | [‘Short’, ‘ Music’] | 9.9 | NaN | 678 | NaN | Arupu is a telugu rap music video about growin… | Harikanth Gunamagari | [‘Star:Roll Rida’] | 5.0 | 2018 Video |
| 4949 | TVF Bachelors | [‘Comedy’] | 9.7 | NaN | 642 | NaN | Shivappa tells the painful ordeal which lead t… | Amrit Raj Gupta | [‘Atul Bhalla’, ‘Jasmeet Singh Bhatia’, ‘Nidhi… | NaN | 2018 |
| 4821 | Violet Evergarden | [‘Animation’, ‘ Drama’, ‘ Fantasy’] | 9.7 | NaN | 495 | NaN | Violet goes to assist a medically ill woman wh… | Directors:Haruka Fujita, Taichi Ishidate, Taii… | [‘Yui Ishikawa’, ‘Aya Endô’, ‘Minori Chihara’,… | 24.0 | 2018 |
| 5336 | Boruto: Naruto Next Generations | [‘Animation’, ‘ Action’, ‘ Adventure’] | 9.8 | NaN | 383 | NaN | Momoshiki undergoes a transformation and becom… | NaN | [‘Stars:Yûko Sanpei’, ‘Junko Takeuchi’, ‘Noria… | NaN | 2018 |
| 4764 | 2 Wrongs | [‘Short’, ‘ Drama’] | 9.8 | NaN | 354 | NaN | A single father, with a troubled past dreams o… | Andy Cruz | [‘Casey Lee’, ‘Donnie Smith’, “Mia Denae’ Brat… | 11.0 | 2018 |
| 2255 | Meie aasta Iraanis | [‘Adventure’, ‘ Family’, ‘ Reality-TV’] | 9.7 | NaN | 257 | NaN | A family with two smart twin boys has lived in… | NaN | [‘Stars:Kristjan Roosma’, ‘Tuuli Roosma’, ‘And… | 43.0 | 2018 |
| 5079 | Nanatsu no taizai | [‘Animation’, ‘ Action’, ‘ Adventure’] | 9.7 | NaN | 210 | NaN | The awakening of the ten commandments and begi… | NaN | [‘Stars:Yûki Kaji’, ‘Sora Amamiya’, ‘Misaki Ku… | NaN | 2018 |
| 5288 | DARLING in the FRANXX | [‘Animation’, ‘ Action’, ‘ Fantasy’] | 9.7 | NaN | 200 | NaN | Hiro and Zero Two remember about their childho… | NaN | [‘Stars:Bryn Apprill’, ‘Tia Lynn Ballard’, ‘Mo… | 24.0 | 2018 |
| 4965 | Steins;Gate 0 | [‘Animation’, ‘ Comedy’, ‘ Drama’] | 9.7 | NaN | 180 | NaN | Okabe is forced to time leap thousands of time… | NaN | [”] | NaN | 2018 |
| 36 | Yours truly Roohani | [‘Romance’] | 9.9 | NaN | 160 | NaN | Add a Plot\n | Sammir i Patel | [‘Vibha Anand’, ‘Rishi Saxena’] | 43.0 | 2018 TV Movie |
| 2254 | Meie suvi iraanlastega | [‘Adventure’, ‘ Comedy’, ‘ Family’] | 9.7 | NaN | 154 | NaN | The popular travel show does not explore exoti… | NaN | [‘Stars:Kristjan Roosma’, ‘Tuuli Roosma’, ‘And… | 43.0 | 2018 |
| 4335 | Audition | [‘Short’, ‘ Comedy’, ‘ Drama’] | 9.8 | NaN | 98 | NaN | AUDITION is a short film about the punishment … | Sarah Kruchowski | [‘Marie Laurin’, ‘Zoran Radanovich’, ‘Desi Iva… | 17.0 | II 2018 |
| 3240 | Gazapizm – Ölüler Dirilerden Çalacak | [‘Short’, ‘ Music’] | 9.7 | NaN | 96 | NaN | Add a Plot\n | Hasan Sezgin | [‘Muzaffer Akin’, ‘Vildan Atasever’, ‘Sezen De… | 5.0 | 2018 Video |
| 4522 | All Japan Peace and Coexistence: Moritomo Scan… | [‘Documentary’, ‘ Talk-Show’] | 9.7 | NaN | 92 | NaN | A public discussion to explore the social and … | Kazuhide Uekusa | [‘Shinzo Abe’, ‘Mizuho Fukushima’, ‘Katsumasa … | 213.0 | 2018 Video |
| 5346 | Black and White Love | [‘Action’, ‘ Drama’, ‘ Romance’] | 9.7 | NaN | 86 | NaN | Asli leaves with Ferhat, Asli realizes that he… | Directors:Altan Dönmez, Emir Khalilzadeh | [‘Ugur Aslan’, ‘Ibrahim Celikkol’, ‘Cahit Gök’… | NaN | 2018 |
この中に特に気になる作品はない。今度はメタスコアで抽出する。
df[(df['メタスコア'] > 89)].sort_values(by='投票数',ascending=False)
| タイトル | ジャンル | IMDBスコア | メタスコア | 投票数 | 興行収入 | あらすじ | 監督 | 出演者 | 上映時間 | 公開年 | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 865 | The Favourite | [‘Biography’, ‘ Drama’, ‘ History’] | 7.6 | 90.0 | 119549 | $34.24M | In early 18th century England, a frail Queen A… | Yorgos Lanthimos | [‘Olivia Colman’, ‘Emma Stone’, ‘Rachel Weisz’… | 119.0 | 2018 |
| 1543 | Roma | [‘Drama’] | 7.8 | 96.0 | 108466 | NaN | A year in the life of a middle-class family’s … | Alfonso Cuarón | [‘Yalitza Aparicio’, ‘Marina de Tavira’, ‘Dieg… | 135.0 | 2018 |
| 3854 | Cold War | [‘Drama’, ‘ History’, ‘ Music’] | 7.6 | 90.0 | 34142 | $4.57M | In the 1950s, a music director falls in love w… | Pawel Pawlikowski | [‘Joanna Kulig’, ‘Tomasz Kot’, ‘Borys Szyc’, ‘… | 89.0 | 2018 |
| 1362 | Shoplifters | [‘Crime’, ‘ Drama’] | 8.0 | 93.0 | 32726 | $3.31M | A family of small-time crooks take in a child … | Hirokazu Koreeda | [‘Lily Franky’, ‘Sakura Andô’, ‘Kirin Kiki’, ‘… | 121.0 | 2018 |
| 4030 | Burning | [‘Drama’, ‘ Mystery’] | 7.6 | 90.0 | 24164 | $0.72M | Jong-su bumps into a girl who used to live in … | Chang-dong Lee | [‘Ah-in Yoo’, ‘Steven Yeun’, ‘Jong-seo Jun’, ‘… | 148.0 | 2018 |
| 463 | They Shall Not Grow Old | [‘Documentary’, ‘ History’, ‘ War’] | 8.4 | 91.0 | 16399 | $17.96M | A documentary about World War I with never-bef… | NaN | [‘Director:Peter Jackson’] | 99.0 | II 2018 |
| 550 | The Tale | [‘Drama’, ‘ Mystery’, ‘ Thriller’] | 7.3 | 90.0 | 10728 | NaN | A woman filming a documentary on childhood rap… | Jennifer Fox | [‘Elizabeth Debicki’, ‘Laura Dern’, ‘Common’, … | 114.0 | 2018 |
| 2221 | Minding the Gap | [‘Documentary’] | 8.1 | 90.0 | 4873 | $0.01M | Three young men bond together to escape volati… | Bing Liu | [‘Keire Johnson’, ‘Bing Liu’, ‘Zack Mulligan’] | 93.0 | 2018 |
| 1150 | Sunday’s Illness | [‘Drama’] | 7.0 | 92.0 | 2017 | NaN | A high-class old lady receives the unexpected … | Ramón Salazar | [‘Bárbara Lennie’, ‘Susi Sánchez’, ‘Greta Fern… | 113.0 | 2018 |
| 4480 | Amazing Grace | [‘Documentary’, ‘ Music’] | 7.8 | 94.0 | 953 | $4.43M | A documentary presenting Aretha Franklin with … | Directors:Alan Elliott, Sydney Pollack | [‘Aretha Franklin’, ‘Reverand James Cleveland’… | 89.0 | 2018 |
| 2617 | King in the Wilderness | [‘Documentary’] | 7.8 | 97.0 | 394 | NaN | A look at the final years in the life of Marti… | NaN | [‘Director:Peter W. Kunhardt’] | 111.0 | 2018 |
| 965 | The Burial Of Kojo | [‘Drama’, ‘ Thriller’] | 6.1 | 93.0 | 248 | NaN | A man is trapped in a mine shaft by his vengef… | Sam Blitz Bazawule | [‘Ama K. Abebrese’, ‘Joe Addo’, ‘Henry Adofo’,… | 80.0 | 2018 |
「The Favourite (女王陛下のお気に入り)」は日本でも今年の2月15日に公開されている。「Shoplifters (万引き家族)」は日本映画である。「They Shall Not Grow Old」は第一次世界大戦の記録フィルムをカラー化したドキュメンタリー映画で、この映画はまだ日本未公開のようである。
めぞん一刻で響子さんは何故三鷹を振って地雷(五代)を踏んだのか？
音無響子は、三鷹瞬という、実家が名家で、料理が得意な、高学歴超イケメンスポーツマン好青年を、何故振ってしまったのか？普通なら有り得ないのですが、そこが、このラブコメ漫画の大金字塔を面白くしている所以でもあります。三鷹さんと結婚していれば、響子さんは、一生安泰で、贅沢で派手な生活を送れていたはずです。管理人さんは、何故
eigo.rumisunheart.com
2020-06-10 20:16
スポンサーリンク
IMDBスコアと投票数で作品を絞り込む¶
IMDBスコアが8以上かつメタスコアが1以上で投票数が100以上の作品を投票数が多い順に抽出する。
word = 'They Shall Not Grow Old|Shoplifters|Minding the Gap'
df[(df['IMDBスコア']>7.9)&(df['投票数']>99)&(df['メタスコア']>0)&\
(-df['タイトル'].str.contains(word))].sort_values(by='投票数',ascending=False)
| タイトル | ジャンル | IMDBスコア | メタスコア | 投票数 | 興行収入 | あらすじ | 監督 | 出演者 | 上映時間 | 公開年 | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 4326 | Avengers: Infinity War | [‘Action’, ‘ Adventure’, ‘ Sci-Fi’] | 8.5 | 68.0 | 680672 | $678.82M | The Avengers and their allies must be willing … | Directors:Anthony Russo, Joe Russo | [‘Robert Downey Jr.’, ‘Chris Hemsworth’, ‘Mark… | 149.0 | 2018 |
| 4087 | Bohemian Rhapsody | [‘Biography’, ‘ Drama’, ‘ Music’] | 8.0 | 49.0 | 353822 | $216.43M | The story of the legendary rock band Queen and… | Bryan Singer | [‘Rami Malek’, ‘Lucy Boynton’, ‘Gwilym Lee’, ‘… | 134.0 | 2018 |
| 1245 | Spider-Man: Into the Spider-Verse | [‘Animation’, ‘ Action’, ‘ Adventure’] | 8.5 | 87.0 | 223211 | $190.24M | Teen Miles Morales becomes Spider-Man of his r… | Directors:Bob Persichetti, Peter Ramsey, Rodne… | [‘Shameik Moore’, ‘Jake Johnson’, ‘Hailee Stei… | 117.0 | 2018 |
| 3147 | Green Book | [‘Biography’, ‘ Comedy’, ‘ Drama’] | 8.2 | 69.0 | 215055 | $85.08M | A working-class Italian-American bouncer becom… | Peter Farrelly | [‘Viggo Mortensen’, ‘Mahershala Ali’, ‘Linda C… | 130.0 | 2018 |
| 3285 | Free Solo | [‘Documentary’, ‘ Sport’] | 8.2 | 83.0 | 33873 | $17.54M | Alex Honnold attempts to become the first pers… | Directors:Jimmy Chin, Elizabeth Chai Vasarhelyi | [‘Alex Honnold’, ‘Tommy Caldwell’, ‘Jimmy Chin… | 100.0 | 2018 |
| 3990 | Capernaum | [‘Drama’] | 8.5 | 75.0 | 21870 | $1.66M | While serving a five-year sentence for a viole… | Nadine Labaki | [‘Zain Al Rafeea’, ‘Yordanos Shiferaw’, ‘Boluw… | 126.0 | 2018 |
| 84 | Won’t You Be My Neighbor? | [‘Documentary’, ‘ Biography’] | 8.4 | 85.0 | 17016 | $22.61M | An exploration of the life, lessons, and legac… | Morgan Neville | [‘Fred Rogers’, ‘Joanne Rogers’, ‘John Rogers’… | 94.0 | 2018 |
| 3548 | Dragon Ball Super: Broly | [‘Animation’, ‘ Action’, ‘ Adventure’] | 8.0 | 59.0 | 16904 | $30.71M | Goku and Vegeta encounter Broly, a Saiyan warr… | Tatsuya Nagamine | [‘Masako Nozawa’, ‘Aya Hisakawa’, ‘Ryô Horikaw… | 100.0 | 2018 |
| 494 | The Wild Pear Tree | [‘Drama’] | 8.2 | 86.0 | 12312 | $0.03M | An unpublished writer returns to his hometown … | Nuri Bilge Ceylan | [‘Dogu Demirkol’, ‘Murat Cemcir’, ‘Bennu Yildi… | 188.0 | 2018 |
| 4586 | Active Measures | [‘Documentary’] | 8.2 | 68.0 | 6993 | $0.01M | Russian president Vladimir Putin attacks the 2… | Jack Bryan | [‘Donald Trump’, ‘Vladimir Putin’, ‘Jeremy Bas… | 109.0 | 2018 |
| 1550 | Robin Williams: Come Inside My Mind | [‘Documentary’, ‘ Biography’, ‘ Comedy’] | 8.0 | 74.0 | 5073 | NaN | An intimate look into the life and work of the… | Marina Zenovich | [‘Robin Williams’, ‘Steve Allen’, ‘Robert Altm… | 116.0 | 2018 |
| 3853 | Coldplay: A Head Full of Dreams | [‘Documentary’, ‘ Music’] | 8.0 | 64.0 | 1947 | NaN | A HEAD FULL OF DREAMS offers an in-depth and i… | Mat Whitecross | [‘Guy Berryman’, ‘Beyoncé’, ‘Jon Buckland’, ‘W… | 115.0 | 2018 |
| 986 | The Biggest Little Farm | [‘Documentary’] | 8.0 | 74.0 | 663 | $3.65M | Documentarian John Chester and his wife Molly … | John Chester | [‘John Chester’, ‘Molly Chester’, ‘Matthew Pil… | 91.0 | 2018 |
| 578 | The Silence of Others | [‘Documentary’] | 8.0 | 73.0 | 623 | $0.06M | The Silence of Others reveals the epic struggl… | Directors:Robert Bahar, Almudena Carracedo | [‘María Martín’, ‘José María Galante’, ‘Carlos… | 96.0 | 2018 |
| 203 | Walking on Water | [‘Documentary’, ‘ Adventure’, ‘ Comedy’] | 8.2 | 63.0 | 342 | $0.09M | An uncensored look into the artistic process a… | Andrey Paounov | [‘Star:Christo’] | 105.0 | 2018 |
| 594 | The Russian Five | [‘Documentary’, ‘ Sport’] | 8.3 | 75.0 | 255 | $0.44M | In the late 1980s, the Detroit Red Wings worke… | Joshua Riehl | [‘Jeff Daniels’, ‘Jim Devellano’, ‘Sergei Fedo… | 102.0 | 2018 |
| 3234 | General Magic | [‘Documentary’] | 8.0 | 72.0 | 146 | NaN | The ideas that dominate the tech industry and … | Directors:Sarah Kerruish, Matt Maude | [‘Tony Fadell’, ‘Andy Hertzfeld’, ‘Marc Porat’… | 90.0 | 2018 |
| 3707 | Dead Souls | [‘Documentary’] | 8.4 | 89.0 | 100 | NaN | A dozen aging survivors are interviewed from J… | NaN | [‘Director:Bing Wang’] | 495.0 | 2018 |
ドラゴンボール以外は特に気になる作品はない。次に、IMDBスコアが7〜8かつメタスコアが0以上かつ興行収入が$1以上で投票数10万以上の作品を投票数が多い順に抽出する。
word = 'The Favourite'
df[(df['IMDBスコア']>6.9)&(df['IMDBスコア']<8.0)&(df['投票数']>=1e5)&\
(-df['タイトル'].str.contains(word))&(df['メタスコア']>0)&\
(df['興行収入'].str.contains('\d',regex=True,na=False))].sort_values(by='投票数',ascending=False)
| タイトル | ジャンル | IMDBスコア | メタスコア | 投票数 | 興行収入 | あらすじ | 監督 | 出演者 | 上映時間 | 公開年 | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 4135 | Black Panther | [‘Action’, ‘ Adventure’, ‘ Sci-Fi’] | 7.3 | 88.0 | 522283 | $700.06M | T’Challa, heir to the hidden but advanced king… | Ryan Coogler | [‘Chadwick Boseman’, ‘Michael B. Jordan’, “Lup… | 134.0 | 2018 |
| 3695 | Deadpool 2 | [‘Action’, ‘ Adventure’, ‘ Comedy’] | 7.8 | 66.0 | 397926 | $324.59M | Foul-mouthed mutant mercenary Wade Wilson (AKA… | David Leitch | [‘Ryan Reynolds’, ‘Josh Brolin’, ‘Morena Bacca… | 119.0 | 2018 |
| 4652 | A Quiet Place | [‘Drama’, ‘ Horror’, ‘ Sci-Fi’] | 7.6 | 82.0 | 309422 | $188.02M | In a post-apocalyptic world, a family is force… | John Krasinski | [‘Emily Blunt’, ‘John Krasinski’, ‘Millicent S… | 90.0 | 2018 |
| 1616 | Ready Player One | [‘Action’, ‘ Adventure’, ‘ Sci-Fi’] | 7.5 | 64.0 | 305263 | $137.69M | When the creator of a virtual reality called t… | Steven Spielberg | [‘Tye Sheridan’, ‘Olivia Cooke’, ‘Ben Mendelso… | 140.0 | 2018 |
| 4393 | Aquaman | [‘Action’, ‘ Adventure’, ‘ Fantasy’] | 7.1 | 55.0 | 271093 | $335.06M | Arthur Curry, the human-born heir to the under… | James Wan | [‘Jason Momoa’, ‘Amber Heard’, ‘Willem Dafoe’,… | 143.0 | 2018 |
| 4641 | A Star Is Born | [‘Drama’, ‘ Music’, ‘ Romance’] | 7.7 | 88.0 | 256802 | $215.29M | A musician helps a young singer find fame as a… | Bradley Cooper | [‘Lady Gaga’, ‘Bradley Cooper’, ‘Sam Elliott’,… | 136.0 | 2018 |
| 4409 | Ant-Man and the Wasp | [‘Action’, ‘ Adventure’, ‘ Comedy’] | 7.1 | 70.0 | 248626 | $216.65M | As Scott Lang balances being both a Super Hero… | Peyton Reed | [‘Paul Rudd’, ‘Evangeline Lilly’, ‘Michael Peñ… | 118.0 | 2018 |
| 2203 | Mission: Impossible – Fallout | [‘Action’, ‘ Adventure’, ‘ Thriller’] | 7.8 | 86.0 | 237232 | $220.16M | Ethan Hunt and his IMF team, along with some f… | Christopher McQuarrie | [‘Tom Cruise’, ‘Henry Cavill’, ‘Ving Rhames’, … | 147.0 | 2018 |
| 1278 | Solo: A Star Wars Story | [‘Action’, ‘ Adventure’, ‘ Fantasy’] | 7.0 | 62.0 | 229033 | $213.77M | During an adventure into the criminal underwor… | Ron Howard | [‘Alden Ehrenreich’, ‘Woody Harrelson’, ‘Emili… | 135.0 | 2018 |
| 2848 | Incredibles 2 | [‘Animation’, ‘ Action’, ‘ Adventure’] | 7.7 | 80.0 | 207129 | $608.58M | The Incredibles hero family takes on a new mis… | Brad Bird | [‘Craig T. Nelson’, ‘Holly Hunter’, ‘Sarah Vow… | 118.0 | 2018 |
| 3256 | Game Night | [‘Action’, ‘ Comedy’, ‘ Crime’] | 7.0 | 66.0 | 165395 | $69.00M | A group of friends who meet regularly for game… | Directors:John Francis Daley, Jonathan Goldstein | [‘Jason Bateman’, ‘Rachel McAdams’, ‘Kyle Chan… | 100.0 | I 2018 |
| 3022 | Hereditary | [‘Drama’, ‘ Horror’, ‘ Mystery’] | 7.3 | 87.0 | 156000 | $44.07M | After the family matriarch passes away, a grie… | Ari Aster | [‘Toni Collette’, ‘Milly Shapiro’, ‘Gabriel By… | 127.0 | 2018 |
| 4142 | BlacKkKlansman | [‘Biography’, ‘ Crime’, ‘ Drama’] | 7.5 | 83.0 | 152827 | $48.69M | Ron Stallworth, an African American police off… | Spike Lee | [‘John David Washington’, ‘Adam Driver’, ‘Laur… | 135.0 | 2018 |
| 3331 | First Man | [‘Biography’, ‘ Drama’, ‘ History’] | 7.4 | 84.0 | 122435 | $44.94M | A look at the life of the astronaut, Neil Arms… | Damien Chazelle | [‘Ryan Gosling’, ‘Claire Foy’, ‘Jason Clarke’,… | 141.0 | 2018 |
| 2799 | Isle of Dogs | [‘Animation’, ‘ Adventure’, ‘ Comedy’] | 7.9 | 82.0 | 109829 | $32.02M | Set in Japan, Isle of Dogs follows a boy’s ody… | Wes Anderson | [‘Bryan Cranston’, ‘Koyu Rankin’, ‘Edward Nort… | 101.0 | 2018 |
| 283 | Upgrade | [‘Action’, ‘ Sci-Fi’, ‘ Thriller’] | 7.6 | 67.0 | 107291 | $11.87M | Set in the near-future, technology controls ne… | Leigh Whannell | [‘Logan Marshall-Green’, ‘Melanie Vallejo’, ‘S… | 100.0 | 2018 |
| 1425 | Searching | [‘Drama’, ‘ Mystery’, ‘ Thriller’] | 7.7 | 71.0 | 101436 | $26.02M | After his 16-year-old daughter goes missing, a… | Aneesh Chaganty | [‘John Cho’, ‘Debra Messing’, ‘Joseph Lee’, ‘M… | 102.0 | III 2018 |
| 3803 | Crazy Rich Asians | [‘Comedy’, ‘ Romance’] | 7.0 | 74.0 | 100120 | $174.53M | This contemporary romantic comedy, based on a … | Jon M. Chu | [‘Constance Wu’, ‘Henry Golding’, ‘Michelle Ye… | 120.0 | 2018 |
特に気になる作品はない。今度はホラー映画に絞って検索してみる。
word = 'Hereditary'
df[(df['ジャンル'].str.contains("Horror"))&(df['興行収入'].str.contains("$"))&\
(-df['タイトル'].str.contains(word))].sort_values(by='メタスコア',ascending=False).head(20)
| タイトル | ジャンル | IMDBスコア | メタスコア | 投票数 | 興行収入 | あらすじ | 監督 | 出演者 | 上映時間 | 公開年 | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 4652 | A Quiet Place | [‘Drama’, ‘ Horror’, ‘ Sci-Fi’] | 7.6 | 82.0 | 309422 | $188.02M | In a post-apocalyptic world, a family is force… | John Krasinski | [‘Emily Blunt’, ‘John Krasinski’, ‘Millicent S… | 90.0 | 2018 |
| 2322 | Mandy | [‘Action’, ‘ Fantasy’, ‘ Horror’] | 6.6 | 81.0 | 45317 | $1.21M | The enchanted lives of a couple in a secluded … | Panos Cosmatos | [‘Nicolas Cage’, ‘Andrea Riseborough’, ‘Linus … | 121.0 | 2018 |
| 4416 | Annihilation | [‘Adventure’, ‘ Drama’, ‘ Horror’] | 6.9 | 79.0 | 231289 | $32.73M | A biologist signs up for a dangerous, secret e… | Alex Garland | [‘Natalie Portman’, ‘Jennifer Jason Leigh’, ‘T… | 115.0 | 2018 |
| 1213 | Starfish | [‘Drama’, ‘ Horror’, ‘ Sci-Fi’] | 5.7 | 74.0 | 1078 | $0.01M | A unique, intimate portrayal of a girl grievin… | A.T. White | [‘Virginia Gardner’, ‘Christina Masterson’, ‘E… | 99.0 | 2018 |
| 2602 | Knife+Heart | [‘Drama’, ‘ Horror’, ‘ Romance’] | 6.2 | 69.0 | 1552 | $0.03M | Paris, summer 1979. Anne is a producer of chea… | Yann Gonzalez | [‘Vanessa Paradis’, ‘Nicolas Maury’, ‘Kate Mor… | 102.0 | 2018 |
| 3868 | Climax | [‘Drama’, ‘ Horror’, ‘ Music’] | 7.2 | 67.0 | 25829 | $0.80M | French dancers gather in a remote, empty schoo… | Gaspar Noé | [‘Sofia Boutella’, ‘Romain Guillermic’, ‘Souhe… | 97.0 | I 2018 |
| 3101 | Halloween | [‘Horror’, ‘ Thriller’] | 6.6 | 67.0 | 90964 | $159.34M | Laurie Strode confronts her long-time foe Mich… | David Gordon Green | [‘Jamie Lee Curtis’, ‘Judy Greer’, ‘Andi Matic… | 106.0 | I 2018 |
| 737 | The Little Stranger | [‘Drama’, ‘ Horror’, ‘ Mystery’] | 5.6 | 67.0 | 5208 | $0.71M | After a doctor is called to visit a crumbling … | Lenny Abrahamson | [‘Domhnall Gleeson’, ‘Will Poulter’, ‘Ruth Wil… | 111.0 | 2018 |
| 493 | The Wind | [‘Horror’, ‘ Western’] | 5.6 | 66.0 | 2584 | $0.03M | A plains-woman faces the harshness and isolati… | Emma Tammi | [‘Caitlin Gerard’, ‘Julia Goldani Telles’, ‘As… | 86.0 | II 2018 |
| 1123 | Suspiria | [‘Fantasy’, ‘ Horror’, ‘ Mystery’] | 6.8 | 64.0 | 38990 | $2.47M | A darkness swirls at the center of a world-ren… | Luca Guadagnino | [‘Chloë Grace Moretz’, ‘Tilda Swinton’, ‘Doris… | 152.0 | I 2018 |
| 294 | Unsane | [‘Drama’, ‘ Horror’, ‘ Mystery’] | 6.4 | 63.0 | 32514 | $7.73M | A young woman is involuntarily committed to a … | Steven Soderbergh | [‘Claire Foy’, ‘Joshua Leonard’, ‘Jay Pharoah’… | 98.0 | 2018 |
| 1762 | Piercing | [‘Horror’, ‘ Mystery’, ‘ Thriller’] | 5.6 | 63.0 | 3471 | $0.02M | A man kisses his wife and baby goodbye and see… | Nicolas Pesce | [‘Christopher Abbott’, ‘Mia Wasikowska’, ‘Laia… | 81.0 | 2018 |
| 1858 | Overlord | [‘Action’, ‘ Adventure’, ‘ Horror’] | 6.7 | 60.0 | 57949 | $21.70M | A small group of American soldiers find horror… | Julius Avery | [‘Jovan Adepo’, ‘Wyatt Russell’, ‘Mathilde Oll… | 110.0 | 2018 |
| 943 | The Clovehitch Killer | [‘Drama’, ‘ Horror’, ‘ Mystery’] | 6.5 | 59.0 | 9638 | $0.01M | A picture-perfect family is shattered when the… | Duncan Skiles | [‘Dylan McDermott’, ‘Charlie Plummer’, ‘Samant… | 109.0 | 2018 |
| 797 | The House with a Clock in Its Walls | [‘Comedy’, ‘ Fantasy’, ‘ Horror’] | 6.0 | 57.0 | 33691 | $68.55M | A young orphan named Lewis Barnavelt aids his … | Eli Roth | [‘Jack Black’, ‘Cate Blanchett’, ‘Owen Vaccaro… | 105.0 | 2018 |
| 857 | The First Purge | [‘Action’, ‘ Horror’, ‘ Sci-Fi’] | 5.1 | 54.0 | 42501 | $69.09M | America’s third political party, the New Found… | Gerard McMurray | [“Y’lan Noel”, ‘Lex Scott Davis’, ‘Joivan Wade… | 98.0 | 2018 |
| 299 | Unfriended: Dark Web | [‘Crime’, ‘ Horror’, ‘ Mystery’] | 5.9 | 53.0 | 14297 | $8.78M | A teen comes into possession of a new laptop a… | Stephen Susco | [‘Colin Woodell’, ‘Stephanie Nogueras’, ‘Betty… | 92.0 | 2018 |
| 2832 | Insidious: The Last Key | [‘Horror’, ‘ Mystery’, ‘ Thriller’] | 5.7 | 49.0 | 42794 | $67.35M | Parapsychologist Dr. Elise Rainier faces her m… | Adam Robitel | [‘Lin Shaye’, ‘Leigh Whannell’, ‘Angus Sampson… | 103.0 | 2018 |
| 2423 | Lords of Chaos | [‘Biography’, ‘ Drama’, ‘ Horror’] | 6.5 | 48.0 | 6668 | $0.25M | A teenager’s quest to launch Norwegian Black M… | Jonas Åkerlund | [‘Rory Culkin’, ‘Emory Cohen’, ‘Jack Kilmer’, … | 118.0 | 2018 |
| 557 | The Strangers: Prey at Night | [‘Horror’] | 5.2 | 48.0 | 21905 | $24.43M | A family of four staying at a secluded mobile … | Johannes Roberts | [‘Christina Hendricks’, ‘Martin Henderson’, ‘B… | 85.0 | 2018 |
2018年公開作品の中で、「Halloween (ハロウィン)」が最も興味深い作品だと思われる。最後に名探偵コナンを検索してみる。
df[(df['タイトル'].str.contains("Conan"))]
| タイトル | ジャンル | IMDBスコア | メタスコア | 投票数 | 興行収入 | あらすじ | 監督 | 出演者 | 上映時間 | 公開年 | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 3640 | Detective Conan: Zero the Enforcer | [‘Animation’, ‘ Action’, ‘ Adventure’] | 6.1 | NaN | 822 | NaN | Detective Conan investigates an explosion that… | Yuzuru Tachikawa | [‘Tôru Furuya’, ‘Megumi Hayashibara’, ‘Rikiya … | 115.0 | 2018 |
| 5298 | Conan | [‘Comedy’, ‘ Music’, ‘ Talk-Show’] | 8.3 | NaN | 152 | NaN | Conan visits various sites throughout the coun… | Mike Sweeney | [“Conan O’Brien”, ‘Jordan Schlansky’, ‘Chiara … | 42.0 | 2018 |
国内興収91.8億円、世界興収110億円のコナン映画史上屈指の名作「ゼロの執行人」がこの扱いである。
プリティ・ウーマンの悲惨なオリジナルエンディングに引いた
映画「Pretty Woman (プリティ・ウーマン)」と言えば、今はハリウッドの大女優となっているJulia Roberts (ジュリア・ロバーツ)の出世作であることは周知の事実であるが、あのハッピー・エンディングのお手本のような名作映画のオリジナルのエンディングは相当悲惨な内容なようです。
eigo.rumisunheart.com
2020-07-04 02:45
スポンサーリンク
スポンサーリンク