The Checkout Numbers of the Ten Books at SPL from 2006-2014
MAT 259, 2016
I visualized the checkout numbers of the ten books (Republic, Leviathan, The Prince, The Clash of Civilizations, The Elements of Style, Ethics, The Structure of Scientific Revolutions, Democracy in America, The Communist Manifesto, The Politics) at the Seattle Public Library from January 2006 to December 2014 (52*9=468 weeks.) I chose these ten books because the students at Princeton University are required to read them, according to this article
FROM spl3._rawXmlDataCheckOuts AS checkouts
WHERE checkouts.title LIKE "Republic"
AND (checkouts.callNumber LIKE "%PLATO%" OR checkouts.callNumber LIKE "%321%")
AND ((checkouts.checkOut BETWEEN "2006-01-01" AND "2014-12-31") AND (checkouts.itemType LIKE "%bk%"))
ORDER BY year(checkouts.checkOut), WeekOfYear(checkouts.checkOut)
I wrote Python scripts to pre-visualize the results.
All work was developed within Python. I continued developing the program using Processing in my Project 3.
Source Code + Data