Extract Previous Row from data.table Using shift() Function

In this method extract previous rows from the data.table using the shift() function, the user needs to first import and install the data.table package to working console, further the user needs to use the mentioned syntax with the call of the shift function to get the values one row before when doing calculations with a data.table. and create a new column and show the values that come accordingly in the R programming language.

Syntax to install and import the data.table library in the working console:

install.packages("data.table")              
library("data.table")

Example:

In this example, we have created a data table with 3 columns and 5 rows then we have added a column containing the values of the variable x time the values of the previous row in the variable y new to the data table using the above approach mentioned in the R programming language.

Output:

   x  y z New
1: 1 10 A  NA
2: 2  9 B  20
3: 3  8 C  27
4: 4  7 D  32
5: 5  6 E  35

In this article, we will be looking at different approaches to using the previous row of data.table using the basic functionality in the R programming language.

The data table subsetting can be performed and the new rows can be created and their values are assigned using the shift method in R. The type can be specified as either “lead” or “lag” depending upon the direction in which the elements are to be moved. The shift method takes as an argument the column name to use the values. 

Syntax: DT[, Row:= shift(val, type = )]

Parameters:

• val – The value to shift
• type – Lead/ lag the values