Skip to main content

Course

Joining Data with data.table in R

IntermediateSkill Level

4.8+

Updated 08/2024

This course will show you how to combine and merge datasets with data.table.

Start Course for Free

RData Manipulation4 hr13 videos47 Exercises3,950 XP17,267Statement of Accomplishment

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Loved by learners at thousands of companies

Training 2 or more people?

Try DataCamp for Business

Course Description

In the real world, data sets typically come split across many tables while most data analysis functions in R are designed to work with single tables of data. In this course, you'll learn how to effectively combine data sets into single tables using data.table. You'll learn how to add columns from one table to another table, how to filter a table based on observations in another table, and how to identify records across multiple tables matching complex criteria. Along the way, you'll learn how to troubleshoot failed join operations and best practices for working with complex data sets. After completing this course you'll be well on your way to be a data.table master!

Prerequisites

Data Manipulation with data.table in R

1

Joining Multiple data.tables

This chapter will show you how to perform simple joins that will enable you to combine information spread across multiple tables.

Welcome to the course

Exploring data.tables

Identifying join keys

Multiple data.tables, multiple keys

The merge function

Left and right joins

Mastering simple joins

2

Joins Using data.table Syntax

In this chapter you will perform joins using the data.table syntax, set and view data.table keys, and perform anti-joins.

Joins using data.table syntax

Right join with the data.table syntax

Inner join with the data.table syntax

Setting and viewing data.table keys

Setting keys

Getting keys

Incorporating joins into your data.table workflow

Exploring the Australian population

Finding multiple matches

Exploring world life expectancy

3

Diagnosing and Fixing Common Join Problems

This chapter will discuss common problems and errors encountered when performing data.table joins and show you how to troubleshoot and avoid them.

Complex keys

Keys with different names

Multi-column keys

Multi-key, single-key

Tricky columns

Column name suffixes

Joining a data.frame

Duplicate matches

Joining with missing values

Filtering duplicates

Joining and filtering duplicates

4

Concatenating and Reshaping data.tables

In the last chapter of this course you'll learn how to concatenate observations from multiple tables together, how to identify observations present in one table but not another, and how to reshape tables between long and wide formats.

Concatenating two or more data.tables

Concatenating data.table variables

Concatenating a list of data.tables

Set operations

Identifying observations shared by multiple tables

Removing duplicates while combining tables

Identifying observations unique to a table

Melting data.tables

Melting a wide table

Casting data.tables

Casting a long table

Casting multiple columns

Splitting by multiple groups

Joining Data with data.table in R

Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance reviewEnroll Now

Don’t just take our word for it

*4.8

from 68 reviews

87%

13%

0%

0%

0%

Sort by

Bowen

3 days ago

Benjamin

3 days ago

Shu Xin

4 days ago

Lawrence

3 weeks ago

N144320004

3 weeks ago

Qi Yen

4 weeks ago

Benjamin

Shu Xin

Lawrence

FAQs

Is this course suitable for beginners?

Absolutely! This course is well suited for those new to data.table in R as it covers the basics and takes you through the fundamentals step-by-step.

Will I receive a certificate at the end of the course?

Yes, after completing this course you will receive an official certification from DataCamp.

Who will benefit from this course?

This course is a must-have for data analysts, data engineers, data scientists, and business intelligence professionals who need to effectively and efficiently join data across multiple tables.

What topics are covered in this course?

This course covers topics such as joining multiple data.tables, joins using data.table syntax, diagnosing and fixing common join problems, and concatenating and reshaping data.tables.

Join over 19 million learners and start Joining Data with data.table in R today!

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Grow your data skills with DataCamp for Mobile

Make progress on the go with our mobile courses and daily 5-minute coding challenges.