Resorting the Top 200 2: User Usage Weighted Mean
What if users who use the site more counted more towards album ratings? I scraped the Top 200 from the charts tab of the site, and scraped user data (# of comments, lists, ratings, reviews) from each user who rated the particular albums. Then I calculated 4 weighted means of the rating for each album by the number of ratings, comments, reviews, and lists; weights determined by the square root of each user usage value (if a user had 1000 comments, their weight was 10). A weighted average of these means was then calculated. I, subjectively, Rachel Ray’d it and gave a weight of 3 for the number of reviews, 2 for the number of lists, 1 for comments, and 1 for number of ratings (essentially, I valued how many reviews a user had as more relevant to user usage, than comments, lists, or ratings). From there, I calculated the lower bound of the 95% credible interval (as described in my previous lists) as the metric for sorting. The lower bound of the 95% credible interval takes into account ratings as well as how many ratings a particular album had. Limitations: (1) some albums had duplicate ratings so I removed them, (2) I had to throw out any ratins that didn’t have a date because I couldn’t trust that I scraped their user data properly (this is because they randomly shuffle sometimes when you refresh a soundoff page… because I couldn’t figure out a way to get external links and scrape the table in parallel, sometimes those ratings and their user pages get out of synch). This means I am missing some ratings. Displayed is the number of ratings that I counted, mean rating of those ratings, the user adjusted weighted mean I came up with, the 95% credible interval, the old rank as the sputnik would have calculated it, and the new rank. Because of list limitations, I present top 1 to 50 and 101. Rec albums that are not in the top 200 and I'll see if they can make it into the top 101. |
1 | | Pink Floyd Wish You Were Here
Number of Ratings: 4837
Mean Rating: 4.646
User Usage Weighted Mean: 4.597
95% Credible Interval: 4.564 - 4.629
New Rank: 1
Original Rank: 2 |
2 | | Ludwig van Beethoven Symphony No. 9 in D minor, Op. 125
Number of Ratings: 368
Mean Rating: 4.662
User Usage Weighted Mean: 4.641
95% Credible Interval: 4.517 - 4.742
New Rank: 2
Original Rank: 1 |
3 | | Pink Floyd Animals
Number of Ratings: 3750
Mean Rating: 4.523
User Usage Weighted Mean: 4.533
95% Credible Interval: 4.493 - 4.571
New Rank: 3
Original Rank: 23 |
4 | | Wu-Tang Clan Enter the Wu-Tang (36 Chambers)
Number of Ratings: 2538
Mean Rating: 4.613
User Usage Weighted Mean: 4.542
95% Credible Interval: 4.493 - 4.587
New Rank: 4
Original Rank: 4 |
5 | | John Coltrane A Love Supreme
Number of Ratings: 1065
Mean Rating: 4.607
User Usage Weighted Mean: 4.542
95% Credible Interval: 4.466 - 4.612
New Rank: 5
Original Rank: 6 |
6 | | Nas Illmatic
Number of Ratings: 2616
Mean Rating: 4.611
User Usage Weighted Mean: 4.507
95% Credible Interval: 4.458 - 4.554
New Rank: 6
Original Rank: 5 |
7 | | Pink Floyd The Dark Side of the Moon
Number of Ratings: 5601
Mean Rating: 4.579
User Usage Weighted Mean: 4.491
95% Credible Interval: 4.457 - 4.524
New Rank: 7
Original Rank: 11 |
8 | | GZA Liquid Swords
Number of Ratings: 1540
Mean Rating: 4.575
User Usage Weighted Mean: 4.52
95% Credible Interval: 4.456 - 4.58
New Rank: 8
Original Rank: 12 |
9 | | Miles Davis Kind of Blue
Number of Ratings: 1754
Mean Rating: 4.618
User Usage Weighted Mean: 4.508
95% Credible Interval: 4.447 - 4.564
New Rank: 9
Original Rank: 3 |
10 | | Charles Mingus The Black Saint and the Sinner Lady
Number of Ratings: 730
Mean Rating: 4.6
User Usage Weighted Mean: 4.535
95% Credible Interval: 4.44 - 4.618
New Rank: 10
Original Rank: 7 |
11 | | King Crimson In the Court of the Crimson King
Number of Ratings: 2964
Mean Rating: 4.575
User Usage Weighted Mean: 4.486
95% Credible Interval: 4.439 - 4.531
New Rank: 11
Original Rank: 13 |
12 | | Black Sabbath Paranoid
Number of Ratings: 3403
Mean Rating: 4.538
User Usage Weighted Mean: 4.482
95% Credible Interval: 4.437 - 4.524
New Rank: 12
Original Rank: 19 |
13 | | Megadeth Rust in Peace
Number of Ratings: 4064
Mean Rating: 4.581
User Usage Weighted Mean: 4.476
95% Credible Interval: 4.435 - 4.515
New Rank: 13
Original Rank: 10 |
14 | | David Bowie The Rise and Fall of Ziggy Stardust...
Number of Ratings: 1768
Mean Rating: 4.563
User Usage Weighted Mean: 4.494
95% Credible Interval: 4.432 - 4.551
New Rank: 14
Original Rank: 16 |
15 | | The Beatles Abbey Road
Number of Ratings: 3452
Mean Rating: 4.585
User Usage Weighted Mean: 4.472
95% Credible Interval: 4.428 - 4.514
New Rank: 15
Original Rank: 9 |
16 | | Sergei Rachmaninoff Piano Concerto No. 2 in C minor, Op. 18
Number of Ratings: 96
Mean Rating: 4.505
User Usage Weighted Mean: 4.685
95% Credible Interval: 4.426 - 4.855
New Rank: 16
Original Rank: 35 |
17 | | Death Symbolic
Number of Ratings: 2833
Mean Rating: 4.536
User Usage Weighted Mean: 4.471
95% Credible Interval: 4.422 - 4.518
New Rank: 17
Original Rank: 20 |
18 | | Yes Close to the Edge
Number of Ratings: 1701
Mean Rating: 4.566
User Usage Weighted Mean: 4.484
95% Credible Interval: 4.421 - 4.543
New Rank: 18
Original Rank: 15 |
19 | | Godspeed You! Black Emperor F#A# (Infinity)
Number of Ratings: 2901
Mean Rating: 4.512
User Usage Weighted Mean: 4.46
95% Credible Interval: 4.412 - 4.507
New Rank: 19
Original Rank: 27 |
20 | | The Jimi Hendrix Experience Are You Experienced
Number of Ratings: 817
Mean Rating: 4.589
User Usage Weighted Mean: 4.502
95% Credible Interval: 4.411 - 4.584
New Rank: 20
Original Rank: 8 |
21 | | Godspeed You! Black Emperor Slow Riot For New Zero Kanada
Number of Ratings: 1805
Mean Rating: 4.489
User Usage Weighted Mean: 4.465
95% Credible Interval: 4.403 - 4.523
New Rank: 21
Original Rank: 44 |
22 | | DJ Shadow Endtroducing...
Number of Ratings: 1837
Mean Rating: 4.519
User Usage Weighted Mean: 4.462
95% Credible Interval: 4.4 - 4.52
New Rank: 22
Original Rank: 25 |
23 | | Elliott Smith Either/Or
Number of Ratings: 1649
Mean Rating: 4.505
User Usage Weighted Mean: 4.462
95% Credible Interval: 4.396 - 4.523
New Rank: 23
Original Rank: 34 |
24 | | Radiohead OK Computer
Number of Ratings: 6594
Mean Rating: 4.571
User Usage Weighted Mean: 4.428
95% Credible Interval: 4.395 - 4.46
New Rank: 24
Original Rank: 14 |
25 | | Godspeed You! Black Emperor Lift Your Skinny Fists Like Antennas to Heaven
Number of Ratings: 2986
Mean Rating: 4.509
User Usage Weighted Mean: 4.436
95% Credible Interval: 4.387 - 4.483
New Rank: 25
Original Rank: 31 |
26 | | Led Zeppelin Led Zeppelin IV
Number of Ratings: 3579
Mean Rating: 4.544
User Usage Weighted Mean: 4.431
95% Credible Interval: 4.386 - 4.474
New Rank: 26
Original Rank: 17 |
27 | | Black Sabbath Master of Reality
Number of Ratings: 2452
Mean Rating: 4.471
User Usage Weighted Mean: 4.435
95% Credible Interval: 4.381 - 4.487
New Rank: 27
Original Rank: 59 |
28 | | Camel Mirage
Number of Ratings: 904
Mean Rating: 4.511
User Usage Weighted Mean: 4.467
95% Credible Interval: 4.378 - 4.547
New Rank: 28
Original Rank: 30 |
29 | | Kate Bush Hounds of Love
Number of Ratings: 687
Mean Rating: 4.464
User Usage Weighted Mean: 4.479
95% Credible Interval: 4.377 - 4.57
New Rank: 29
Original Rank: 68 |
30 | | The Cure Disintegration
Number of Ratings: 1829
Mean Rating: 4.502
User Usage Weighted Mean: 4.44
95% Credible Interval: 4.377 - 4.499
New Rank: 30
Original Rank: 36 |
31 | | Ludwig van Beethoven "Moonlight" Piano Sonata No. 14 in C♯ minor, Op. 27, No. 2
Number of Ratings: 178
Mean Rating: 4.542
User Usage Weighted Mean: 4.573
95% Credible Interval: 4.375 - 4.726
New Rank: 31
Original Rank: 18 |
32 | | King Crimson Red
Number of Ratings: 1522
Mean Rating: 4.493
User Usage Weighted Mean: 4.441
95% Credible Interval: 4.372 - 4.505
New Rank: 32
Original Rank: 40 |
33 | | Iron Maiden Powerslave
Number of Ratings: 2921
Mean Rating: 4.491
User Usage Weighted Mean: 4.419
95% Credible Interval: 4.368 - 4.466
New Rank: 33
Original Rank: 43 |
34 | | Rush Hemispheres
Number of Ratings: 1570
Mean Rating: 4.429
User Usage Weighted Mean: 4.433
95% Credible Interval: 4.364 - 4.496
New Rank: 34
Original Rank: 130 |
35 | | The Notorious B.I.G. Ready to Die
Number of Ratings: 1419
Mean Rating: 4.511
User Usage Weighted Mean: 4.434
95% Credible Interval: 4.361 - 4.5
New Rank: 35
Original Rank: 29 |
36 | | The Beach Boys Pet Sounds
Number of Ratings: 1380
Mean Rating: 4.508
User Usage Weighted Mean: 4.428
95% Credible Interval: 4.354 - 4.496
New Rank: 36
Original Rank: 33 |
37 | | The Beatles Revolver
Number of Ratings: 2906
Mean Rating: 4.533
User Usage Weighted Mean: 4.4
95% Credible Interval: 4.349 - 4.449
New Rank: 37
Original Rank: 21 |
38 | | Stevie Wonder Songs in the Key of Life
Number of Ratings: 425
Mean Rating: 4.519
User Usage Weighted Mean: 4.48
95% Credible Interval: 4.348 - 4.593
New Rank: 38
Original Rank: 24 |
39 | | Judas Priest Painkiller
Number of Ratings: 1655
Mean Rating: 4.517
User Usage Weighted Mean: 4.411
95% Credible Interval: 4.343 - 4.474
New Rank: 39
Original Rank: 26 |
40 | | Nick Drake Pink Moon
Number of Ratings: 1431
Mean Rating: 4.476
User Usage Weighted Mean: 4.411
95% Credible Interval: 4.338 - 4.479
New Rank: 40
Original Rank: 52 |
41 | | Death Human
Number of Ratings: 2349
Mean Rating: 4.447
User Usage Weighted Mean: 4.394
95% Credible Interval: 4.337 - 4.448
New Rank: 41
Original Rank: 85 |
42 | | Talking Heads Remain in Light
Number of Ratings: 1215
Mean Rating: 4.493
User Usage Weighted Mean: 4.416
95% Credible Interval: 4.337 - 4.489
New Rank: 42
Original Rank: 39 |
43 | | Koji Kondo The Legend of Zelda: Ocarina of Time OST
Number of Ratings: 256
Mean Rating: 4.473
User Usage Weighted Mean: 4.507
95% Credible Interval: 4.336 - 4.646
New Rank: 43
Original Rank: 58 |
44 | | The Smiths The Queen Is Dead
Number of Ratings: 1892
Mean Rating: 4.45
User Usage Weighted Mean: 4.397
95% Credible Interval: 4.333 - 4.456
New Rank: 44
Original Rank: 81 |
45 | | Bob Dylan Blood on the Tracks
Number of Ratings: 1044
Mean Rating: 4.473
User Usage Weighted Mean: 4.418
95% Credible Interval: 4.332 - 4.496
New Rank: 45
Original Rank: 57 |
46 | | Immolation Close to a World Below
Number of Ratings: 901
Mean Rating: 4.434
User Usage Weighted Mean: 4.423
95% Credible Interval: 4.331 - 4.506
New Rank: 46
Original Rank: 115 |
47 | | David Bowie Low
Number of Ratings: 1154
Mean Rating: 4.455
User Usage Weighted Mean: 4.411
95% Credible Interval: 4.329 - 4.486
New Rank: 47
Original Rank: 75 |
48 | | Miles Davis Bitches Brew
Number of Ratings: 1073
Mean Rating: 4.477
User Usage Weighted Mean: 4.411
95% Credible Interval: 4.327 - 4.489
New Rank: 48
Original Rank: 51 |
49 | | The Stooges Fun House
Number of Ratings: 823
Mean Rating: 4.475
User Usage Weighted Mean: 4.421
95% Credible Interval: 4.324 - 4.508
New Rank: 49
Original Rank: 55 |
50 | | Smashing Pumpkins Siamese Dream
Number of Ratings: 2611
Mean Rating: 4.434
User Usage Weighted Mean: 4.377
95% Credible Interval: 4.322 - 4.429
New Rank: 50
Original Rank: 114 |
51 | | Gospel The Moon Is a Dead World
Number of Ratings: 1056
Mean Rating: 4.412
User Usage Weighted Mean: 4.348
95% Credible Interval: 4.259 - 4.43
New Rank: 101
Original Rank: 150 |
52 | | Aspid Extravasation
Extras:
Number of Ratings: 269
Mean Rating: 4.327
User Usage Weighted Mean: 4.38
95% Credible Interval: 4.2 - 4.533
Would be in Top 101?: FALSE |
53 | | Grotesque Incantation
Number of Ratings: 52
Mean Rating: 3.942
User Usage Weighted Mean: 3.966
95% Credible Interval: 3.453 - 4.371
Would be in Top 101?: FALSE |
54 | | Frank Zappa Hot Rats
Number of Ratings: 791
Mean Rating: 4.439
User Usage Weighted Mean: 4.368
95% Credible Interval: 4.266 - 4.461
New Rank: 95
Original Rank: 104 |
55 | | The Ocean Precambrian
Number of Ratings: 968
Mean Rating: 4.282
User Usage Weighted Mean: 4.181
95% Credible Interval: 4.079 - 4.275
Would be in Top 101?: FALSE |
56 | | Bathory Blood Fire Death
Number of Ratings: 868
Mean Rating: 4.373
User Usage Weighted Mean: 4.32
95% Credible Interval: 4.219 - 4.412
Would be in Top 101?: FALSE |
57 | | The Hotelier Goodness
Number of Ratings: 152
Mean Rating: 4.283
User Usage Weighted Mean: 4.253
95% Credible Interval: 3.991 - 4.469
Would be in Top 101?: FALSE |
58 | | Ichiko Aoba 0%
Number of Ratings: 47
Mean Rating: 4.383
User Usage Weighted Mean: 4.288
95% Credible Interval: 3.79 - 4.639
Would be in Top 101?: FALSE |
59 | | Mr. Bungle California
Number of Ratings: 1244
Mean Rating: 4.374
User Usage Weighted Mean: 4.319
95% Credible Interval: 4.236 - 4.396
Would be in Top 101?: FALSE |
60 | | The Cure Pornography
Number of Ratings: 1061
Mean Rating: 4.241
User Usage Weighted Mean: 4.145
95% Credible Interval: 4.047 - 4.237
Would be in Top 101?: FALSE |
61 | | Joy Division Closer
Number of Ratings: 1593
Mean Rating: 4.371
User Usage Weighted Mean: 4.262
95% Credible Interval: 4.187 - 4.333
Would be in Top 101?: FALSE |
62 | | Demilich Nespithe
Number of Ratings: 541
Mean Rating: 4.267
User Usage Weighted Mean: 4.249
95% Credible Interval: 4.116 - 4.369
Would be in Top 101?: FALSE |
63 | | The Stooges Raw Power
Number of Ratings: 806
Mean Rating: 4.389
User Usage Weighted Mean: 4.311
95% Credible Interval: 4.206 - 4.407
New Rank: 143
Original Rank: 186 |
64 | | Vektor Terminal Redux
Number of Ratings: 442
Mean Rating: 4.492
User Usage Weighted Mean: 4.312
95% Credible Interval: 4.169 - 4.439
New Rank: 163
Original Rank: 42 |
65 | | Dismember Like an Ever Flowing Stream
Number of Ratings: 628
Mean Rating: 4.381
User Usage Weighted Mean: 4.331
95% Credible Interval: 4.213 - 4.437
Would be in Top 101?: FALSE |
66 | | Peste Noire La Sanie des siecles - Panegyrique de la
Number of Ratings: 199
Mean Rating: 4.176
User Usage Weighted Mean: 4.166
95% Credible Interval: 3.931 - 4.367
Would be in Top 101?: FALSE |
|