University of Edinburgh

Aug 22-23, 2016

9:30 am - 4:30 pm

Instructors: Martin Callaghan, Mario Antonioletti, Alexey Tarutin

Helpers: Clair Barrass

General Information

Data Carpentry develops and teaches workshops on the fundamental data skills needed to conduct research. Our mission is to provide researchers with high-quality, domain-specific training covering the full lifecycle of data-driven research. Data Carpentry's focus is on the introductory computational skills needed for data management and analysis in all domains of research. This event is an example-driven two-day workshop on basic data science computing skills. Short tutorials alternate with hands-on practical exercises, and participants are encouraged both to help one another, and to try applying what they have learned to their own research problems during and between sessions. Participants should bring their own laptops to work on and have permissions to install programs on them. The initial target audience of this workshop is learners who have little to no prior computational experience. It will be a friendly environment for learning to empower researchers and enable data driven discovery.

For more information on what we teach and why, please see our paper "Best Practices for Scientific Computing".

The Research Data Service is a suite of tools and support for University staff and students to aid them in data management planning, working with data, sharing and preserving their data, and re-skilling. It is delivered by a virtual team spanning across a number of sections of Information Services including EDINA and Data Library, Library & University Collections, IT Infrastructure, User Services, and the Digital Curation Centre.

The Software Sustanability Institute's mission is to cultivate better, more sustainable, research software to enable world-class research (better software, better research). Software is fundamental to research: seven out of ten UK researchers report that their work would be impossible without it.

Who: The course is open to all graduate students and other researchers of the University of Edinburgh. Places not filled by Edinburgh's researchers may be offered to researchers from other universities. You don't need to have any previous knowledge of the tools that will be presented at the workshop.

Where: Main Library at 30 George Square, Edinburgh EH8 9LJ. Get directions with OpenStreetMap or Google Maps.

Requirements: Participants must bring a laptop with a Mac, Linux, or Windows operating sytem (not a tablet, Chromebook, etc.) that they have administrative privileges on. They should have a few specific software packages installed (listed below). They are also required to abide by Software Carpentry's Code of Conduct.

Accessibility: We are committed to making this workshop accessible to everybody. The workshop organisers have checked that:

Materials will be provided in advance of the workshop and large-print handouts are available if needed by notifying the organizers in advance. If we can help making learning easier for you (e.g. sign-language interpreters, lactation facilities) please get in touch and we will attempt to provide them.

Contact: Please mail datalib@ed.ac.uk for more information.


Schedule

Surveys

Please be sure to complete these surveys before and after the workshop.

Pre-workshop Survey

Post-workshop Survey

Day 1

09:30 Welcome and Introductions
09:45 Using Spreadsheets Effectively
10:45 Coffee
11:00 Using OpenRefine for data cleaning
13:00 Lunch
13:45 Introduction to R
15:15 Coffee
15:30 Introduction to R
16:30 Feedback and Wrap Up

Day 2

09:30 Welcome and recap on day 1
09:45 Introduction to R and visualisation
10:45 Coffee
11:00 Creating interactive documents with R
13:00 Lunch
13:45 Databases and SQL
15:15 Coffee
15:30 Databases and R
16:30 Feedback and Wrap Up

Syllabus

Programming in R

  • Working with vectors and data frames
  • Reading and plotting data
  • Creating and using functions
  • Loops and conditionals
  • Using R from the command line
  • Reference...

Managing Data with SQL

  • Reading and sorting data
  • Filtering with where
  • Calculating new values on the fly
  • Handling missing values
  • Combining values using aggregation
  • Combining information from multiple tables using join
  • Creating, modifying, and deleting data
  • Programming with databases
  • Reference...

Setup

To participate in a Data Carpentry workshop, you will need working copies of the software described below. Please make sure to install everything and try opening it to make sure it works before the start of your workshop. If you run into any problems, please feel free to email the instructor or arrive early to your workshop on the first day. Participants should bring and use their own laptops to insure the proper setup of tools for an efficient workflow once you leave the workshop.

This workshop will be using the software outlined in the install instructions below. Please see the section for your operating system for those directions.

Windows

