About Data Demos
These videos are part of the data demo series, showing key demonstrations of things involving spreadsheet, database, and data analysis programs.
If you have a topic you think would be useful to have a canonical example of, contact it.training@otago.ac.nz
Merging data from Excel in R – 15 June 2017
This demonstration covers merge two Excel files in R and a couple of steps to check the data along the way.
You can watch the recording (4 minutes 46 seconds):
or download (right click and choose the save/download link option) the recording to your computer via the link:
mergeExcelInR (.m4v format, 42 MB)
and read the parts of the script below (code available when viewing the full article)
R meeting March 21st- Plotting Demo
An 19 minute recording of a discussion around plotting in R.
You can watch the recording (18 minutes 43 seconds)
or download (right click and choose the save/download link option) the recording to your computer via the link:
march21.m4v (.m4v format, 88 MB)
and read the parts of the script below (code available when viewing the full article)
Talking about Swirl
An 18 minute 19 second recording of the discussion around using, developing, and delivering swirl modules for the R users session on the 15th of March 2017
You could also download the movie file (.m4v format, 89 Mb)
Getting Data from the Web discussion March 7 2017
An 23 minute recording of a discussion of getting data from the web from a March 7th meeting: CSVs, HTML tables via rvest, fixed width embedded in tables, JSON.
You can watch the recording (23 minutes 11 seconds)
or download (right click and choose the save/download link option) the recording to your computer via the link:
march7.m4v (.m4v format, 102.2 MB)
and read the parts of the script below (code available when viewing the full article)
R reading a csv, functions, and subsetting tutorial. Feb 28th 2017
As a service to the university, IT Training is providing R notes about reading in a csv, working with functions in R, and subsetting data. This is intended to be a resource for a hour long session. While people outside the University of Otago are welcome to use this, if staff of the university want to modify and customise these instructions, then contact david.hood@otago.ac.nz for the RMarkdown file so you can freely modify the instructions to suit you and produce HTML (suitable for learning management systems) or Word versions.
R csv tutorial in PDF form (283 K)
Importing Data Examples – 17th February 2017
An 10 minute example showing importing 3 files into R:
- a relatively easy to read csv file into R, which shows the general process and a few settings
- a “worst case” tab delimited text file with several tricky areas, which runs over some of the error messages you might see and what they mean
- using RStudio’s import option which has changed a bit in the latest version.
You can watch the recording (10 minutes 10 seconds)
or download (right click and choose the save/download link option) the recording to your computer via the link:
RImportData (.mp4 format, 117.6 MB)
and read the parts of the script below (code available when viewing the full article)
R explainer
A five minute 30 second general explainer about what R is. About 2 and a half minutes of explanation, about 3 minutes of demonstration.
or available as a downloadable file aboutR (MP4 format, 54 MB)
Timelines in Excel – 16 Sep 2016
This demonstration covers using Excel to make a Timeline- a series of blocks designating how long activities take.
You can watch the recording (3:56 in length)
or download the recording to your computer via the link:
Excel Timeline download timeline video (.mp4 format, 44.2 MB)
Filemaker Pro 14 Making a Report
This a video stepping through creating a new report grouping entries and calculating a running total in Filemaker 14.
or download (right click and choose the save/download link option) the recording to your computer via the link:
Filemaker 14 creating a report: fmp14report (.mp4 format, 46.6 MB)
Filemaker 14 – Creating a New Solution 5 September 2016
This a video stepping through creating a new solution (database file) in Filemaker 14.
or download (right click and choose the save/download link option) the recording to your computer via the link:
Creating a Filemaker Solution: FMPSolution.mp4 (.mp4 format, 31.1 MB)
