The Trend of Checkout Numbers of Books During Corresponding Adaptation Film Released Time
From Seattle Library
MAT 259, 2016
Lu Liu

Books and movies remain the most popular cultural represent forms.
Will they have mutual impact on each other?
For example: When a film adapted from a book released, will the checkout number of this book in library increase?
I chose several adapted films respectively released on 2006, 2009, 2012 and 2014.Compare the checkout number of specific book in the normal time and the time after adaptation film released to find the trend over months and years.

YEAR(checkOut) AS CheckoutYear,
MONTH(checkout) AS CheckoutMonth,
COUNT(checkOut) AS CheckoutCount
title LIKE '%Hunger Games%'
AND SUBSTRING(itemType, 3, 4) = 'bk'
GROUP BY CheckoutYear , CheckoutMonth

Preliminary sketches
This is a two-dimension project. The horizontal axis is time. The vertical axis is checkout number of book in every month.
And I plan to highlight the specific area to show more details.

The amount of rectangulars represents the checkout number of the book in specific month.

Final result
I use different colors to represent diverse books. Press "s" OR "S" on keyboard to show the whole trend of four books.
Click the specific movie item to see more details information about the adaptation movie and its correspond book.

All work is developed within Processing
Source Code + Data