Fill in missing values by group in data.table

by

Here’s a slightly faster and more compact way of doing it (version 1.9.3+):

DT[, filled4 := DT[!is.na(value)][DT, value, roll = T]]

More Related Contents:

  1. Naming columns in a data table in R
  2. data.table objects assigned with := from within function not printed
  3. What is the purpose of setting a key in data.table?
  4. .EACHI in data.table?
  5. Use a value from the previous row in an R data.table calculation
  6. How to efficiently calculate distance between pair of coordinates using data.table :=
  7. Sample random rows within each group in a data.table
  8. Melt using patterns when variable names contain string information – avoid coercion to numeric
  9. Error: package or namespace load failed for ggplot2 and for data.table
  10. How to perform join over date ranges using data.table?
  11. Split text string in a data.table columns
  12. How to speed up subset by groups
  13. knitr gets tricked by data.table `:=` assignment
  14. Add multiple columns to R data.table in one function call?
  15. Extract a column from a data.table as a vector, by position
  16. data.table merge based on date ranges
  17. Reason behind speed of fread in data.table package in R
  18. data.table row-wise sum, mean, min, max like dplyr?
  19. := (pass by reference) operator in the data.table package modifies another data table object simultaneously
  20. Rowwise cumulative sum
  21. Using data.table i and j arguments in functions
  22. R data.table breaks in exported functions
  23. Applying a function to each row of a data.table
  24. Union of intersecting vectors in a list in R
  25. Empty factors in “by” data.table
  26. data.table is not handling integer64 in by statement
  27. When and why does “print” need two attempts to print a “data.table”? [duplicate]
  28. How to use data.table within functions and loops?
  29. What you can do with a data.frame that you can’t with a data.table?
  30. data.table: anonymous function in j

Leave a Comment