Media Arts and Technology

Concept Visualize fiction titles using word2vec mapping for words in 3 dimensions, and graphing the titles on the resulting word cloud. Training Data I am using the google news word vectors described here: https://code.google.com/archive/p/word2vec/ and accessible here: https://github.com/mmihaltz/...

I wanted to look at mapping fiction titles. I ended up using the same query (fiction that was only checked out once) but I did further analysis on the items titles. I analyzed them using tensorflow's implementation of word2vec (https://www.tensorflow.org/tutorials/word2vec). Word2Vec converts words ...

What fiction items are checked out once, or checked out once and never returned? datavisualization1.png Author name vs Time are the axis Red represents young adult books Blue represents genre books like "Mystery" and "Western" Yellow represents fiction Circles are books checked out that were never r...

Original Post: Jan 19, 2017 1:18 am Concept/Question: What fiction items are checked out once, or checked out once and never returned? Provide the Query: SELECT c, checkout, checkin, title, callNumber, CASE WHEN callNumber LIKE '%SCI-FIC%' THEN 1 ELSE 0 END AS sci, CASE WHEN callNumber LIKE '%MYSTER...

Question 1: Where do people checkout items from the library about god? Query 1a: select count(checkOut), title, deweyClass, spl_2016.transactions.bibNumber from spl_2016.title INNER JOIN spl_2016.deweyClass ON spl_2016.deweyClass.bibNumber=spl_2016.title.bibNumber INNER JOIN spl_2016.transactions ON...