Advertisement
Guest User

Untitled

a guest
Feb 28th, 2017
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.09 KB | None | 0 0
  1. df <- data.frame(rbind(c('A', '','W','1'),c('A','','W', '3'),c('A', 'BK','R','4'),c('B','BN','T', '12')))
  2.  
  3. df <- data.frame(rbind(c('A', '','W','0'),c('A','','W', '0'),c('A', 'BK','R','4'),c('B','BN','T', '12')))
  4.  
  5. # create the sample data frame
  6. df <- data.frame(rbind(c('A', '','W','1'),c('A','','W', '3'),c('A', 'BK','R','4'),c('B','BN','T', '12')))
  7.  
  8. # add a new level to the 4th column factor
  9. df[, 4] <- factor(df[, 4], levels=c(levels(df[, 4]), '0'))
  10.  
  11. # write 0 to 4th column where 2nd column is ''
  12. df[df[, 2] == '',4] <- '0'
  13.  
  14. > df <- data.frame(rbind(c('A', '','W','1'),c('A','','W', '3'),c('A', 'BK','R','4'),c('B','BN','T', '12')))
  15. > df
  16. X1 X2 X3 X4
  17. 1 A W 1
  18. 2 A W 3
  19. 3 A BK R 4
  20. 4 B BN T 12
  21. > str(df)
  22. 'data.frame': 4 obs. of 4 variables:
  23. $ X1: Factor w/ 2 levels "A","B": 1 1 1 2
  24. $ X2: Factor w/ 3 levels "","BK","BN": 1 1 2 3
  25. $ X3: Factor w/ 3 levels "R","T","W": 3 3 1 2
  26. $ X4: Factor w/ 4 levels "1","12","3","4": 1 3 4 2
  27.  
  28. df$X4<-as.numeric(df$X4)
  29.  
  30. df[df$X2 == "", "X4"] <- 0
  31.  
  32. > df
  33. X1 X2 X3 X4
  34. 1 A W 0
  35. 2 A W 0
  36. 3 A BK R 4
  37. 4 B BN T 2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement