|
It is currently 27 Apr 2024, 02:01
|
View unsolved topics | View unanswered posts
|
|
|
|
Author |
Message |
yeahdef
|
Post subject: Sort by IMDB star rating? Posted: 04 Apr 2022, 03:13 |
Second post |
|
|
Joined: 25 Oct 2018, 06:24 Posts: 2 Location: United States Has thanked: 0 time Been thanked: 0 time
|
It would be handy for me to see what are the 'top movies' in my collection, according to the star rating on IMDB. Is that possible at this time? Some time ago, I wrote a little script that helped me with this, but it would be great if it were part of the LDDB site! https://github.com/yeahdef/laserdisc_helper
|
|
|
|
|
admin
|
Post subject: Re: Sort by IMDB star rating? Posted: 04 Apr 2022, 03:47 |
Site Admin |
|
|
Joined: 07 Aug 2002, 23:37 Posts: 4551 Location: Tokyo Has thanked: 295 times Been thanked: 1147 times
|
yeahdef wrote: It would be handy for me to see what are the 'top movies' in my collection, according to the star rating on IMDB. Is that possible at this time? Some time ago, I wrote a little script that helped me with this, but it would be great if it were part of the LDDB site! https://github.com/yeahdef/laserdisc_helperI started looking at it before but there was no easy way using directly the IMDb API. I generate the IMDb ranking/score using their provided code that does send back multiple information. I'll take a look at http://omdbapi.com/ or https://datasets.imdbws.com/ (might be faster to regenerate once in a while from a full dataset). Julien
_________________ HARDWARE DATABASE HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
|
|
|
|
|
admin
|
Post subject: Re: Sort by IMDB star rating? Posted: 04 Apr 2022, 16:35 |
Site Admin |
|
|
Joined: 07 Aug 2002, 23:37 Posts: 4551 Location: Tokyo Has thanked: 295 times Been thanked: 1147 times
|
admin wrote: (might be faster to regenerate once in a while from a full dataset). Loading the full dataset IMDb/Ratings in a table takes about 2h... Not practical. That's more than 1,230,000 lines. However just running 1,230,000+ updates only takes about 2 minutes. I'll update the catalog structure to add the IMDb rating (when known/existing) and see how we can use it. Following updates would be manual but I don't think the ratings change very quickly overtime for such old contents. Actually it's fun. My highest IMDb rating in collection is: Otis Redding: Ready Steady Go! Special Edition (1966) [TOLW-3081] (9.6/10) And the lowest... Madonna in SEX RAPE (1985) [SHLY-17] (2.4/10) Julien
_________________ HARDWARE DATABASE HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
|
|
|
|
|
admin
|
Post subject: Re: Sort by IMDB star rating? Posted: 05 Apr 2022, 07:42 |
Site Admin |
|
|
Joined: 07 Aug 2002, 23:37 Posts: 4551 Location: Tokyo Has thanked: 295 times Been thanked: 1147 times
|
I could easily calculate your average IMDb score, and show your highest/lowest entries in the collection page as a piece of trivia +------+------+------+ | min | avg | max | +------+------+------+ | 2.4 | 7.4 | 9.6 | +------+------+------+
Maybe even a graph distribution for 0-1, 1-2, ... , 8-9, 9-10! +-----------+----------+ | bin_floor | count(*) | +-----------+----------+ | 2-3 | 1 | | 3-4 | 1 | | 4-5 | 3 | | 5-6 | 32 | | 6-7 | 181 | | 7-8 | 355 | | 8-9 | 213 | | 9-10 | 10 | +-----------+----------+
Julien
_________________ HARDWARE DATABASE HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
|
|
|
|
|
admin
|
Post subject: Re: Sort by IMDB star rating? Posted: 06 Apr 2022, 17:11 |
Site Admin |
|
|
Joined: 07 Aug 2002, 23:37 Posts: 4551 Location: Tokyo Has thanked: 295 times Been thanked: 1147 times
|
Quick graphs for fun could look like this: Attachment:
Ratings.png [ 6.84 KiB | Viewed 1336 times ]
Julien
_________________ HARDWARE DATABASE HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
|
|
|
|
|
admin
|
Post subject: Re: Sort by IMDB star rating? Posted: 07 Apr 2022, 14:46 |
Site Admin |
|
|
Joined: 07 Aug 2002, 23:37 Posts: 4551 Location: Tokyo Has thanked: 295 times Been thanked: 1147 times
|
Just click on the and you'll get your graph generated automatically: Attachment:
ratings_v1.png [ 12.15 KiB | Viewed 1299 times ]
Julien
_________________ HARDWARE DATABASE HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
|
|
|
|
|
|
|
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum
|
|