Skip to content

Instantly share code, notes, and snippets.

@christianp

christianp/oscars.ipynb

Created June 26, 2017 07:37
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 christianp/c292680be3dc9c8ed7e7bf2c78f53bf3 to your computer and use it in GitHub Desktop.
Save christianp/c292680be3dc9c8ed7e7bf2c78f53bf3 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
oscars.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 38,
"metadata": {},
"outputs": [],
"source": [
"import csv\n",
"import re\n",
"from collections import defaultdict\n",
"with open(r'h:\\downloads\\academy_awards.csv') as f:\n",
" winners = defaultdict(list)\n",
" r = csv.reader(f)\n",
" for row in r:\n",
" year,category,nominee,additional,won = row[:5]\n",
" if won=='YES':\n",
" if re.match(r'^Act(or|ress)',category):\n",
" m = re.match(r'^([^{]*)',additional)\n",
" if not m:\n",
" film = ''\n",
" else:\n",
" film = m.group(1)\n",
" else:\n",
" film = nominee\n",
" if not re.match(r'^(Scientific|Honorary)',category):\n",
" winners[film].append(row[:4])"
]
},
{
"cell_type": "code",
"execution_count": 39,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"43\n"
]
}
],
"source": [
"good = {k:v for k,v in winners.items() if len(v)>=5 and len(v)<=10}\n",
"print(len(good))"
]
},
{
"cell_type": "code",
"execution_count": 42,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Wilson won 5 awards in 1944 (17th)\n",
"Art Direction\n",
"Cinematography\n",
"Film Editing\n",
"Sound\n",
"Writing\n",
" \n",
"Chicago won 5 awards in 2002 (75th)\n",
"Art Direction\n",
"Costume Design\n",
"Film Editing\n",
"Best Picture\n",
"Sound\n",
" \n",
"Braveheart won 5 awards in 1995 (68th)\n",
"Cinematography\n",
"Directing\n",
"Makeup\n",
"Best Picture\n",
"Sound Editing\n",
" \n",
"Doctor Zhivago won 5 awards in 1965 (38th)\n",
"Art Direction\n",
"Cinematography\n",
"Costume Design\n",
"Music (Scoring)\n",
"Writing\n",
" \n",
"Oliver! won 5 awards in 1968 (41st)\n",
"Art Direction\n",
"Directing\n",
"Music (Scoring)\n",
"Best Picture\n",
"Sound\n",
" \n",
"The Apartment won 5 awards in 1960 (33rd)\n",
"Art Direction\n",
"Directing\n",
"Film Editing\n",
"Best Picture\n",
"Writing\n",
" \n",
"The Sound of Music won 5 awards in 1965 (38th)\n",
"Directing\n",
"Film Editing\n",
"Music (Scoring)\n",
"Best Picture\n",
"Sound\n",
" \n",
"All about Eve won 5 awards in 1950 (23rd)\n",
"Costume Design\n",
"Directing\n",
"Best Picture\n",
"Sound\n",
"Writing\n",
" \n",
"Going My Way won 5 awards in 1944 (17th)\n",
"Directing\n",
"Music (Song)\n",
"Best Picture\n",
"Writing\n",
"Writing\n",
" \n",
"The Best Years of Our Lives won 5 awards in 1946 (19th)\n",
"Directing\n",
"Film Editing\n",
"Music (Scoring)\n",
"Best Picture\n",
"Writing\n",
" \n",
"King Kong won 5 awards in 2005 (78th)\n",
"Sound\n",
"Sound Editing\n",
"Visual Effects\n",
"Visual Effects\n",
"Special Achievement Award\n",
" \n",
"Around the World in 80 Days won 5 awards in 1956 (29th)\n",
"Cinematography\n",
"Film Editing\n",
"Music (Scoring)\n",
"Best Picture\n",
"Writing\n",
" \n",
"Cleopatra won 5 awards in 1963 (36th)\n",
"Art Direction\n",
"Cinematography\n",
"Costume Design\n",
"Visual Effects\n",
"Cinematography\n",
" \n",
"Shakespeare in Love won 5 awards in 1998 (71st)\n",
"Art Direction\n",
"Costume Design\n",
"Music (Scoring)\n",
"Best Picture\n",
"Writing\n",
" \n",
"A Man for All Seasons won 5 awards in 1966 (39th)\n",
"Cinematography\n",
"Costume Design\n",
"Directing\n",
"Best Picture\n",
"Writing\n",
" \n",
"Forrest Gump won 5 awards in 1994 (67th)\n",
"Directing\n",
"Film Editing\n",
"Best Picture\n",
"Visual Effects\n",
"Writing\n",
" \n",
"Saving Private Ryan won 5 awards in 1998 (71st)\n",
"Cinematography\n",
"Directing\n",
"Film Editing\n",
"Sound\n",
"Sound Editing\n",
" \n",
"The Godfather Part II won 5 awards in 1974 (47th)\n",
"Art Direction\n",
"Directing\n",
"Music (Scoring)\n",
"Best Picture\n",
"Writing\n",
" \n",
"On the Waterfront won 6 awards in 1954 (27th)\n",
"Art Direction\n",
"Cinematography\n",
"Directing\n",
"Film Editing\n",
"Best Picture\n",
"Writing\n",
" \n",
"A Place in the Sun won 6 awards in 1951 (24th)\n",
"Cinematography\n",
"Costume Design\n",
"Directing\n",
"Film Editing\n",
"Music (Scoring)\n",
"Writing\n",
" \n",
"Raiders of the Lost Ark won 6 awards in 1981 (54th)\n",
"Art Direction\n",
"Film Editing\n",
"Sound\n",
"Sound Editing\n",
"Visual Effects\n",
"Special Achievement Award\n",
" \n",
"The Hurt Locker won 6 awards in 2009 (82nd)\n",
"Directing\n",
"Film Editing\n",
"Best Picture\n",
"Sound\n",
"Sound Editing\n",
"Writing\n",
" \n",
"Star Wars won 6 awards in 1977 (50th)\n",
"Art Direction\n",
"Costume Design\n",
"Film Editing\n",
"Music (Scoring)\n",
"Sound\n",
"Visual Effects\n",
" \n",
"Patton won 6 awards in 1970 (43rd)\n",
"Art Direction\n",
"Directing\n",
"Film Editing\n",
"Best Picture\n",
"Sound\n",
"Writing\n",
" \n",
"Cabaret won 6 awards in 1972 (45th)\n",
"Art Direction\n",
"Cinematography\n",
"Directing\n",
"Film Editing\n",
"Music (Scoring)\n",
"Sound\n",
" \n",
"Gone with the Wind won 6 awards in 1939 (12th)\n",
"Art Direction\n",
"Cinematography\n",
"Directing\n",
"Film Editing\n",
"Best Picture\n",
"Writing\n",
" \n",
"From Here to Eternity won 6 awards in 1953 (26th)\n",
"Cinematography\n",
"Directing\n",
"Film Editing\n",
"Best Picture\n",
"Sound\n",
"Writing\n",
" \n",
"The Bridge on the River Kwai won 6 awards in 1957 (30th)\n",
"Cinematography\n",
"Directing\n",
"Film Editing\n",
"Music (Scoring)\n",
"Best Picture\n",
"Writing\n",
" \n",
"An American in Paris won 6 awards in 1951 (24th)\n",
"Art Direction\n",
"Cinematography\n",
"Costume Design\n",
"Music (Scoring)\n",
"Best Picture\n",
"Writing\n",
" \n",
"Schindler's List won 7 awards in 1993 (66th)\n",
"Art Direction\n",
"Cinematography\n",
"Directing\n",
"Film Editing\n",
"Music (Scoring)\n",
"Best Picture\n",
"Writing\n",
" \n",
"Out of Africa won 7 awards in 1985 (58th)\n",
"Art Direction\n",
"Cinematography\n",
"Directing\n",
"Music (Scoring)\n",
"Best Picture\n",
"Sound\n",
"Writing\n",
" \n",
"The Sting won 7 awards in 1973 (46th)\n",
"Art Direction\n",
"Costume Design\n",
"Directing\n",
"Film Editing\n",
"Music (Scoring)\n",
"Best Picture\n",
"Writing\n",
" \n",
"Dances With Wolves won 7 awards in 1990 (63rd)\n",
"Cinematography\n",
"Directing\n",
"Film Editing\n",
"Music (Scoring)\n",
"Best Picture\n",
"Sound\n",
"Writing\n",
" \n",
"My Fair Lady won 7 awards in 1964 (37th)\n",
"Art Direction\n",
"Cinematography\n",
"Costume Design\n",
"Directing\n",
"Music (Scoring)\n",
"Best Picture\n",
"Sound\n",
" \n",
"Lawrence of Arabia won 7 awards in 1962 (35th)\n",
"Art Direction\n",
"Cinematography\n",
"Directing\n",
"Film Editing\n",
"Music (Scoring)\n",
"Best Picture\n",
"Sound\n",
" \n",
"Amadeus won 7 awards in 1984 (57th)\n",
"Art Direction\n",
"Costume Design\n",
"Directing\n",
"Makeup\n",
"Best Picture\n",
"Sound\n",
"Writing\n",
" \n",
"Gandhi won 7 awards in 1982 (55th)\n",
"Art Direction\n",
"Cinematography\n",
"Costume Design\n",
"Directing\n",
"Film Editing\n",
"Best Picture\n",
"Writing\n",
" \n",
"West Side Story won 8 awards in 1961 (34th)\n",
"Art Direction\n",
"Cinematography\n",
"Costume Design\n",
"Directing\n",
"Film Editing\n",
"Music (Scoring)\n",
"Best Picture\n",
"Sound\n",
" \n",
"Slumdog Millionaire won 8 awards in 2008 (81st)\n",
"Cinematography\n",
"Directing\n",
"Film Editing\n",
"Music (Scoring)\n",
"Music (Song)\n",
"Best Picture\n",
"Sound\n",
"Writing\n",
" \n",
"The English Patient won 8 awards in 1996 (69th)\n",
"Art Direction\n",
"Cinematography\n",
"Costume Design\n",
"Directing\n",
"Film Editing\n",
"Music (Scoring)\n",
"Best Picture\n",
"Sound\n",
" \n",
"Gigi won 9 awards in 1958 (31st)\n",
"Art Direction\n",
"Cinematography\n",
"Costume Design\n",
"Directing\n",
"Film Editing\n",
"Music (Scoring)\n",
"Music (Song)\n",
"Best Picture\n",
"Writing\n",
" \n",
"The Last Emperor won 9 awards in 1987 (60th)\n",
"Art Direction\n",
"Cinematography\n",
"Costume Design\n",
"Directing\n",
"Film Editing\n",
"Music (Scoring)\n",
"Best Picture\n",
"Sound\n",
"Writing\n",
" \n",
"Ben-Hur won 9 awards in 1959 (32nd)\n",
"Art Direction\n",
"Cinematography\n",
"Costume Design\n",
"Directing\n",
"Film Editing\n",
"Music (Scoring)\n",
"Best Picture\n",
"Sound\n",
"Special Effects (archaic category)\n",
" \n"
]
}
],
"source": [
"for film,awards in sorted(good.items(),key=lambda x:len(x[1])):\n",
" print('{} won {} awards in {}'.format(film, len(awards), awards[0][0]))\n",
" for year,category,nominee,additional in awards:\n",
" print(category)\n",
" print(' ')"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.5.0"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment