Search found 5 matches
- Fri Mar 10, 2017 11:48 am
- Forum: Winter 2017
- Topic: 4 Student Defined Final Project
- Replies: 10
- Views: 12101
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: ...
- Sat Feb 25, 2017 1:42 am
- Forum: Winter 2017
- Topic: 3D Visualization
- Replies: 10
- Views: 10511
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...
- Tue Jan 24, 2017 11:18 am
- Forum: Winter 2017
- Topic: 2D Frequency Pattern Visualization
- Replies: 11
- Views: 10808
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...
- Mon Jan 16, 2017 3:34 pm
- Forum: Winter 2017
- Topic: 1 Advanced MySQL: Frequency Pattern
- Replies: 10
- Views: 9351
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 ...
- Thu Jan 12, 2017 8:42 am
- Forum: Winter 2017
- Topic: 1a Basic MySQL
- Replies: 11
- Views: 11180
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 ...