merge.R 606 B

1234567891011121314151617181920
  1. op <- options(digits.secs=3)
  2. d1 = cbind(as.numeric(hengli_24v[,1]) * 20, hengli_24v)
  3. d2 = cbind(as.numeric(hengli_480v[,1]) * 20, hengli_480v)
  4. d3 = cbind(as.numeric(hengli_plant[,1]) * 20, hengli_plant)
  5. d3$any = apply(d3[,3:length(names(d3))], 1, any)
  6. # merge based on nearest 100ms
  7. merged = merge(merge(
  8. d1, d2, by=1, suffixes=c("_24v", "_480v"), all.x = TRUE
  9. ), d3, by=1, all.x = TRUE)
  10. library(tidyr)
  11. merged = merged %>% fill(names(merged), .direction = 'up')
  12. library(dplyr)
  13. merged$group = cumsum(merged$seitenteil_links_und_rechts_oeffnen & !lag(merged)$any)
  14. s = split(merged, merged$group)[-1]