Skip to main content
HomeR

Data Manipulation with data.table in R

Master core concepts about data manipulation such as filtering, selecting and calculating groupwise statistics using data.table.

Start Course for Free
4 hours15 videos59 exercises24,300 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.
Group

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies


Course Description

The data.table package provides a high-performance version of base R's data.frame with syntax and feature enhancements for ease of use, convenience and programming speed. This course shows you how to create, subset, and manipulate data.tables. You'll also learn about the database-inspired features of data.tables, including built-in groupwise operations. The course concludes with fast methods of importing and exporting tabular text data such as CSV files. Upon completion of the course, you will be able to use data.table in R for a more efficient manipulation and analysis process. Throughout the course you'll explore the San Francisco Bay Area bike share trip dataset from 2014.
For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.
DataCamp For BusinessFor a bespoke solution book a demo.
  1. 1

    Introduction to data.table

    Free

    This chapter introduces data.tables as a drop-in replacement for data.frames and shows how to use data.table's i argument to filter rows.

    Play Chapter Now
    Welcome to the course!
    50 xp
    data.table pop quiz
    50 xp
    Creating a data.table
    100 xp
    Introducing bikes data
    100 xp
    Filtering rows in a data.table
    50 xp
    Filtering rows using positive integers
    100 xp
    Filtering rows using negative integers
    100 xp
    Filtering rows using logical vectors
    100 xp
    Helpers for filtering
    50 xp
    I %like% data.tables
    100 xp
    Filtering with %in%
    100 xp
    Filtering with %between% and %chin%
    100 xp
  2. 2

    Selecting and Computing on Columns

    Just as the i argument lets you filter rows, the j argument of data.table lets you select columns and also perform computations. The syntax is far more convenient and flexible when compared to data.frames.

    Play Chapter Now
  3. 5

    Importing and Exporting Data

    Not only does the data.table package help you perform incredibly fast computations, it can also help you read and write data to disk with amazing speeds. This chapter focuses on data.table's fread() and fwrite() functions which let you import and export flat files quickly and easily!

    Play Chapter Now
For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.

collaborators

Collaborator's avatar
Benjamin Feder
Collaborator's avatar
Eunkyung Park
Collaborator's avatar
Sumedh Panchadhar
Collaborator's avatar
Richie Cotton

prerequisites

Intermediate R
Matt Dowle HeadshotMatt Dowle

Author of data.table

See More

What do other learners have to say?

Join over 15 million learners and start Data Manipulation 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.