Paste multiple columns together

by 
# your starting data..
data <- data.frame('a' = 1:3, 'b' = c('a','b','c'), 'c' = c('d', 'e', 'f'), 'd' = c('g', 'h', 'i')) 

# columns to paste together
cols <- c( 'b' , 'c' , 'd' )

# create a new column `x` with the three columns collapsed together
data$x <- apply( data[ , cols ] , 1 , paste , collapse = "-" )

# remove the unnecessary columns
data <- data[ , !( names( data ) %in% cols ) ]

More Related Contents:

  1. How to reshape data from long to wide format
  2. Grouping functions (tapply, by, aggregate) and the *apply family
  3. Reshaping multiple sets of measurement columns (wide format) into single columns (long format)
  4. Select the row with the maximum value in each group
  5. How to create a consecutive group number
  6. R memory management / cannot allocate vector of size n Mb
  7. Finding ALL duplicate rows, including “elements with smaller subscripts”
  8. Error in if/while (condition) {: missing Value where TRUE/FALSE needed
  9. Using ggplot2, can I insert a break in the axis?
  10. Change R default library path using .libPaths in Rprofile.site fails to work
  11. Convert date-time string to class Date
  12. Installing older version of R package
  13. General suggestions for debugging in R
  14. Find the day of a week
  15. Reorder levels of a factor without changing order of values
  16. Warning message: In `…` : invalid factor level, NA generated
  17. Pasting two vectors with combinations of all vectors’ elements
  18. Rename multiple columns by names
  19. Error in : target of assignment expands to non-language object
  20. Convert integer to class Date
  21. How to unload a package without restarting R
  22. as.Date returning NA while converting from ‘ddmmmyyyy’
  23. How to load packages in R automatically?
  24. How to search for “R” materials? [closed]
  25. What is the difference between = and ==?
  26. Convert a dataframe to a vector (by rows)
  27. What is the difference between = and == in R?
  28. Should I use a data.frame or a matrix?
  29. Variable name restrictions in R
  30. Convert a vector into a list, each element in the vector as an element in the list

Leave a Comment