Skip to content

Instantly share code, notes, and snippets.

@zachwill

zachwill/_Pareto IMDB for The Office.ipynb

Last active April 28, 2020 20:14
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 zachwill/34bd94cd97a9136f81fcb4fda5531b57 to your computer and use it in GitHub Desktop.
Save zachwill/34bd94cd97a9136f81fcb4fda5531b57 to your computer and use it in GitHub Desktop.
Download ZIP
Pareto IMDB for The Office.ipynb
Display the source blob
Display the rendered blob
Raw
_Pareto IMDB for The Office.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Raw
imdb_office.csv
Trend Season Episode Title Year Votes Rating
50 1 1 Pilot 2005 4,635 7.5
46 1 2 Diversity Day 2005 4,497 8.3
43 1 3 Health Care 2005 3,787 7.8
44 1 4 The Alliance 2005 3,680 8.1
49 1 5 Basketball 2005 4,021 8.4
45 1 6 Hot Girl 2005 3,612 7.8
52 2 1 The Dundies 2005 4,050 8.7
43 2 2 Sexual Harassment 2005 3,437 8.2
39 2 3 Office Olympics 2005 3,436 8.4
41 2 4 The Fire 2005 3,388 8.4
42 2 5 Halloween 2005 3,190 8.1
44 2 6 The Fight 2005 3,178 8.2
42 2 7 The Client 2005 3,307 8.6
38 2 8 Performance Review 2005 3,011 8.2
35 2 9 E-Mail Surveillance 2005 3,126 8.4
36 2 10 Christmas Party 2005 3,413 8.9
42 2 11 Booze Cruise 2006 3,313 8.6
44 2 12 The Injury 2006 4,026 9.1
31 2 13 The Secret 2006 2,935 8.3
30 2 14 The Carpet 2006 2,918 7.8
31 2 15 Boys and Girls 2006 2,896 8.2
34 2 16 Valentine's Day 2006 2,906 8.3
36 2 17 Dwight's Speech 2006 3,068 8.5
35 2 18 Take Your Daughter to Work Day 2006 2,991 8.3
31 2 19 Michael's Birthday 2006 2,882 8.1
29 2 20 Drug Testing 2006 2,952 8.4
40 2 21 Conflict Resolution 2006 3,020 8.7
47 2 22 Casino Night 2006 4,432 9.4
46 3 1 Gay Witch Hunt 2006 3,825 9
34 3 2 The Convention 2006 2,827 8.2
32 3 3 The Coup 2006 2,957 8.6
31 3 4 Grief Counseling 2006 2,850 8
27 3 5 Initiation 2006 2,772 8.1
30 3 6 Diwali 2006 2,864 7.9
29 3 7 Branch Closing 2006 2,808 8.6
31 3 8 The Merger 2006 2,945 8.7
26 3 9 The Convict 2006 2,936 8.3
29 3 10 A Benihana Christmas 2006 3,112 8.8
29 3 11 Back from Vacation 2007 2,795 8.5
29 3 12 Traveling Salesmen 2007 2,856 8.6
30 3 13 The Return 2007 3,002 8.8
28 3 14 Ben Franklin 2007 2,779 8.1
32 3 15 Phyllis' Wedding 2007 2,809 8.2
38 3 16 Business School 2007 3,218 8.9
32 3 17 Cocktails 2007 2,792 8.5
32 3 18 The Negotiation 2007 3,152 9
32 3 19 Safety Training 2007 2,965 8.8
29 3 20 Product Recall 2007 2,950 8.7
33 3 21 Women's Appreciation 2007 2,960 8.8
33 3 22 Beach Games 2007 3,391 9.2
35 3 23 The Job 2007 3,656 9.3
30 4 1 Fun Run 2007 3,430 8.8
24 4 2 Dunder Mifflin Infinity 2007 2,751 8.3
23 4 3 Launch Party 2007 2,665 8.5
28 4 4 Money 2007 2,870 8.7
24 4 5 Local Ad 2007 2,930 8.8
21 4 6 Branch Wars 2007 2,696 8.5
24 4 7 Survivor Man 2007 2,601 8.2
22 4 8 The Deposition 2007 2,729 8.7
66 4 9 Dinner Party 2008 5,155 9.5
22 4 10 Chair Model 2008 2,579 8
27 4 11 Night Out 2008 2,680 8.6
26 4 12 Did I Stutter? 2008 2,580 8.3
24 4 13 Job Fair 2008 2,445 7.8
33 4 14 Goodbye, Toby 2008 3,658 9.3
34 5 1 Weight Loss 2008 3,051 8.8
29 5 2 Business Ethics 2008 2,478 8.3
29 5 3 Baby Shower 2008 2,445 8
28 5 4 Crime Aid 2008 2,360 8.1
31 5 5 Employee Transfer 2008 2,433 8.1
33 5 6 Customer Survey 2008 2,526 8.5
34 5 7 Business Trip 2008 2,347 8.2
35 5 8 Frame Toby 2008 2,607 8.6
32 5 9 The Surplus 2008 2,588 8.8
31 5 10 Moroccan Christmas 2008 2,444 8.4
31 5 11 The Duel 2009 2,530 8.7
26 5 12 Prince Family Paper 2009 2,437 8
91 5 13 Stress Relief 2009 7,513 9.7
26 5 14 Lecture Circuit: Part 1 2009 2,311 8.2
24 5 15 Lecture Circuit: Part 2 2009 2,273 8.2
26 5 16 Blood Drive 2009 2,302 8
26 5 17 Golden Ticket 2009 2,480 8.7
26 5 18 New Boss 2009 2,339 8.3
24 5 19 Two Weeks 2009 2,322 8.4
27 5 20 Dream Team 2009 2,324 8.3
27 5 21 Michael Scott Paper Company 2009 2,537 8.7
25 5 22 Heavy Competition 2009 2,397 8.7
34 5 23 Broke 2009 3,143 9.2
22 5 24 Casual Friday 2009 2,299 8.3
25 5 25 Cafe Disco 2009 2,611 8.7
28 5 26 Company Picnic 2009 2,734 9
28 6 1 Gossip 2009 2,663 8.8
22 6 2 The Meeting 2009 2,190 8.1
23 6 3 The Promotion 2009 2,182 8
33 6 4 Niagara: Part 1 2009 4,256 9.4
36 6 5 Niagara: Part 2 2009 2,749 9.4
22 6 6 Mafia 2009 2,287 7.6
26 6 7 The Lover 2009 2,407 8.6
25 6 8 Koi Pond 2009 2,181 8.2
22 6 9 Double Date 2009 2,149 8.1
33 6 10 Murder 2009 2,547 8.7
25 6 11 Shareholder Meeting 2009 2,164 8.2
32 6 12 Scott's Tots 2009 2,485 8.3
24 6 13 Secret Santa 2009 2,286 8.5
26 6 14 The Banker 2010 2,807 6.8
25 6 15 Sabre 2010 2,081 7.7
24 6 16 Manager and Salesman 2010 2,061 8.1
26 6 17 The Delivery: Part 1 2010 2,175 8.4
28 6 18 The Delivery: Part 2 2010 2,191 8.5
25 6 19 St. Patrick's Day 2010 2,037 7.7
25 6 20 New Leads 2010 1,996 7.8
30 6 21 Happy Hour 2010 2,327 8.6
26 6 22 Secretary's Day 2010 2,006 7.8
28 6 23 Body Language 2010 2,040 8
30 6 24 The Cover-Up 2010 2,038 8.2
27 6 25 The Chump 2010 1,961 7.8
25 6 26 Whistleblower 2010 2,021 8
26 7 1 Nepotism 2010 2,339 8.4
25 7 2 Counseling 2010 2,103 8.2
22 7 3 Andy's Play 2010 2,233 8.2
22 7 4 Sex Ed 2010 2,043 7.9
21 7 5 The Sting 2010 1,991 7.8
23 7 6 Costume Contest 2010 2,075 8.2
23 7 7 Christening 2010 2,069 7.4
21 7 8 Viewing Party 2010 2,030 7.9
25 7 9 WUPHF.com 2010 1,974 7.7
24 7 10 China 2010 2,068 8.2
21 7 11 Classy Christmas 2010 2,637 9
21 7 12 Ultimatum 2011 2,106 8.3
22 7 13 The Seminar 2011 2,004 7.7
24 7 14 The Search 2011 2,180 8.5
27 7 15 PDA 2011 2,162 8.4
44 7 16 Threat Level Midnight 2011 4,463 9.4
19 7 17 Todd Packer 2011 1,968 7.5
34 7 18 Garage Sale 2011 3,392 9.3
23 7 19 Training Day 2011 2,052 7.8
32 7 20 Michael's Last Dundies 2011 2,762 9
93 7 21 Goodbye, Michael 2011 7,354 9.8
26 7 22 The Inner Circle 2011 2,018 7.6
28 7 23 Dwight K. Schrute, (Acting) Manager 2011 2,239 8.7
27 7 24 Search Committee 2011 2,440 8.8
29 8 1 The List 2011 2,198 8.1
25 8 2 The Incentive 2011 2,034 8.1
21 8 3 Lotto 2011 1,941 7.3
21 8 4 Garden Party 2011 2,090 8.1
21 8 5 Spooked 2011 1,877 7.6
19 8 6 Doomsday 2011 1,798 7.7
22 8 7 Pam's Replacement 2011 1,919 7.7
18 8 8 Gettysburg 2011 1,929 6.9
16 8 9 Mrs. California 2011 1,893 7.7
16 8 10 Christmas Wishes 2011 1,871 8
17 8 11 Trivia 2012 1,825 7.9
20 8 12 Pool Party 2012 1,978 8
17 8 13 Jury Duty 2012 1,791 7.4
18 8 14 Special Project 2012 1,747 7.7
18 8 15 Tallahassee 2012 1,853 7.8
19 8 16 After Hours 2012 1,910 8.1
20 8 17 Test the Store 2012 1,806 7.8
20 8 18 Last Day in Florida 2012 1,760 7.8
23 8 19 Get the Girl 2012 2,038 6.6
19 8 20 Welcome Party 2012 1,822 7.1
19 8 21 Angry Andy 2012 1,936 7.1
16 8 22 Fundraiser 2012 1,762 7
13 8 23 Turf War 2012 1,696 7.6
13 8 24 Free Family Portrait Studio 2012 1,773 7.7
16 9 1 New Guys 2012 1,919 7.6
15 9 2 Roy's Wedding 2012 1,807 7.1
13 9 3 Andy's Ancestry 2012 1,782 7.4
13 9 4 Work Bus 2012 1,887 7.8
13 9 5 Here Comes Treble 2012 1,858 7
15 9 6 The Boat 2012 1,801 7.7
13 9 7 The Whale 2012 1,728 7.6
14 9 8 The Target 2012 1,775 7.8
16 9 9 Dwight Christmas 2012 2,014 8.4
12 9 10 Lice 2013 1,801 7.6
11 9 11 Suit Warehouse 2013 1,771 7.9
11 9 12 Customer Loyalty 2013 1,827 8
13 9 13 Junior Salesman 2013 1,722 7.6
13 9 14 Vandalism 2013 1,718 7.5
11 9 15 Couples Discount 2013 1,734 7.3
13 9 16 Moving On 2013 1,925 8.1
15 9 17 The Farm 2013 2,018 7.5
13 9 18 Promos 2013 1,777 8
15 9 19 Stairmageddon 2013 1,829 8
14 9 20 Paper Airplane 2013 1,839 8
25 9 21 Livin' the Dream 2013 2,581 9
33 9 22 A.A.R.M. 2013 3,586 9.5
97 9 23 Finale 2013 9,746 9.8
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment