R Data manipulation workshop - AFS 2022

Welcome!

Hi everyone and welcome to the super-fun R workshop on data mainpulation in R. Have you started to use R but have trouble getting your dataset into the right format? Do dates and times confuse you? Do you “fix” your data in Excel before uploading into R? Then this is the class for you!

Required software:

• R, version 4.0 or above. The latest version is 4.1.2, available here: https://cloud.r-project.org/
• Rstudio, version 1.2 or above. The latest version is 1.4.1, available here: https://rstudio.com

Required packages:

• tidyverse

• hms

• readxl

• lubridate

  To load the required packages before the workshop, run this code:

packages <- installed.packages()[,"Package"]
if(!is.element("tidyverse",packages)) install.packages("tidyverse")
if(!is.element("readxl",packages)) install.packages("readxl")
if(!is.element("hms",packages)) install.packages("hms")
if(!is.element("lubridate",packages)) install.packages("lubridate")

In this class, you will be learning how to download data, restructure it, clean it up, and merge different types of data together. We have broken it into modules. We may not get through them all today, but you can walk though them on your own afterwards.

• Part one Introduction - Style, Projects, Functions, Packages.

• Part two Data Manipulation - downloading data, changing variable formats, changing names

• Part three Data Restructuring- transitioning from wide to long format, summarizing data, merging tables

• Part three Iteration tools - Iterating functions, loops, apply functions, split-apply-combine.

• Part four Dates - Date and time classes, conversions, lubridate

Data:

We will be using the California Department of Fish and Wildlife Sacramento-San Joaquin Zooplankton data for this course. You may want to download the data ahead of time in case you have wi-fi issues. Data are available at the links below.

• CBdata.csv
• Stations_GPS.csv
• 1972-2019CBMatrix.xlsx
• 1972-2019MysidMatrix.xlsx

Other resources

• Join the Data Science PWT for more help on these topics! Sign up here or visit us on GitHub.
• rseek is a search engine that just searches R-related pages
• R for Data Science is a free webbook with all kinds of useful resources for data manipulation and visualization.
• Cookbook for R is a great site walking you through the basics.
• Stack Overflow is the site for questions and answers on all types of coding topics.
• Software Carpentry teaches a variety of data science workshops, and makes their lessons available online.

You can do it!

Remember, the difference between being good at coding and being bad at coding it being OK with copying and pasting from Google.