Skip to main content
HomeRJoining Data with data.table in R

Joining Data with data.table in R

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

Start Course for Free
4 Hours13 Videos47 Exercises
15,984 LearnersTrophyStatement of Accomplishment

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
GroupTraining 2 or more people?Try DataCamp For Business

Loved by learners at thousands of companies


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!
For Business

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more
Try DataCamp for BusinessFor a bespoke solution book a demo.
  1. 1

    Joining Multiple data.tables

    Free

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

    Play Chapter Now
    Welcome to the course
    50 xp
    Exploring data.tables
    100 xp
    Identifying join keys
    50 xp
    Multiple data.tables, multiple keys
    50 xp
    The merge function
    50 xp
    Inner join
    100 xp
    Full join
    100 xp
    Left and right joins
    50 xp
    Left join
    100 xp
    Right join
    100 xp
    Mastering simple joins
    100 xp
  2. 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.

    Play Chapter Now
For Business

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more

Datasets

IMDBNetflixAustralia PopulationLife ExpectancySchool DatabaseHeart DiseaseEbola CasesGDP

Collaborators

Collaborator's avatar
Sumedh Panchadhar
Collaborator's avatar
Eunkyung Park
Collaborator's avatar
Richie Cotton
Scott Ritchie HeadshotScott Ritchie

Postdoctoral Researcher in Systems Genomics

See More

What do other learners have to say?

FAQs

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

Create Your Free Account

GoogleLinkedInFacebook

or

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