Since I’m talking about books so much this morning, I figured I post something I’ve been meaning to look at for some time now: my highest rated authors. The data comes from my reading lists, which I have kept since January 1, 1996. In order to generate the following data, I filtered it for fiction only, and only those authors for which I had read, and rated 5 or more books.
For fellow database nerds, my exact SQL query was:
SELECT Author1, COUNT(Rating), AVG(Rating)
FROM ReadingList
WHERE Fiction = ‘y’
GROUP BY Author1
HAVING COUNT(Rating) >= 5
ORDER BY 3 DESC
I rate the books I read on a scale of 1-5 stars.
Here are the (relatively unsurprising) results for fiction authors:
Author | Books Read | Avg Rating |
Asimov, Isaac | 43 | 3.7907 |
Sawyer, Robert J. | 7 | 3.7143 |
Haldeman, Joe | 10 | 3.5000 |
Bear, Greg | 5 | 3.4000 |
Bradbury, Ray | 9 | 3.3333 |
Anthony, Piers | 10 | 3.3000 |
Malzberg, Barry N. | 23 | 3.2609 |
Clarke, Arthur C. | 7 | 3.1429 |
Clancy, Tom. | 7 | 3.1429 |
Heinlein, Robert A. | 8 | 3.0000 |
It’s a little embarrassing to find Clarke and Clancy tied for 8th place. I feel like I enjoy Clarke’s stuff more than Clancy. I read Clancy’s "Jack Ryan" novels in a whirlwind vacation week in the summer of 2000 and haven’t returned to them since. I keep reading Clarke, but at least one of his books, The Fountains of Paradise, underwhelmed me. As for Piers Anthony: I read a lot of PA growing up, before I ever kept my lists. At one point, I went back and reread the first 10 books of the Xanth series. I think this was late 1999. That’s why he shows up on the list. His score might have been higher if I included stuff from before the list like Macroscope or Tarot.
It would seem that I can’t produce a list of highest rated fiction authors without showing the list of highest-rated non-fiction authors. If we go based on the same criteria, the list looks like this:
Author | Books Read | Avg Rating |
Asimov, Isaac | 71 | 3.8028 |
Sagan, Carl | 6 | 3.6667 |
Rooney, Andy | 5 | 3.6000 |
Ambrose, Stephen E. | 6 | 3.3333 |
So there you have it. Isaac Asimov takes top position for both categories. In the fiction category, most of my favorite authors make the list. A few are missing, probably because I’ve read less than 5 books each (Bester and Kornbluth, for instance.)
Anyone else have similar data?