In [1]:
import os
import pandas as pd
import morejson as json
import holcrawl
import holcrawl.shared
from tqdm import tqdm
import numpy as np
In [2]:
UNITED_DIR_PATH = holcrawl.shared._get_united_dir_path()
verbose = True
In [3]:
DEMOGRAPHICS = [
'aged_under_18',
'males_under_18',
'males_aged_45+',
'females',
'males_aged_18-29',
'imdb_staff',
'imdb_users',
'males',
'aged_30-44',
'females_aged_45+',
'aged_18-29',
'females_aged_18-29',
'aged_45+',
'males_aged_30-44',
'top_1000_voters',
'females_under_18',
'females_aged_30-44',
'us_users',
'non-us_users'
]
In [4]:
def _decompose_dict_column(df, colname, allowed_cols):
newdf = df[colname].apply(pd.Series)
newdf = newdf.drop([
col for col in newdf.columns if col not in allowed_cols], axis=1)
newdf.columns = [colname+'.'+col for col in newdf.columns]
return pd.concat([df.drop([colname], axis=1), newdf], axis=1)
def _dummy_list_column(df, colname):
value_set = set([
value for value_list in df[colname].dropna() for value in value_list])
def _value_list_to_dict(value_list):
try:
return {
value : 1 if value in value_list else 0
for value in value_set}
except TypeError:
return {value : 0 for value in value_set}
df[colname] = df[colname].apply(_value_list_to_dict)
return _decompose_dict_column(df, colname, list(value_set))
In [5]:
def _list_to_sorted_str(listi):
return '_'.join(sorted([string.replace('-', '') for string in listi]))
In [6]:
profiles = []
profile_files = os.listdir(UNITED_DIR_PATH)
if verbose:
profile_files = tqdm(profile_files)
for profile_file in profile_files:
if verbose:
profile_files.set_description('Reading {}'.format(profile_file))
file_path = os.path.join(UNITED_DIR_PATH, profile_file)
_, ext = os.path.splitext(file_path)
if ext == '.json':
with open(file_path, 'r') as json_file:
profiles.append(json.load(json_file))
Reading woman_in_gold.json: 100%|██████████| 180/180 [00:00<00:00, 675.89it/s]
In [11]:
df['opening_weekend_date'][0]
Out[11]:
datetime.date(2014, 4, 18)
In [ ]:
def _avg_review_by_opening_generator(colname):
def _avg_review_by_opening(row):
return np.mean([
review['score'] for review in row[colname]
if review['review_date'] <= row['opening_weekend_date']
])
return _avg_review_by_opening
In [9]:
df = pd.DataFrame(profiles)
In [23]:
df['opening_weekend_date'].map(lambda opendate: opendate.year)
Out[23]:
0 2014
1 2014
2 2014
3 2014
4 2014
5 2014
6 2014
7 2014
8 2015
9 2014
10 2014
11 2015
12 2014
13 2014
14 2015
15 2014
16 2015
17 2014
18 2014
19 2015
20 2014
21 2015
22 2015
23 2015
24 2014
25 2014
26 2015
27 2014
28 2015
29 2015
...
150 2015
151 2015
152 2014
153 2014
154 2014
155 2014
156 2014
157 2015
158 2015
159 2014
160 2015
161 2015
162 2015
163 2014
164 2015
165 2015
166 2014
167 2014
168 2014
169 2015
170 2015
171 2014
172 2014
173 2015
174 2014
175 2015
176 2014
177 2014
178 2014
179 2015
Name: opening_weekend_date, dtype: int64
In [22]:
df['opening_weekend_date'].map(lambda opendate: opendate.timetuple().tm_yday)
Out[22]:
0 108
1 164
2 66
3 52
4 87
5 108
6 262
7 45
8 114
9 45
10 283
11 149
12 206
13 276
14 198
15 241
16 121
17 52
18 80
19 107
20 311
21 261
22 30
23 16
24 143
25 115
26 23
27 94
28 65
29 107
...
150 100
151 275
152 262
153 38
154 17
155 38
156 199
157 359
158 65
159 269
160 212
161 16
162 2
163 262
164 142
165 198
166 108
167 262
168 360
169 65
170 107
171 38
172 73
173 331
174 122
175 149
176 283
177 339
178 199
179 93
Name: opening_weekend_date, dtype: int64
In [ ]:
df = _decompose_dict_column(df, 'avg_rating_per_demo', DEMOGRAPHICS)
df = _decompose_dict_column(df, 'votes_per_demo', DEMOGRAPHICS)
df = _decompose_dict_column(
df, 'rating_freq', [str(i) for i in range(1, 11)])
df = _dummy_list_column(df, 'genres')
# df.genres = df.genres.apply(_list_to_sorted_str)
df['avg_mc_critic_by_opening'] = df.apply(_avg_review_by_opening_generator('mc_pro_critic_reviews'), axis=1)
df['avg_mc_user_by_opening'] = df.apply(_avg_review_by_opening_generator('mc_user_reviews'), axis=1)
df['opening_month'] = df['opening_weekend_date'].map(lambda opendate: opendate.month)
df['opening_day'] = df['opening_weekend_date'].map(lambda opendate: opendate.day)
df['opening_day_of_year'] = df['opening_weekend_date'].map(lambda opendate: opendate.timetuple().tm_yday)
In [ ]:
df.columns
In [15]:
pd.options.display.max_columns = 999
df
Out[15]:
avg_screens
budget
budget_currency
closing_date
critic_review_count
duration
gross_income
max_screens
mc_avg_user_score
mc_metascore
mc_mixed_rating_frequency
mc_movie_name
mc_negative_rating_frequency
mc_positive_rating_frequency
mc_pro_critic_reviews
mc_user_reviews
metascore
name
num_weekends
opening_weekend_date
opening_weekend_income
opening_weekend_income_currency
rating
rating_count
release_day
release_month
release_year
user_review_count
year
avg_rating_per_demo.aged_18-29
avg_rating_per_demo.aged_30-44
avg_rating_per_demo.aged_45+
avg_rating_per_demo.aged_under_18
avg_rating_per_demo.females
avg_rating_per_demo.females_aged_18-29
avg_rating_per_demo.females_aged_30-44
avg_rating_per_demo.females_aged_45+
avg_rating_per_demo.females_under_18
avg_rating_per_demo.imdb_staff
avg_rating_per_demo.imdb_users
avg_rating_per_demo.males
avg_rating_per_demo.males_aged_18-29
avg_rating_per_demo.males_aged_30-44
avg_rating_per_demo.males_aged_45+
avg_rating_per_demo.males_under_18
avg_rating_per_demo.non-us_users
avg_rating_per_demo.top_1000_voters
avg_rating_per_demo.us_users
votes_per_demo.aged_18-29
votes_per_demo.aged_30-44
votes_per_demo.aged_45+
votes_per_demo.aged_under_18
votes_per_demo.females
votes_per_demo.females_aged_18-29
votes_per_demo.females_aged_30-44
votes_per_demo.females_aged_45+
votes_per_demo.females_under_18
votes_per_demo.imdb_staff
votes_per_demo.imdb_users
votes_per_demo.males
votes_per_demo.males_aged_18-29
votes_per_demo.males_aged_30-44
votes_per_demo.males_aged_45+
votes_per_demo.males_under_18
votes_per_demo.non-us_users
votes_per_demo.top_1000_voters
votes_per_demo.us_users
rating_freq.1
rating_freq.10
rating_freq.2
rating_freq.3
rating_freq.4
rating_freq.5
rating_freq.6
rating_freq.7
rating_freq.8
rating_freq.9
genres.action
genres.adventure
genres.animation
genres.biography
genres.comedy
genres.crime
genres.documentary
genres.drama
genres.family
genres.fantasy
genres.history
genres.horror
genres.music
genres.musical
genres.mystery
genres.romance
genres.sci-fi
genres.sport
genres.thriller
genres.war
avg_mc_critic_by_opening
avg_mc_user_by_opening
0
45.000000
4000000.0
$
2014-04-18
94
93
9134
45
6.8
44
10
13 Sins
3
23
[{'publication': 'RogerEbert.com', 'review_dat...
[{'total_reactions': 1, 'neg_reactions': 0, 'u...
44
13 Sins
1
2014-04-18
9134
$
6.3
25068
NaN
NaN
NaN
69
2014
6.4
6.2
6.3
7.3
6.4
6.5
6.3
6.5
7.6
7.0
6.3
6.3
6.4
6.2
6.3
7.3
6.2
5.8
6.4
8575.0
10068.0
2256.0
55.0
3968.0
1882.0
1525.0
325.0
11.0
4.0
25068.0
17778.0
6605.0
8426.0
1889.0
44.0
12964.0
230.0
3845.0
337
1254
280
544
1255
3351
6991
6984
3093
979
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
1
0
49.700000
NaN
1
2605.375000
50000000.0
$
2014-11-07
335
112
191616238
3426
8.1
71
81
22 Jump Street
42
621
[{'publication': 'Boston Globe', 'review_date'...
[{'total_reactions': 1, 'neg_reactions': 0, 'u...
71
22 Jump Street
8
2014-06-13
57071445
$
7.1
274236
13.0
June
2014.0
322
2014
7.3
6.7
6.3
7.9
7.1
7.3
6.8
6.4
8.2
6.1
7.1
7.0
7.3
6.7
6.3
7.8
6.9
6.2
7.2
128688.0
65135.0
9028.0
2267.0
40031.0
25654.0
8858.0
1383.0
620.0
16.0
274236.0
180467.0
101712.0
55439.0
7490.0
1628.0
119172.0
506.0
35147.0
2883
25688
1901
3165
6626
16774
43760
81836
64989
26614
1
0
0
0
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
72.844444
7.833333
2
1891.833333
110000000.0
$
2014-05-16
367
102
106369117
3490
6.0
48
179
300: Rise of an Empire
105
277
[{'publication': 'Chicago Sun-Times', 'review_...
[{'total_reactions': 4, 'neg_reactions': 0, 'u...
48
300: Rise of an Empire
12
2014-03-07
45038460
$
6.2
234420
7.0
March
2014.0
532
2014
6.3
6.1
6.1
6.7
6.3
6.3
6.2
6.2
6.8
6.3
6.2
6.2
6.3
6.1
6.1
6.7
6.1
5.7
6.2
95933.0
73988.0
11634.0
691.0
20214.0
10390.0
6941.0
1219.0
78.0
11.0
234420.0
174235.0
84680.0
66014.0
10209.0
610.0
110596.0
496.0
22633.0
10053
15924
4188
7262
13817
29217
53207
56500
31549
12703
1
0
0
0
0
0
0
1
0
1
0
0
0
0
0
0
0
0
0
0
49.833333
7.142857
3
938.750000
28000000.0
$
2014-05-09
215
117
30688364
2872
5.6
40
51
3 Days to Kill
24
41
[{'publication': 'Chicago Sun-Times', 'review_...
[{'total_reactions': 1, 'neg_reactions': 0, 'u...
40
3 Days to Kill
12
2014-02-21
12242218
$
6.2
72337
21.0
February
2014.0
216
2014
6.3
6.0
6.3
6.7
6.3
6.4
6.2
6.5
6.7
6.1
6.2
6.2
6.3
6.0
6.3
6.7
6.1
5.7
6.1
21120.0
28352.0
8328.0
182.0
7668.0
3020.0
2906.0
1089.0
39.0
6.0
72337.0
53624.0
17895.0
25103.0
7092.0
142.0
36147.0
381.0
9738.0
1167
3518
1138
2125
4308
9575
19788
19413
8586
2719
1
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
1
0
45.523810
6.500000
4
29.000000
10000000.0
$
2014-10-10
8
110
1063723
133
8.1
37
0
50 to 1
1
6
[{'publication': 'Washington Post', 'review_da...
[{'total_reactions': 0, 'neg_reactions': 0, 'u...
37
50 to 1
14
2014-03-28
39638
$
6.6
1482
NaN
NaN
NaN
55
2014
6.5
6.2
6.7
NaN
7.6
6.8
7.4
8.1
NaN
NaN
6.6
6.2
6.4
5.9
6.3
NaN
6.2
5.2
6.7
174.0
456.0
533.0
NaN
457.0
55.0
147.0
235.0
NaN
NaN
1482.0
747.0
117.0
306.0
290.0
NaN
480.0
48.0
405.0
36
433
25
38
56
123
231
279
169
92
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
NaN
NaN
5
1303.600000
4000000.0
$
2014-06-06
69
86
17314483
2310
3.8
17
22
A Haunted House 2
57
27
[{'publication': 'St. Louis Post-Dispatch', 'r...
[{'total_reactions': 2, 'neg_reactions': 0, 'u...
17
A Haunted House 2
5
2014-04-18
8843875
$
4.7
15409
18.0
April
2014.0
50
2014
5.0
4.3
4.0
5.7
4.8
5.0
4.5
4.1
6.3
NaN
4.7
4.6
4.9
4.3
4.0
5.6
4.5
3.9
4.4
6946.0
4103.0
788.0
161.0
1932.0
1157.0
499.0
104.0
30.0
NaN
15409.0
10838.0
5726.0
3563.0
672.0
131.0
6458.0
172.0
2592.0
1663
1620
1096
1384
1921
2701
2185
1535
902
402
0
0
0
0
1
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
21.785714
4.000000
6
2714.000000
28000000.0
$
2014-10-17
256
114
25977365
2714
6.5
57
53
A Walk Among the Tombstones
13
95
[{'publication': 'RogerEbert.com', 'review_dat...
[{'total_reactions': 4, 'neg_reactions': 0, 'u...
57
A Walk Among the Tombstones
1
2014-09-19
12758780
$
6.5
92251
19.0
September
2014.0
208
2014
6.6
6.5
6.6
7.1
6.5
6.5
6.5
6.8
7.1
6.8
6.5
6.5
6.6
6.5
6.6
7.1
6.5
6.4
6.7
29490.0
34653.0
8845.0
238.0
9328.0
3785.0
3604.0
1130.0
42.0
12.0
92251.0
68213.0
25446.0
30638.0
7580.0
195.0
46413.0
435.0
11518.0
835
3565
592
1158
3042
9591
26634
31444
12168
3222
0
0
0
0
0
1
0
1
0
0
0
0
0
0
1
0
0
0
0
0
60.323529
5.333333
7
778.090909
12500000.0
$
2014-04-25
90
100
48637684
2253
6.1
62
17
About Last Night
12
27
[{'publication': 'Tampa Bay Times', 'review_da...
[{'total_reactions': 1, 'neg_reactions': 0, 'u...
62
About Last Night
11
2014-02-14
27838201
$
6.1
17804
14.0
February
2014.0
42
2014
6.3
5.9
5.6
7.1
6.3
6.4
6.0
6.2
6.8
5.3
6.1
6.0
6.2
5.8
5.4
7.3
5.9
5.0
6.2
7620.0
5049.0
1092.0
62.0
4567.0
2619.0
1251.0
284.0
28.0
3.0
17804.0
10224.0
4919.0
3744.0
787.0
34.0
7521.0
160.0
3056.0
545
1392
297
499
1074
2472
4809
4049
1885
782
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
64.642857
8.000000
8
22.250000
NaN
NaN
2015-05-29
50
92
104415
54
6.6
57
6
Adult Beginners
1
5
[{'publication': 'The Playlist', 'review_date'...
[{'total_reactions': 1, 'neg_reactions': 0, 'u...
57
Adult Beginners
4
2015-04-24
36657
$
5.6
6010
NaN
NaN
NaN
23
2014
5.7
5.5
5.4
5.8
5.8
5.9
5.8
5.8
5.8
7.0
5.6
5.5
5.7
5.4
5.3
5.9
5.4
4.8
5.9
2166.0
2287.0
475.0
17.0
1409.0
724.0
502.0
94.0
6.0
2.0
6010.0
3708.0
1403.0
1746.0
376.0
10.0
2737.0
105.0
1330.0
209
207
151
214
571
1367
1824
1040
323
104
0
0
0
0
1
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
59.166667
NaN
9
6.500000
NaN
NaN
2014-03-07
40
97
16740
11
7.1
61
4
Adult World
3
12
[{'publication': 'Village Voice', 'review_date...
[{'total_reactions': 0, 'neg_reactions': 0, 'u...
61
Adult World
2
2014-02-14
4368
$
6.2
13983
14.0
February
2014.0
44
2013
6.3
5.9
6.0
7.3
6.5
6.5
6.2
6.4
7.4
6.5
6.2
6.0
6.2
5.8
6.0
7.3
6.1
5.5
6.2
6289.0
3941.0
1150.0
75.0
4535.0
3160.0
876.0
210.0
54.0
2.0
13983.0
7277.0
3045.0
3004.0
917.0
19.0
6558.0
156.0
2721.0
234
853
210
389
883
2014
3842
3416
1549
593
0
0
0
0
1
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
59.312500
NaN
10
93.333333
28000000.0
$
2015-02-20
120
81
66950483
157
5.7
54
34
Alexander and the Terrible, Horrible, No Good,...
18
38
[{'publication': 'RogerEbert.com', 'review_dat...
[{'total_reactions': 3, 'neg_reactions': 0, 'u...
54
Alexander and the Terrible, Horrible, No Good,...
3
2014-10-10
18360230
$
6.2
31607
10.0
October
2014.0
86
2014
6.3
6.1
6.2
6.4
6.5
6.5
6.4
6.6
7.1
7.0
6.2
6.1
6.2
6.0
6.1
6.1
6.1
5.5
6.3
11924.0
9976.0
2399.0
276.0
6969.0
3727.0
2067.0
452.0
105.0
1.0
31607.0
19075.0
8042.0
7777.0
1897.0
167.0
14306.0
243.0
4693.0
596
1886
392
656
1690
4498
9256
8110
3424
1099
0
0
0
0
1
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
56.714286
NaN
11
1308.666667
37000000.0
$
2015-07-17
142
105
20991497
2815
4.3
40
32
Aloha
52
31
[{'publication': 'Chicago Sun-Times', 'review_...
[{'total_reactions': 6, 'neg_reactions': 2, 'u...
40
Aloha
6
2015-05-29
9670235
$
5.4
43735
29.0
May
2015.0
177
2015
5.5
5.3
5.5
5.9
5.5
5.5
5.4
5.7
6.1
5.8
5.4
5.4
5.5
5.3
5.5
5.7
5.4
4.8
5.3
15871.0
13953.0
3728.0
189.0
12186.0
6473.0
3884.0
890.0
96.0
4.0
43735.0
23195.0
9204.0
9837.0
2776.0
90.0
19449.0
256.0
6962.0
1825
1868
1594
2702
5078
9184
10397
6848
3150
1089
0
0
0
0
1
0
0
1
0
0
0
0
0
0
0
1
0
0
0
0
44.030303
3.500000
12
1199.333333
18000000.0
$
2014-09-26
109
94
15155772
1816
6.1
38
11
And So It Goes
0
5
[{'publication': 'Chicago Sun-Times', 'review_...
[{'total_reactions': 1, 'neg_reactions': 0, 'u...
38
And So It Goes
3
2014-07-25
4642329
$
5.8
9629
25.0
July
2014.0
50
2014
5.7
5.6
6.0
5.8
5.8
5.8
5.7
6.2
6.4
7.0
5.8
5.7
5.7
5.6
5.9
5.3
5.7
4.9
5.7
2160.0
3549.0
1996.0
24.0
3072.0
1046.0
1218.0
607.0
9.0
1.0
9629.0
4986.0
1085.0
2274.0
1354.0
15.0
4641.0
164.0
1588.0
247
374
185
411
787
1851
2876
1856
794
248
0
0
0
0
1
0
0
1
0
0
0
0
0
0
0
1
0
0
0
0
44.428571
5.000000
13
3185.000000
6500000.0
$
2014-12-12
275
99
84263837
3185
5.0
37
92
Annabelle
95
96
[{'publication': 'TheWrap', 'review_date': dat...
[{'total_reactions': 1, 'neg_reactions': 0, 'u...
37
Annabelle
1
2014-10-03
37134255
$
5.4
88605
3.0
October
2014.0
302
2014
5.4
5.3
5.4
5.5
5.5
5.5
5.4
5.6
6.1
5.8
5.4
5.3
5.4
5.3
5.3
5.3
5.3
4.9
5.3
37653.0
23538.0
4067.0
712.0
17648.0
10324.0
4571.0
828.0
243.0
4.0
88605.0
53914.0
27007.0
18639.0
3178.0
467.0
36747.0
364.0
10704.0
4061
4859
3312
5853
10408
17865
20483
13047
6205
2512
0
0
0
0
0
0
0
0
0
0
0
1
0
0
1
0
0
0
1
0
41.720000
5.125000
14
1338.578947
130000000.0
$
2015-12-11
529
117
180191634
3868
8.1
64
145
Ant-Man
61
1297
[{'publication': 'RogerEbert.com', 'review_dat...
[{'total_reactions': 47, 'neg_reactions': 14, ...
64
Ant-Man
19
2015-07-17
57225526
$
7.3
353755
17.0
July
2015.0
564
2015
7.4
7.2
7.3
7.9
7.4
7.5
7.3
7.5
8.1
7.2
7.3
7.3
7.4
7.2
7.3
7.8
7.2
6.9
7.5
130533.0
98097.0
18703.0
3041.0
39342.0
21558.0
11257.0
2454.0
576.0
39.0
353755.0
230139.0
107565.0
85405.0
15913.0
2436.0
144174.0
629.0
42602.0
3037
30880
1522
2400
4694
13549
41856
105410
108894
41513
1
1
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
66.731707
8.153846
15
1534.000000
5000000.0
$
2014-10-03
196
93
21197315
2640
6.3
38
41
As Above, So Below
25
74
[{'publication': 'Film.com', 'review_date': da...
[{'total_reactions': 3, 'neg_reactions': 0, 'u...
38
As Above, So Below
2
2014-08-29
10284110
$
6.2
54022
29.0
August
2014.0
220
2014
6.4
6.0
5.7
6.8
6.4
6.5
6.2
5.9
6.9
6.3
6.2
6.1
6.3
6.0
5.7
6.8
6.1
5.1
6.2
20160.0
18441.0
3638.0
240.0
10050.0
5461.0
3222.0
575.0
81.0
5.0
54022.0
34779.0
14474.0
14963.0
2993.0
159.0
24694.0
327.0
8295.0
1238
3491
1114
1955
3635
7074
12545
13005
7217
2748
0
0
0
0
0
0
0
0
0
0
0
1
0
0
1
0
0
0
1
0
47.333333
7.000000
16
1541.789474
250000000.0
$
2015-10-02
650
141
458991599
4276
7.1
66
405
Avengers: Age of Ultron
243
1576
[{'publication': 'Chicago Sun-Times', 'review_...
[{'total_reactions': 16, 'neg_reactions': 0, '...
66
Avengers: Age of Ultron
19
2015-05-01
191271109
$
7.4
501696
1.0
May
2015.0
1128
2015
7.5
7.3
7.3
7.9
7.7
7.7
7.5
7.5
8.5
7.1
7.4
7.4
7.5
7.2
7.3
7.8
7.3
6.7
7.5
191615.0
128734.0
23458.0
4590.0
59344.0
33350.0
15919.0
3426.0
996.0
42.0
501696.0
318845.0
156342.0
110946.0
19613.0
3558.0
192711.0
641.0
58723.0
7727
71148
3058
4651
8698
21623
57620
124712
131908
70551
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
68.875000
7.541667
17
18.000000
6000000.0
$
2014-02-21
26
90
11766
18
5.6
22
6
Barefoot
5
6
[{'publication': 'RogerEbert.com', 'review_dat...
[{'total_reactions': 1, 'neg_reactions': 1, 'u...
22
Barefoot
1
2014-02-21
11766
$
6.6
18316
NaN
NaN
NaN
51
2014
6.8
6.3
6.4
6.8
6.6
6.8
6.4
6.5
7.0
NaN
6.6
6.5
6.8
6.3
6.4
6.3
6.5
5.2
6.4
7571.0
5510.0
1474.0
53.0
7304.0
4368.0
2131.0
378.0
43.0
NaN
18316.0
7858.0
3113.0
3307.0
1071.0
9.0
8941.0
139.0
2098.0
228
1826
208
398
786
1773
3719
5146
2909
1323
0
0
0
0
1
0
0
1
0
0
0
0
0
0
0
1
0
0
0
0
29.500000
NaN
18
25.000000
5000000.0
$
2014-03-21
40
91
72273
25
6.0
40
6
Better Living Through Chemistry
2
5
[{'publication': 'New York Observer', 'review_...
[{'total_reactions': 2, 'neg_reactions': 2, 'u...
40
Better Living Through Chemistry
1
2014-03-21
5337
$
6.3
11800
NaN
NaN
NaN
31
2014
6.4
6.2
6.2
6.8
6.2
6.1
6.2
6.5
6.5
6.0
6.3
6.3
6.4
6.2
6.2
6.8
6.3
5.6
6.3
3624.0
5023.0
1348.0
10.0
2019.0
935.0
808.0
169.0
2.0
2.0
11800.0
8244.0
2649.0
4140.0
1140.0
8.0
6529.0
132.0
1837.0
144
435
102
208
571
1639
3516
3469
1333
383
0
0
0
0
1
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
46.666667
5.000000
19
10.000000
NaN
NaN
2015-04-24
81
91
44577
10
4.2
34
9
Beyond the Reach
6
3
[{'publication': 'RogerEbert.com', 'review_dat...
[{'total_reactions': 1, 'neg_reactions': 0, 'u...
34
Beyond the Reach
1
2015-04-17
30287
$
5.6
7152
NaN
NaN
NaN
47
2014
5.6
5.5
5.7
6.9
5.6
5.7
5.4
5.9
9.0
NaN
5.6
5.5
5.6
5.5
5.7
6.8
5.5
5.3
5.6
1266.0
3176.0
1357.0
15.0
567.0
149.0
274.0
108.0
1.0
NaN
7152.0
5480.0
1102.0
2861.0
1228.0
14.0
3873.0
148.0
1004.0
216
204
201
349
779
1600
2070
1194
411
128
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
39.277778
NaN
20
209.384615
165000000.0
$
2015-05-08
390
102
222487711
451
8.0
74
80
Big Hero 6
36
618
[{'publication': 'Arizona Republic', 'review_d...
[{'total_reactions': 14, 'neg_reactions': 2, '...
74
Big Hero 6
13
2014-11-07
56215889
$
7.9
300738
7.0
November
2014.0
444
2014
7.9
7.7
7.6
8.3
8.2
8.3
8.0
7.9
8.7
7.9
7.9
7.7
7.8
7.6
7.6
8.0
7.7
7.2
7.9
125615.0
79120.0
12945.0
2715.0
56332.0
34106.0
13800.0
2233.0
936.0
33.0
300738.0
180343.0
90150.0
64129.0
10465.0
1756.0
126920.0
518.0
34973.0
1391
48687
506
970
2092
6375
21077
62147
98618
58875
1
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
75.636364
10.000000
21
1481.125000
53000000.0
$
2015-11-27
403
123
62563543
3188
7.6
68
75
Black Mass
25
303
[{'publication': 'Variety', 'review_date': dat...
[{'total_reactions': 3, 'neg_reactions': 0, 'u...
68
Black Mass
8
2015-09-18
22635037
$
6.9
131937
18.0
September
2015.0
305
2015
7.0
6.8
6.9
7.3
6.8
6.9
6.7
7.1
7.5
7.2
6.9
6.9
7.0
6.8
6.9
7.2
6.8
6.4
7.0
47860.0
41440.0
9458.0
552.0
13277.0
6503.0
4410.0
1282.0
69.0
12.0
131937.0
91787.0
40839.0
36465.0
8024.0
480.0
59138.0
410.0
18018.0
1155
7800
611
1167
2750
8484
24959
48114
28466
8431
0
0
0
1
0
1
0
1
0
0
0
0
0
0
0
0
0
0
0
0
69.923077
7.000000
22
570.428571
9000000.0
$
2015-05-08
94
121
21569041
1823
7.7
45
6
Black or White
3
25
[{'publication': 'St. Louis Post-Dispatch', 'r...
[{'total_reactions': 2, 'neg_reactions': 0, 'u...
45
Black or White
14
2015-01-30
6456000
$
6.6
8862
30.0
January
2015.0
61
2014
6.7
6.5
6.8
8.0
6.9
6.8
6.7
7.2
8.3
8.0
6.6
6.5
6.5
6.4
6.6
7.7
6.5
5.9
6.7
2182.0
2922.0
1653.0
33.0
2856.0
1055.0
970.0
562.0
21.0
1.0
8862.0
4373.0
1101.0
1915.0
1074.0
11.0
3176.0
144.0
2283.0
244
852
66
144
279
763
1879
2647
1470
518
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
50.586207
7.000000
23
2567.500000
70000000.0
$
2015-01-23
274
133
7097125
2568
5.2
51
49
Blackhat
33
37
[{'publication': 'RogerEbert.com', 'review_dat...
[{'total_reactions': 6, 'neg_reactions': 0, 'u...
51
Blackhat
2
2015-01-16
4415000
$
5.4
41950
16.0
January
2015.0
217
2015
5.4
5.3
5.6
5.9
5.2
5.1
5.1
5.6
5.8
4.0
5.4
5.4
5.4
5.3
5.6
5.9
5.4
5.0
5.4
12051.0
16756.0
4646.0
108.0
4498.0
1799.0
1799.0
574.0
21.0
9.0
41950.0
30651.0
10111.0
14721.0
3986.0
87.0
20912.0
300.0
5931.0
2082
1399
1719
2969
5392
9262
9395
6076
2744
912
0
0
0
0
0
1
0
1
0
0
0
0
0
0
1
0
0
0
0
0
53.656250
6.000000
24
1527.000000
40000000.0
$
2014-08-22
173
117
46280507
3555
5.1
31
39
Blended
87
101
[{'publication': 'Los Angeles Times', 'review_...
[{'total_reactions': 2, 'neg_reactions': 0, 'u...
31
Blended
9
2014-05-23
18185000
$
6.5
91944
23.0
May
2014.0
192
2014
6.7
6.3
6.3
7.3
6.9
7.0
6.6
6.6
7.9
5.5
6.5
6.4
6.5
6.2
6.2
6.8
6.4
5.3
6.3
35170.0
28067.0
5650.0
668.0
22962.0
12557.0
6679.0
1252.0
325.0
6.0
91944.0
51766.0
22243.0
21002.0
4300.0
333.0
39944.0
336.0
11490.0
2238
9548
1406
2140
3790
8324
18715
24543
14805
6435
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
38.161290
5.000000
25
1248.666667
28000000.0
$
2014-06-20
181
90
20285518
2647
5.6
40
35
Brick Mansions
18
28
[{'publication': 'Portland Oregonian', 'review...
[{'total_reactions': 3, 'neg_reactions': 0, 'u...
40
Brick Mansions
6
2014-04-25
9516855
$
5.7
33640
25.0
April
2014.0
112
2014
5.9
5.4
5.5
6.7
6.2
6.4
5.8
6.1
6.6
4.0
5.7
5.6
5.9
5.4
5.4
6.7
5.5
5.1
5.5
12545.0
11024.0
2453.0
179.0
3636.0
1740.0
1215.0
296.0
29.0
2.0
33640.0
24429.0
10685.0
9662.0
2116.0
150.0
15356.0
268.0
4326.0
1129
2947
958
1695
3158
5935
8227
5694
2737
1160
1
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
1
0
0
0
45.550000
5.000000
26
278.500000
7000000.0
$
2015-02-06
162
102
1873547
482
6.4
49
19
Cake
8
33
[{'publication': 'Entertainment Weekly', 'revi...
[{'total_reactions': 1, 'neg_reactions': 0, 'u...
49
Cake
2
2015-01-23
916179
$
6.4
28853
23.0
January
2015.0
133
2014
6.5
6.3
6.5
7.3
6.7
6.7
6.7
6.7
7.0
7.5
6.4
6.3
6.4
6.2
6.4
7.4
6.4
5.9
6.5
9443.0
9907.0
3459.0
80.0
10103.0
4580.0
3742.0
1101.0
33.0
6.0
28853.0
13834.0
4766.0
6002.0
2309.0
46.0
13268.0
259.0
4818.0
587
1885
388
603
1317
3252
6843
7925
4377
1676
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
54.242424
6.333333
27
1762.466667
170000000.0
$
2014-08-15
583
136
259746958
3938
8.5
70
117
Captain America: The Winter Soldier
76
1658
[{'publication': 'Hitfix', 'review_date': date...
[{'total_reactions': 54, 'neg_reactions': 18, ...
70
Captain America: The Winter Soldier
15
2014-04-04
95023721
$
7.8
529139
4.0
April
2014.0
757
2014
7.8
7.6
7.7
8.4
7.9
7.9
7.7
7.8
8.6
7.5
7.8
7.7
7.8
7.6
7.6
8.3
7.5
7.3
8.1
205352.0
142084.0
27023.0
4248.0
64395.0
35683.0
17482.0
3841.0
969.0
40.0
529139.0
348291.0
167734.0
122574.0
22715.0
3251.0
206214.0
702.0
69241.0
5034
82280
1841
2629
5325
13905
41889
114223
161719
100294
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
71.357143
8.300000
28
1333.000000
49000000.0
$
2015-05-01
375
120
31569268
3201
7.2
41
164
Chappie
83
507
[{'publication': 'Time Out London', 'review_da...
[{'total_reactions': 48, 'neg_reactions': 23, ...
41
Chappie
8
2015-03-06
13346782
$
6.9
184099
6.0
March
2015.0
649
2015
7.0
6.8
6.5
7.2
6.9
7.1
6.8
6.6
7.7
6.9
6.9
6.8
7.0
6.8
6.5
7.1
6.8
6.1
6.7
64629.0
65204.0
11813.0
769.0
18277.0
8981.0
6410.0
1410.0
128.0
18.0
184099.0
131907.0
54899.0
57778.0
10168.0
635.0
88678.0
476.0
18399.0
3503
16837
2441
4100
7004
14504
29120
49056
39512
18022
1
0
0
0
0
1
0
1
0
0
0
0
0
0
0
0
0
0
0
0
47.108108
6.937500
29
200.000000
50000000.0
$
2015-05-08
176
137
1206135
510
5.3
41
30
Child 44
31
47
[{'publication': 'Total Film', 'review_date': ...
[{'total_reactions': 1, 'neg_reactions': 0, 'u...
41
Child 44
3
2015-04-17
621812
$
6.5
46043
NaN
NaN
NaN
201
2015
6.5
6.3
6.5
6.6
6.7
6.8
6.6
6.8
7.0
4.0
6.5
6.4
6.5
6.3
6.5
6.4
6.4
5.7
6.2
14432.0
16877.0
4906.0
76.0
7154.0
3168.0
2700.0
813.0
20.0
3.0
46043.0
30741.0
11097.0
13954.0
4010.0
56.0
24137.0
277.0
4161.0
1039
3382
506
947
2094
4909
10393
12900
7220
2653
0
0
0
0
0
1
0
1
0
0
0
0
0
0
0
0
0
0
1
0
45.434783
5.600000
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
150
1545.555556
34000000.0
$
2015-06-26
118
123
37432299
3371
5.1
33
15
The Longest Ride
24
31
[{'publication': 'Empire', 'review_date': date...
[{'total_reactions': 2, 'neg_reactions': 0, 'u...
33
The Longest Ride
9
2015-04-10
13019686
$
7.1
56331
10.0
April
2015.0
120
2015
7.2
6.7
6.8
8.1
7.3
7.4
7.1
7.2
8.3
6.8
7.1
6.8
7.0
6.6
6.7
7.4
6.9
5.5
6.8
23688.0
12364.0
3339.0
590.0
21446.0
13368.0
4784.0
1025.0
451.0
4.0
56331.0
21304.0
10064.0
7391.0
2260.0
132.0
22865.0
227.0
5482.0
827
9289
432
799
1496
3312
7865
14203
11886
6222
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
1
0
0
0
0
38.448276
4.333333
151
1115.157895
108000000.0
$
2016-03-11
591
144
228430993
3854
8.0
80
160
The Martian
83
1360
[{'publication': 'Wall Street Journal', 'revie...
[{'total_reactions': 29, 'neg_reactions': 10, ...
80
The Martian
19
2015-10-02
54308575
$
8.0
538729
2.0
October
2015.0
1068
2015
8.1
7.9
8.0
8.5
8.1
8.1
7.9
8.2
8.5
8.2
8.0
8.0
8.1
7.9
7.9
8.4
7.9
7.7
8.1
195563.0
150533.0
32802.0
3572.0
67761.0
35507.0
20595.0
5037.0
694.0
78.0
538729.0
342811.0
157950.0
127685.0
27168.0
2850.0
228455.0
652.0
57888.0
2799
72365
1250
1930
3598
9303
29264
96542
188203
133475
0
1
0
0
0
0
0
1
0
0
0
0
0
0
0
0
1
0
0
0
80.133333
8.052632
152
1840.000000
34000000.0
$
2015-01-23
298
113
102413606
3638
6.7
57
135
The Maze Runner
68
322
[{'publication': 'Chicago Sun-Times', 'review_...
[{'total_reactions': 1, 'neg_reactions': 0, 'u...
57
The Maze Runner
2
2014-09-19
32512804
$
6.8
328953
19.0
September
2014.0
531
2014
7.0
6.6
6.5
7.7
7.2
7.3
6.8
6.8
8.3
6.4
6.8
6.7
6.9
6.5
6.5
7.4
6.7
6.0
6.8
134241.0
86244.0
16133.0
3536.0
62292.0
38013.0
14076.0
2708.0
1575.0
11.0
328953.0
196505.0
94833.0
70949.0
13143.0
1935.0
141881.0
529.0
30924.0
3499
31303
2473
4624
9631
24565
61565
100820
64920
25553
1
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
1
0
0
0
60.218750
7.333333
153
1320.928571
70000000.0
$
2014-05-16
375
118
78031620
3083
5.3
52
95
The Monuments Men
49
75
[{'publication': 'New York Observer', 'review_...
[{'total_reactions': 6, 'neg_reactions': 0, 'u...
52
The Monuments Men
14
2014-02-07
22003433
$
6.1
106397
7.0
February
2014.0
406
2014
6.1
6.0
6.3
6.4
6.4
6.4
6.3
6.8
6.5
6.5
6.1
6.0
6.1
5.9
6.2
6.4
6.0
5.9
6.2
33945.0
38729.0
12291.0
277.0
15860.0
6801.0
5616.0
2155.0
56.0
12.0
106397.0
73887.0
26744.0
32540.0
9914.0
217.0
52362.0
483.0
16476.0
2202
3371
1765
3311
6981
16497
30937
26934
11045
3354
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
56.325000
5.000000
154
1270.666667
42000000.0
$
2014-05-02
120
85
64238770
3472
4.1
37
24
The Nut Job
42
19
[{'publication': 'New York Magazine (Vulture)'...
[{'total_reactions': 2, 'neg_reactions': 0, 'u...
37
The Nut Job
15
2014-01-17
25700000
$
5.8
20653
17.0
January
2014.0
67
2014
5.9
5.6
5.8
5.9
5.9
6.0
5.8
6.3
6.2
5.0
5.8
5.7
5.8
5.6
5.7
5.8
5.8
4.9
5.3
7924.0
6546.0
1497.0
183.0
4006.0
2087.0
1264.0
286.0
40.0
3.0
20653.0
13127.0
5758.0
5209.0
1185.0
142.0
9056.0
187.0
3065.0
700
1592
542
887
1815
3851
5446
3481
1629
710
0
1
1
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
42.076923
8.000000
155
5.000000
NaN
NaN
2014-02-21
35
90
11186
5
6.9
53
4
The Pretty One
2
11
[{'publication': 'Slant Magazine', 'review_dat...
[{'total_reactions': 0, 'neg_reactions': 0, 'u...
53
The Pretty One
1
2014-02-07
1484
$
6.3
7857
7.0
February
2014.0
12
2013
6.4
6.2
6.1
7.0
6.5
6.5
6.5
6.3
7.1
6.0
6.3
6.1
6.3
6.0
6.0
6.9
6.3
5.0
6.4
3885.0
2031.0
403.0
41.0
4186.0
2882.0
979.0
98.0
30.0
2.0
7857.0
2385.0
956.0
1015.0
294.0
10.0
4129.0
67.0
823.0
145
446
96
195
367
935
2081
2154
1067
371
0
0
0
0
1
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
60.300000
NaN
156
2479.750000
9000000.0
$
2014-09-12
297
103
71519230
2856
6.3
50
77
The Purge: Anarchy
41
132
[{'publication': 'New York Magazine (Vulture)'...
[{'total_reactions': 2, 'neg_reactions': 0, 'u...
50
The Purge: Anarchy
4
2014-07-18
29816675
$
6.5
103934
18.0
July
2014.0
252
2014
6.6
6.3
6.3
7.1
6.6
6.7
6.4
6.5
7.2
6.6
6.5
6.4
6.5
6.3
6.3
7.1
6.4
6.0
6.5
41438.0
31438.0
5323.0
584.0
14243.0
8204.0
3947.0
687.0
172.0
7.0
103934.0
69963.0
32799.0
27059.0
4531.0
409.0
46014.0
416.0
14553.0
1594
6366
1101
2143
4581
11065
24956
31376
15495
5257
1
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
1
0
0
0
53.413793
5.000000
157
1234.130435
135000000.0
$
2016-05-20
586
156
183635922
3711
8.0
76
156
The Revenant
91
1254
[{'publication': 'New Orleans Times-Picayune',...
[{'total_reactions': 34, 'neg_reactions': 16, ...
76
The Revenant
23
2015-12-25
474560
$
8.0
480772
8.0
January
2016.0
1266
2015
8.1
7.9
7.8
8.5
7.9
8.0
7.7
7.8
8.2
8.4
8.0
8.0
8.2
7.9
7.8
8.6
7.9
7.6
8.1
179566.0
128377.0
26157.0
2923.0
57503.0
30604.0
17144.0
3905.0
518.0
43.0
480772.0
306115.0
147100.0
109300.0
21766.0
2382.0
202091.0
584.0
48080.0
4308
76936
2108
3133
5193
11887
30974
84371
146724
115138
0
1
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
1
0
78.828571
7.777778
158
798.750000
10000000.0
$
2015-06-19
159
122
33071558
2022
6.1
51
23
The Second Best Exotic Marigold Hotel
7
25
[{'publication': 'Empire', 'review_date': date...
[{'total_reactions': 1, 'neg_reactions': 0, 'u...
51
The Second Best Exotic Marigold Hotel
12
2015-03-06
8540370
$
6.6
24232
6.0
March
2015.0
102
2015
6.6
6.4
6.6
6.9
6.8
6.8
6.7
7.1
7.1
7.1
6.6
6.4
6.5
6.3
6.5
6.7
6.5
5.8
6.6
6088.0
8312.0
4826.0
66.0
7411.0
2783.0
2720.0
1407.0
29.0
5.0
24232.0
12794.0
3229.0
5457.0
3355.0
34.0
12211.0
245.0
3415.0
252
1346
207
383
914
2428
6098
7454
3786
1364
0
0
0
0
1
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
56.714286
6.000000
159
6.000000
NaN
NaN
2014-12-19
196
96
506067
6
6.4
66
18
The Two Faces of January
4
20
[{'publication': 'Philadelphia Inquirer', 'rev...
[{'total_reactions': 1, 'neg_reactions': 0, 'u...
66
The Two Faces of January
1
2014-09-26
43116
$
6.2
23732
NaN
NaN
NaN
94
2014
6.3
6.1
6.3
6.2
6.1
6.2
6.1
6.3
5.9
7.0
6.2
6.2
6.4
6.1
6.3
6.3
6.2
5.8
6.3
6534.0
9686.0
3671.0
42.0
4185.0
1597.0
1713.0
640.0
12.0
3.0
23732.0
16386.0
4855.0
7815.0
2971.0
30.0
14248.0
251.0
2611.0
256
622
267
511
1256
3610
7628
6601
2358
623
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
1
0
68.909091
6.000000
160
239.500000
8000000.0
$
2015-08-07
92
91
1712111
427
3.9
37
3
The Vatican Tapes
7
4
[{'publication': 'Slant Magazine', 'review_dat...
[{'total_reactions': 2, 'neg_reactions': 0, 'u...
37
The Vatican Tapes
2
2015-07-31
321464
$
4.6
8336
NaN
NaN
NaN
57
2015
4.4
4.5
4.8
5.1
4.7
4.6
4.7
5.0
6.5
NaN
4.6
4.5
4.4
4.5
4.8
4.7
4.5
4.3
4.7
2466.0
3110.0
842.0
29.0
1552.0
732.0
576.0
126.0
9.0
NaN
8336.0
5229.0
1710.0
2490.0
702.0
20.0
3853.0
123.0
1002.0
700
350
610
995
1469
1764
1272
693
331
152
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
1
0
41.454545
6.500000
161
1247.750000
23000000.0
$
2015-04-03
119
101
64460211
3003
3.0
35
30
The Wedding Ringer
101
44
[{'publication': 'Charlotte Observer', 'review...
[{'total_reactions': 2, 'neg_reactions': 0, 'u...
35
The Wedding Ringer
12
2015-01-16
24500000
$
6.7
57447
16.0
January
2015.0
113
2015
6.8
6.5
6.3
7.2
6.7
6.8
6.6
6.5
7.8
6.7
6.7
6.6
6.8
6.5
6.3
7.0
6.6
5.5
6.5
23475.0
16889.0
2990.0
302.0
10215.0
5809.0
2912.0
552.0
90.0
3.0
57447.0
36324.0
17402.0
13791.0
2383.0
210.0
25106.0
254.0
7941.0
766
4738
484
969
1842
4722
12384
18012
9797
3733
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
38.600000
6.000000
162
479.571429
15000000.0
$
2015-03-13
179
98
26496583
2602
4.4
42
37
The Woman in Black 2: Angel of Death
23
11
[{'publication': 'The Guardian', 'review_date'...
[{'total_reactions': 3, 'neg_reactions': 0, 'u...
42
The Woman in Black 2: Angel of Death
7
2015-01-02
15027415
$
4.9
21014
2.0
January
2015.0
112
2014
5.0
4.7
4.9
5.8
5.0
5.1
4.9
5.1
6.4
4.0
4.9
4.8
4.9
4.7
4.8
5.6
4.8
4.5
4.7
8117.0
6360.0
1637.0
154.0
4423.0
2510.0
1275.0
279.0
49.0
1.0
21014.0
12811.0
5513.0
5004.0
1329.0
104.0
9676.0
220.0
2676.0
1071
943
1112
2027
3626
5042
3887
2075
874
357
0
0
0
0
0
0
0
1
0
0
0
1
0
0
0
0
0
0
1
0
50.153846
4.000000
163
2868.000000
19800000.0
$
2014-11-28
158
103
34290142
2868
6.4
44
35
This Is Where I Leave You
7
40
[{'publication': 'ReelViews', 'review_date': d...
[{'total_reactions': 2, 'neg_reactions': 0, 'u...
44
This Is Where I Leave You
1
2014-09-19
11558149
$
6.6
57611
19.0
September
2014.0
150
2014
6.7
6.5
6.6
7.2
6.8
6.8
6.7
6.9
7.4
7.8
6.6
6.5
6.6
6.4
6.5
7.0
6.5
5.7
6.7
20592.0
19541.0
5470.0
153.0
15573.0
7454.0
5425.0
1499.0
66.0
16.0
57611.0
32485.0
12879.0
13831.0
3882.0
82.0
24922.0
298.0
11423.0
735
3139
518
901
2102
5357
13084
18191
10071
3513
0
0
0
0
1
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
48.891892
6.000000
164
1404.666667
190000000.0
$
2015-09-11
450
130
93417865
3972
6.4
60
169
Tomorrowland
47
236
[{'publication': 'Village Voice', 'review_date...
[{'total_reactions': 5, 'neg_reactions': 0, 'u...
60
Tomorrowland
12
2015-05-22
32972000
$
6.5
138757
22.0
May
2015.0
511
2015
6.5
6.4
6.5
6.9
6.5
6.5
6.4
6.5
7.2
6.2
6.5
6.5
6.5
6.4
6.5
6.8
6.4
6.0
6.5
47744.0
46126.0
11652.0
961.0
20420.0
10397.0
6395.0
1697.0
328.0
14.0
138757.0
91910.0
36754.0
38983.0
9737.0
623.0
64367.0
474.0
17603.0
2343
8053
1656
2838
6341
16091
35115
39273
19727
7320
1
1
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
63.977273
5.714286
165
1488.833333
35000000.0
$
2015-10-09
344
125
110008260
3171
5.6
75
77
Trainwreck
113
184
[{'publication': 'New York Post', 'review_date...
[{'total_reactions': 5, 'neg_reactions': 0, 'u...
75
Trainwreck
12
2015-07-17
30097040
$
6.3
103115
17.0
July
2015.0
322
2015
6.4
6.2
6.3
6.6
6.5
6.4
6.5
6.5
6.8
7.4
6.3
6.2
6.3
6.1
6.2
6.5
6.1
5.8
6.6
36550.0
33877.0
8124.0
369.0
25202.0
13402.0
8059.0
1748.0
156.0
27.0
103115.0
57824.0
22699.0
25327.0
6234.0
208.0
41169.0
434.0
22370.0
3939
4924
2137
3194
5823
12366
23780
27206
14589
5157
0
0
0
0
1
0
0
1
0
0
0
0
0
0
0
1
0
0
0
0
76.375000
5.750000
166
1560.500000
100000000.0
$
2014-06-13
363
119
23014504
3455
6.0
42
114
Transcendence
73
173
[{'publication': 'Chicago Sun-Times', 'review_...
[{'total_reactions': 27, 'neg_reactions': 9, '...
42
Transcendence
6
2014-04-18
10886386
$
6.3
181330
18.0
April
2014.0
471
2014
6.4
6.1
6.1
6.6
6.4
6.5
6.2
6.3
7.1
5.8
6.3
6.2
6.4
6.1
6.1
6.4
6.2
5.5
6.0
67843.0
62614.0
12476.0
583.0
25593.0
13258.0
8436.0
1844.0
173.0
14.0
181330.0
125684.0
53854.0
53271.0
10403.0
406.0
90331.0
491.0
17374.0
3073
11081
2679
5169
10952
23735
44097
45753
24766
10025
0
0
0
0
0
0
0
1
0
0
0
0
0
0
1
1
0
0
0
0
48.000000
4.727273
167
449.000000
3000000.0
$
2014-11-07
262
102
1821983
449
6.1
55
30
Tusk
27
62
[{'publication': 'The Globe and Mail (Toronto)...
[{'total_reactions': 2, 'neg_reactions': 0, 'u...
55
Tusk
1
2014-09-19
846831
$
5.4
33795
19.0
September
2014.0
265
2014
5.5
5.3
5.2
5.6
5.1
5.0
5.1
5.3
5.8
6.7
5.4
5.4
5.6
5.4
5.2
5.5
5.3
4.9
5.6
11152.0
13809.0
2675.0
99.0
4481.0
2057.0
1766.0
383.0
14.0
3.0
33795.0
24256.0
8956.0
11862.0
2232.0
84.0
14875.0
300.0
7772.0
3147
1822
1781
2273
3337
5206
6678
5526
2970
1055
0
0
0
0
1
0
0
1
0
0
0
1
0
0
0
0
0
0
0
0
55.843750
3.500000
168
1423.000000
65000000.0
$
2015-03-06
327
137
115603980
3190
6.5
59
73
Unbroken
40
148
[{'publication': 'New York Daily News', 'revie...
[{'total_reactions': 4, 'neg_reactions': 0, 'u...
59
Unbroken
8
2014-12-26
31748000
$
7.2
111078
25.0
December
2014.0
368
2014
7.3
7.0
7.1
7.6
7.5
7.7
7.3
7.2
8.3
7.8
7.2
7.1
7.2
6.9
7.1
7.5
7.1
6.3
7.1
42045.0
31414.0
9431.0
658.0
18609.0
10046.0
4957.0
1757.0
197.0
8.0
111078.0
70725.0
31547.0
26033.0
7518.0
452.0
47320.0
377.0
15807.0
1341
11829
679
1036
2080
5589
15333
32414
28431
12346
0
0
0
1
0
0
0
1
0
0
0
0
0
0
0
0
0
1
0
0
62.809524
10.000000
169
1061.666667
35000000.0
$
2015-04-10
94
91
10214013
2777
4.1
32
16
Unfinished Business
24
12
[{'publication': 'The Globe and Mail (Toronto)...
[{'total_reactions': 4, 'neg_reactions': 1, 'u...
32
Unfinished Business
6
2015-03-06
4772613
$
5.4
24666
6.0
March
2015.0
90
2015
5.5
5.3
5.4
5.4
5.5
5.5
5.4
5.6
6.4
5.7
5.4
5.4
5.5
5.3
5.3
5.2
5.4
4.9
5.3
8716.0
8725.0
2000.0
119.0
3057.0
1502.0
1028.0
258.0
30.0
3.0
24666.0
17416.0
7113.0
7575.0
1712.0
89.0
11215.0
200.0
4363.0
895
865
843
1464
2920
5543
6721
3605
1361
449
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
37.000000
6.000000
170
2359.000000
1000000.0
$
2015-05-14
277
83
31537320
2775
5.6
59
64
Unfriended
56
95
[{'publication': 'Slant Magazine', 'review_dat...
[{'total_reactions': 2, 'neg_reactions': 0, 'u...
59
Unfriended
4
2015-04-17
15845115
$
5.6
48799
17.0
April
2015.0
317
2014
5.7
5.6
5.3
6.1
5.5
5.6
5.5
5.3
6.3
6.4
5.6
5.7
5.8
5.6
5.3
6.0
5.7
4.9
5.6
20764.0
13147.0
2682.0
538.0
8743.0
5242.0
2235.0
469.0
190.0
5.0
48799.0
30338.0
15292.0
10736.0
2164.0
344.0
20812.0
286.0
7668.0
3227
2689
2016
2798
4346
7698
11196
9065
4321
1443
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
60.357143
5.200000
171
750.250000
30000000.0
$
2014-04-04
137
104
7791146
2676
5.8
30
21
Vampire Academy
44
63
[{'publication': 'Village Voice', 'review_date...
[{'total_reactions': 2, 'neg_reactions': 0, 'u...
30
Vampire Academy
8
2014-02-07
3921742
$
5.6
43335
7.0
February
2014.0
226
2014
5.8
5.1
5.2
6.9
6.1
6.2
5.8
5.9
7.4
7.0
5.6
5.0
5.2
4.8
5.0
5.5
5.3
4.4
5.5
19848.0
10284.0
2138.0
533.0
19320.0
12797.0
3988.0
592.0
435.0
3.0
43335.0
15385.0
6826.0
6179.0
1511.0
94.0
17710.0
255.0
5805.0
2521
7202
1772
2541
3844
5986
7257
6083
3926
2203
1
0
0
0
1
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
34.444444
5.666667
172
160.000000
6000000.0
$
2014-04-18
181
107
3319109
347
7.6
62
25
Veronica Mars
13
94
[{'publication': 'RogerEbert.com', 'review_dat...
[{'total_reactions': 1, 'neg_reactions': 0, 'u...
62
Veronica Mars
6
2014-03-14
1988351
$
6.8
42997
NaN
NaN
NaN
134
2014
7.1
6.6
6.4
7.2
7.5
7.6
7.4
7.2
7.5
6.4
6.8
6.5
6.8
6.3
6.2
6.8
6.6
6.2
7.2
15377.0
15976.0
3956.0
69.0
13859.0
7329.0
4787.0
903.0
36.0
8.0
42997.0
22807.0
7875.0
10988.0
2995.0
32.0
20944.0
306.0
8027.0
915
6683
527
837
1640
3639
7570
9851
7231
4104
0
0
0
0
0
1
0
1
0
0
0
0
0
0
1
0
0
0
0
0
65.156250
9.000000
173
1688.285714
40000000.0
$
2015-12-25
173
110
5773519
2797
5.4
36
34
Victor Frankenstein
22
34
[{'publication': 'Empire', 'review_date': date...
[{'total_reactions': 1, 'neg_reactions': 0, 'u...
36
Victor Frankenstein
7
2015-11-27
2350000
$
6.0
35858
25.0
November
2015.0
110
2015
6.1
5.8
6.0
6.4
6.2
6.3
6.1
6.3
6.8
6.6
6.0
5.9
6.0
5.8
6.0
6.3
5.9
5.4
6.0
12409.0
11953.0
2927.0
155.0
6753.0
3518.0
2189.0
502.0
49.0
5.0
35858.0
22140.0
8728.0
9590.0
2369.0
106.0
17083.0
256.0
3832.0
604
1643
575
1134
2541
5905
10784
8119
3405
1148
0
0
0
0
0
0
0
1
0
0
0
1
0
0
0
0
1
0
0
0
38.038462
7.500000
174
51.000000
NaN
NaN
2014-05-02
75
95
39751
51
4.8
25
22
Walk of Shame
19
18
[{'publication': 'Film.com', 'review_date': da...
[{'total_reactions': 5, 'neg_reactions': 2, 'u...
25
Walk of Shame
1
2014-05-02
39751
$
6.0
42562
NaN
NaN
NaN
70
2014
6.1
5.8
6.0
7.1
6.3
6.4
6.1
6.1
7.3
6.2
6.0
5.9
6.0
5.8
6.0
6.8
5.9
5.4
5.9
17031.0
14814.0
2929.0
162.0
11703.0
7058.0
3354.0
495.0
94.0
8.0
42562.0
24649.0
9756.0
11245.0
2375.0
66.0
22592.0
261.0
4774.0
907
2473
811
1493
3040
6615
11757
9653
4230
1583
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
32.571429
NaN
175
328.333333
NaN
NaN
2015-06-19
152
103
400295
910
7.7
72
3
When Marnie Was There
8
62
[{'publication': 'Washington Post', 'review_da...
[{'total_reactions': 3, 'neg_reactions': 0, 'u...
72
When Marnie Was There
3
2015-05-29
40282
$
7.8
16201
NaN
NaN
NaN
54
2014
7.9
7.6
7.7
8.2
7.8
7.9
7.7
8.0
8.5
7.5
7.8
7.7
7.8
7.6
7.6
8.0
7.7
6.8
7.7
7142.0
4543.0
926.0
107.0
3563.0
2238.0
934.0
157.0
46.0
5.0
16201.0
9614.0
4810.0
3552.0
748.0
60.0
8403.0
155.0
1828.0
85
2458
35
72
160
422
1383
3744
4938
2904
0
0
1
0
0
0
0
1
1
0
0
0
0
0
0
0
0
0
0
0
72.857143
7.000000
176
318.500000
3300000.0
$
2015-03-27
544
107
13092000
567
8.9
88
41
Whiplash
36
1031
[{'publication': 'Total Film', 'review_date': ...
[{'total_reactions': 41, 'neg_reactions': 5, '...
88
Whiplash
8
2014-10-10
135388
$
8.5
456446
NaN
NaN
NaN
791
2014
8.6
8.3
8.1
9.1
8.4
8.5
8.2
8.2
8.9
8.8
8.5
8.5
8.7
8.3
8.1
9.1
8.4
7.9
8.6
196858.0
114083.0
21350.0
3045.0
66421.0
39712.0
17492.0
3504.0
691.0
55.0
456446.0
290221.0
155138.0
94885.0
17430.0
2332.0
201486.0
573.0
46451.0
2502
102630
1101
1666
2671
5497
15200
51706
123008
150465
0
0
0
0
0
0
0
1
0
0
0
0
1
0
0
0
0
0
0
0
87.857143
9.333333
177
115.250000
15000000.0
$
2015-05-01
353
115
37877959
505
7.1
76
42
Wild
15
138
[{'publication': 'New Orleans Times-Picayune',...
[{'total_reactions': 3, 'neg_reactions': 0, 'u...
76
Wild
12
2014-12-05
606810
$
7.1
93033
19.0
December
2014.0
258
2014
7.3
7.0
7.1
7.4
7.4
7.5
7.3
7.3
7.6
7.7
7.1
7.1
7.2
7.0
7.0
7.3
7.1
6.6
7.2
33107.0
31820.0
9056.0
225.0
22923.0
11717.0
7596.0
2013.0
74.0
15.0
93033.0
54644.0
21020.0
23749.0
6894.0
149.0
45828.0
397.0
13191.0
927
5456
486
842
1690
4819
14006
31428
24453
8926
0
1
0
1
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
75.764706
8.500000
178
410.500000
6000000.0
$
2014-09-05
148
106
3588432
753
7.5
43
18
Wish I Was Here
5
55
[{'publication': 'Hitfix', 'review_date': date...
[{'total_reactions': 1, 'neg_reactions': 0, 'u...
43
Wish I Was Here
2
2014-07-18
484401
$
6.7
31065
25.0
July
2014.0
95
2014
6.8
6.5
6.5
7.3
6.8
6.9
6.7
6.8
7.0
7.5
6.7
6.6
6.8
6.5
6.4
7.2
6.6
5.7
6.7
12185.0
10939.0
2196.0
53.0
6414.0
3377.0
2162.0
456.0
20.0
2.0
31065.0
19856.0
8635.0
8605.0
1692.0
32.0
15683.0
195.0
4906.0
608
2513
333
483
1190
2713
6069
8953
5728
2475
0
0
0
0
1
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
48.375000
NaN
179
723.214286
11000000.0
$
2015-08-07
206
109
33305037
2011
7.2
51
25
Woman in Gold
8
65
[{'publication': 'New York Observer', 'review_...
[{'total_reactions': 11, 'neg_reactions': 0, '...
51
Woman in Gold
14
2015-04-03
2091551
$
7.3
37995
10.0
April
2015.0
157
2015
7.4
7.2
7.5
7.8
7.6
7.7
7.5
7.8
8.1
7.4
7.3
7.2
7.2
7.1
7.4
7.6
7.2
6.2
7.4
10647.0
12575.0
6181.0
98.0
10674.0
4577.0
3610.0
1670.0
42.0
7.0
37995.0
20269.0
5922.0
8753.0
4409.0
54.0
17640.0
288.0
5520.0
419
3827
121
207
435
1338
4322
11037
11406
4883
0
0
0
1
0
0
0
1
0
0
1
0
0
0
0
0
0
0
0
0
55.200000
10.000000
180 rows × 99 columns
In [16]:
dataset_dir = holcrawl.shared._get_dataset_dir_path()
In [17]:
df = pd.read_csv(os.path.join(dataset_dir, 'movies_dataset.csv'))
In [18]:
pd.options.display.max_columns = 999
df.ix[0:2]
Out[18]:
avg_screens
budget
budget_currency
closing_date
critic_review_count
duration
gross_income
max_screens
mc_avg_user_score
mc_metascore
mc_mixed_rating_frequency
mc_movie_name
mc_negative_rating_frequency
mc_positive_rating_frequency
mc_pro_critic_reviews
mc_user_reviews
metascore
name
num_weekends
opening_weekend_date
opening_weekend_income
opening_weekend_income_currency
rating
rating_count
release_day
release_month
release_year
user_review_count
year
avg_rating_per_demo.aged_18-29
avg_rating_per_demo.aged_30-44
avg_rating_per_demo.aged_45+
avg_rating_per_demo.aged_under_18
avg_rating_per_demo.females
avg_rating_per_demo.females_aged_18-29
avg_rating_per_demo.females_aged_30-44
avg_rating_per_demo.females_aged_45+
avg_rating_per_demo.females_under_18
avg_rating_per_demo.imdb_staff
avg_rating_per_demo.imdb_users
avg_rating_per_demo.males
avg_rating_per_demo.males_aged_18-29
avg_rating_per_demo.males_aged_30-44
avg_rating_per_demo.males_aged_45+
avg_rating_per_demo.males_under_18
avg_rating_per_demo.non-us_users
avg_rating_per_demo.top_1000_voters
avg_rating_per_demo.us_users
votes_per_demo.aged_18-29
votes_per_demo.aged_30-44
votes_per_demo.aged_45+
votes_per_demo.aged_under_18
votes_per_demo.females
votes_per_demo.females_aged_18-29
votes_per_demo.females_aged_30-44
votes_per_demo.females_aged_45+
votes_per_demo.females_under_18
votes_per_demo.imdb_staff
votes_per_demo.imdb_users
votes_per_demo.males
votes_per_demo.males_aged_18-29
votes_per_demo.males_aged_30-44
votes_per_demo.males_aged_45+
votes_per_demo.males_under_18
votes_per_demo.non-us_users
votes_per_demo.top_1000_voters
votes_per_demo.us_users
rating_freq.1
rating_freq.10
rating_freq.2
rating_freq.3
rating_freq.4
rating_freq.5
rating_freq.6
rating_freq.7
rating_freq.8
rating_freq.9
genres.action
genres.adventure
genres.animation
genres.biography
genres.comedy
genres.crime
genres.documentary
genres.drama
genres.family
genres.fantasy
genres.history
genres.horror
genres.music
genres.musical
genres.mystery
genres.romance
genres.sci-fi
genres.sport
genres.thriller
genres.war
avg_mc_critic_by_opening
avg_mc_user_by_opening
0
45.000000
4000000.0
$
2014-04-18
94
93
9134
45
6.8
44
10
13 Sins
3
23
[{'critic': 'Christy Lemire', 'publication': '...
[{'total_reactions': 1, 'user': 'Tss5078', 'po...
44
13 Sins
1
2014-04-18
9134
$
6.3
25068
NaN
NaN
NaN
69
2014
6.4
6.2
6.3
7.3
6.4
6.5
6.3
6.5
7.6
7.0
6.3
6.3
6.4
6.2
6.3
7.3
6.2
5.8
6.4
8575.0
10068.0
2256.0
55.0
3968.0
1882.0
1525.0
325.0
11.0
4.0
25068.0
17778.0
6605.0
8426.0
1889.0
44.0
12964.0
230.0
3845.0
337
1254
280
544
1255
3351
6991
6984
3093
979
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
1
0
49.700000
NaN
1
2605.375000
50000000.0
$
2014-11-07
335
112
191616238
3426
8.1
71
81
22 Jump Street
42
621
[{'critic': 'Ty Burr', 'publication': 'Boston ...
[{'total_reactions': 1, 'user': 'travellyn', '...
71
22 Jump Street
8
2014-06-13
57071445
$
7.1
274236
13.0
June
2014.0
322
2014
7.3
6.7
6.3
7.9
7.1
7.3
6.8
6.4
8.2
6.1
7.1
7.0
7.3
6.7
6.3
7.8
6.9
6.2
7.2
128688.0
65135.0
9028.0
2267.0
40031.0
25654.0
8858.0
1383.0
620.0
16.0
274236.0
180467.0
101712.0
55439.0
7490.0
1628.0
119172.0
506.0
35147.0
2883
25688
1901
3165
6626
16774
43760
81836
64989
26614
1
0
0
0
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
72.844444
7.833333
2
1891.833333
110000000.0
$
2014-05-16
367
102
106369117
3490
6.0
48
179
300: Rise of an Empire
105
277
[{'critic': 'Richard Roeper', 'publication': '...
[{'total_reactions': 4, 'user': 'LXQUICKJUSTIC...
48
300: Rise of an Empire
12
2014-03-07
45038460
$
6.2
234420
7.0
March
2014.0
532
2014
6.3
6.1
6.1
6.7
6.3
6.3
6.2
6.2
6.8
6.3
6.2
6.2
6.3
6.1
6.1
6.7
6.1
5.7
6.2
95933.0
73988.0
11634.0
691.0
20214.0
10390.0
6941.0
1219.0
78.0
11.0
234420.0
174235.0
84680.0
66014.0
10209.0
610.0
110596.0
496.0
22633.0
10053
15924
4188
7262
13817
29217
53207
56500
31549
12703
1
0
0
0
0
0
0
1
0
1
0
0
0
0
0
0
0
0
0
0
49.833333
7.142857
In [ ]:
Content source: shaypal5/rotten_needles
Similar notebooks: