In [33]:
import pandas as pd
import matplotlib as plt
%matplotlib inline
In [2]:
df = pd.read_csv('mailchimp.csv')
In [4]:
df.columns
Out[4]:
Index([u'Title', u'Subject', u'List', u'Send Date', u'Send Weekday',
u'Total Recipients', u'Successful Deliveries', u'Soft Bounces',
u'Hard Bounces', u'Total Bounces', u'Times Forwarded',
u'Forwarded Opens', u'Unique Opens', u'Open Rate', u'Total Opens',
u'Unique Clicks', u'Click Rate', u'Total Clicks', u'Unsubscribes',
u'Abuse Complaints', u'Times Liked on Facebook', u'Folder Id',
u'Unique Id', u'Analytics ROI', u'Campaign Cost', u'Revenue Created',
u'Visits', u'New Visits', u'Pages/Visit', u'Bounce Rate',
u'Time on Site', u'Goal Conversion Rate', u'Per Visit Goal Value',
u'Transactions', u'Ecommerce Conversion Rate', u'Per Visit Value',
u'Average Value'],
dtype='object')
In [8]:
df[(df.List == 'Atlas Obscura') and (df['Unique Opens'] > 1000)]
---------------------------------------------------------------------------
ValueError Traceback (most recent call last)
<ipython-input-8-56d14f2c33b2> in <module>()
----> 1 df[(df.List == 'Atlas Obscura') and (df['Unique Opens'] > 1000)]
/Users/Mike/anaconda/lib/python2.7/site-packages/pandas/core/generic.pyc in __nonzero__(self)
885 raise ValueError("The truth value of a {0} is ambiguous. "
886 "Use a.empty, a.bool(), a.item(), a.any() or a.all()."
--> 887 .format(self.__class__.__name__))
888
889 __bool__ = __nonzero__
ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().
In [17]:
df = df[(df['Unique Opens'] > 1000)]
In [18]:
df = df[df['List']== 'Atlas Obscura']
In [19]:
df.head()
Out[19]:
Title
Subject
List
Send Date
Send Weekday
Total Recipients
Successful Deliveries
Soft Bounces
Hard Bounces
Total Bounces
...
New Visits
Pages/Visit
Bounce Rate
Time on Site
Goal Conversion Rate
Per Visit Goal Value
Transactions
Ecommerce Conversion Rate
Per Visit Value
Average Value
0
Newsletter 4/8/2016 | Winner
The Chinese Female Pirate Who Commanded 80,000...
Atlas Obscura
Apr 08, 2016 10:00 am
Friday
183746
183670
67
9
76
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
1
Newsletter 4/8/2016
NaN
Atlas Obscura
Apr 08, 2016 7:00 am
Friday
262493
262383
0
110
110
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
2
Newsletter 4/8/2016 | Combo 2
How Black Pepper Won Europe From a Better Pepper
Atlas Obscura
Apr 08, 2016 6:59 am
Friday
26249
26239
8
2
10
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
3
Newsletter 4/8/2016 | Combo 3
The Chinese Female Pirate Who Commanded 80,000...
Atlas Obscura
Apr 08, 2016 6:59 am
Friday
26249
26238
10
1
11
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
4
Newsletter 4/8/2016 | Combo 1
The Photos that Exposed American Child Labor
Atlas Obscura
Apr 08, 2016 6:59 am
Friday
26249
26236
10
3
13
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
5 rows × 37 columns
In [23]:
df['Open Rate'] = [x.split('%')[0] for x in df['Open Rate']]
In [ ]:
df['Open Rate']=df['Open Rate'].astype(float)
In [63]:
df['Click Rate'] = [x.split('%')[0] for x in df['Click Rate']]
df['Click Rate']=df['Click Rate'].astype(float)
In [29]:
df.dtypes
Out[29]:
Title object
Subject object
List object
Send Date object
Send Weekday object
Total Recipients int64
Successful Deliveries int64
Soft Bounces int64
Hard Bounces int64
Total Bounces int64
Times Forwarded int64
Forwarded Opens int64
Unique Opens int64
Open Rate float64
Total Opens int64
Unique Clicks int64
Click Rate object
Total Clicks int64
Unsubscribes int64
Abuse Complaints int64
Times Liked on Facebook int64
Folder Id int64
Unique Id object
Analytics ROI object
Campaign Cost object
Revenue Created object
Visits object
New Visits object
Pages/Visit object
Bounce Rate object
Time on Site object
Goal Conversion Rate object
Per Visit Goal Value object
Transactions object
Ecommerce Conversion Rate object
Per Visit Value object
Average Value object
dtype: object
In [36]:
plt.figure
Out[36]:
<module 'matplotlib.figure' from '/Users/Mike/anaconda/lib/python2.7/site-packages/matplotlib/figure.pyc'>
In [64]:
df.iloc[::-1].plot(x='Send Date',y='Click Rate',kind='line',figsize=(20,10),title = 'Open Rates since April')
Out[64]:
<matplotlib.axes._subplots.AxesSubplot at 0x11d6ef710>
In [59]:
df.iloc[::-1]
Out[59]:
Title
Subject
List
Send Date
Send Weekday
Total Recipients
Successful Deliveries
Soft Bounces
Hard Bounces
Total Bounces
...
New Visits
Pages/Visit
Bounce Rate
Time on Site
Goal Conversion Rate
Per Visit Goal Value
Transactions
Ecommerce Conversion Rate
Per Visit Value
Average Value
1970
2012/2013 AO Readership Survey
NaN
Atlas Obscura
Nov 19, 2012 6:31 pm
Monday
11479
11320
104
55
159
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
1902
Announcing Field Trip Days in Brooklyn and Lon...
Join us in Brooklyn and London for Field Trip ...
Atlas Obscura
Aug 08, 2013 4:22 pm
Thursday
11316
11012
126
178
304
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
1894
Announcing Field Trip Days in Los Angeles and ...
Join us! Field Trip Days in Los Angeles and Se...
Atlas Obscura
Sep 05, 2013 12:35 pm
Thursday
11089
10927
131
31
162
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
1800
One Off: Upcoming Adventures from Atlas Obscura
Upcoming Adventures from Atlas Obscura
Atlas Obscura
Mar 25, 2014 2:00 pm
Tuesday
25629
24998
175
456
631
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
1716
AB Live Email Test #1
NaN
Atlas Obscura
Aug 12, 2014 9:30 am
Tuesday
5497
5487
3
7
10
...
746
2.5066909975669
59.31%
02:57
9.06%
$0.00
0
0.00%
$0.00
$0.00
1713
Newsletter 8/15 AB Test
NaN
Atlas Obscura
Aug 15, 2014 9:30 am
Friday
10798
10739
19
40
59
...
888
3.0836909871245
57.30%
03:23
10.14%
$0.00
0
0.00%
$0.00
$0.00
1710
Newsletter 8/19
NaN
Atlas Obscura
Aug 19, 2014 9:30 am
Tuesday
36821
36122
355
344
699
...
2010
3.2188968587682
60.47%
03:28
9.28%
$0.00
0
0.00%
$0.00
$0.00
1708
Newsletter 8/22
NaN
Atlas Obscura
Aug 22, 2014 1:00 pm
Friday
36182
35791
364
27
391
...
1475
3.1052631578947
57.67%
03:42
8.48%
$0.00
0
0.00%
$0.00
$0.00
1705
8/26 Newsletter
NaN
Atlas Obscura
Aug 26, 2014 10:50 am
Tuesday
35935
35562
363
10
373
...
1214
2.5467494521549
60.30%
02:44
7.23%
$0.00
0
0.00%
$0.00
$0.00
1702
Newsletter 8/29
NaN
Atlas Obscura
Aug 29, 2014 8:30 am
Friday
35709
35331
361
17
378
...
1230
2.8897524467473
55.24%
03:50
5.67%
$0.00
0
0.00%
$0.00
$0.00
1701
Newsletter 9/1
NaN
Atlas Obscura
Sep 02, 2014 11:30 am
Tuesday
35517
35042
358
117
475
...
973
2.369144284822
59.74%
03:06
5.75%
$0.00
0
0.00%
$0.00
$0.00
1696
Newsletter 9/5
NaN
Atlas Obscura
Sep 05, 2014 3:00 pm
Friday
35279
34892
28
359
387
...
2855
2.053630847524
68.21%
02:16
4.05%
$0.00
0
0.00%
$0.00
$0.00
1695
Newsletter 9/8
NaN
Atlas Obscura
Sep 09, 2014 9:00 am
Tuesday
34825
34765
26
34
60
...
1625
2.2497918401332
63.28%
02:37
6.36%
$0.00
0
0.00%
$0.00
$0.00
1692
Newsletter 9/12
NaN
Atlas Obscura
Sep 12, 2014 9:00 am
Friday
37888
37844
26
18
44
...
1771
2.2244301578025
60.96%
03:02
4.46%
$0.00
0
0.00%
$0.00
$0.00
1690
Newsletter 9/16
NaN
Atlas Obscura
Sep 16, 2014 9:00 am
Tuesday
37836
37802
21
13
34
...
6133
1.8468555389878
72.77%
02:07
2.58%
$0.00
0
0.00%
$0.00
$0.00
1684
Newsletter 9/18
NaN
Atlas Obscura
Sep 19, 2014 8:45 am
Friday
37773
37744
15
14
29
...
1627
2.3061538461538
62.88%
03:03
4.15%
$0.00
0
0.00%
$0.00
$0.00
1681
Newsletter 9/22
NaN
Atlas Obscura
Sep 23, 2014 9:00 am
Tuesday
37761
37733
17
11
28
...
1495
2.3895408688491
57.13%
03:12
4.67%
$0.00
0
0.00%
$0.00
$0.00
1678
Newsletter 9/26
NaN
Atlas Obscura
Sep 26, 2014 9:00 am
Friday
37724
37697
22
5
27
...
1893
2.007731602927
62.67%
02:59
3.87%
$0.00
0
0.00%
$0.00
$0.00
1677
Newsletter 9/29
NaN
Atlas Obscura
Sep 30, 2014 9:00 am
Tuesday
37722
37687
21
14
35
...
1064
2.225819265144
55.00%
02:51
3.67%
$0.00
0
0.00%
$0.00
$0.00
1675
Newsletter 10/3
NaN
Atlas Obscura
Oct 03, 2014 10:16 am
Friday
37686
37654
22
10
32
...
1340
2.4087591240876
54.08%
03:40
4.09%
$0.00
0
0.00%
$0.00
$0.00
1674
Newsletter 10/7
NaN
Atlas Obscura
Oct 07, 2014 9:00 am
Tuesday
37645
37607
35
3
38
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
1670
Newsletter 10/10
NaN
Atlas Obscura
Oct 10, 2014 9:00 am
Friday
37659
37607
41
11
52
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
1667
Newsletter 10/14
NaN
Atlas Obscura
Oct 14, 2014 9:00 am
Tuesday
37676
37630
40
6
46
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
1661
Newsletter 10/15
NaN
Atlas Obscura
Oct 17, 2014 9:00 am
Friday
37686
37453
228
5
233
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
1659
Newsletter 10/21
NaN
Atlas Obscura
Oct 21, 2014 9:00 am
Tuesday
37700
37445
222
33
255
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
1656
Newsletter 10/24
NaN
Atlas Obscura
Oct 24, 2014 9:00 am
Friday
37732
37521
186
25
211
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
1653
Newsletter 10/28
NaN
Atlas Obscura
Oct 28, 2014 9:00 am
Tuesday
37950
37752
189
9
198
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
1650
Newsletter 10/31
NaN
Atlas Obscura
Oct 31, 2014 9:00 am
Friday
38171
37979
184
8
192
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
1648
Newsletter 11/4
NaN
Atlas Obscura
Nov 04, 2014 11:15 am
Tuesday
40457
40166
54
237
291
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
1645
Newsletter 10/7
NaN
Atlas Obscura
Nov 07, 2014 9:00 am
Friday
41359
41188
56
115
171
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
165
Newsletter 3/29/2016 | Combo 2
The Demonic Origins of Ventriloquism
Atlas Obscura
Mar 29, 2016 6:59 am
Tuesday
26066
26056
10
0
10
...
611
1.9939759036145
26.38%
03:51
0.09%
$0.00
0
0.00%
$0.00
$0.00
164
Newsletter 3/29/2016 | Combo 1
Stave Churches Are All Wood, Dragons, and Beauty
Atlas Obscura
Mar 29, 2016 6:59 am
Tuesday
26066
26050
13
3
16
...
615
1.8171378091873
28.49%
03:19
0.18%
$0.00
0
0.00%
$0.00
$0.00
163
Newsletter 3/29/2016 | Combo 3
Inside the Packed Showrooms of a Prolific Map ...
Atlas Obscura
Mar 29, 2016 6:59 am
Tuesday
26066
26050
14
2
16
...
553
1.9145613229215
26.09%
03:15
0.00%
$0.00
0
0.00%
$0.00
$0.00
162
Newsletter 3/29/2016
NaN
Atlas Obscura
Mar 29, 2016 7:00 am
Tuesday
260660
260528
0
132
132
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
157
Newsletter 3/29/2016 | Winner
Inside the Packed Showrooms of a Prolific Map ...
Atlas Obscura
Mar 29, 2016 10:00 am
Tuesday
182462
182372
76
14
90
...
4222
1.8659295550847
28.93%
03:06
0.07%
$0.00
0
0.00%
$0.00
$0.00
152
Newsletter 3/31/2016 (NYC)
Can an Outsider Ever Truly Become Amish?
Atlas Obscura
Mar 31, 2016 10:00 am
Thursday
13902
13895
7
0
7
...
312
1.6580125335721
30.89%
03:11
0.00%
$0.00
0
0.00%
$0.00
$0.00
151
Newsletter 3/31/2016
Can an Outsider Ever Truly Become Amish?
Atlas Obscura
Mar 31, 2016 10:00 am
Thursday
181299
181202
85
12
97
...
5675
1.7585832349469
31.68%
03:35
0.02%
$0.00
0
0.00%
$0.00
$0.00
138
Newsletter 4/1/2016 | Combo 3
The Cursed History of P.T. Barnum’s Museums
Atlas Obscura
Apr 01, 2016 6:59 am
Friday
26132
26111
19
2
21
...
1515
1.5596389426177
52.45%
02:21
0.00%
$0.00
0
0.00%
$0.00
$0.00
137
Newsletter 4/1/2016 | Combo 2
The World's Only LGBT Cemetery Section
Atlas Obscura
Apr 01, 2016 6:59 am
Friday
26132
26120
10
2
12
...
692
1.7763221737021
40.42%
03:09
0.10%
$0.00
0
0.00%
$0.00
$0.00
136
Newsletter 4/1/2016 | Combo 1
Where Should Robots Go When They Retire?
Atlas Obscura
Apr 01, 2016 6:59 am
Friday
26132
26117
13
2
15
...
410
2.1621943947525
37.15%
04:01
0.00%
$0.00
0
0.00%
$0.00
$0.00
135
Newsletter 4/1/2016
NaN
Atlas Obscura
Apr 01, 2016 7:00 am
Friday
261322
261170
0
152
152
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
130
Newsletter 4/1/2016 | Winner
The World's Only LGBT Cemetery Section
Atlas Obscura
Apr 01, 2016 10:00 am
Friday
182926
182822
83
21
104
...
4468
1.8284971545001
39.25%
03:15
0.09%
$0.00
0
0.00%
$0.00
$0.00
125
Newsletter 4/4/2016 | Combo 3
Wizards, Warriors, and the Quest for LARP Insu...
Atlas Obscura
Apr 04, 2016 6:59 am
Monday
26202
26180
15
7
22
...
545
1.8768656716418
29.48%
03:09
0.11%
$0.00
0
0.00%
$0.00
$0.00
124
Newsletter 4/4/2016 | Combo 2
Why Do We Even Have Toes?
Atlas Obscura
Apr 04, 2016 6:59 am
Monday
26203
26185
16
2
18
...
637
1.6966126656848
29.46%
03:09
0.00%
$0.00
0
0.00%
$0.00
$0.00
123
Newsletter 4/4/2016 | Combo 1
The First Popular Text About Birth Control
Atlas Obscura
Apr 04, 2016 6:59 am
Monday
26203
26186
14
3
17
...
471
1.846615720524
27.18%
03:16
0.05%
$0.00
0
0.00%
$0.00
$0.00
122
Newsletter 4/4/2016
NaN
Atlas Obscura
Apr 04, 2016 7:00 am
Monday
262028
261854
0
174
174
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
121
Newsletter 4/4/2016 | Winner
The First Popular Text About Birth Control
Atlas Obscura
Apr 04, 2016 9:59 am
Monday
183420
183303
90
27
117
...
5137
1.7168470681984
28.25%
02:59
0.07%
$0.00
0
0.00%
$0.00
$0.00
112
Newsletter 4/5/2016 | Combo 2
Lose Yourself in this Atlas of the World's Los...
Atlas Obscura
Apr 05, 2016 6:59 am
Tuesday
26197
26151
44
2
46
...
318
1.8042813455657
38.38%
03:26
0.08%
$0.00
0
0.00%
$0.00
$0.00
111
Newsletter 4/5/2016 | Combo 1
Buried Somewhere in the Catskills is a Stash o...
Atlas Obscura
Apr 05, 2016 6:59 am
Tuesday
26198
26125
70
3
73
...
433
1.8157099697885
39.34%
03:23
0.06%
$0.00
0
0.00%
$0.00
$0.00
110
Newsletter 4/5/2016
NaN
Atlas Obscura
Apr 05, 2016 7:00 am
Tuesday
261976
261764
0
212
212
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
105
Newsletter 4/5/2016 | Winner
Buried Somewhere in the Catskills is a Stash o...
Atlas Obscura
Apr 05, 2016 10:00 am
Tuesday
209581
209488
72
21
93
...
3653
1.7392712550607
41.36%
03:05
0.08%
$0.00
0
0.00%
$0.00
$0.00
28
Newsletter 4/7/2016 | Combo 1
The Asymmetrical Charm of Crooked Houses
Atlas Obscura
Apr 07, 2016 6:59 am
Thursday
26237
26227
8
2
10
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
27
Newsletter 4/7/2016 | Combo 2
The Man Who Recorded and Sold Nature Sounds to...
Atlas Obscura
Apr 07, 2016 6:59 am
Thursday
26237
26220
13
4
17
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
26
Newsletter 4/7/2016
NaN
Atlas Obscura
Apr 07, 2016 7:00 am
Thursday
262373
262251
0
122
122
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
21
Newsletter 4/7/2016 | Winner
The Man Who Recorded and Sold Nature Sounds to...
Atlas Obscura
Apr 07, 2016 9:59 am
Thursday
209899
209804
77
18
95
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
4
Newsletter 4/8/2016 | Combo 1
The Photos that Exposed American Child Labor
Atlas Obscura
Apr 08, 2016 6:59 am
Friday
26249
26236
10
3
13
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
3
Newsletter 4/8/2016 | Combo 3
The Chinese Female Pirate Who Commanded 80,000...
Atlas Obscura
Apr 08, 2016 6:59 am
Friday
26249
26238
10
1
11
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
2
Newsletter 4/8/2016 | Combo 2
How Black Pepper Won Europe From a Better Pepper
Atlas Obscura
Apr 08, 2016 6:59 am
Friday
26249
26239
8
2
10
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
1
Newsletter 4/8/2016
NaN
Atlas Obscura
Apr 08, 2016 7:00 am
Friday
262493
262383
0
110
110
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
0
Newsletter 4/8/2016 | Winner
The Chinese Female Pirate Who Commanded 80,000...
Atlas Obscura
Apr 08, 2016 10:00 am
Friday
183746
183670
67
9
76
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
584 rows × 37 columns
In [52]:
df.dtypes
Out[52]:
Title object
Subject object
List object
Send Date object
Send Weekday object
Total Recipients int64
Successful Deliveries int64
Soft Bounces int64
Hard Bounces int64
Total Bounces int64
Times Forwarded int64
Forwarded Opens int64
Unique Opens int64
Open Rate float64
Total Opens int64
Unique Clicks int64
Click Rate object
Total Clicks int64
Unsubscribes int64
Abuse Complaints int64
Times Liked on Facebook int64
Folder Id int64
Unique Id object
Analytics ROI object
Campaign Cost object
Revenue Created object
Visits object
New Visits object
Pages/Visit object
Bounce Rate object
Time on Site object
Goal Conversion Rate object
Per Visit Goal Value object
Transactions object
Ecommerce Conversion Rate object
Per Visit Value object
Average Value object
dtype: object
In [68]:
eric = pd.read_csv('atlas/eric-traffic.csv')
In [72]:
eric_sum = pd.DataFrame(eric.sum())
In [73]:
eric_sum.head()
Out[73]:
0
Unnamed: 0
405450.0
articles/10-little-known-beaches-to-explore-in-the-last-days-of-summer
944.0
articles/360-degrees-of-war-6-cycloramas-that-make-you-a-part-of-the-action
1629.0
articles/7-dubai-locations-that-defy-their-desert-setting
14080.0
articles/7-of-americas-smallest-civic-institutions
6086.0
In [77]:
eric = eric.drop('Unnamed: 0',axis=1)
In [78]:
eric_sum=pd.DataFrame(eric.sum())
In [83]:
eric_sum.sort_values(0,ascending=False,inplace=True)
In [86]:
eric_sum.reset_index(inplace=True)
In [93]:
eric_sum.columns = ['url','PVs']
In [106]:
eric_sum[eric_sum.url.str.contains('articles/')][0:30]
Out[106]:
url
PVs
0
articles/how-miracle-max-nearly-shut-down-the-...
345763.0
3
articles/the-ao-exit-interview-12-years-in-the...
159547.0
4
articles/step-up-2-nature-8-staircases-that-ma...
119212.0
5
articles/how-advertising-invented-8-phrases-we...
80342.0
6
articles/everything-youve-ever-wanted-to-know-...
75556.0
7
articles/forgotten-wonders-of-the-digital-worl...
74785.0
10
articles/a-burial-machine-that-will-freeze-you...
56548.0
11
articles/the-hollow-earth-is-filled-with-giant...
49950.0
12
articles/the-1980s-media-panic-over-dungeons-d...
48864.0
14
articles/tumblrs-newest-target-is-jon-arbuckle...
40652.0
15
articles/the-1980s-book-series-that-literally-...
40103.0
16
articles/mermaids-are-real-7-places-where-you-...
37726.0
18
articles/the-secret-rooms-that-were-custom-bui...
34477.0
20
articles/the-ramree-island-massacre
32948.0
21
articles/the-atlas-obscura-guide-to-ruins-of-s...
30641.0
22
articles/forgotten-wonders-of-the-digital-worl...
27131.0
23
articles/the-virgin-rainbow-the-worlds-finest-...
26715.0
29
articles/beauty-in-the-wreckage-7-of-the-lovel...
23467.0
30
articles/what-it-was-like-to-seek-asylum-in-me...
23173.0
31
articles/the-doomed-effort-to-make-videos-go-v...
22238.0
34
articles/livin-on-the-edge-the-precarious-arch...
21499.0
37
articles/hidden-wonders-of-the-digital-world-l...
18947.0
38
articles/flight-of-the-night-witches-wwii-s-al...
18882.0
39
articles/the-ten-trials-of-the-master-bladesmith
18814.0
40
articles/essential-guide-to-bars-at-the-end-of...
18805.0
41
articles/the-quest-for-the-reallife-treasures-...
18352.0
42
articles/how-book-designers-around-the-world-i...
18194.0
44
articles/the-most-viewed-file-in-the-fbis-vaul...
16873.0
47
articles/the-silver-arrow-the-real-ghost-train...
15618.0
48
articles/essential-guide-to-living-lovecraft
15229.0
In [107]:
eric_sum[0:30]
Out[107]:
url
PVs
0
articles/how-miracle-max-nearly-shut-down-the-...
345763.0
1
places/nishiyama-onsen-keiunkan
342642.0
2
places/gustav-eiffel-s-secret-apartment
305873.0
3
articles/the-ao-exit-interview-12-years-in-the...
159547.0
4
articles/step-up-2-nature-8-staircases-that-ma...
119212.0
5
articles/how-advertising-invented-8-phrases-we...
80342.0
6
articles/everything-youve-ever-wanted-to-know-...
75556.0
7
articles/forgotten-wonders-of-the-digital-worl...
74785.0
8
places/the-museum-of-alchemists-and-magicians-...
63110.0
9
places/the-tree-goats-of-morocco
58469.0
10
articles/a-burial-machine-that-will-freeze-you...
56548.0
11
articles/the-hollow-earth-is-filled-with-giant...
49950.0
12
articles/the-1980s-media-panic-over-dungeons-d...
48864.0
13
places/sidu-river-bridge
46627.0
14
articles/tumblrs-newest-target-is-jon-arbuckle...
40652.0
15
articles/the-1980s-book-series-that-literally-...
40103.0
16
articles/mermaids-are-real-7-places-where-you-...
37726.0
17
places/zao-fox-village
35961.0
18
articles/the-secret-rooms-that-were-custom-bui...
34477.0
19
places/mumtaz-begum
34319.0
20
articles/the-ramree-island-massacre
32948.0
21
articles/the-atlas-obscura-guide-to-ruins-of-s...
30641.0
22
articles/forgotten-wonders-of-the-digital-worl...
27131.0
23
articles/the-virgin-rainbow-the-worlds-finest-...
26715.0
24
places/daksa-island
25943.0
25
places/the-lonely-castle
25672.0
26
places/the-fugitive-train-wreck
24312.0
27
places/the-warren-s-occult-museum
24282.0
28
places/baldwin-street
23930.0
29
articles/beauty-in-the-wreckage-7-of-the-lovel...
23467.0
In [ ]:
Content source: facemelters/data-science
Similar notebooks: