Efficient row-wise operations on a data.table

by

Or, just pmin.

my.dt <- as.data.table(my.df)
system.time(my.dt[,row.min:=pmin(A,B,C)])
# user  system elapsed 
# 0.02    0.00    0.01 
head(my.dt)
#      A B C row.min
# [1,] 2 5 2       2
# [2,] 4 5 5       4
# [3,] 1 5 3       1
# [4,] 4 4 3       3
# [5,] 3 5 5       3
# [6,] 1 5 3       1

More Related Contents:

  1. data.table row-wise sum, mean, min, max like dplyr?
  2. Naming columns in a data table in R
  3. How to create a lag variable within each group?
  4. data.table objects assigned with := from within function not printed
  5. What is the purpose of setting a key in data.table?
  6. .EACHI in data.table?
  7. Use a value from the previous row in an R data.table calculation
  8. How to efficiently calculate distance between pair of coordinates using data.table :=
  9. Sample random rows within each group in a data.table
  10. Melt using patterns when variable names contain string information – avoid coercion to numeric
  11. Error: package or namespace load failed for ggplot2 and for data.table
  12. How to perform join over date ranges using data.table?
  13. Split text string in a data.table columns
  14. How to speed up subset by groups
  15. knitr gets tricked by data.table `:=` assignment
  16. Add multiple columns to R data.table in one function call?
  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. data.table merge based on date ranges
  21. Reason behind speed of fread in data.table package in R
  22. best way to transpose data.table
  23. := (pass by reference) operator in the data.table package modifies another data table object simultaneously
  24. Rowwise cumulative sum
  25. Convert a data frame to a data.table without copy
  26. Row sums over columns with a certain pattern in their name
  27. data.table package in R 3.5 does not install
  28. paste two data.table columns
  29. Removing multiple columns from R data.table with parameter for columns to remove
  30. Fill option for fread

Leave a Comment