<h1>Mode 'Meta Report' for COGS 127, UC Merced</h1>
<div><font size="large">Hi COGS 127 students! Use the simple examples below,
showing you a variety of queries that you can run on your data.
Most are meant to illustrate a simple function that you can use,
such as computing averages, taking counts, manipulating strings, etc.
Note in some places I use /* comments */, showing how you can explain your
steps for people who might check out your query.
An example with the simple <a href="https://modeanalytics.com/rdale/tables/some_run_data">running table</a> that I posted a while ago.
<a href="https://modeanalytics.com/rdale/reports/e0e88312a445" target="_blank">Using WHERE to narrow your data</a>
<a href="https://modeanalytics.com/rdale/reports/2c54af7a2c70" target="_blank">Taking an AVG with GROUP BY</a>
<a href="https://modeanalytics.com/rdale/reports/100c512b8190" target="_blank">Getting a COUNT with GROUP BY</a>
<a href="https://modeanalytics.com/rdale/reports/f63b3442c3c2" target="_blank">Scatterplot with AVG and COUNT</a>
<a href="https://modeanalytics.com/rdale/reports/9210f329b336" target="_blank">Calculating a SUM</a>
An example with GPS data that we've collected from class. Wanna scatterplot your GPS data?
We need to do a bit of complicated "string" processing. Mode needs our latitude and longitude
to be (i) separated from each other and then (ii) converted into numbers so that they
can be plotted.
<a href="https://modeanalytics.com/rdale/reports/043e13e2216e" target="_blank">Click here to see an example.</a>
Some recent questions include:<br><br>
<u>I forgot to reset my data, and now two forms show up in my downloaded CSV</u>
Here's a quick fix, simply using Excel.<br>
1) Open your CSV in Excel.<br>
2) Delete the columns you don't need (they will be the ones that are "n/a" ever since you updated your form)<br>
3) Delete the rows that you don't need (where the "n/a" starts for the old questions)<br>
4) Save the CSV (make sure that you just save it as a text file by clicking "Continue")<br>
5) You should be able to import into Mode normally.
<u>I have strings not numbers, what should I do!</u>
There are a few ways you can convert strings into
numbers in some fashion, so that you can perform more interesting numeric plots.
Check out these SQL examples showing you how to do it. <br><br>
<b>Quick tip</b>: As a side note,
one very simple trick is to use a text editor to search and replace
some "offending string". For example, you may have used a coding scheme
that had "1" and "2" and so on as radio button values (and these Mode recognizes as
numbers), however a "5 or more" at the end of this range will cause
Mode to see it as a string. You can open a text editor (e.g., Notepad or TextEdit) and
just search and replace " or more" and replace it with "". This will result in a "5"
and now you can treat these as numbers again.
<a href="https://modeanalytics.com/editor/rdale/reports/a7237e786b28">Searching Strings and Casting into Numbers</a><br>
<a href="https://modeanalytics.com/editor/rdale/reports/df0c994bcf77">Count the Number of Checkboxes Clicked</a><br>
<a href="https://modeanalytics.com/editor/rdale/reports/e775749dc6ae">Search and Replace in a String Field</a>
<u>I am getting errors in Mode import, is it because of HTML?</u>
I would suggest opening your CSV file in a text editor and simply find and
replace any HTML (e.g., "<font></font>") or text that you want to remove
(e.g., " or more" in "5 or more") with empty strings (search and replace
with ""). This will help. In addition, bear in mind that if your users
entered a quote " anywhere in the text input, Mode will be confused because
Mode recognizes that quote character as special. If youd o get an error,
go to the line that Mode tells you about, and check for this kind of
quote character in a response. Replace it with a single quote (') and it
<u>How can I map my GPS coordinates?</u>
Consult <a href="https://modeanalytics.com/rdale/reports/043e13e2216e">this query</a>
to show you how to extract the GPS coordinates (lat/long)
as numbers. Then, download that data (click "Edit" then "Export") and you can use an online service
like <a href="http://www.darrinward.com/lat-long/">this one</a> to plot your coordinates right on a map. You can use this
as one of your figures in the paper, if you wish.
I will post more of these as you ask more questions or issues arise.