It is currently 28 Mar 2024, 13:38




 Page 1 of 1 [ 8 posts ] 
Author Message
 Post subject: Sort by IMDB star rating?
PostPosted: 04 Apr 2022, 03:13 
Second post
Second post
User avatar

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
Offline
 Profile  
 
 Post subject: Re: Sort by IMDB star rating?
PostPosted: 04 Apr 2022, 03:47 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 4540
Location: Tokyo
Has thanked: 292 times
Been thanked: 1136 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_helper


I 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
Offline
 Profile  
 
 Post subject: Re: Sort by IMDB star rating?
PostPosted: 04 Apr 2022, 16:35 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 4540
Location: Tokyo
Has thanked: 292 times
Been thanked: 1136 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
Offline
 Profile  
 
 Post subject: Re: Sort by IMDB star rating?  Topic is solved
PostPosted: 05 Apr 2022, 07:42 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 4540
Location: Tokyo
Has thanked: 292 times
Been thanked: 1136 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
Offline
 Profile  
 
 Post subject: Re: Sort by IMDB star rating?
PostPosted: 05 Apr 2022, 13:28 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 4540
Location: Tokyo
Has thanked: 292 times
Been thanked: 1136 times
admin wrote:
However just running 1,230,000+ updates only takes about 2 minutes.


1:35.34 to be precise.

=> https://www.lddb.com/collection.php?action=list&sort=rating

That was an easy hack!

Julien
_________________
HARDWARE DATABASE
HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G
LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
Offline
 Profile  
 
 Post subject: Re: Sort by IMDB star rating?
PostPosted: 06 Apr 2022, 17:11 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 4540
Location: Tokyo
Has thanked: 292 times
Been thanked: 1136 times
Quick graphs for fun could look like this:

Attachment:
Ratings.png
Ratings.png [ 6.84 KiB | Viewed 1205 times ]


Julien
_________________
HARDWARE DATABASE
HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G
LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
Offline
 Profile  
 
 Post subject: Re: Sort by IMDB star rating?
PostPosted: 06 Apr 2022, 17:42 
Second post
Second post
User avatar

Joined: 25 Oct 2018, 06:24
Posts: 2
Location: United States
Has thanked: 0 time
Been thanked: 0 time
Hell yeah! Thanks julien!
Offline
 Profile  
 
 Post subject: Re: Sort by IMDB star rating?
PostPosted: 07 Apr 2022, 14:46 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 4540
Location: Tokyo
Has thanked: 292 times
Been thanked: 1136 times
Just click on the Image and you'll get your graph generated automatically:

Attachment:
ratings_v1.png
ratings_v1.png [ 12.15 KiB | Viewed 1168 times ]


Julien
_________________
HARDWARE DATABASE
HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G
LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
Offline
 Profile  
 
Display posts from previous:  Sort by  
 Page 1 of 1 [ 8 posts ] 


Who is online

Users browsing this forum: No registered users and 1 guest


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

Search for:
Jump to: