Turning my photoblog into a book
November 30, 2008
At January 1st, 2009 I want to compile a list of images which have high ratings on my photoblog. The top 40 most rated images will be compiled into a real-life book.
However, compiling such a list proved to be a nice challenge based upon the information stored in the database. Currently all images have three types of statistics: Number of votes, Total rating and Averaged rating. In this case I couldn’t just sort on the Averaged rating, since images with only one vote but with a five star rating will float to the top. So basically I had to do something with the number of votes for each image.
Since the maximum rating for my blog is 5 stars I decided to divide each average rating by this maximum rating. The result is then multiplied by the number of votes. This will give a weighted rating based upon both the average rating and the number of votes.
Sorting on this results gives me a list of the top rated images which will be in a book after January 1st, 2009. Please vote for your favorite images over at my photoblog and see if your image makes it into the book.
Curious which images are currently in the book? Take a look at this crude and unstyled output of the top40 script.
