Proj 2 - 2D Visualization

yokoebata
Posts: 4
Joined: Thu Jan 10, 2019 11:00 am

2D Meditation Dewey Vis

Post by yokoebata » Thu Jan 31, 2019 3:29 pm

INITIAL CONCEPT

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
IMG_5418.JPG

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
screenShot.png

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.
Attachments
meditationDewey.zip
(36.97 KiB) Downloaded 28 times
meditationDeweys.csv
(491 Bytes) Downloaded 31 times
Last edited by yokoebata on Tue Feb 05, 2019 7:48 pm, edited 1 time in total.

aschoettler
Posts: 4
Joined: Thu Jan 10, 2019 11:03 am

Re: Proj 2 - 2D Visualization

Post by aschoettler » Tue Feb 05, 2019 3:08 pm

My project uses heat maps to compare checkout activity over the course of a week of books and dvds in 2006 and 2016.
processing-output.pdf
(68.74 KiB) Downloaded 35 times
Attachments
project.zip
(248.62 KiB) Downloaded 28 times

Post Reply