Please go through all the installation steps below and make sure that you not only installed them, but start them up to make sure they're working. If you have any problems, don't hesitate to email the instructors to ask for help, or arrive early on the first day of the workshop to get help.

  1. A spreadsheet program
    For this workshop you will need a spreadsheet program. Many people already have Microsoft Excel installed, and if you do, you're set!
    If you need a spreadsheet program, there are a few other options, like OpenOffice and LibreOffice. Install instructions for LibreOffice, which is free and open source, are here.
    • Download the Installer
      Install LibreOffice by going to the installation page. The version for Windows should automatically be selected. Click on the button below "Main Installer" Download Version x.y.z. You will go to a page that asks about a donation, but you don't need to make one. Your download should begin automatically.
    • Install LibreOffice
      Once the installer is downloaded, double click on it and it should install.
    • To use LibreOffice, double click on the icon and it will open.

  2. OpenRefine
    OpenRefine (previously Google Refine) is a tool for data cleaning that runs through a web browser, and any browser - Safari, Firefox, Chrome, Explorer - should work fine. You will need to download OpenRefine and install it, and when you open it, it will run through the browser, but you don't need an internet connection, and the data will all be stored on your computer.
    • Go to the OpenRefine download page
    • Click on Windows kit to download the install file
    • To use it, unzip, and double-click on openrefine.exe (if you're having issues with openrefine.exe try refine.bat instead)
    • OpenRefine will then open in your web browser.
    • If it doesn't open automatically, open a web broswer after you've started the program and go to the URL http://localhost:3333 and you should see OpenRefine.

  3. R
    In the workshop, we will use RStudio. RStudio is a nice interface to the programming language R. To use RStudio, you need to install both R and RStudio.
    • Download R from here
    • Run the .exe file that was just downloaded
    • Go to the RStudio Download page
    • Under Installers select RStudio 0.98.1103 - Windows XP/Vista/7/8
    • Double click the file to install it
    • Once it's installed, open RStudio to make sure it works and you don't get any error messages.

  4. SQLite
    For this workshop we're going to use the Firefox SQLite Plugin. It works through the web browser Firefox.
    • If you don't already have Firefox installed install Firefox
    • Start Firefox
    • Go to the plugin homepage.
    • Click the "Add Now" button.
    • Click "Install Now" on the dialog that appears after the download completes.
    • Restart Firefox when prompted.
    • Select "SQLite Manager" from the "Tools" menu and it will open within Firefox

Mac

Please go through all the installation steps below and make sure that you not only installed them, but start them up to make sure they're working. If you have any problems, don't hesitate to email the instructors to ask for help, or arrive early on the first day of the workshop to get help.

  1. A spreadsheet program
    For this workshop you will need a spreadsheet program. Many people already have Microsoft Excel installed, and if you do, you're set!
    If you need a spreadsheet program, there are a few other options, like OpenOffice and LibreOffice. Install instructions for LibreOffice, which is free and open source, are here.
    • Download the Installer
      Install LibreOffice by going to the installation page. The version for Mac should automatically be selected. Click on the button below "Main Installer" Download Version x.y.z. You will go to a page that asks about a donation, but you don't need to make one. Your download should begin automatically.
    • Install LibreOffice
      Once the installer is downloaded, double click on it and it should install.
    • To use LibreOffice, double click on the icon and it will open.

  2. OpenRefine
    OpenRefine (previously Google Refine) is a tool for data cleaning that runs through a web browser, and any browser - Safari, Firefox, Chrome, Explorer - should work fine. You will need to download Google Refine and install it, and when you open it, it will run through the browser, but you don't need an internet connection, and the data will all be stored on your computer.
    • Go to the OpenRefine download page
    • Click on Mac kit to download the install file
    • Open the downloaded .dmg file
    • Drag the icon in to the Applications folder
    • Double click on the icon and Google Refine will then open in your web browser.
    • If it doesn't open automatically, open a web broswer after you've started the program and go to the URL http://localhost:3333 and you should see OpenRefine.

  3. R
    In the workshop, we will use RStudio. RStudio is a nice interface to the programming language R. To use RStudio, you need to install both R and RStudio.
    • Go to CRAN and click on Download R for (Mac) OS X
    • Select the .pkg file for the version of OS X that you have and the file will download.
    • Double click on the file that was downloaded and R will install
    • Go to the RStudio Download page
    • Under Installers select RStudio x.yy.zzz - Mac OS X 10.6+ (64-bit) to download it.
    • Once it's downloaded, double click the file to install it
    • Once it's installed, open RStudio to make sure it works and you don't get any error messages.

  4. SQLite
    For this workshop we're going to use the Firefox SQLite Plugin. It works through the web browser Firefox.
    • If you don't already have Firefox installed install Firefox
    • Start Firefox
    • Go to the plugin homepage.
    • Click the "Add Now" button.
    • Click "Install Now" on the dialog that appears after the download completes.
    • Restart Firefox when prompted.
    • Select "SQLite Manager" from the "Tools" menu and it will open within Firefox

Linux

Please go through all the installation steps below and make sure that you not only installed them, but start them up to make sure they're working. If you have any problems, don't hesitate to email the instructors to ask for help, or arrive early on the first day of the workshop to get help.

  1. A spreadsheet program
    For this workshop you will need a spreadsheet program. LibreOffice comes preinstalled with several Linux distributions. If you don't already have it, use your package manager to install it: (e.g., sudo apt-get install libreoffice for Ubuntu and other Debian-based distributions).

  2. OpenRefine
    OpenRefine (previously Google Refine) is a tool for data cleaning that runs through a web browser, and any browser - Safari, Firefox, Chrome, Explorer - should work fine. You will need to download Google Refine and install it, and when you open it, it will run through the browser, but you don't need an internet connection, and the data will all be stored on your computer.
    • Go to the OpenRefine download page
    • Click on Linux kit to download the install file
    • Download and extract
    • Type ./refine in your terminal and Google Refine will then open in your web browser.
    • If it doesn't open automatically, open a web broswer after you've started the program and go to the URL http://localhost:3333 and you should see OpenRefine.

  3. R
    In the workshop, we will use RStudio. RStudio is a nice interface to the programming language R. To use RStudio, you need to install both R and RStudio.
    • Follow the instructions for your distribution from CRAN. For most distributions, you can use your package manager (e.g. for Debian/Ubuntu run sudo apt-get install r-base, and for Fedora run sudo yum install R) but make sure that you have at least R 3.2.2 (as pre-packaged versions might be out of date).
    • To install RStudio, go to the RStudio Download page
    • Under Installers select the version for your distribution.
    • Once it's downloaded, double click the file to install it (or sudo dpkg -i rstudio-x.yy.zzz-amd64.deb at the terminal).
    • Once it's installed, open RStudio to make sure it works and you don't get any error messages.

  4. SQLite
    For this workshop we're going to use the Firefox SQLite Plugin. It works through the web browser Firefox.
    • If you don't already have Firefox installed install Firefox
    • Start Firefox
    • Go to the plugin homepage.
    • Click the "Add Now" button.
    • Click "Install Now" on the dialog that appears after the download completes.
    • Restart Firefox when prompted.
    • Select "SQLite Manager" from the "Tools" menu and it will open within Firefox