Search found 5 matches
- Thu Mar 09, 2017 2:44 pm
- Forum: Winter 2017
- Topic: 4 Student Defined Final Project
- Replies: 10
- Views: 10733
Re: 4 Student Defined Final Project
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/...
- Wed Feb 15, 2017 9:11 pm
- Forum: Winter 2017
- Topic: 3D Visualization
- Replies: 10
- Views: 9374
Re: 3D Visualization
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 ...
- Tue Jan 24, 2017 10:23 am
- Forum: Winter 2017
- Topic: 2D Frequency Pattern Visualization
- Replies: 11
- Views: 9849
Re: 2 2D Frequency Pattern Visualization
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...
- Thu Jan 19, 2017 1:18 am
- Forum: Winter 2017
- Topic: 1 Advanced MySQL: Frequency Pattern
- Replies: 10
- Views: 8503
Re: 1b Advanced MySQL: Frequency Pattern
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...
- Wed Jan 11, 2017 7:50 pm
- Forum: Winter 2017
- Topic: 1a Basic MySQL
- Replies: 11
- Views: 10247
Re: 1a Basic MySQL
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...