Use a value from the previous row in an R data.table calculation

by

With shift() implemented in v1.9.6, this is quite straightforward. 

DT[ , D := C + shift(B, 1L, type="lag")]
# or equivalently, in this case,
DT[ , D := C + shift(B)]

From NEWS:

  1. New function shift() implements fast lead/lag of vector, list, data.frames or data.tables. It takes a type argument which can be either “lag” (default) or “lead”. It enables very convenient usage along with := or set(). For example: DT[, (cols) := shift(.SD, 1L), by=id]. Please have a look at ?shift for more info.

See history for previous answers.

More Related Contents:

  1. Naming columns in a data table in R
  2. How to create a lag variable within each group?
  3. What is the purpose of setting a key in data.table?
  4. .EACHI in data.table?
  5. data.table “key indices” or “group counter”
  6. Select multiple columns in data.table by their numeric indices
  7. Select subset of columns in data.table R [duplicate]
  8. How to extract the first n rows per group?
  9. Finding Overlaps between interval sets / Efficient Overlap Joins
  10. Force character vector encoding from “unknown” to “UTF-8” in R
  11. R: data.table cross-join not working
  12. Why is allow.cartesian required at times when when joining data.tables with duplicate keys?
  13. Dynamically build call for lookup multiple columns
  14. Select values from different columns based on a variable containing column names [duplicate]
  15. Add a row by reference at the end of a data.table object
  16. How to speed up subset by groups
  17. Subsetting data.table using variables with same name as column
  18. Extract a column from a data.table as a vector, by position
  19. data.table equivalent of tidyr::complete()
  20. Using dynamic column names in `data.table`
  21. How do you delete a column by name in data.table?
  22. best way to transpose data.table
  23. := (pass by reference) operator in the data.table package modifies another data table object simultaneously
  24. Select NA in a data.table in R
  25. Merging two sets of data by data.table roll=’nearest’ function
  26. Rowwise cumulative sum
  27. data.table package in R 3.5 does not install
  28. Data Table – Select Value of Column by Name From Another Column
  29. Merging multiple data.tables
  30. How to use data.table within functions and loops?

Leave a Comment