Complex non-equi merge in R

by

So I was very close. I had 2 problems, first a bad installation of the data.table package (Data table error could not find function “.”) caused an obscure error.

After having fixed that, I got closer an found that :

dt1[dt2, on=.(sp=sp, dbh>=dbh_min, dbh<=dbh_max), nomatch=0]

gave me what I wanted with a bad dbh column. Inverting the command with:

dt2[dt1, on=.(sp=sp, dbh_min<=dbh, dbh_max>=dbh)]

fixed the problem with only one useless extra column.

More Related Contents:

  1. Naming columns in a data table in R
  2. How to create a lag variable within each group?
  3. data.table objects assigned with := from within function not printed
  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. Faster way to read fixed-width files
  9. Melt using patterns when variable names contain string information – avoid coercion to numeric
  10. Error: package or namespace load failed for ggplot2 and for data.table
  11. Update subset of data.table based on join
  12. Add a row by reference at the end of a data.table object
  13. How to speed up subset by groups
  14. knitr gets tricked by data.table `:=` assignment
  15. Add multiple columns to R data.table in one function call?
  16. Subsetting data.table using variables with same name as column
  17. Extract a column from a data.table as a vector, by position
  18. data.table equivalent of tidyr::complete()
  19. data.table merge based on date ranges
  20. Reason behind speed of fread in data.table package in R
  21. best way to transpose data.table
  22. data.table row-wise sum, mean, min, max like dplyr?
  23. Select NA in a data.table in R
  24. How to select R data.table rows based on substring match (a la SQL like)
  25. Subset data.table by logical column
  26. Any way to force fread() of data.table not to stop on empty lines?
  27. R data table: update join
  28. Merging data.tables uses more than 10 GB RAM
  29. Split a string column into several dummy variables
  30. R fast single item lookup from list vs data.table vs hash

Leave a Comment