MAT 259, 2013
The purpose of this project is to show the correlation between checkout number of Jane Austin’s novels and the searching number of “Jane Austin” in Google.
when title = 'Mansfield Park' then 1
end) as 'Mansfield Park',
when title = 'Sense and Sensibility' then 1
end) as 'Sense and Sensibility',
when title = 'Pride and Prejudice' then 1
end) as 'Pride and Prejudice',
when title = 'Emma' then 1
end) as emma,
when title = 'Becoming Jane' then 1
end) as Jane
title.bib = activity.bib
and o > '2006-01-01'
and o < '2011-01-01'
group by year(o) , month(o)
order by year(o) , month(o);
I selected four famous novels of Jane Austin and one movie about Jane Austin in Seattle Public Library, and counted them separately during 2006-2010. The results are group by month and year, and ordered by year and month. I use MySQL methods to query data in Processing, so it would start query when running the program.
Moreover, I also query searching amount of ”Jane Austin” on Google by Google Trend, and then loaded the data in Processing.
Results and Analysis
The visualization has several modes, and user can choose to show which ones like only “Emma” with “Becoming Jane.” or only “ Mansfield Park”. Each circle size represents different amount and so as the height of each circle. There are six colors because of different items. The maximum numbers are normalized to one hundred, so each peak of different item is shown in the same height.
I used Processing and Google Correlation.
Run in Browser