• Mode connects the world’s data and the people who analyze it. Learn More
  • Sign In
  • Sign Up
rdale
@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