RSS iconTwitter iconFacebook icon

The Trek BBS title image

The Trek BBS statistics

Threads: 135,836
Posts: 5,220,244
Members: 24,233
Currently online: 581
Newest member: waqarkeihk

TrekToday headlines

Kurtzman And Orci Go Solo
By: T'Bonz on Apr 22

Star Trek #32 Preview
By: T'Bonz on Apr 22

Voyager Bridge Via The Oculus Rift
By: T'Bonz on Apr 21

Miles Away Glyph Award Nominations
By: T'Bonz on Apr 21

Q Meets NuTrek Crew
By: T'Bonz on Apr 18

Pine In Talks For Drama
By: T'Bonz on Apr 18

New X-Men: Days of Future Past Trailer
By: T'Bonz on Apr 17

Nimoy to Receive Award
By: T'Bonz on Apr 17

Star Trek Special: Flesh and Stone Comic
By: T'Bonz on Apr 16

These Are The Voyages TOS Season Two Book Review
By: T'Bonz on Apr 16


Welcome! The Trek BBS is the number one place to chat about Star Trek with like-minded fans. Please login to see our full range of forums as well as the ability to send and receive private messages, track your favourite topics and of course join in the discussions.

If you are a new visitor, join us for free. If you are an existing member please login below. Note: for members who joined under our old messageboard system, please login with your display name not your login name.


Go Back   The Trek BBS > Misc. Star Trek > Trek Literature

Trek Literature "...Good words. That's where ideas begin."

Reply
 
Thread Tools
Old January 13 2012, 04:36 AM   #1
Sho
Fleet Captain
 
Sho's Avatar
 
Location: Berlin, Germany
Tabulated review threads sorted by average score

I have trouble sleeping tonight, so I got back up and banged together a little toy program that goes over a text file full of TrekBBS review thread URLs and computes a HTML file that tabulates them sorted by average score.

The average score is determined as follows: Each vote is given a weight from 1 for "Poor" to 5 for "Outstanding". Then the sum of all votes is divided by the number of votes and rounded to two places.

Here's the output: http://www.eikehein.com/stuff/trekbb...w_threads.html

This is static, i.e. it'll be outdated as soon as any new vote comes in past the time I generated the page (see below regarding future plans).

Here's the source code, under GPL v3: http://paste.kde.org/186488/03186132/

And the URL file used as input, put together manually via a search for "review thread": http://paste.kde.org/185954/64256221/

It's written in Python 3 and requires the lxml library. I ran it on Linux, but it should run equally well on Windows and other operating systems, with an invocation à la "python3 threads.py threads.txt > threads.html". Beware that this was written hurriedly while suffering sleep deprivation, so it may eat babies or attract Borg cubes.

