Data Manipulation and Visualisation

Overview

As the data generated from high-throughput biological experiments increase in volume and become more complex, the ability to manipulate and visualise data is a highly-desirable skill in academia and industry. Whilst familiar tools such as Excel allow basic manipulations, they are often not scalable to larger datasets and are not ameanable to reproducible analysis.

R is a highly-regarded, free, software environment for statistical analysis, with many useful features that promote and facilitate reproducible research.

In this course, we give an introduction to the R environment and explain how it can be used to import, manipulate and visualise tabular data.

After the course you should feel confident to start exploring your own dataset using the materials and references provided.

Setup

These instructions are also described in a video:- https://youtu.be/QIubJ8W8R4g

1) First, install both R and RStudio for your operating system.

Windows

Install R by downloading and running this .exe file from CRAN. Also, please install the RStudio IDE. Note that if you have separate user and admin accounts, you should run the installers as administrator (right-click on .exe file and select “Run as administrator” instead of double-clicking). Otherwise problems may occur later, for example when installing R packages.

Mac

Install R by downloading and running this .pkg file from CRAN. Also, please install the free RStudio IDE

Linux

You can download the binary files for your distribution from CRAN. Or 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). Also, please install free the RStudio IDE.

2) Please download and extract (un-zip) this zip file into the directory on the computer that you wish to work in

3) Create an RStudio project using the menu File -> New Project -> Existing Directory and browse to the directory that you extraced the zip file to. Rstudio will refresh so that the working directory corresponds to the course data folder.

4) Type the following into the R console to install some extra R packages required for the workshop

install.packages("dplyr")
install.packages("ggplot2")
install.packages("readr")

Mac Users may get the following error message when trying to install these packages

xcrun error: inactive developer path (/Library/Developer/CommandLineTools), missing xcrun at:.....

If this is the case, you will need to follow the instructions from this link to install “Xcode”

https://apple.stackexchange.com/questions/254380/why-am-i-getting-an-invalid-active-developer-path-when-attempting-to-use-git-a

Window users might get a message that Rtools is required. This shouldn’t be neccesary, but you might need it for other packages. It can be installed here:-

https://cran.r-project.org/bin/windows/Rtools/

5) Check your installation. You can check everything is installed by copying and pasting this into the R console

source("https://raw.githubusercontent.com/sheffield-bioinformatics-core/r-online/master/check_packages.R")

Course Notes

Video Recordings

Videos of the instructor going through the course materials will be available on youtube

Who should follow this course?

Researchers in life sciences who want to get manipulate and visualise their data more efficiently

Objectives:- After this course you should be able to:

  • Import data and plot graphs in R
  • Create a documented and reproducible piece of R code
  • Know how to develop your skills in R after the course

Aims:- During this course you will learn about:

  • The RStudio interface to R
  • The many ways to access help about R
  • Basic object types in R
  • Importing tabular data into R
  • Manipulating data in R
  • Using in-built functions
  • Basic Plotting
  • Customizing plots
  • Creating reproducible reports in R

Prerequisites

  • No prior programming experience is required

References


For queries relating to collaborating with the Bioinformatics Core team on projects: bioinformatics-core@sheffield.ac.uk

Join our mailing list so as to be notified when we advertise talks and workshops by subscribing to this Google Group. You can also connect with us on Linkedin.

Requests for a Bioinformatics support clinic can be made via the Research Software Engineering (RSE) code clinic system. This is monitored by Bioinformatics Core staff, so we will ensure the appropriate expertise (which may involve individuals from multiple teams) will be available to help you

Queries regarding sequencing and library preparation provision at The University of Sheffield should be directed to the Multi-omics facility in SITraN or the Genomics Laboratory in Biosciences.