目录
一。pandas与numpy
numpy能够帮助我们处理数值,但是pandas除了处理数值之外(基于numpy),还能够帮助我们处理其他类型的数据。
二。pandas常用数据类型
1.Series 一维,带标签数组
2.DataFrame 二维,Series容器
三。pandas之series的创建
import string
import pandas as pd
t=pd.Series([1,2,31,12,3,4])
print(t)
print(type(t))
t2=pd.Series([1,23,2,2,1],index=list("abcde")).astype(float)
print(t2)
temp_dict={"name":"小红","age":30,"tel":10086}#通过字典创建
t3=pd.Series(temp_dict)
print(t3)
a={string.ascii_uppercase[i]:i for i in range(10)}
t4=pd.Series(a)
t5=pd.Series(a,index=list(string.ascii_uppercase[5:15]))
print(t4)
print(t5)
print(t3["name"])
print(t3[0])
print(t3[:2])
print(t3[:3])#取连续多行
print(t3[[0,2]])#取不连续多行
print(t3[["age","tel"]])
print(t3[["age","tel"]])
print(t3.index)
print(t3.values)
print(len(t3.index))
/Users/lichengxiang/opt/anaconda3/bin/python /Users/lichengxiang/Desktop/python/数据分析/pandas之series创建.py
0 1
1 2
2 31
3 12
4 3
5 4
dtype: int64
<class 'pandas.core.series.Series'>
a 1.0
b 23.0
c 2.0
d 2.0
e 1.0
dtype: float64
name 小红
age 30
tel 10086
dtype: object
A 0
B 1
C 2
D 3
E 4
F 5
G 6
H 7
I 8
J 9
dtype: int64
F 5.0
G 6.0
H 7.0
I 8.0
J 9.0
K NaN
L NaN
M NaN
N NaN
O NaN
dtype: float64
小红
小红
name 小红
age 30
dtype: object
name 小红
age 30
tel 10086
dtype: object
name 小红
tel 10086
dtype: object
age 30
tel 10086
dtype: object
age 30
tel 10086
dtype: object
Index(['name', 'age', 'tel'], dtype='object')
['小红' 30 10086]
3
进程已结束,退出代码0
四。pandas之dataframe创建
import numpy as np
import pandas as pd
t=pd.DataFrame(np.arange(12).reshape(3,4),index=list("abc"),columns=list("WXYZ"))
print(t)
d1={"name":["xiaoming","xiaohong"],"age":[20,32],"tel":[10086,10010]}
t1=pd.DataFrame(d1)
print(t1)
d2=[{"name":"xiaohong","age":32,"tel":10010},{"name":"xiaogang","tel":10000},{"name":"xiaowang","age":22}]
t2=pd.DataFrame(d2)
print(t2)
print(t2.index)
print(t2.columns)
print(t2.shape)
print(t2.dtypes)
print(t2.ndim)#ndim说明其是几维的
/Users/lichengxiang/opt/anaconda3/bin/python /Users/lichengxiang/Desktop/python/数据分析/pandas之dataframe创建.py
W X Y Z
a 0 1 2 3
b 4 5 6 7
c 8 9 10 11
name age tel
0 xiaoming 20 10086
1 xiaohong 32 10010
name age tel
0 xiaohong 32.0 10010.0
1 xiaogang NaN 10000.0
2 xiaowang 22.0 NaN
RangeIndex(start=0, stop=3, step=1)
Index(['name', 'age', 'tel'], dtype='object')
(3, 3)
name object
age float64
tel float64
dtype: object
2
进程已结束,退出代码0
五。pandas读取csv与排序,索引
import numpy as np
import pandas as pd
df=pd.read_csv("./dogNames2.csv")
print(df.head(5))
print(df.info())
df=df.sort_values(by="Count_AnimalName",ascending=False)#ascending参数:指定升序还是降序,默认为True表示升序,设置为False表示降序
print(df)
# print(df.head(5))
print(df[:20])#取前20行 方括号写数字取行,写字符串取列
print(df[:20]["Row_Labels"])
print("*"*50)
print(df[19:20]["Row_Labels"])
print(df["Row_Labels"][4])#这里的4指的是index值为4,不是第四行
print(type(df[:20]["Row_Labels"]))
print(type(df[:20]))
t3=pd.DataFrame(np.arange(12).reshape(3,4),index=list("abc"),columns=list("WXYZ"))
print(t3)
print(t3.loc["a","Z"])#loc中的参数是index和columns
print(type(t3.loc["a","Z"]))
print(t3.loc["a"])
print(t3.loc[:,"Y"])
print(t3.loc[["a","c"]])
print(t3.loc[["a","c"],["W","Z"]])
print(t3.loc["a":"c",["W","Z"]])
print(t3)
print(t3.iloc[1])#iloc的参数是第几行(从0开始),第几列
print(t3.iloc[:,[2,1]])
print(t3.iloc[[0,2],[2,1]])
print(t3.iloc[1:,:2])
t3.iloc[1:,:2]=30
print(t3)
t3.iloc[1:,:2]=np.nan#DataFrame里自动转换成浮点型
print(t3)
/Users/lichengxiang/opt/anaconda3/bin/python /Users/lichengxiang/Desktop/python/数据分析/pandas读取csv与排序.索引.py
Row_Labels Count_AnimalName
0 1 1
1 2 2
2 40804 1
3 90201 1
4 90203 1
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 16220 entries, 0 to 16219
Data columns (total 2 columns):
# Column Non-Null Count Dtype
--- ------ -------------- -----
0 Row_Labels 16217 non-null object
1 Count_AnimalName 16220 non-null int64
dtypes: int64(1), object(1)
memory usage: 253.6+ KB
None
Row_Labels Count_AnimalName
1156 BELLA 1195
9140 MAX 1153
2660 CHARLIE 856
3251 COCO 852
12368 ROCKY 823
... ... ...
6884 J-LO 1
6888 JOANN 1
6890 JOAO 1
6891 JOAQUIN 1
16219 39743 1
[16220 rows x 2 columns]
Row_Labels Count_AnimalName
1156 BELLA 1195
9140 MAX 1153
2660 CHARLIE 856
3251 COCO 852
12368 ROCKY 823
8417 LOLA 795
8552 LUCKY 723
8560 LUCY 710
2032 BUDDY 677
3641 DAISY 649
11703 PRINCESS 603
829 BAILEY 532
9766 MOLLY 519
14466 TEDDY 485
2913 CHLOE 465
14779 TOBY 446
8620 LUNA 432
6515 JACK 425
8788 MAGGIE 393
13762 SOPHIE 383
1156 BELLA
9140 MAX
2660 CHARLIE
3251 COCO
12368 ROCKY
8417 LOLA
8552 LUCKY
8560 LUCY
2032 BUDDY
3641 DAISY
11703 PRINCESS
829 BAILEY
9766 MOLLY
14466 TEDDY
2913 CHLOE
14779 TOBY
8620 LUNA
6515 JACK
8788 MAGGIE
13762 SOPHIE
Name: Row_Labels, dtype: object
**************************************************
13762 SOPHIE
Name: Row_Labels, dtype: object
90203
<class 'pandas.core.series.Series'>
<class 'pandas.core.frame.DataFrame'>
W X Y Z
a 0 1 2 3
b 4 5 6 7
c 8 9 10 11
3
<class 'numpy.int64'>
W 0
X 1
Y 2
Z 3
Name: a, dtype: int64
a 2
b 6
c 10
Name: Y, dtype: int64
W X Y Z
a 0 1 2 3
c 8 9 10 11
W Z
a 0 3
c 8 11
W Z
a 0 3
b 4 7
c 8 11
W X Y Z
a 0 1 2 3
b 4 5 6 7
c 8 9 10 11
W 4
X 5
Y 6
Z 7
Name: b, dtype: int64
Y X
a 2 1
b 6 5
c 10 9
Y X
a 2 1
c 10 9
W X
b 4 5
c 8 9
W X Y Z
a 0 1 2 3
b 30 30 6 7
c 30 30 10 11
W X Y Z
a 0.0 1.0 2 3
b NaN NaN 6 7
c NaN NaN 10 11
进程已结束,退出代码0
六。pandas常用统计方法
import numpy as np
import pandas as pd
file_path="./IMDB-Movie-Data.csv"
df=pd.read_csv(file_path)
print(df.info())
print(df.head(1))
print(df["Rating"].mean())
print("*"*50)
print(df["Director"])
print(df["Director"].tolist())#把series类型转化为列表类型
print(set(df["Director"].tolist()))#set将列表转化为集合,且去掉重复的项
print(len(set(df["Director"].tolist())))
print("*"*50)
print(len(df["Director"].unique()))
temp_actors_list=df["Actors"].str.split(",").tolist()
# actors_list=[i for j in temp_actors_list for i in j]
print(df["Actors"])
print(df["Actors"].str.split(","))
print(temp_actors_list)
t=np.array([1,2,3])
print(t)#ndarray类型
print(type(t))
print(t.tolist())
print(list(t))
/Users/lichengxiang/opt/anaconda3/bin/python /Users/lichengxiang/Desktop/python/数据分析/pandas的常用统计方法.py
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 1000 entries, 0 to 999
Data columns (total 12 columns):
# Column Non-Null Count Dtype
--- ------ -------------- -----
0 Rank 1000 non-null int64
1 Title 1000 non-null object
2 Genre 1000 non-null object
3 Description 1000 non-null object
4 Director 1000 non-null object
5 Actors 1000 non-null object
6 Year 1000 non-null int64
7 Runtime (Minutes) 1000 non-null int64
8 Rating 1000 non-null float64
9 Votes 1000 non-null int64
10 Revenue (Millions) 872 non-null float64
11 Metascore 936 non-null float64
dtypes: float64(3), int64(4), object(5)
memory usage: 93.9+ KB
None
Rank Title ... Revenue (Millions) Metascore
0 1 Guardians of the Galaxy ... 333.13 76.0
[1 rows x 12 columns]
6.723200000000003
**************************************************
0 James Gunn
1 Ridley Scott
2 M. Night Shyamalan
3 Christophe Lourdelet
4 David Ayer
...
995 Billy Ray
996 Eli Roth
997 Jon M. Chu
998 Scot Armstrong
999 Barry Sonnenfeld
Name: Director, Length: 1000, dtype: object
['James Gunn', 'Ridley Scott', 'M. Night Shyamalan', 'Christophe Lourdelet', 'David Ayer', 'Yimou Zhang', 'Damien Chazelle', 'Sean Foley', 'James Gray', 'Morten Tyldum', 'David Yates', 'Theodore Melfi', 'Gareth Edwards', 'Ron Clements', 'Nacho Vigalondo', 'Chris Renaud', 'Mel Gibson', 'Paul Greengrass', 'Garth Davis', 'Denis Villeneuve', 'Stephen Gaghan', 'Kenneth Lonergan', 'Ben Young', 'Walt Dohrn', 'Roland Emmerich', 'Dominique Abel', 'S.S. Rajamouli', 'Phillip Guzman', 'Jon Lucas', 'Justin Kurzel', 'John Hamburg', 'Tom Ford', 'Bryan Singer', 'Tim Miller', 'Paul W.S. Anderson', 'Anthony Russo', 'Christopher Nolan', 'Scott Derrickson', 'Antoine Fuqua', 'Patrick Read Johnson', 'Greg Tiernan', 'Barry Jenkins', 'Shawn Burkett', 'John Lee Hancock', 'Ricardo de Montreuil', 'Rob Marshall', 'John Madden', 'Scott Hicks', 'Justin Lin', 'Sean Penn', 'J.J. Abrams', 'Anna Foerster', 'Garry Marshall', 'Chad Stahelski', 'Christopher Nolan', 'Martin Scorsese', 'Fede Alvarez', 'Thea Sharrock', 'Lone Scherfig', 'Clint Eastwood', 'Zack Snyder', 'André Øvredal', 'Tate Taylor', 'Sam Taylor-Johnson', 'Christopher Nolan', 'Matthew Vaughn', 'Peter Berg', 'George Miller', 'Robin Swicord', 'Peter Berg', 'Terry George', 'Robert Zemeckis', 'J.A. Bayona', 'David Frankel', 'Byron Howard', 'Gore Verbinski', 'Joss Whedon', 'Quentin Tarantino', 'Gore Verbinski', 'Paul Feig', 'Christopher Nolan', 'Matt Ross', 'Martin Scorsese', 'David Fincher', 'James Wan', 'Colin Trevorrow', 'Ben Affleck', 'James Cameron', 'Quentin Tarantino', "Gavin O'Connor", 'Denis Villeneuve', 'Duncan Jones', 'Tate Taylor', 'Todd Phillips', 'Joss Whedon', 'Shane Black', 'Makoto Shinkai', 'Jeremy Gillespie', 'Olivier Assayas', 'Martin Scorsese', 'Brian Helgeland', 'Kenneth Branagh', 'Ridley Scott', 'Oriol Paulo', 'Guy Ritchie', 'David Mackenzie', 'Taylor Hackford', 'David Yates', 'Katie Holmes', 'Alex Garland', 'Greg McLean', 'Steve McQueen', 'Ana Lily Amirpour', 'Zack Snyder', 'David Yates', 'Josh Gordon', 'Nicolas Winding Refn', 'Nitesh Tiwari', 'Dan Trachtenberg', 'Andrew Stanton', 'Tim Burton', 'Neil Burger', 'Jake Szymanski', 'Todor Chapkanov', 'Christopher Nolan', 'Jon Favreau', 'Michael Bay', 'Henry Joost', 'Phyllida Lloyd', 'Alejandro González Iñárritu', 'Denzel Washington', 'Rob Marshall', 'Jaume Collet-Serra', 'Damien Chazelle', 'Justin Lin', 'Derek Cianfrance', 'Ethan Coen', 'Baz Luhrmann', 'Martin Scorsese', 'Martin Koolhoven', 'J.J. Abrams', 'Thor Freudenthal', 'Adam McKay', 'Lenny Abrahamson', 'Quentin Tarantino', 'Chan-wook Park', 'Kelly Fremon Craig', 'Zack Snyder', 'Greg Mottola', 'Ron Howard', 'Steven Spielberg', 'Gary Ross', 'Elizabeth Wood', 'Denis Villeneuve', 'David Lynch', 'Colin Strause', 'Guillermo del Toro', 'Glenn Ficarra', 'Edgar Wright', 'Edgar Wright', 'Fabio Guaglione', 'Ben Wheatley', 'Bryan Singer', 'Edward Zwick', 'Martin Campbell', 'Catherine Hardwicke', 'Jon M. Chu', 'Simon Curtis', 'Michael Bay', 'Sam Mendes', 'Dan Gilroy', 'Travis Knight', 'Jackson Stewart', 'Spike Jonze', 'Chris Buck', 'Brad Bird', 'Matt Reeves', 'Ben Stiller', 'James Wan', 'Peyton Reed', 'Sharon Maguire', 'Robert Eggers', 'Kenneth Branagh', 'Mateo Gil', 'Asghar Farhadi', 'Gaspar Noé', 'Ang Lee', 'Guillermo del Toro', 'Nicolas Winding Refn', 'Judd Apatow', 'Derek Cianfrance', 'April Mullen', 'Tom McCarthy', 'Luke Scott', "Gavin O'Connor", 'Joe Johnston', 'Akan Satayev', 'Sean Penn', 'Morten Tyldum', 'Rawson Marshall Thurber', 'Doug Liman', 'Gore Verbinski', 'Oliver Stone', 'Jon Favreau', 'Robert Schwentke', 'Matthew Vaughn', 'Julia Ducournau', 'Jim Jarmusch', 'Paul Feig', 'Colm McCarthy', 'Brad Peyton', 'Harmony Korine', 'Michael Bay', 'Spike Lee', 'Alan Taylor', 'Alex Proyas', 'Anthony Russo', 'Chris Wedge', 'Liam Gavin', 'Matthew Vaughn', 'Ilya Naishuller', 'John Lasseter', 'David Robert Mitchell', 'David Fincher', 'Rawson Marshall Thurber', 'Andrea Arnold', 'Yorgos Lanthimos', 'Nimród Antal', 'Robert Stromberg', 'Steven Shainberg', 'Guillermo del Toro', 'Andy Goddard', 'Mel Gibson', 'Christopher McQuarrie', 'Cedric Nicolas-Troyan', 'Stephen Chbosky', 'Pablo Larraín', 'D.J. Caruso', 'Wes Anderson', 'Andrew Niccol', 'David Ayer', 'Pete Docter', 'Ash Brannon', 'Alan Taylor', 'Chris Columbus', 'Tom Hooper', 'Alfonso Cuarón', 'Mike Mills', 'Paul Feig', 'Olivier Nakache', 'Eleanor Coppola', 'Yorgos Lanthimos', 'F. Gary Gray', 'Marc Webb', 'James Wan', 'Todd Phillips', 'Peter Berg', 'Rupert Wyatt', 'David F. Sandberg', 'Joseph Cedar', 'Alejandro González Iñárritu', 'Darren Aronofsky', 'Justin Simien', 'Lars von Trier', 'Dave Green', 'Eli Roth', 'Dan Mazer', 'Tom Tykwer', 'Gavin Hood', 'Jeffrey G. Hunt', 'Sam Mendes', 'Peter Jackson', 'Phil Lord', 'John Carney', 'Eric Summer', 'Joseph Kosinski', 'Phil Lord', 'David Fincher', 'Richard Linklater', 'Shane Black', 'Louis Leterrier', 'Guy Ritchie', 'Quentin Tarantino', 'Tom Hooper', 'Brett Ratner', 'Zack Snyder', 'Greg Mottola', 'Lana Wachowski', 'Jared Hess', 'Jalil Lespert', 'Sang-ho Yeon', 'Jason Moore', 'Nicholas Stoller', 'David Leveaux', 'Zack Snyder', 'Ross Katz', 'Mike Thurmeier', 'David Frankel', 'Brad Furman', 'Paul Thomas Anderson', 'Antoine Fuqua', 'Peter Berg', 'Drew Goddard', 'Fred Wolf', 'Jim Field Smith', 'Paul Thomas Anderson', 'James Bobin', 'Gary Michael Schultz', 'Justin Lin', 'Christian Ditter', 'John Lee Hancock', 'Abdellatif Kechiche', 'Jennifer Kent', 'Peter Jackson', 'David Yates', 'Bong Joon Ho', 'J Blakeson', 'Dan Berk', 'M. Night Shyamalan', 'Justin Lin', 'Anne Fletcher', 'So Yong Kim', 'Guy Ritchie', 'Andrew Niccol', 'David Fincher', 'Breck Eisner', 'Paul McGuigan', 'Roger Spottiswoode', 'Jeremy Saulnier', 'Michael Mann', 'Nicholas Stoller', 'Clint Eastwood', 'Jean-Marc Vallée', 'Steven Spielberg', 'Ron Howard', 'Mike Flanagan', 'David O. Russell', 'Alexi Pappas', 'Josh Boone', 'Frank Coraci', 'Justin Lin', 'Rian Johnson', 'Roland Emmerich', 'David Lowery', 'Sam Raimi', 'Paul W.S. Anderson', 'Matthew Vaughn', 'David O. Russell', 'Karyn Kusama', 'Woody Allen', 'William Oldroyd', 'David O. Russell', 'Jocelyn Moorhouse', 'Woody Allen', 'Robert Schwentke', 'Sergei Bodrov', 'Hugo Gélin', 'James Marsh', 'Evan Goldberg', 'Richard Curtis', 'Adam McKay', 'Jon Watts', 'J.J. Abrams', 'Ruben Fleischer', 'Ethan Coen', 'Danny Boyle', 'Bill Condon', 'Alex Ranarivelo', 'Marc Webb', 'Timur Bekmambetov', 'J.D. Dillard', 'Wes Ball', 'Ariel Vromen', 'Timur Bekmambetov', 'Stephen Frears', 'Eran Creevy', 'Scott Cooper', 'Ryan Coogler', 'Dan Kwan', 'Patrick Hughes', 'Jemaine Clement', 'Antoine Fuqua', 'Mike Flanagan', 'Steven Spielberg', 'Phil Lord', 'Baltasar Kormákur', 'Chris Columbus', 'Ridley Scott', 'James Mangold', 'Andrew Stanton', 'Peter Atencio', 'Pierre Morel', 'Danny Boyle', 'Gillies MacKinnon', 'Dennis Dugan', 'Lee Toland Krieger', 'Louis Leterrier', 'Peter Billingsley', 'Terry Jones', 'Steven Soderbergh', 'Kyle Balda', 'Rolfe Kanefsky', 'Nicolas Winding Refn', 'Pierre Coffin', 'Michael Hoffman', 'Karyn Kusama', 'Kathryn Bigelow', 'Nathan Greno', 'Francis Lawrence', 'John Francis Daley', 'Pierre Morel', 'Elizabeth Banks', 'Dan Scanlon', 'Paul Verhoeven', 'Dennis Gansel', 'Kevin Smith', 'Mark Williams', 'Joe Wright', 'David Yates', 'Steve McQueen', 'Joe Wright', 'David Ross', 'Burr Steers', 'Noam Murro', 'Babak Najafi', 'David Fincher', 'Frank Miller', 'Paul Greengrass', 'Srdjan Spasojevic', 'James DeMonaco', 'Rajkumar Hirani', 'Ben Stiller', 'Marc Forster', 'Brad Bird', 'Corey Asraf', 'Jon S. Baird', 'George Tillman Jr.', 'J.A. Bayona', 'Jeff Wadlow', 'Jeff Grace', 'Sam Raimi', 'John Crowley', 'Henry Selick', 'Derek Cianfrance', 'Michael J. Gallagher', 'Christophe Gans', 'Pete Travis', 'Taika Waititi', 'Don Hall', 'Kimberly Peirce', 'Jon Favreau', 'Jean-Marc Vallée', 'Christian Alvart', 'Antoine Fuqua', 'D.J. Caruso', 'Thomas Vinterberg', 'Anne Fletcher', 'Etan Cohen', 'Dennis Dugan', 'Sam Mendes', 'Ben Affleck', 'William Brent Bell', 'Mick Jackson', 'Michael Spierig', 'Rob Letterman', 'Guy Ritchie', 'Phillip Noyce', 'Denis Villeneuve', 'Neill Blomkamp', 'Adam McKay', 'Ridley Scott', 'Sofia Coppola', 'Roland Emmerich', 'David Yates', 'Ben Affleck', 'Dexter Fletcher', 'Florian Henckel von Donnersmarck', 'Carles Torrens', 'Amber Tamblyn', 'Justin Kurzel', 'Nicholas Stoller', 'Phillip Noyce', 'John Hillcoat', 'Paolo Genovese', 'Clay Kaytis', 'Wes Anderson', 'Adam Shankman', 'Lasse Hallström', 'Glenn Ficarra', 'Brad Bird', 'Jim Mickle', 'Albert Hughes', 'Matt Reeves', 'Ericson Core', 'Jonathan Glazer', 'Francis Lawrence', 'Barry Sonnenfeld', 'J.J. Abrams', 'F. Gary Gray', 'Pete Docter', 'Wes Ball', 'Todd Haynes', 'Daniel Ragussis', 'Paolo Sorrentino', 'Jaco Van Dormael', 'Pete Travis', 'Oliver Stone', 'Marc Webb', 'Elizabeth Banks', 'Alfonso Cuarón', 'Mark Herman', 'Antoine Fuqua', 'M. Night Shyamalan', 'S. Craig Zahler', 'Gregory Jacobs', 'Will Gluck', 'Ridley Scott', 'Neill Blomkamp', 'Peter Jackson', 'Biyi Bandele', 'Sean Ellis', 'Ridley Scott', 'Andrey Kravchuk', 'Glenn Ficarra', 'David Schwimmer', 'George Nolfi', 'Neill Blomkamp', 'Eli Roth', 'Gareth Edwards', 'Tony Gilroy', 'Ridley Scott', 'Simon Verhoeven', 'Tony Scott', 'Luc Besson', 'Terence Davies', 'Scott Waugh', 'Christopher McQuarrie', 'Steven Brill', 'Alexandros Avranas', 'Ewan McGregor', 'Roman Polanski', 'Neil Burger', 'Nic Mathieu', 'Richard LaGravenese', 'Mora Stephens', 'Jeff Nichols', 'Mike Birbiglia', 'Tim Burton', 'Philippe Falardeau', 'Ken Loach', 'Peyton Reed', 'Jeff Nichols', 'Josh Trank', 'Stephen Fingleton', 'Florian Gallenberger', 'Rob Cohen', 'Joel Edgerton', 'Gary Shore', 'Ron Howard', 'Mike Judge', 'Sylvester Stallone', 'Fede Alvarez', 'Scott Derrickson', 'Rich Moore', 'Rupert Sanders', 'Joe Wright', 'Michael Bay', 'Jason Reitman', 'Tom Tykwer', 'Jodie Foster', 'Nick Cassavetes', 'Kevin Lima', 'Nancy Meyers', 'Jonathan Dayton', 'Ben Younger', 'Louis Leterrier', 'Craig Gillespie', 'Joseph Kosinski', 'Francis Lawrence', 'Andrew Jarecki', 'John Stockwell', 'M. Night Shyamalan', 'Jake Kasdan', 'Kirk Jones', 'Bennett Miller', 'Mark Steven Johnson', 'Angelina Jolie', 'Tarsem Singh', 'Danny Boyle', 'Mark Andrews', 'Niels Arden Oplev', 'Anne Fontaine', 'Michaël R. Roskam', 'Andy Fickman', 'Sean Anders', 'Matt Reeves', 'Jeff Wadlow', 'Louis Leterrier', 'Duncan Jones', 'Tom McGrath', 'Ruben Fleischer', 'Jean-François Richet', 'Ken Kwapis', 'Alessandro Carloni', 'Zackary Adler', 'John Butler', 'Debra Granik', 'Seth Gordon', 'Xavier Dolan', 'Guillermo del Toro', 'Richard LaGravenese', 'Maren Ade', 'Peter Jackson', 'Andrew Dominik', 'Joseph Gordon-Levitt', 'James Watkins', 'Joey Curtis', 'Gary Ross', 'Paco Cabezas', 'Ben Stiller', 'Rick Famuyiwa', 'Måns Mårlind', 'Lars von Trier', 'Marcus Nispel', 'Olivier Megaton', 'Len Wiseman', 'Brett Ratner', 'Will Slocombe', 'Courtney Hunt', 'Shawn Levy', 'Edward Zwick', 'Evan Goldberg', 'Bong Joon Ho', 'Michael Goi', 'Andrew Stanton', 'Judd Apatow', 'Duncan Jones', 'John Hillcoat', 'Levan Gabriadze', 'Jon Hurwitz', 'Gabriele Muccino', 'Damián Szifron', 'Frank Coraci', 'François Ozon', 'Henry Joost', 'Clint Eastwood', 'John Wells', 'Jonathan Holbrook', 'Julia Leigh', 'Mark Waters', 'Tim Burton', 'Afonso Poyart', 'James Wan', 'Akiva Schaffer', 'Hope Dickson Leach', 'Michael Mann', 'Richard Linklater', 'Jonathan Liebesman', 'David Cronenberg', 'Simon Stone', 'David Gordon Green', 'Jon Kasdan', 'Ben Affleck', 'Paul Feig', 'Mia Hansen-Løve', 'Joe Wright', 'Alejandro Amenábar', 'Seth MacFarlane', 'Michael Bay', 'Edward Zwick', 'Atom Egoyan', 'Daniel Espinosa', 'Kathryn Bigelow', 'Martin Campbell', 'John Michael McDonagh', 'Frank Darabont', 'Mikael Håfström', 'Christian Ditter', 'Ari Sandel', 'Jee-woon Kim', 'Francis Lawrence', 'Lynne Ramsay', 'Whit Stillman', 'Harald Zwart', 'Gabriele Muccino', 'Tom Hooper', 'Steve McQueen', 'Doug Liman', 'Lee Unkrich', 'Tomas Alfredson', 'Paul W.S. Anderson', 'Gauri Shinde', 'Michael Grandage', 'Paul W.S. Anderson', 'Ang Lee', 'Lasse Hallström', 'Jamie Linden', 'Mike Cahill', 'Len Wiseman', 'Caleb Vetter', 'Michael Haneke', 'Seth MacFarlane', 'Robert Schwentke', 'Baz Luhrmann', 'George Tillman Jr.', 'Marcus Dunstan', 'George Nolfi', 'John Krasinski', 'David Dobkin', 'John Crowley', 'Michael Bay', 'Michael Dudok de Wit', 'Jorge R. Gutiérrez', 'Denis Villeneuve', 'Bobby Farrelly', 'George Miller', 'Doug Ellin', 'Bryan Bertino', 'Darren Aronofsky', 'Nicholas Stoller', 'Lars von Trier', 'Jean-Marc Vallée', 'Dennis Dugan', 'Adam Wingard', 'Harald Zwart', 'Tim Burton', 'Will Gluck', 'Neil Burger', 'Joe Carnahan', 'Adam Wingard', 'Shawn Levy', 'Greg Mottola', 'Simon Aboud', 'Ron Howard', 'Bruce Beresford', 'Martin Scorsese', 'Oz Perkins', 'Ridley Scott', 'Terrence Malick', 'Rob Cohen', 'Ben Falcone', 'Jonathan Jakubowicz', 'Juan José Campanella', 'Ethan Coen', 'Max Joseph', 'Seth MacFarlane', 'Chris Stokes', 'Warren Beatty', 'Mike Flanagan', 'Thor Freudenthal', 'Gregory Hoblit', 'Mike Flanagan', 'Martin McDonagh', 'McG', 'Filip Renc', 'John Hillcoat', 'Ed Gass-Donnelly', 'Jamal Hill', 'Marcus Nispel', 'David O. Russell', 'Kirsten Sheridan', 'Jon Favreau', 'Gavin Hood', 'D.J. Caruso', 'James DeMonaco', 'Rajkumar Hirani', 'Gavin Hood', 'Steven Spielberg', 'Jake Schreier', 'Ben Wheatley', 'Marc Forster', 'Walter Hill', 'Dean DeBlois', 'M. Night Shyamalan', 'Darren Aronofsky', 'John Lasseter', 'Rob Zombie', 'Tyler Shields', 'Hisonni Johnson', 'Matt Brown', 'Jaume Collet-Serra', 'Tarsem Singh', 'Bruce A. Evans', 'Adam Leon', 'Chris Evans', 'Paul Greengrass', 'Jim Sheridan', 'Stewart Hendler', 'Genndy Tartakovsky', 'Peter Berg', 'Jason Moore', 'Luc Besson', 'Kevin Smith', 'Claude Barras', 'Asger Leth', 'Ivan Reitman', 'Werner Herzog', 'Pierre Coffin', 'Scott Frank', 'Edgar Wright', 'Kevin Smith', 'Martin McDonagh', 'Robert Zemeckis', 'Kenneth Branagh', 'Mikael Håfström', 'Rupert Wyatt', 'Mike Newell', 'James Ponsoldt', 'Amma Asante', 'Mario Van Peebles', 'François Simard', 'Andrés Muschietti', 'Jaume Collet-Serra', 'Woody Allen', 'Wes Anderson', 'Spike Lee', 'John Moore', 'Danny Boyle', 'John R. Leonetti', 'John R. Leonetti', 'Saul Dibb', 'Terry Gilliam', 'Stephen Sommers', 'Antonio Campos', 'Dito Montiel', 'Phil Claydon', 'Farren Blackburn', 'Matthias Hoene', 'Robert Rodriguez', 'Jason Friedberg', 'Sylvester Stallone', 'David Bowers', 'Cary Joji Fukunaga', 'Andy Tennant', 'Larry Charles', 'Erik Van Looy', 'Cristian Mungiu', 'Dennis Dugan', 'Gee Malik Linton', 'Aisling Walsh', 'Sean Anders', 'Luca Guadagnino', 'Lars von Trier', 'Ron Clements', 'Tony Scott', 'Robert Zemeckis', 'Tim Johnson', 'Giuseppe Tornatore', 'Nathan Morlando', 'Brian Helgeland', 'Robert Luketic', 'John Carney', 'Scott Cooper', 'Woody Allen', 'Mark Osborne', 'Malcolm D. Lee', 'McG', 'Richard LaGravenese', 'Alexandre Aja', 'Clint Eastwood', 'Allen Coulter', 'Naoko Yamada', 'Miguel Arteta', 'Steven Knight', 'Alexandre Aja', 'Alexandre Aja', 'James Schamus', 'Kyle Patrick Alvarez', 'David Bowers', 'J.J. Abrams', 'Hannes Holm', 'James Wong', 'Dan Bradley', 'Lone Scherfig', 'Greg Berlanti', 'Juan Carlos Fresnadillo', 'Jonathan Levine', 'Woody Allen', 'Jon M. Chu', 'Jonathan Liebesman', 'Hideaki Anno', 'John Lee Hancock', 'Wally Pfister', 'Carlos Saldanha', 'Drake Doremus', 'Alejandro González Iñárritu', 'Terrence Malick', 'Scott Hicks', 'Alexandre Aja', 'Jonathan Levine', 'Femi Oyeniran', 'Judd Apatow', 'Shawn Levy', 'Michael Patrick King', 'Sylvester Stallone', 'Robert Rodriguez', 'Peter Landesman', 'Tarsem Singh', 'Robert Luketic', 'Gary Winick', 'Leslye Headland', 'David R. Ellis', 'Michael Dowse', 'Dean DeBlois', 'José Padilha', 'James Franco', 'Michael Showalter', 'Steven Soderbergh', 'James Gunn', 'Steven Soderbergh', 'Matteo Garrone', 'Oz Perkins', 'Gabor Csupo', 'James Ward Byrkit', 'George Tillman Jr.', 'Hong-jin Na', 'Simon West', 'Gregory Wilson', 'Tom Tykwer', 'Chris Weitz', 'Neil Marshall', 'Christopher Landon', 'Burr Steers', 'John Erick Dowdle', 'Bryan Singer', 'Bill Condon', 'Lee Daniels', 'Gus Van Sant', 'Chris McCoy', 'Paul Thomas Anderson', 'Craig Brewer', 'R.J. Cutler', 'Ido Fluk', 'Christopher Smith&