With quicker, modern, accessible apps allowing humans to practice meditation, mindfulness, & furthermore, a pathway to happiness, curiosity sprouts the question:
“Could the SPL database behave synonymously with the possible checkout decrease in mindful-meditation related items?”
PIVOT CONCEPT
Noticing the surprising range of the deweyClasses, I decided to pivot the focus of this visualization, in conjunction of my first focus, to see the checkout behavior over the years of what deweyClasses are the most popular.
PRIMARY DOODLE
FIRST QUERY: for overall checkout items + deweyClasses
Code: Select all
SELECT YEAR(cout) AS year, bibNumber, title,
COUNT(bibNumber) AS Counts,
deweyClass
FROM
spl_2016.outraw
WHERE
title LIKE '%meditation%' OR title LIKE '%happiness%' OR title LIKE '%mindfulness%'
AND deweyClass > 0 AND deweyClass < 1000
GROUP BY YEAR(cout), bibNumber, title, deweyClass
ORDER BY YEAR(cout), bibNumber, title, deweyClass
SECOND QUERY: to organize yearly dewey meditation items, created multiple annual csv files in order to quantify ranges of Deweys
Code: Select all
SELECT
YEAR(cout),
SUBSTRING(deweyClass, 1, 3),
bibNumber,
title,
COUNT(bibNumber) AS Counts,
deweyClass
FROM
spl_2016.outraw
WHERE
YEAR(cout) = 2008 //or any year
AND (title LIKE '%meditation%'
OR title LIKE '%mindfulness%')
AND (SUBSTRING(deweyClass, 1, 3) BETWEEN 1 AND 1000)
GROUP BY SUBSTRING(deweyClass, 1, 3) ASC, YEAR(cout) , bibNumber , title , deweyClass
ORDER BY SUBSTRING(deweyClass, 1, 3) ASC, YEAR(cout) , bibNumber , title , deweyClass
VISUALIZATION OUTCOME
ANALYSIS
DeweyClasses 100 (comp sci, info + general works), 200 (philosophy+psychology), 600 (technology) and 700 (arts + recreation) were the most popular nonfiction genres of all the deweyClasses. As much as they weren't a surprise overall, the lower checkout deweyClasses struck the most surprises, including social sciences (400) and history/geography(900). Looking deeper into the entries (as demonstrated in the progress presentation slides I have), several many interesting book titles were embedded in these minor checkout rate deweyClasses.
Overall, it can be observed that even though our digital technology has fluctuated over time, especially in its features, books related to mindfulness and meditation has always remained consistent in its checkout numbers, especially within the deweyClasses as well.