Mode connects the world’s data and the people who analyze it.
Learn More
Sign In
Sign Up
@rdale
Rick Dale
17
Public Reports
6
Public Tables
Reports
Tables
Published
Meta Report for COGS 127
For COGS 127 students: The following list of reports will help you decide on the basic ...
Published
COGS 127 - Example Replacement of Strings with Numbers
/* This looks trickier than it is... we are g...int) as whyAsNumber from orionwill.fakedata
Published
COGS 127 - Search for Commas to Count Items
/* What if you want to count how many items t...pped, morningenergy from orionwill.fakedata
Published
COGS 127 - Searching Strings and Casting into Numbers
/* This query searches for a string inside a ...fast, morningenergy from orionwill.fakedata
Published
COGS 127: Example Age Binning (Mood Data)
SELECT round(age/10)*10 as ageBin, avg...ple_mood_data GROUP BY ageBin ORDER BY ageBin
Published
COGS 127: SELECT, GROUP BY Mood Example
SELECT avg(age) as averageAge, avg(moo...merced.rdale_sample_mood_data GROUP BY gender
Published
COGS 127: Splicing out GPS coordinates
SELECT cast(substr(gps,1,(strpos(gps,','))...n, Jose, and Jansen for the sample data! */
Published
COGS 127: The WHERE clause
select * from rdale.some_run_data where sub...ine search criteria in the "where clause." */
Published
COGS 127: SUM with GROUP BY
select sum(miles) as total_distance, subt...un entry I have */ group by subtype LIMIT 100
Published
COGS 127: AVG with GROUP BY
select avg(miles) as average_distance, su...bad '0' run entry I have */ group by subtype
Published
COGS 127: AVG and COUNT for a scatterplot
select count(subtype) as total_count, avg...' /* clear bad '0' entry */ group by subtype
Published
COGS 127: COUNT with GROUP BY
select count(subtype) as total_count, sub...' /* clear bad '0' entry */ group by subtype
Published
Sample Report from Run Data
A quick demonstration of some plotting and SQL features.
Published
Map Visualization of UCM Locations
Locations generated with crowdsourcing GPS app with students in COGS 127
Published
LatLong Coordinates of COGS 127 UCM Locations
Students independently used a mapping tool to identify coordinates of interesting locat...
Published
Miles by Subtype
SELECT subtype,avg(miles) from rdale.some_run_data where subtype!='0' group by subtype
Published
Distribution of Consonant Inventories in Language Families
select family,f1_a,count(f1_a) as n_instances...having count(f1_a)>1 order by family,f1_a asc