Merge 2 dataframes if value within range

by

There is a package in Bioconductor called IRanges that does what you want.

First, form an IRanges object for your zones:

zone.ranges <- with(zones, IRanges(ZoneStart, ZoneEnd))

Next, find the overlaps:

zone.ind <- findOverlaps(fixes$StartPosition, zone.ranges, select="arbitrary")

Now you have indices into the rows of the zones data frame, so you can merge:

fixes$Zone <- zones$Zone[zone.ind]

Edit: Just realized you have floating point values, while IRanges is integer-based. So you would need to multiply the coordinates by 100, given your precision.

More Related Contents:

  1. how to use loop to subset 1000 csv files and do co-integration test in R?
  2. How to read data when some numbers contain commas as thousand separator?
  3. What’s wrong with my function to load multiple .csv files into single dataframe in R using rbind?
  4. How to convert dataframe into time series?
  5. Trimming a huge (3.5 GB) csv file to read into R
  6. Convert comma separated string to numeric columns
  7. Specifying colClasses in the read.csv
  8. How do I import a CSV file in R? [closed]
  9. Delete “” from csv values and change column names when writing to a CSV
  10. duplicate ‘row.names’ are not allowed error
  11. RStudio not picking the encoding I’m telling it to use when reading a file
  12. How to add a index by set of data when using rbindlist?
  13. Reading multiple csv files from a folder into a single dataframe in R [duplicate]
  14. Error in file(file, “rt”) : cannot open the connection [duplicate]
  15. How to check if CSV file has a comma or a semicolon as separator?
  16. R on Windows: character encoding hell
  17. How to get a .csv file into R?
  18. How to read csv file in R where some values contain the percent symbol (%)
  19. write.csv for large data.table
  20. Using R to download zipped data file, extract, and import .csv
  21. Trying to merge multiple csv files in R
  22. Partially read really large csv.gz in R using vroom
  23. Save imported csv data in vector – R
  24. Correct number of decimal places reading in a .csv
  25. R: How to save lists into csv?
  26. consolidating data frames in R
  27. Importing “csv” file with multiple-character separator to R?
  28. How can I merge many data frames from csv files when the ID column is implied?
  29. What does the error “arguments imply differing number of rows: x, y” mean?
  30. Override column types when importing data using readr::read_csv() when there are many columns

Leave a Comment