IMDb Top 10,000 adjusted to my specifications (Part II)

Created by LeSchpountz.
Favorited 2 times, disliked 0 times, added to 2 watchlists.
.
A little number game. What have I done?
.
On April 9, 2023 I pulled data from IMDb ( www.imdb.com/interfaces/ ). Now the data does not all fit in a csv or excel file. That's why I decided to use Power Pivot to filter out the film types (movie, short, tv-MiniSeries, tv-Movie) that are most important to me. So I had a list of over 90,000 films. (I only included films with at least 250 votes and a rating of 2.5).
.
Basically, my focus is on the type "movie".
.
Therefore, in the first step of my specification, I assigned malus points (penalty points, minus points) for "shorts", "tv-MiniSeries" and "tv-Movies" as well as for the genres "Adult" and "Documentary". In the case of the "shorts", the penalty points even increased the shorter the film is. In my opinion, I only accept a film that is longer than 5 minutes.
.
In the second step, I gave plus and minus points depending on data ("most favorite movies" and "most official lists") on ICM ( www.icheckmovies.com/ ).
.
In the third step, I then also added a weighting by year to account for the significant distortion of timeliness in online vote counts. This weight was "votes x (1+((1977 minus the release year of the movie)/100)". I copied this great idea (adapted a bit at my discretion) from the Letterboxd user Prof. Ratigan.
.
I chose the year 1977 because from 1977 the VHS format for video recorders became more and more established and the home video recorder market became established as a result.
.
In the fourth step, I used the IMDb formula* for the "weighted rating" to adjust the film rating I had already specified.
.
*weighted rating (WR) = (v ÷ (v+m)) × R + (m ÷ (v+m)) × C
where:
R = my specified average for the movie (mean) = (Rating)
v = my specified number of votes for the movie = (votes)
m = minimum votes required to be listed in the Top 10,000 (currently 999)
C = the minimum vote across the whole report (currently 4.9)
.
And now the following is the result, have fun with it.
Filter
-
1 new
Joker
2016, in 0 top lists Check -
2 new
Kozijat rog
1972 — a.k.a. The Goat Horn, in 2 top lists Check -
3 new
Home
2015, in 2 top lists Check -
4 new
Ofelas
1987 — a.k.a. Pathfinder, in 3 top lists Check -
5 new
Grandma's Boy
2006, in 0 top lists Check -
6 new
El Club
2015 — a.k.a. The Club, in 2 top lists Check -
7 new
Mientras duermes
2011 — a.k.a. Sleep Tight, in 1 top list Check -
8 new
Sorok pervyy
1956 — a.k.a. The Forty-First, in 3 top lists Check -
9 new
Retfærdighedens ryttere
2020 — a.k.a. Riders of Justice, in 1 top list -
10 new
Max Manus
2008 — a.k.a. Max Manus: Man of War, in 1 top list Check -
11 new
Ravenous
1999, in 1 top list Check -
12 new
Les rendez-vous d'Anna
1978 — a.k.a. The Meetings of Anna, in 5 top lists Check -
13 new
Karnavalnaya noch
1956 — a.k.a. Carnival Night, in 2 top lists Check -
14 new
El esqueleto de la señora Morales
1960 — a.k.a. Skeleton of Mrs. Morales, in 2 top lists Check -
15 new
Gervaise
1956, in 3 top lists Check -
16 new
Fresa y chocolate
1993 — a.k.a. Strawberry and Chocolate, in 2 top lists Check -
17 new
Padman
2018, in 0 top lists -
18 new
Du skal ære din hustru
1925 — a.k.a. Master of the House, in 5 top lists Check -
19 new
Le petit soldat
1963 — a.k.a. The Little Soldier, in 3 top lists Check -
20 new
Story of G.I. Joe
1945 — a.k.a. War Correspondent, in 3 top lists Check -
21 new
Die verlorene Ehre der Katharina Blum
1975 — a.k.a. The Lost Honor of Katharina Blum, in 2 top lists Check -
22 new
Shortbus
2006, in 2 top lists Check -
23 new
The End of the Tour
2015, in 0 top lists Check -
24 new
'71
2014, in 0 top lists Check -
25 new
Nagareru
1956 — a.k.a. Flowing, in 4 top lists Check -
26 new
Only the Brave
2017, in 0 top lists -
27 new
Koshish
1972, in 0 top lists Check -
28 new
Hell in the Pacific
1968, in 2 top lists Check -
29 new
Tri topolya na Plyushchikhe
1968 — a.k.a. Three Poplars at Plyuschika, in 3 top lists Check -
30 new
Michael
1924, in 6 top lists Check -
31 new
Potomok Chingis-Khana
1928 — a.k.a. Storm Over Asia, in 8 top lists Check -
32 new
The Tarnished Angels
1957, in 4 top lists Check -
33 new
Das schreckliche Mädchen
1990 — a.k.a. The Nasty Girl, in 4 top lists Check -
34 new
An American Crime
2007, in 0 top lists Check -
35 new
Koruto wa ore no pasupooto
1967 — a.k.a. A Colt Is My Passport, in 3 top lists Check -
36 new
Baishe Srabon
2011, in 0 top lists Check -
37 new
Anjali
1990, in 0 top lists Check -
38 new
Jana Aranya
1975 — a.k.a. The Middleman, in 2 top lists Check -
39 new
Valentín
2002, in 2 top lists Check -
40 new
Mommie Dearest
1981, in 2 top lists Check -
41 new
Paruthi Veeran
2007, in 0 top lists Check -
42 new
Kapurush
1965 — a.k.a. The Coward, in 2 top lists Check -
43 new
Kedamono no ken
1965 — a.k.a. Sword of the Beast, in 2 top lists Check -
44 new
Everybody Wants Some!!
2016, in 0 top lists Check -
45 new
The Blue Elephant 2
2019, in 0 top lists -
46 new
Ji-geum-eun-mat-go-geu-ddae-neun-teul-li-da
2015 — a.k.a. Right Now, Wrong Then, in 6 top lists Check -
47 new
Chor Nikal Ke Bhaga
2023, in 0 top lists -
48 new
Reise der Hoffnung
1990 — a.k.a. Journey of Hope, in 3 top lists Check -
49 new
Unleashed
2005, in 1 top list Check -
50 new
Fei ying gai wak
1991 — a.k.a. Armour of God 2: Operation Condor, in 2 top lists Check