Obviously there are tons of things that could be improved, starting with the scoring algorithm: The Children of Kings comes out on top with a single "Outstanding" vote at present (edit: the output has since been regenerated to reflect additional votes), because the number of voters is not taken into account (luckily this is the only thread with a sample size that's too small to be useful). It would also be nice to output a little fancier HTML, with sortable table columns. And the review thread discovery could be automated, obviating the need to prepare an input file.

At least it does already take care to reject threads that don't follow the "standard poll format", so the data should be reliable .

Stay tuned, I'll probably revisit this and make it a proper, live website at some point - or, of course, you can grab the source and beat me to it if you want!

Thanks to Thrawn who inspired me to do this with this post.

Last edited by Sho; January 14 2012 at 02:07 AM.
Sho is offline   Reply With Quote
Old January 13 2012, 04:46 AM   #2
DorkBoy [TM]
Captain
 
Re: Tabulated review threads sorted by average score

This is very cool.

Kinda reminds me of the Spoiler-free Opinion Summary site, which is a site for grading episodes of Trek that I've always loved. If I remember right, it started off as grading threads on the usenet trek boards, back in the early 90s, and eventually he set up a website and automated it.

I've often wished there was an SOS for Trek books. Your script could become that.
__________________
Homer: The information superhighway showed the average person what some nerd thinks about Star Trek.
DorkBoy [TM] is offline   Reply With Quote
Old January 13 2012, 05:06 AM   #3
Sho
Fleet Captain
 
Sho's Avatar
 
Location: Berlin, Germany
Re: Tabulated review threads sorted by average score

Thanks . Yeah, I was thinking, given the ever-popular "So which ones did you love the most?" thread format, it would be fun to actually pull together what hard, numeric data we have about the forum participants' preferences.

Edit: I really like the little vote distribution bar graphs on SOS, another one for the todo .

Last edited by Sho; January 13 2012 at 06:38 AM.
Sho is offline   Reply With Quote
Old January 13 2012, 01:06 PM   #4
Thrawn
Rear Admiral
 
Thrawn's Avatar
 
Location: Washington, DC
Re: Tabulated review threads sorted by average score

Hah! This is awesome. Always knew my anal-retentiveness in making these review threads would pay off someday!
__________________
The Almighty Star Trek Lit-Verse Reading Order Flowchart - be confused no longer about what to read next, or what to read first.
Thrawn is offline   Reply With Quote
Old January 13 2012, 01:25 PM   #5
Stevil2001
Rear Admiral
 
Stevil2001's Avatar
 
Location: 2010
Re: Tabulated review threads sorted by average score

I used to run a website called "The Star Trek Novel Rankings," actually, which attempted to do that very sort of thing! It is long gone, sadly.

I'm glad to see my love of The Children of Kings validated.
__________________
"All of time and space. Everywhere and anywhere, every star that ever was. Where do you want to start?"
Exploring the Universe
Stevil2001 is offline   Reply With Quote
Old January 13 2012, 01:28 PM   #6
Stevil2001
Rear Admiral
 
Stevil2001's Avatar
 
Location: 2010
Re: Tabulated review threads sorted by average score

Oh yes Wayback Machine! Here's the site as last archived: http://web.archive.org/web/200702150...ks.analma.com/
__________________
"All of time and space. Everywhere and anywhere, every star that ever was. Where do you want to start?"
Exploring the Universe
Stevil2001 is offline   Reply With Quote
Old January 13 2012, 08:53 PM   #7
Sho
Fleet Captain
 
Sho's Avatar
 
Location: Berlin, Germany
Re: Tabulated review threads sorted by average score

That's nifty, maybe if I do wind up taking it in this direction I could seed it with your dataset?

My original ambition was just to track the voting already going on here, though, as a service to the forum. I think being able to compare just the threads here has its own value / fun factor socially, so I definitely want to retain having a site just for that . I hope to find some time to make a first auto-updating and more respectably looking+handling version later this weekend or next week. Keep making those review threads!

My worry regarding a more general voting site is that it would necessarily double as a book directory, and thus duplicate that part of existing sites. Perhaps it would be more sensible to plug a rating component into a place like Memory Beta. OTOH, maybe rating and associated charting / report generating features are big enough to stand alone and make the redundancy a minor offense - the greater UI focus that affords would be a big plus I should think.

Oh well, high-flying plans and so little time . I'll focus on the TrekBBS version for the moment, but keep reusability in mind for later.

Re The Children of Kings, best way to fix that is for everyone to head over there now and vote .

Edit: I've taken a few moments to add a datestamp below the table, fix a problem with polls lacking any votes turned up by the new The Rings of Time poll, fix a typo in one of the column headers and reflect a second vote for Children. Output and source code link updated.

Last edited by Sho; January 14 2012 at 01:38 AM.
Sho is offline   Reply With Quote
Old January 15 2012, 02:47 AM   #8
Therin of Andor
Admiral
 
Therin of Andor's Avatar
 
Location: New Therin Park, Andor (via Australia)
View Therin of Andor's Twitter Profile
Re: Tabulated review threads sorted by average score

Steve Mollmann wrote: View Post
I used to run a website called "The Star Trek Novel Rankings," actually, which attempted to do that very sort of thing! It is long gone, sadly.
Yeah, I miss it, too. Always good when you see your quirky faves are others' faves.
__________________
Thiptho lapth! Ian (Entire post is personal opinion)
The Andor Files @ http://andorfiles.blogspot.com/
http://therinofandor.blogspot.com/
Therin of Andor is offline   Reply With Quote
Old January 15 2012, 03:30 AM   #9
GHS
Lieutenant Commander
 
Location: Washington
Re: Tabulated review threads sorted by average score

Wow, this just became my favorite thread ever!

Not only do we get Sho's cool collection of all the recent book polls, but we get another peek at Mollmann's site (and, to a Wayback Machine novice, it seems extremely reluctant to divulge more than a peek).

Mollmann's site was the greatest thing in the history of mankind while it was around. As one who paid for many a good - as well as many a bad - Trek book, it was fun to see the consensus on the comparative level of talent possesed by the authors (which - in the case of the ones who proclaimed themselves experts of their craft - was doubly amusing). The site didn't get updated that often, though (was it updated shortly before its demise, Steve, or did it die off with a ton of votes never getting entered)?

Kind of ironic now to see Steve himself now getting smacked around in Sho's ratings (actually, he comes out in the middle of the pack, but somewhere Pamela Sargent must be taking perverse pleasure, nonetheless)

Last edited by GHS; January 15 2012 at 03:50 AM.
GHS is offline   Reply With Quote
Old January 15 2012, 04:44 AM   #10
Sho
Fleet Captain
 
Sho's Avatar
 
Location: Berlin, Germany
Re: Tabulated review threads sorted by average score

Well, another way to look at it it is that with 2.68 being the lowest score and the range going from 1-5, people seem to generally be relatively happy about their TrekLit .

Though it's interesting to note that many of the poll options may be relative rather than absolute, i.e. "Above Average" might not satisfy the question "Is this a good book?" but only "Is this a good TrekLit book?" depending on the reference frame people adopt while voting. So technically you probably can't really derive a general level of satisfaction with TrekLit, except that "Poor" is, well, poor in an absolute sense, so general dissatisfaction would be visible. Then again, it's probably moot - people who generally dislike TrekLit are unlikely to vote here. So TrekLit-relative poll options make good sense.
Sho is offline   Reply With Quote
Old January 15 2012, 05:44 AM   #11
Kertrats47
Fleet Captain
 
Kertrats47's Avatar
 
Location: Calgary, Alberta, Canada
View Kertrats47's Twitter Profile
Re: Tabulated review threads sorted by average score

I kind of like GoodRead's 5 star system.

One star = I didn't like it.
Two stars = It was OK.
Three stars = I liked it.
Four stars = I really liked it.
Five stars = It was amazing.

But that's neither here nor there, I suppose. I like the system here as well, and it wouldn't really do to change the ranking mid-stream.
__________________
Trek Lit Reviews (Rise of the Federation: Tower of Babel by Christopher L. Bennett - March 13th, 2014)
2014 Star Trek Book Releases
Kertrats47 is offline   Reply With Quote
Old January 15 2012, 05:57 AM   #12
Sho
Fleet Captain
 
Sho's Avatar
 
Location: Berlin, Germany
Re: Tabulated review threads sorted by average score

Yeah, we're kind of stuck with it now if we want to be able to compare existing and future threads fairly. But I think it's ok anyway .

Settling on a rating system for the possible general voting site is an open question, though.

Reminds me of something I read recently: http://blog.steepster.com/post/22667...-rating-system
Sho is offline   Reply With Quote
Old January 15 2012, 03:04 PM   #13
Stevil2001
Rear Admiral
 
Stevil2001's Avatar
 
Location: 2010
Re: Tabulated review threads sorted by average score

GHS wrote: View Post
Wow, this just became my favorite thread ever!

Not only do we get Sho's cool collection of all the recent book polls, but we get another peek at Mollmann's site (and, to a Wayback Machine novice, it seems extremely reluctant to divulge more than a peek).
To be honest, I'd very nearly forgotten I'd ever ran before this thread appeared. It looks like some of the series will display, and some will not. Who knows. The domain was not mine, but a friend's-- and I lost touch with him many years ago now.

Mollmann's site was the greatest thing in the history of mankind while it was around. As one who paid for many a good - as well as many a bad - Trek book, it was fun to see the consensus on the comparative level of talent possesed by the authors (which - in the case of the ones who proclaimed themselves experts of their craft - was doubly amusing). The site didn't get updated that often, though (was it updated shortly before its demise, Steve, or did it die off with a ton of votes never getting entered)?
Well, thanks. If only more people had been so enthusiastic, eh? I don't think it ever got the critical mass of votes it needed to be really useful, but I suspect had I stuck with it, that may have come someday. Oh well.

I updated it monthly for a while, if I remember right, but then began to lose interest. I don't know if there were tons of unentered votes, but I doubt it.

Kind of ironic now to see Steve himself now getting smacked around in Sho's ratings (actually, he comes out in the middle of the pack, but somewhere Pamela Sargent must be taking perverse pleasure, nonetheless)
The irony did not go unnoticed!
__________________
"All of time and space. Everywhere and anywhere, every star that ever was. Where do you want to start?"
Exploring the Universe
Stevil2001 is offline   Reply With Quote
Old January 17 2012, 05:02 AM   #14
Sho
Fleet Captain
 
Sho's Avatar
 
Location: Berlin, Germany
Re: Tabulated review threads sorted by average score

Alrighty, I finally found some time to make this a little nicer! Let's go over the changes:

  • The location has changed: http://www.eikehein.com/stuff/trekbbs/review_threads/ (I've set up a redirect from the old file since I can edit the original post no longer).
  • Probably the most important bit is that the listing will now be automatically updated twice daily to pick up new threads and votes.
  • I've made it look a little nicer, although the colors could still use some tweaking.
  • It's now possible to sort by every column, in ascending or descending order, by clicking on the table headers.
  • Threads with less than four votes are no longer included in the main listing, but rather listed separately.
  • I've added an intro / explanation blurb.
  • I've changed the license of the source code to AGPL v3 and set up a proper repo and viewer: http://www.eikehein.com/repositories...king&a=summary (the old warning still applies, though: this is relatively hurriedly written, scrounging scraps of time from other activities).
Please note that while this page is still very simple, it does make use of some relatively recent web technology, including WOFF fonts / @font-face and CSS border radius. Do tell me if it looks bad on your end (here's how it's supposed to look: screenshot) so I can try to improve things, but upgrading your browser might also be in order .

So ... you like?

Edit: Didn't have time yet to add little vote distribution graphs, but that's coming too!

Last edited by Sho; January 17 2012 at 06:26 AM.
Sho is offline   Reply With Quote
Old January 17 2012, 01:32 PM   #15
Stevil2001
Rear Admiral
 
Stevil2001's Avatar
 
Location: 2010
Re: Tabulated review threads sorted by average score

It looks quite nice!
__________________
"All of time and space. Everywhere and anywhere, every star that ever was. Where do you want to start?"
Exploring the Universe
Stevil2001 is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT +1. The time now is 12:05 PM.

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
FireFox 2+ or Internet Explorer 7+ highly recommended.