Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2017
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. A B C
  2. 1 NA NA NA
  3. 2 NA 200 NA
  4.  
  5.  
  6. A B C
  7. 1 NotImportant NA NA
  8. 2 Unknown 200 NA
  9.  
  10. if(is.na(ColumnA)) ColumnB[is.na(ColumnB)] <= "Not Important"
  11. if(is.na(ColumnA)) ColumnB[!is.na(ColumnB)] <= "Unknown"
  12.  
  13. df$A <- c("Unknown", "NotImportant")[(rowSums(is.na(df)) == ncol(df)) + 1L]
  14. df
  15. # A B C
  16. # 1 NotImportant NA NA
  17. # 2 Unknown 200 NA
  18.  
  19. df <- structure(list(A = c(NA, NA), B = c(NA, 200L), C = c(NA, NA)), .Names = c("A",
  20. "B", "C"), class = "data.frame", row.names = c("1", "2"))
  21.  
  22. df[rowSums(is.na(df))==3,]$A <- "NotImportant"
  23. df[with(df, is.na(A) & (!is.na(B) | !is.na(C))),]$A <- "Unknown"
  24.  
  25. # A B C
  26. #1 NotImportant NA NA
  27. #2 Unknown 200 NA
  28.  
  29. df <- structure(list(A = c(NA, NA), B = c(NA, 200L), C = c(NA, NA)), .Names = c("A",
  30. "B", "C"), class = "data.frame", row.names = c("1", "2"))
  31.  
  32. library(dplyr)
  33. df%>%
  34. mutate(A=case_when(
  35. is.na(.$A)&is.na(.$B)&is.na(.$C) ~ "Not Important",
  36. is.na(.$A)&(is.na(.$B)|is.na(.$C)) ~ "Unknown")
  37. )
  38.  
  39. A B C
  40. 1 Not Important NA NA
  41. 2 Unknown 200 NA
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement