Course Description

In this course, you will learn to join tables using dplyr's two table verbs. Data does not come in the structure or shape in which we need it for analysis and a lot of time is spent in getting the data into shape. You will learn the best ways to combine split data sets to create single tables for your data analysis pipeline.

What will I learn?

After completing this course, you will know the basics of

  • inner join
  • left join
  • right join
  • semi join
  • anti join
  • full join


Self Paced Online Courses


Our online self paced courses are designed to allow participants to learn at their convenience. Learning outcomes are clearly defined and enhanced by the use of byte sized videos, PPTs, assignments, quizzes, suggested reading and case studies. Participants can take advantage of the discussion forum to discuss with their peers and the instructors to enhance their learning experience.


Course Features


Course Requirements

  • Access to a computer with an internet connection

  • Ability and permissions to download files & install software

  • Basic knowledge of English (Course is delivered in English language)


Who is this course for?


We expect the students to have some prior experience with R and RStudio. If you have never used R before, our Introduction to R course will help you prepare for this course.


If I do not meet the requirements to enroll, what should I do?

We have a number of free courses that can help you prepare including:

  • Introduction to R

  • Import Data into R

  • Data Wrangling with dplyr


How will I execute the practical's?


You will use RStudio for the practical's. All the R scripts used in the examples, assignments and case study are available for download from the Learning Management System. For those of you who face issues installing RStudio on your system, we have created a RStudio cloud project where you can practice without installing any software or downloading files.

Do I need to apply? What are the admission criteria?

No. This course is open to enrolment for all and accepts students regardless of experience and background.

Course curriculum

  • 1

    Course Materials

    • Slides

    • R Script

    • Data

    • Blog Post
  • 2

    Introduction

    • Agenda & Case Study

    • Case Study - Data
  • 3

    Types of Joins

    • Inner join

    • Left join

    • Right join

    • Semi join

    • Anti join

    • Full join
  • 4

    Summary

    • Course Summary

Recommended Courses