Skip to content

Instantly share code, notes, and snippets.

@jpasini

jpasini/.block

Last active November 1, 2017 03:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jpasini/1c801d065f48aceb25a6930fbe00553b to your computer and use it in GitHub Desktop.
Save jpasini/1c801d065f48aceb25a6930fbe00553b to your computer and use it in GitHub Desktop.
Download ZIP
[unlisted] base scatter plot rev 02
Raw
.block
license: mit
Raw
film_data.csv
RecID Release year Rank Title Studio Release_date Tickets_sold Bechdel_Test_Result Executive_Prod_1 Executive_Prod_2 Executive_Prod_3 Executive_Prod_4 Executive_Prod_5 Executive_Prod_6 Executive_Prod_7 Executive_Prod_8 Executive_Prod_9 Director_1 Director_2 Director_3
1 2000 1 How the Grinch Stole Christmas Uni. 11/17/00 48245794 No Data
2 2000 2 Cast Away Fox 12/22/00 43345481 Fail
3 2000 3 Mission: Impossible II Par. 5/24/00 39964729 Fail
4 2000 4 Gladiator DW 5/5/00 34824755 Fail
5 2000 5 What Women Want Par. 12/15/00 33916829 Fail
6 2000 6 The Perfect Storm WB 6/30/00 33880972 No Data
7 2000 7 Meet the Parents Uni. 10/6/00 30843052 Fail
8 2000 8 X-Men Fox 7/14/00 29183621 Fail
9 2000 9 Scary Movie Mira. 7/7/00 29131683 Pass Brad Grey Cary Granat Bob Weinstein Harvey Weinstein Keenen Ivory Wayans
10 2000 10 What Lies Beneath DW 7/21/00 28843108 Pass Mark Johnson Joan Bradshaw Robert Zemeckis
11 2000 11 Dinosaur BV 5/19/00 25556227 Pass Pam Marsden Baker Bloodworth Eric Leighton Ralph Zondag
12 2000 12 Crouching Tiger, Hidden Dragon SPC 12/8/00 23762314 Pass David Linde James Schamus Ang Lee
13 2000 13 Erin Brockovich Uni. 3/17/00 23301523 Pass Carla Santos John Hardy Steven Soderbergh
14 2000 14 Charlie's Angels Sony 11/3/00 23247783 Pass Joseph M. Caracciolo Aaron Spelling Jenno Topping Betty Thomas McG
15 2000 15 Traffic USA 12/27/00 23027037 No Data
16 2000 16 The Nutty Professor II: The Klumps Uni. 7/28/00 22877531 No Data
17 2000 17 Big Momma's House Fox 6/2/00 21810657 No Data
18 2000 18 Remember the Titans BV 9/29/00 21457283 Fail
19 2000 19 The Patriot Sony 6/28/00 21026038 Fail
20 2000 20 Chicken Run DW 6/23/00 19820884 Pass Jake Eberts Jeffery Katzenberg Michael Rose Peter Lod Nick Parl
21 2000 21 Miss Congeniality WB 12/22/00 19815894 Pass Bruce Berman Marc Lawrence Ginger Sledge Donald Petrie
22 2000 22 Gone in 60 Seconds BV 6/9/00 18858734 Fail
23 2000 23 Unbreakable BV 11/22/00 17627336 Fail
24 2000 24 Me, Myself and Irene Fox 6/23/00 16803525 No Data
25 2000 25 Space Cowboys WB 8/4/00 16783817 Fail
26 2001 1 Harry Potter and the Sorcerer's Stone WB 11/16/01 56108755 Pass Chris Columbus Michael Barnathan Mark Radcliffe Duncan Henderson Chris Columbus
27 2001 2 The Lord of the Rings: The Fellowship of the Ring NL 12/19/01 55364685 Fail
28 2001 3 Shrek DW 5/16/01 47290638 Fail
29 2001 4 Monsters, Inc. BV 11/2/01 45207288 Fail
30 2001 5 Rush Hour 2 NL 8/3/01 39958355 Pass Andrew Z. Davis Michael De Luca Toby Emmerich Brett Ratner
31 2001 6 The Mummy Returns Uni. 5/4/01 35692542 Pass Bob Ducsay Don Zepfel Stephen Sommers
32 2001 7 Pearl Harbor BV 5/25/01 35078190 Fail
33 2001 8 Ocean's Eleven WB 12/7/01 32405857 Fail
34 2001 9 Jurassic Park III Uni. 7/18/01 32009166 Fail
35 2001 10 Planet of the Apes (2001) Fox 7/27/01 31804195 Pass Ralph Winter Tim Burton
36 2001 11 A Beautiful Mind Uni. 12/21/01 30166492 Fail
37 2001 12 Hannibal MGM 2/9/01 29168246 Pass Branko Lustig Ridley Scott
38 2001 13 American Pie 2 Uni. 8/10/01 25636678 Pass Adam Herz Chris Weitz Paul Weitz J.B. Rogers
39 2001 14 The Fast and the Furious Uni. 6/22/01 25536030 Fail
40 2001 15 Lara Croft: Tomb Raider Par. 6/15/01 23174571 Fail
41 2001 16 Dr. Dolittle 2 Fox 6/22/01 19956343 Pass Neil A Machlis Steve Carr
42 2001 17 Spy Kids Mira. 3/30/01 19915018 Pass Harvey Weinstein Bob Weinstein Cary Garnat Robert Rodriguez
43 2001 18 Black Hawk Down SonR 12/28/01 19194125 Fail
44 2001 19 The Princess Diaries BV 8/3/01 19125258 Pass Whitney Houston Debra Martin Chase Mario Iscovich Garry Marshall
45 2001 20 Vanilla Sky Par. 12/14/01 17777093 Fail
46 2001 21 The Others Mira. 8/10/01 17053479 Pass Harvey Weinstein Bob Weinstein Paula Wagner Tom Cruise Rick Schwartz Alejandro Amen��bar
47 2001 22 Legally Blonde MGM 7/13/01 17053123 Pass Marc Platt Ric Kidney Robert Luketic
48 2001 23 America's Sweethearts SonR 7/20/01 16538459 No Data
49 2001 24 Cats & Dogs WB 7/4/01 16499208 No Data
50 2001 25 Save the Last Dance Par. 1/12/01 16087811 Pass Robert W. Cort David Madden Thomas Carter
51 2002 1 Spider-Man Sony 5/3/02 69484747 Fail
52 2002 2 The Lord of the Rings: The Two Towers NL 12/18/02 58483629 Fail
53 2002 3 Star Wars: Episode II - Attack of the Clones Fox 5/16/02 52012264 Fail
54 2002 4 Harry Potter and the Chamber of Secrets WB 11/15/02 45092682 Pass Chris Columbus Michael Barnathan Mark Radcliffe David Barron Chris Columbus
55 2002 5 My Big Fat Greek Wedding IFC 4/19/02 41555630 Pass Paul Brooks Steven Shareshian Norm Waitt Joel Zwick
56 2002 6 Signs BV 8/2/02 39236943 Fail
57 2002 7 Austin Powers in Goldmember NL 7/26/02 36713923 Fail
58 2002 8 Men in Black II Sony 7/3/02 32774321 Fail
59 2002 9 Ice Age Fox 3/15/02 30359278 Fail
60 2002 10 Chicago Mira. 12/27/02 29378231 Pass Jennifer Berman Sam Crothers Neil Meron Meryl Poster Bob Weinstein Harvey Weinstein Craig Zadan Julie Goldstein Rob Marshall
61 2002 11 Catch Me If You Can DW 12/25/02 28333107 Fail
62 2002 12 Die Another Day MGM 11/22/02 27700885 Fail
63 2002 13 Scooby-Doo WB 6/14/02 26384538 Pass Raja Gosnell Robert Engelman Andrew Mason William Hanna Kelley Smith-Wait Raja Gosnell
64 2002 14 Lilo & Stitch BV 6/21/02 25093690 Pass Clark Spencer Dean DeBlois Chris Sanders
65 2002 15 XXX SonR 8/9/02 24459447 Fail
66 2002 16 The Santa Clause 2 BV 11/1/02 23964945 Fail
67 2002 17 Minority Report Fox 6/21/02 22732002 Fail
68 2002 18 The Ring DW 10/18/02 22225152 Pass Roy Lee Mike Macari Doug Davison Michele Weisler Gore Verbinski
69 2002 19 Sweet Home Alabama BV 9/27/02 21897319 Fail
70 2002 20 Mr. Deeds Sony 6/28/02 21737256 Fail
71 2002 21 The Bourne Identity Uni. 6/14/02 20940049 Fail
72 2002 22 The Sum of All Fears Par. 5/31/02 20465928 No Data
73 2002 23 8 Mile Uni. 11/8/02 20094820 Fail
74 2002 24 Road to Perdition DW 7/12/02 17978445 Fail
75 2002 25 Panic Room Sony 3/29/02 16591624 Pass David Koepp Ce��n Chaffin Gavin Polone Judy Hofflund David Fincher
76 2003 1 The Lord of the Rings: The Return of the King NL 12/17/03 62525262 Fail
77 2003 2 Finding Nemo BV 5/30/03 56337476 Fail
78 2003 3 Pirates of the Caribbean: The Curse of the Black Pearl BV 7/9/03 50649075 Fail
79 2003 4 The Matrix Reloaded WB 5/15/03 46695931 Pass Lana Wachowski Lilly Wachowski Bruce Berman Grant Hill Andrew Mason David Forbes Lana Wachowski Lilly Wachowski
80 2003 5 Bruce Almighty Uni. 5/23/03 40270193 Pass Steve Oedekerk Gary Barber Roger Birnbaum Tom Shadyac
81 2003 6 X2: X-Men United Fox 5/2/03 35646716 Pass Bryan Singer Stan Lee Avi Arad Tom DeSanto Bryan Singer
82 2003 7 Elf NL 11/7/03 28755974 No Data
83 2003 8 Terminator 3: Rise of the Machines WB 7/2/03 24937167 Pass Gale Anne Hurd Moritz Borman Nigel Sinclair Guy East Aslan Nadery Dieter Nobbe Volker Schauz Jonathan Mostow
84 2003 9 The Matrix Revolutions WB 11/5/03 23103474 Pass Lana Wachowski Lilly Wachowski Bruce Berman Grant Hill Andrew Mason David Forbes Lana Wachowski Lilly Wachowski
85 2003 10 Cheaper by the Dozen Fox 12/25/03 22987487 No Data
86 2003 11 Bad Boys II Sony 7/18/03 22986475 No Data
87 2003 12 Anger Management SonR 4/11/03 22495162 No Data
88 2003 13 Bringing Down the House BV 3/7/03 22009400 No Data
89 2003 14 Hulk Uni. 6/20/03 21919940 Fail
90 2003 15 2 Fast 2 Furious Uni. 6/6/03 21087049 Fail
91 2003 16 Something's Gotta Give Sony 12/12/03 20684700 Pass Nancy Meyers Bruce A. Block Nancy Meyers
92 2003 17 Seabiscuit Uni. 7/25/03 19946577 No Data
93 2003 18 S.W.A.T. Sony 8/8/03 19392148 Pass Louis D'Esposito Clark Johnson
94 2003 19 Spy Kids 3D: Game Over Dim. 7/25/03 18534326 Pass Harvey Weinstein Bob Weinstein Robert Rodriguez
95 2003 20 The Last Samurai WB 12/5/03 18429066 Fail
96 2003 21 Freaky Friday BV 8/6/03 18280321 Pass Mario Iscovich Mark Waters
97 2003 22 Scary Movie 3 Dim. 10/24/03 18242657 Pass Bob Weinstein Harvey Weinstein Andrew Rona Andrew Rona David Zucker
98 2003 23 The Italian Job Par. 5/30/03 17600100 Fail
99 2003 24 How to Lose a Guy in 10 Days Par. 2/7/03 17547824 Fail
100 2003 25 American Wedding Uni. 8/1/03 17340815 No Data
101 2004 1 Shrek 2 DW 5/19/04 71050926 Pass Jeffrey Katzenberg Andrew Adamson Kelly Asbury Conrad Vernon
102 2004 2 Spider-Man 2 Sony 6/30/04 60158748 Fail
103 2004 3 The Passion of the Christ NM 2/25/04 59625541 No Data
104 2004 4 Meet the Fockers Uni. 12/22/04 44969591 Pass Nancy Tenenbaum Amy Sayres Jay Roach
105 2004 5 The Incredibles BV 11/5/04 42100015 Pass John Lasseter Brad Bird
106 2004 6 Harry Potter and the Prisoner of Azkaban WB 6/4/04 40183748 Pass Michael Barnathan Tanya Seghatchian Callum McDougall Alfonso Cuar�_n
107 2004 7 The Day After Tomorrow Fox 5/28/04 30070983 Pass Ute Emmerich Kelly Van Horn Stephanie Germain Roland Emmerich
108 2004 8 The Bourne Supremacy Uni. 7/23/04 28380345 Fail
109 2004 9 National Treasure BV 11/19/04 27859726 Fail
110 2004 10 The Polar Express WB 11/10/04 26211813 Fail
111 2004 11 Shark Tale DW 10/1/04 25903689 Fail
112 2004 12 I, Robot Fox 7/16/04 23317396 Fail
113 2004 13 Troy WB 5/14/04 21477981 Fail
114 2004 14 Ocean's Twelve WB 12/10/04 20216471 Fail
115 2004 15 50 First Dates Sony 2/13/04 19469900 Fail
116 2004 16 Van Helsing Uni. 5/7/04 19352188 Pass Sam Mercer Stephen Sommers
117 2004 17 Fahrenheit 9/11 Lions 6/23/04 19194005 No Data
118 2004 18 Lemony Snicket's A Series of Unfortunate Events Par. 12/17/04 19103793 Pass Albie Hecht Julia Pistor Scott Rudin Barry Sonnenfeld Brad Silberling
119 2004 19 DodgeBall: A True Underdog Story Fox 6/18/04 18410103 Pass Rhoades Rader Mary McLaglen Rawson Marshall Thurber
120 2004 20 The Village BV 7/30/04 18389295 Pass M. Night Shyamalan Scott Rudin Sam Mercer M. Night Shyamalan
121 2004 21 The Grudge Sony 10/22/04 17771234 Pass Doug Davison Joseph Drake Nathan Kahane Roy Lee Carsten H.W. Lorenz Takashi Shimizu
122 2004 22 The Aviator Mira. 12/17/04 16523403 Fail
123 2004 23 Collateral DW 8/6/04 16265009 Fail
124 2004 24 Million Dollar Baby WB 12/15/04 16182320 Pass Robert Lorenz Gary Lucchesi Clint Eastwood
125 2004 25 The Princess Diaries 2: Royal Engagement BV 8/11/04 15325360 Pass Ellen H. Schwartz Garry Marshall
126 2005 1 Star Wars: Episode III - Revenge of the Sith Fox 5/19/05 59324583 Fail
127 2005 2 The Chronicles of Narnia: The Lion, the Witch and the Wardrobe BV 12/9/05 45508730 Pass Andrew Adamson Perry Moore Andrew Adamson
128 2005 3 Harry Potter and the Goblet of Fire WB 11/18/05 45243844 Fail
129 2005 4 War of the Worlds Par. 6/29/05 36549198 Fail
130 2005 5 King Kong Uni. 12/14/05 34021845 Fail
131 2005 6 Wedding Crashers NL 7/15/05 32645230 Pass Toby Emmerich Richard Brener Guy Riedel Cale Boyter David Dobkin
132 2005 7 Charlie and the Chocolate Factory WB 7/15/05 32208905 Pass Bruce Berman Felicity d'Abreu Crosland Michael Siegel Graham Burke Patrick McCormick Tim Burton
133 2005 8 Batman Begins WB 6/15/05 32034911 Fail
134 2005 9 Madagascar DW 5/27/05 30202110 Fail
135 2005 10 Mr. & Mrs. Smith Fox 6/10/05 29069623 Fail
136 2005 11 Hitch Sony 2/11/05 28002427 Fail
137 2005 12 The Longest Yard Par. 5/27/05 24667623 Fail
138 2005 13 Fantastic Four (2005) Fox 7/8/05 24133554 Fail
139 2005 14 Chicken Little BV 11/4/05 21121165 Fail
140 2005 15 Robots Fox 3/11/05 20000002 Fail
141 2005 16 Walk the Line Fox 11/18/05 18645773 Pass Alan C. Blomquist John Carter Cash James Mangold
142 2005 17 The Pacifier BV 3/4/05 17642258 Pass Adam Shankman Jennifer Gibgot George Zakk Garrett Grant Derek Evans Adam Shankman
143 2005 18 Fun with Dick and Jane Sony 12/21/05 17212596 Pass Peter Bart Max Palevsky Jane Bartelme Dean Parisot
144 2005 19 The 40-Year-Old Virgin Uni. 8/19/05 17074764 Pass Steve Carell Jon Poll Judd Apatow
145 2005 20 Flightplan BV 9/23/05 13994899 Pass Erica Huggins Charles J.D. Schlissel James Whitaker Robert DeNozzi Robert Schwentke
146 2005 21 Saw II Lions 10/28/05 13578778 Fail
147 2005 22 Brokeback Mountain Focus 12/9/05 12955345 Fail
148 2005 23 Monster-in-Law NL 5/13/05 12937801 Fail
149 2005 24 Are We There Yet? SonR 1/21/05 12897722 No Data
150 2005 25 Cheaper by the Dozen 2 Fox 12/21/05 12881619 No Data
151 2006 1 Pirates of the Caribbean: Dead Man's Chest BV 7/7/06 64628369 Fail
152 2006 2 Night at the Museum Fox 12/22/06 38299736 Pass Mark Radcliffe Thomas M. Hammel Ira Shuman Shawn Levy
153 2006 3 Cars BV 6/9/06 37264578 Fail
154 2006 4 X-Men: The Last Stand Fox 5/26/06 35780529 Pass Stan Lee Kevin Feige John Palermo Brett Ratner
155 2006 5 The Da Vinci Code Sony 5/19/06 33211625 Fail
156 2006 6 Superman Returns WB 6/28/06 30546747 Fail
157 2006 7 Happy Feet WB 11/17/06 30229057 Pass Bruce Berman Dana Goldberg Graham Burke Ed Jones George Miller
158 2006 8 Ice Age: The Meltdown Fox 3/31/06 29821469 Fail
159 2006 9 Casino Royale Sony 11/17/06 25564269 Fail
160 2006 10 The Pursuit of Happyness Sony 12/15/06 24971979 Fail
161 2006 11 Over the Hedge P/DW 5/19/06 23667075 No Data
162 2006 12 Talladega Nights: The Ballad of Ricky Bobby Sony 8/4/06 22627997 No Data
163 2006 13 Click SonR 6/23/06 20970326 Pass Barry Bernardi Tim Herlihy Frank Coraci
164 2006 14 Mission: Impossible III Par. 5/5/06 20462566 Fail
165 2006 15 The Departed WB 10/6/06 20211346 Fail
166 2006 16 Borat: Cultural Learnings of America for Make Benefit Glorious Nation of Kazakhstan Fox 11/3/06 19619231 Fail
167 2006 17 The Devil Wears Prada Fox 6/30/06 19044346 Pass Karen Rosenfelt Joseph M. Caracciolo Jr. David Frankel
168 2006 18 The Break-Up Uni. 6/2/06 18122638 Fail
169 2006 19 Dreamgirls P/DW 12/15/06 15781062 Pass Patricia Whitcher Bill Condon
170 2006 20 Scary Movie 4 W/Dim. 4/14/06 13848950 Pass Harvey Weinstein Bob Weinstein David Zucker
171 2006 21 Failure to Launch Par. 3/10/06 13544305 No Data
172 2006 22 Inside Man Uni. 3/24/06 13513511 Fail
173 2006 23 Open Season Sony 9/29/06 12993170 Fail
174 2006 24 The Santa Clause 3: The Escape Clause BV 11/3/06 12900782 No Data
175 2006 25 Charlotte's Web (2006) Par. 12/15/06 12669574 No Data
176 2007 1 Spider-Man 3 Sony 5/4/07 48914289 Fail
177 2007 2 Shrek the Third P/DW 5/18/07 46906969 Pass Andrew Adamson John H. Williams Chris Miller Raman Hui
178 2007 3 Transformers P/DW 7/3/07 46402063 Fail
179 2007 4 Pirates of the Caribbean: At World's End BV 5/25/07 44973899 Pass Chad Oman Mike Stenson Bruce Hendricks Eric McLeod Gore Verbinski
180 2007 5 Harry Potter and the Order of the Phoenix WB 7/11/07 42442550 Pass Lionel Wigram David Yates
181 2007 6 I Am Legend WB 12/14/07 37266426 Pass Erwin Stoff Bruce Berman Michael Tadross Dana Goldberg Francis Lawrence
182 2007 7 The Bourne Ultimatum Uni. 8/3/07 33062656 Fail
183 2007 8 National Treasure: Book of Secrets BV 12/21/07 31971529 No Data
184 2007 9 Alvin and the Chipmunks Fox 12/14/07 31588223 No Data
185 2007 10 300 WB 3/9/07 30612637 Fail
186 2007 11 Ratatouille BV 6/29/07 30006636 Fail
187 2007 12 The Simpsons Movie Fox 7/27/07 26618462 Pass Nikki Vanzo David Silverman
188 2007 13 Wild Hogs BV 3/2/07 24458365 Fail
189 2007 14 Knocked Up Uni. 6/1/07 21623390 Pass Seth Rogen Evan Goldberg Judd Apatow
190 2007 15 Juno FoxS 12/5/07 20856870 Pass Daniel Dubiecki Nathan Kahane Joe Drake Jason Reitman
191 2007 16 Rush Hour 3 NL 8/10/07 20367147 Fail
192 2007 17 Live Free or Die Hard Fox 6/27/07 19553693 Fail
193 2007 18 Fantastic Four: Rise of the Silver Surfer Fox 6/15/07 19174672 Fail
194 2007 19 American Gangster Uni. 11/2/07 18919280 Fail
195 2007 20 Enchanted BV 11/21/07 18576637 Pass Sunil Perkash Ezra Swerdlow Christopher Chase Kevin Lima
196 2007 21 Bee Movie P/DW 11/2/07 18405709 Fail
197 2007 22 Superbad Sony 8/17/07 17654539 Fail
198 2007 23 I Now Pronounce You Chuck and Larry Uni. 7/20/07 17450517 No Data
199 2007 24 Hairspray (2007) NL 7/20/07 17277886 Pass Toby Emmerich Jennifer Gibgot Garrett Grant Mark Kaufman Michael Lynne Marc Shaiman Adam Shankman Robert Shaye Scott Wittman Adam Shankman
200 2007 25 Blades of Glory P/DW 4/30/07 17237580 Pass Marty P. Ewing Josh Gordon
201 2008 1 The Dark Knight WB 7/18/08 74282084 Fail
202 2008 2 Iron Man Par. 5/2/08 44347090 Fail
203 2008 3 Indiana Jones and the Kingdom of the Crystal Skull Par. 5/22/08 44164502 Fail
204 2008 4 Hancock Sony 7/2/08 31747392 Fail
205 2008 5 WALL-E BV 6/27/08 31171054 Fail
206 2008 6 Kung Fu Panda P/DW 6/6/08 30004818 Fail
207 2008 7 Twilight Sum. 11/21/08 26848170 Pass Karen Rosenfelt Karen Rosenfelt
208 2008 8 Madagascar: Escape 2 Africa P/DW 11/7/08 25071163 Fail
209 2008 9 Quantum of Solace Sony 11/14/08 23449642 Fail
210 2008 10 Dr. Seuss' Horton Hears a Who! Fox 3/14/08 21522206 Fail
211 2008 11 Sex and the City WB (NL) 5/30/08 21260064 Pass Richard Brener Kathy Busby Toby Emmerich Jonathan Filley Michael Patrick King
212 2008 12 Gran Torino WB 12/12/08 20626087 Fail
213 2008 13 Mamma Mia! Uni. 7/18/08 20073825 Pass Benny Andersson Tom Hanks Mark Huffam Bj�_rn Ulvaeus Rita Wilson Phyllida Lloyd
214 2008 14 Marley and Me Fox 12/25/08 19937849 Fail
215 2008 15 The Chronicles of Narnia: Prince Caspian BV 5/16/08 19724442 Pass Perry Moore Andrew Adamson
216 2008 16 Slumdog Millionaire FoxS 11/12/08 19682442 Fail
217 2008 17 The Incredible Hulk Uni. 6/13/08 18775337 Fail
218 2008 18 Wanted Uni. 6/27/08 18733782 Fail
219 2008 19 Get Smart WB 6/20/08 18150308 Fail
220 2008 20 The Curious Case of Benjamin Button Par. 12/25/08 17758960 Fail
221 2008 21 Four Christmases WB (NL) 11/26/08 16733432 Pass Peter Billingsley Peter Billingsley Michael Disco Toby Emmerich Mark Kaufman Guy Riedel Seth Gordon
222 2008 22 Bolt BV 11/21/08 15884900 Pass John Lasseter Chris Williams Byron Howard
223 2008 23 Tropic Thunder P/DW 8/13/08 15392105 Fail
224 2008 24 Bedtime Stories BV 12/25/08 15334537 Pass Adam Shankman Jennifer Gibgot Garrett Grant Ann Marie Sanderlin Adam Shankman
225 2008 25 The Mummy: Tomb of the Dragon Emperor Uni. 8/1/08 14274621 Pass Chris Brigham Huang Jianxin Zhong-lun Ren Rob Cohen
226 2009 1 Avatar Fox 12/18/09 99968819 Fail
227 2009 2 Transformers: Revenge of the Fallen P/DW 6/24/09 53614916 Pass Michael Bay Steven Spielberg Brian Goldner Mark Vahradian Michael Bay
228 2009 3 Harry Potter and the Half-Blood Prince WB 7/15/09 40261227 Pass Lionel Wigram David Yates
229 2009 4 The Twilight Saga: New Moon Sum. 11/20/09 39549818 No Data
230 2009 5 Up BV 5/29/09 39067222 Fail
231 2009 6 The Hangover WB 6/5/09 36976334 Fail
232 2009 7 Star Trek Par. 5/8/09 34364003 Pass Bryan Burk Jeffrey Chernov Roberto Orci J.J. Abrams
233 2009 8 The Blind Side WB 11/20/09 34127930 Fail
234 2009 9 Alvin and the Chipmunks: The Squeakquel Fox 12/23/09 29281949 No Data
235 2009 10 Sherlock Holmes WB 12/25/09 27870491 Fail
236 2009 11 Monsters Vs. Aliens P/DW 3/27/09 26446871 Pass Lisa Stewart Rob Letterman Conrad Vernon
237 2009 12 Ice Age: Dawn of the Dinosaurs Fox 7/1/09 26209828 Fail
238 2009 13 X-Men Origins: Wolverine Fox 5/1/09 23984421 Fail
239 2009 14 Night at the Museum: Battle of the Smithsonian Fox 5/22/09 23632497 Pass Mark Radcliffe Josh McLaglen Thomas M. Hammel Shawn Levy
240 2009 15 2012 Sony 11/13/09 22148289 Fail
241 2009 16 The Proposal BV 6/19/09 21861071 Fail
242 2009 17 Fast and Furious Uni. 4/3/09 20675236 No Data
243 2009 18 G.I. Joe: The Rise of Cobra Par. 8/7/09 20026867 Fail
244 2009 19 Paul Blart: Mall Cop Sony 1/16/09 19511491 No Data
245 2009 20 Taken Fox 1/30/09 19333466 Pass Didier Hoarau Pierre Morel
246 2009 21 A Christmas Carol (2009) BV 11/6/09 18380782 No Data
247 2009 22 Angels & Demons Sony 5/15/09 17783447 Fail
248 2009 23 Terminator Salvation WB 5/21/09 16709663 Fail
249 2009 24 Cloudy with a Chance of Meatballs Sony 9/18/09 16649370 Fail
250 2009 25 Inglourious Basterds Wein. 8/21/09 16072096 Fail
251 2010 1 Toy Story 3 BV 6/18/10 52598845 Fail
252 2010 2 Alice in Wonderland (2010) BV 3/5/10 42356288 Pass Chris Lebenzon Peter M. Tobyansen Tim Burton
253 2010 3 Iron Man 2 Par. 5/7/10 39598648 Pass Louis D'Esposito Susan Downey Jon Favreau Alan Fine Stan Lee David Maisel Denis L. Stewart Jon Favreau
254 2010 4 The Twilight Saga: Eclipse Sum. 6/30/10 38090210 Pass Mark Morgan Greg Mooradian Marty Bowen Guy Oseary David Slade
255 2010 5 Harry Potter and the Deathly Hallows Part 1 WB 11/19/10 37513727 Pass J. K. Rowling David Heyman David Barron David Yates
256 2010 6 Inception WB 7/16/10 37081901 Fail
257 2010 7 Despicable Me Uni. 7/9/10 31877565 Pass Chris Meledandri Janet Healy Janet Healy Pierre Coffin Chris Renaud
258 2010 8 Shrek Forever After P/DW 5/21/10 30258148 Fail
259 2010 9 How to Train Your Dragon P/DW 3/26/10 27576836 Pass Bonnie Arnold Dean DeBlois Chris Sanders
260 2010 10 Tangled BV 11/24/10 25452717 Pass Roy Conli Nathan Greno Byron Howard
261 2010 11 The Karate Kid Sony 6/11/10 22381701 Fail
262 2010 12 Tron Legacy BV 12/17/10 21807702 Fail
263 2010 13 True Grit Par. 12/22/10 21703803 Pass David Ellison Megan Ellison Robert Graf Paul Schwake Steven Spielberg Ethan Coen Joel Coen
264 2010 14 Clash of the Titans (2010) WB 4/2/10 20686298 Pass Brenda Berrisford William Fay Jon Jashni Thomas Tull Richard D. Zanuck Louis Leterrier
265 2010 15 Grown Ups Sony 6/25/10 20532470 Pass Adam Sandler Jack Giarraputo Dennis Dugan
266 2010 16 Little Fockers Uni. 12/22/10 18813511 Pass Ryan Kavanaugh Daniel Lupi Meghan Lyvers Andrew Miano Nancy Tenenbaum Paul Weitz
267 2010 17 Megamind P/DW 11/5/10 18810628 Fail
268 2010 18 The King's Speech Wein. 11/26/10 17167699 Pass Paul Brett Mark Foligno Geoffrey Rush Tim Smith Bob Weinstein Harvey Weinstein Tom Hooper
269 2010 19 The Last Airbender Par. 7/1/10 16701165 Fail
270 2010 20 Shutter Island Par. 2/19/10 16224707 Fail
271 2010 21 The Other Guys Sony 8/6/10 15110264 Fail
272 2010 22 Salt Sony 7/23/10 14995104 Pass Mark Vahradian Ryan Kavanaugh Ric Kidney Phillip Noyce
273 2010 23 Jackass 3-D Par. 10/15/10 14858010 No Data
274 2010 24 Valentine's Day WB (NL) 2/12/10 14003252 Pass Diana Pokorny Samuel J. Brown Michael Disco Garry Marshall
275 2010 25 Black Swan FoxS 12/3/10 13555726 Pass Jon Avnet Brad Fischer Peter Fruchtman Darren Aronofsky
276 2011 1 Harry Potter and the Deathly Hallows Part 2 WB 7/15/11 48046812 Pass David Heyman Lionel Wigram David Yates
277 2011 2 Transformers: Dark of the Moon P/DW 6/29/11 44437648 Pass Michael Bay Steven Spielberg Brian Goldner Mark Vahradian Michael Bay
278 2011 3 The Twilight Saga: Breaking Dawn Part 1 Sum. 11/18/11 35471266 Pass Mark Morgan Bill Condon
279 2011 4 The Hangover Part II WB 5/26/11 32088816 Fail
280 2011 5 Pirates of the Caribbean: On Stranger Tides BV 5/20/11 30399976 Fail
281 2011 6 Fast Five Uni. 4/29/11 26461246 Pass Justin Lin Samantha Vincent Amanda Lewis Justin Lin
282 2011 7 Mission: Impossible - Ghost Protocol Par. 12/16/11 26405789 Fail
283 2011 8 Cars 2 BV 6/24/11 24142799 Fail
284 2011 9 Sherlock Holmes: A Game of Shadows WB 12/16/11 23562222 Fail
285 2011 10 Thor Par. 5/6/11 22828579 Pass Louis D'Esposito Alan Fine Stan Lee David Maisel Patricia Whitcher Kenneth Branagh
286 2011 11 Rise of the Planet of the Apes Fox 8/5/11 22290062 Fail
287 2011 12 Captain America: The First Avenger Par. 7/22/11 22276735 Fail
288 2011 13 The Help BV 8/10/11 21400771 Pass Mohamed Khalaf Al-Mazrouei Nate Berkus Jennifer Blum L. Dean Jones Jr. John Norris Mark Radcliffe Jeff Skoll Tate Taylor Tate Taylor
289 2011 14 Bridesmaids Uni. 5/13/11 21324934 Pass Paul Feig Paul Feig
290 2011 15 Kung Fu Panda 2 P/DW 5/26/11 20838470 Pass Melissa Cobb Jennifer Yuh Nelson
291 2011 16 Puss in Boots P/DW 10/28/11 18822258 Fail
292 2011 17 X-Men: First Class Fox 6/3/11 18462586 Pass Josh McLaglen Stan Lee Tarquin Pack Matthew Vaughn
293 2011 18 Rio Fox 4/15/11 18110947 Fail
294 2011 19 The Smurfs Sony 7/29/11 17984131 Pass Ezra Swerdlow Ben Haber Paul Neesan Raja Gosnell
295 2011 20 Alvin and the Chipmunks: Chipwrecked Fox 12/16/11 16785718 Pass Arnon Milchan Karen Rosenfelt Steve Waterman Neil A. Machlis Mike Mitchell
296 2011 21 Super 8 Par. 6/10/11 16015660 Pass Guy Riedel J.J. Abrams
297 2011 22 Rango Par. 3/4/11 15570947 Fail
298 2011 23 Horrible Bosses WB (NL) 7/8/11 14822013 Pass Richard Brener Samuel J. Brown Michael Disco Toby Emmerich Diana Pokorny Seth Gordon
299 2011 24 Green Lantern WB 6/17/11 14703805 Fail
300 2011 25 Hop Uni. 4/1/11 13629925 Fail
301 2012 1 Marvel's The Avengers BV 5/4/12 78311296 Fail
302 2012 2 The Dark Knight Rises WB 7/20/12 56298882 Fail
303 2012 3 The Hunger Games LGF 3/23/12 51257625 Pass Suzanne Collins Robin Bissell Louise Rosner Gary Ross
304 2012 4 Skyfall Sony 11/9/12 38236216 Fail
305 2012 5 The Hobbit: An Unexpected Journey WB (NL) 12/14/12 38065775 Fail
306 2012 6 The Twilight Saga: Breaking Dawn Part 2 LG/S 11/16/12 36724214 Pass Mark Morgan Guy Oseary Marty Bowen Greg Mooradian Bill Condon
307 2012 7 The Amazing Spider-Man Sony 7/3/12 32918425 Fail
308 2012 8 Brave BV 6/22/12 29809449 Pass Pete Docter John Lasseter Andrew Stanton Mark Andrews Brenda Chapman Steve Purcell
309 2012 9 Ted Uni. 6/29/12 27489383 Fail
310 2012 10 Madagascar 3: Europe's Most Wanted P/DW 6/8/12 27184860 Fail
311 2012 11 Dr. Seuss' The Lorax Uni. 3/2/12 26888254 Fail
312 2012 12 Wreck-It Ralph BV 11/2/12 23796846 Pass John Lasseter Rich Moore
313 2012 13 Lincoln BV 11/9/12 22890449 Pass Daniel Lupi Jeffrey Skoll Jonathan King Steven Spielberg
314 2012 14 MIB 3 Sony 5/25/12 22490058 Fail
315 2012 15 Django Unchained Wein. 12/25/12 20452944 Fail
316 2012 16 Ice Age: Continental Drift Fox 7/13/12 20266564 No Data
317 2012 17 Snow White and the Huntsman Uni. 6/1/12 19514119 Pass Gloria Borders Rupert Sanders
318 2012 18 Les Miserables (2012) Uni. 12/25/12 18694695 Pass Liza Chasin F. Richard Pappas Angela Morrison Nicholas Allott Tom Hooper
319 2012 19 Hotel Transylvania Sony 9/28/12 18632293 Pass Adam Sandler Robert Smigel Genndy Tartakovsky
320 2012 20 Taken 2 Fox 10/5/12 17569635 Fail
321 2012 21 21 Jump Street Sony 3/16/12 17392923 Fail
322 2012 22 Argo WB 10/12/12 17088632 Pass Chris Brigham Chay Carter Tim Headington Graham King David Klawans Nina Wolarsky Ben Affleck
323 2012 23 Silver Linings Playbook Wein. 11/16/12 16594593 Pass Bradley Cooper George Parra Michelle Raimo Bob Weinstein Harvey Weinstein Renee Witt David O. Russell
324 2012 24 Prometheus Fox 6/8/12 15889081 Pass Damon Lindelof Mark Huffam Michael Costigan Michael Ellenberg Ridley Scott
325 2012 25 Safe House Uni. 2/10/12 15876060 No Data
326 2013 1 The Hunger Games: Catching Fire LGF 11/22/13 52234693 Pass Suzanne Collins Allison Shearmur Joe Drake Louise Rosner Francis Lawrence
327 2013 2 Iron Man 3 BV 5/3/13 50309225 Fail
328 2013 3 Frozen BV 11/22/13 49291269 Pass John Lasseter Chris Buck Jennifer Lee
329 2013 4 Despicable Me 2 Uni. 7/3/13 45271989 Pass Chris Meledandri Janet Healy Pierre Coffin Chris Renaud
330 2013 5 Man of Steel WB 6/14/13 35798957 Pass Jon Peters Thomas Tull Lloyd Phillips Zack Snyder
331 2013 6 Gravity WB 10/4/13 33713740 Fail
332 2013 7 Monsters University BV 6/21/13 33024941 Fail
333 2013 8 The Hobbit: The Desolation of Smaug WB (NL) 12/13/13 31779441 Fail
334 2013 9 Fast & Furious 6 Uni. 5/24/13 29357916 Pass Justin Lin Justin Lin Samantha Vincent Amanda Lewis Justin Lin
335 2013 10 Oz The Great and Powerful BV 3/8/13 28894444 Pass Palak Patel Grant Curtis Philip Steuer Joshua Donen Sam Raimi
336 2013 11 Star Trek Into Darkness Par. 5/16/13 28140057 Fail
337 2013 12 Thor: The Dark World BV 11/8/13 25382798 Fail
338 2013 13 World War Z Par. 6/21/13 24890494 Fail
339 2013 14 The Croods Fox 3/22/13 23021947 Fail
340 2013 15 The Heat Fox 6/28/13 19628806 Pass Paul Feig Dylan Clark Michele Imperato Paul Feig
341 2013 16 We're the Millers WB (NL) 8/7/13 18498662 Pass Richard Brener Toby Emmerich David Heyman Dave Neustadter J.C. Spink Marcus Viscidi Rawson Marshall Thurber
342 2013 17 American Hustle Sony 12/13/13 18464675 Pass Bradley Cooper Eric Singer George Parra Matthew Budman David O. Russell
343 2013 18 The Great Gatsby (2013) WB 5/10/13 17815550 Pass Jay Z Barrie M. Osborne Bruce Berman Baz Luhrmann
344 2013 19 The Conjuring WB (NL) 7/19/13 16900387 Pass Walter Hamada Dave Neustadter James Wan
345 2013 20 Identity Thief Uni. 2/8/13 16544517 Fail
346 2013 21 Grown Ups 2 Sony 7/12/13 16441393 Fail
347 2013 22 The Wolverine Fox 7/26/13 16304656 Pass Stan Lee Joseph M. Caracciolo Jr. James Mangold
348 2013 23 Anchorman 2: The Legend Continues Par. 12/18/13 15395864 Pass Jessica Elbaum Kevin J. Messick David B. Householter Adam McKay
349 2013 24 Lone Survivor Uni. 12/25/13 15386913 No Data
350 2013 25 G.I. Joe: Retaliation Par. 3/28/13 15070488 Pass Gary Barber Roger Birnbaum David Ellison Herb Gains Dana Goldberg Erik Howsam Paul Schwake Stephen Sommers Jon M. Chu
Raw
index.html
<!DOCTYPE html>
<meta charset="utf-8">
<style> /* set the CSS */
body { font: 12px Arial;}
path {
stroke: steelblue;
stroke-width: 2;
fill: none;
}
.axis path,
.axis line {
fill: none;
stroke: grey;
stroke-width: 1;
shape-rendering: crispEdges;
}
// Legend-------------
.legend{font-family: 'Open Sans', sans-serif;
font-size: 12pt;}
rect{ stroke-width: 2;}
.tooltip {
position: absolute;
text-align: left;
width: 250px;
height: 60px;
padding: 2px;
font: 12px sans-serif;
background: white;
border: 0px;
border-radius: 8px;
pointer-events: none;
}
</style>
<body>
<!-- load the d3.js library -->
<script src="https://d3js.org/d3.v4.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/d3-legend/2.24.0/d3-legend.min.js"></script>
<script>
//---------------------------------------------------------
// Set up & Define variables-------------------------------
//---------------------------------------------------------
// Set the dimensions of the canvas / graph--------------
var margin = {top: 80, right: 40, bottom: 30, left: 80},
width = 900 - margin.left - margin.right,
height = 470 - margin.top - margin.bottom;
// Parse the date / time---------------------------------
// see https://github.com/d3/d3-time-format for details on parsing dates
var parseDate = d3.timeParse("%m/%e/%y");
// Set the ranges----------------------------------------
var x = d3.scaleTime().range([0, width]);
var y = d3.scaleLinear().range([height, 0]);
// Define the axes----------------------------------------
var xAxis = d3.axisBottom(x).ticks(5);
var yAxis = d3.axisLeft(y).ticks(5);
// Define the line----------------------------------------
var valueline = d3.line()
.x(function(d) { return x(d.date); })
.y(function(d) { return y(d.sold); });
var hoveredColorValue; // this is used later
// Adds the svg canvas-----------------------------------
var svg = d3.select("body").append("svg")
.attr("width", width + margin.left + margin.right)
.attr("height", height + margin.top + margin.bottom)
var g = svg.append("g").attr("transform", "translate("
+ margin.left + "," + margin.top + ")");
//Based on http://blockbuilder.org/curran/0d2cc6698cad72a48027b8de0ebb417d
//This is the layer where the cars are drawn
var baseLayer = g.append("g");
// This layer contains a semi-transparent overlay
// that fades out the base dots.
var overlayRect = g.append("g")
.append("rect")
.attr("width", innerWidth)
.attr("height", innerHeight)
.attr("fill", "none")
.style("pointer-events", "none");
// This contains the subset of dots rendered on top
// when you hover over the entries in the color legend.
var foregroundLayer = g.append("g");
// setup fill color---------------------------------------
var cValue = function(d) { return d.Bechdel_Test_Result;},
color = d3.schemeCategory10;
// add the tooltip area to the webpage--------------------
var tooltip = d3.select("body").append("div")
.attr("class", "tooltip")
.style("opacity", 0);
function type(d) {
d.date = parseDate(d.Release_date);
d.sold = +d.Tickets_sold;
d.result = d.Bechdel_Test_Result;
return d;
}
var fillopac = 0.3;
var r = 10; //set dot size
var tipNumberFormat = d3.format(",");
// Get the data---------------------------------------------
function render(data) {
x.domain(d3.extent(data, d => d.date));
y.domain([0, d3.max(data, d => d.sold)]);
// Define Colors & Fill------------------------------------
var color = d3.scaleOrdinal()
.domain(["Pass", "Fail", "No Data"])
.range(["green", "red" , "black"]);
//---------------------------------------------------------
// Set up the legend---------------------------------------
//---------------------------------------------------------
var legendRectSize = 20;
var legendSpacing = 5;
var legend = g.selectAll('.legend')
.data(color.domain())
.enter()
.append('g')
.attr('class', 'legend')
.attr('transform', function(d, i) {
var height = legendRectSize + legendSpacing+5;
var offset = height * color.domain().length / 2;
var horz = width -2 * legendRectSize;
var vert = i * height - offset;
return 'translate(' + horz + ',' + vert + ')';
});
legend.append('rect')
.attr('width', legendRectSize)
.attr('height', legendRectSize)
.style('fill', color)
.attr("fill-opacity", fillopac);
legend.append('text')
.attr('x', legendRectSize + legendSpacing)
.attr('y', legendRectSize - legendSpacing)
.text(d => d);
//---------------------------------------------------------
// Draw the Dots ------------------------------------------
//---------------------------------------------------------
//Render the Base dataset
renderdots(baseLayer, data);
listenForHover(legend.selectAll('rect'), data);
listenForHover(legend.selectAll('text'), data);
}
// Draw the dots------------------------
function renderdots(g, layers){
let g2 = g.selectAll(".dot").data(layers);
g2 = g2
.enter().append("circle")
.attr('class', 'dot')
.merge(g2)
.attr("fill-opacity", d => ((d.result == hoveredColorValue) ? 0.7 : 0.3))
.attr("r", r)
.attr("cx", function(d) { return x(d.date); })
.attr("cy", function(d) { return y(d.sold); })
//Set color based on value-----
.style("fill", d => colorOfDot(d))
.on("mouseover", function(d) {
d3.select(this)
.attr("r",r*1.5)
.attr("fill-opacity", fillopac*3); // Change size of marker
tooltip.transition()
.duration(100)
.style("opacity", .9);
tooltip.html(d["Title"]
+ "<br/>" + d["Bechdel_Test_Result"]
+ "<br/> Released: " + d["Release_date"]
+ "<br/> Tickets sold: "+ tipNumberFormat(d["Tickets_sold"]) )
.style("left", (d3.event.pageX + 15) + "px")
.style("top", (d3.event.pageY - 10) + "px");
})
.on("mouseout", function(d) {
d3.select(this).attr("r",r).attr("fill-opacity", fillopac);
tooltip.transition()
.duration(500)
.style("opacity", 0);
})
;}
function listenForHover(selection, data){
selection
.on("mouseover", function (d){
hoveredColorValue = d;
render(data);
})
.on("mouseout", function (d){
hoveredColorValue = null;
render(data);
})
.style("cursor", "pointer");
}
function setOverlayTransparency(alpha){
overlayRect
.transition().duration(400)
.attr("fill", "rgba(255, 255, 255, " + alpha + ")");
}
function colorOfDot(d) {
if (d.result == 'Pass'){return "green";}
else if (d.result == 'Fail'){return "red";}
else {return "black";}
}
//---------------------------------------------------------
//Axis-----------------------------------------------------
//---------------------------------------------------------
// Add the X Axis
g.append("g")
.attr("class", "x axis")
.attr("transform", "translate(0," + height + ")")
.call(xAxis);
// Add the Y Axis
g.append("g")
.attr("class", "y axis")
.call(yAxis);
d3.csv("film_data.csv", type, render);
</script>
</body>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment