LaserDisc Database
https://forum.lddb.com/

Sort by IMDB star rating?
https://forum.lddb.com/viewtopic.php?f=8&t=10316		 Page 1 of 1
Author:  yeahdef [ 04 Apr 2022, 03:13 ]
Post subject:  Sort by IMDB star rating?
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
Author:  admin [ 04 Apr 2022, 03:47 ]
Post subject:  Re: Sort by IMDB star rating?
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
Author:  admin [ 04 Apr 2022, 16:35 ]
Post subject:  Re: Sort by IMDB star rating?
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
Author:  admin [ 05 Apr 2022, 07:42 ]
Post subject:  Re: Sort by IMDB star rating?  Topic is solved
I could easily calculate your average IMDb score, and show your highest/lowest entries in the collection page as a piece of trivia :-)

Code: Select all
+------+------+------+
| min  | avg  | max  |
+------+------+------+
|  2.4 |  7.4 |  9.6 |
+------+------+------+


Maybe even a graph distribution for 0-1, 1-2, ... , 8-9, 9-10!

Code: Select all
+-----------+----------+
| 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
Author:  admin [ 05 Apr 2022, 13:28 ]
Post subject:  Re: Sort by IMDB star rating?
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
Author:  admin [ 06 Apr 2022, 17:11 ]
Post subject:  Re: Sort by IMDB star rating?
Quick graphs for fun could look like this:

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


Julien
Author:  yeahdef [ 06 Apr 2022, 17:42 ]
Post subject:  Re: Sort by IMDB star rating?
Hell yeah! Thanks julien!
Author:  admin [ 07 Apr 2022, 14:46 ]
Post subject:  Re: Sort by IMDB star rating?
Just click on the Image and you'll get your graph generated automatically:

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


Julien
Page 1 of 1 All times are UTC [ DST ]
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/