Advertisement
LinNine

ReadTableFixCol

Nov 14th, 2017
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. library(data.table)
  2. library(magrittr)
  3.  
  4. dt <- fread("11 22 33 44 55 66
  5. 11 22 33 44 55 66 77 88 99
  6. 11 22 33 44 55 66 77 88 99 00", fill = TRUE)
  7.  
  8. dt %>% .[, ':='(V11 = NA, V12 = NA)]
  9.  
  10. dt <- rbind(dt %>% .[, c(paste0("V", 1:6))] %>% .[, I := .I * 2 -1],
  11. dt %>% .[, c(paste0("V", 7:12))] %>% .[, I := .I * 2] %>% setnames(colnames(.), c(paste0("V", 1:6), "I"))) %>%
  12. setorder(I) %>% .[, I := NULL] %>%
  13. .[rowSums(is.na(.)) != ncol(.), ]
  14.  
  15. dt
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement