Search found 5 matches

by jingyi_xiao
Fri Mar 10, 2017 11:48 am
Forum: Winter 2017
Topic: 4 Student Defined Final Project
Replies: 10
Views: 9364

Re: 4 Student Defined Final Project

I found an interesting dataset American Time Use Survey(ATUS) https://www.bls.gov/tus/ from Bureau of Labor Statistics . I think this dataset is really interesting and I'm going to explore the temporal and spatial characteristic of American time usage. Data (2015) o 10905 interviewees o basic info: ...
by jingyi_xiao
Sat Feb 25, 2017 1:42 am
Forum: Winter 2017
Topic: 3D Visualization
Replies: 10
Views: 8372

Re: 3D Visualization

Question Some books have longer title while others have shorter ones. Does this difference change over time? Does the difference vary in different Dewey classes? Idea I queried the average title length in different Dewey classes in different years (from 2006 to 2016) using Seattle Public Library da...
by jingyi_xiao
Tue Jan 24, 2017 11:18 am
Forum: Winter 2017
Topic: 2D Frequency Pattern Visualization
Replies: 11
Views: 8820

Re: 2 2D Frequency Pattern Visualization

Question :Does title length in different Dewey classes differ? I queried the average title length in Seattle Public Library and classified as different Dewey classes, divisions and sections. I want to see if there is anything interesting, like some Dewey classes tend to have longer title than other...
by jingyi_xiao
Mon Jan 16, 2017 3:34 pm
Forum: Winter 2017
Topic: 1 Advanced MySQL: Frequency Pattern
Replies: 10
Views: 7543

Re: 1b Advanced MySQL: Frequency Pattern

Question : What is the average title length of different kinds of items (book, media) in different dewey classes? Does title length vary in different dewey classes and in different itemes? Query1: select a.dewey, avg(case when a.itemtype like '%bk%' then a.length else 0 end) as book, avg(case when ...
by jingyi_xiao
Thu Jan 12, 2017 8:42 am
Forum: Winter 2017
Topic: 1a Basic MySQL
Replies: 11
Views: 9262

Re: 1a Basic MySQL

Question 1 : How is ‘map’ related books being classified as different Dewey classification? select spl_2016.subject.bibNumber, spl_2016.subject.subject, spl_2016.deweyClass.deweyClass from spl_2016.subject inner join spl_2016.deweyClass on spl_2016.deweyClass.bibNumber = spl_2016.subject.bibNumber ...