Merge two rows in data.frame

An idea via dplyr,

library(dplyr)

df %>% 
 group_by(Date, Origin) %>% 
 summarise_all(funs(trimws(paste(., collapse = ''))))

 A tibble: 4 x 5
 Groups:   Date [?]
        Date   Origin Checkin Checkout Destination
       <chr>    <chr>   <chr>    <chr>       <chr>
1  03-07-17   A         08:00    09:00           B
2  03-07-17   B         17:00    18:00           A
3  04-07-17   A         08:00    09:00           B
4  04-07-17   B         17:00    18:00           A

DATA

dput(df)
structure(list(Date = c(" 03-07-17 ", " 03-07-17 ", " 03-07-17 ", 
" 03-07-17 ", " 04-07-17 ", " 04-07-17 ", " 04-07-17 ", " 04-07-17 "
), Checkin = c(" 08:00   ", "         ", " 17:00   ", "         ", 
" 08:00   ", "         ", " 17:00   ", "         "), Origin = c(" A      ", 
" A      ", " B      ", " B      ", " A      ", " A      ", " B      ", 
" B      "), Checkout = c("          ", " 09:00    ", "          ", 
" 18:00    ", "          ", " 09:00    ", "          ", " 18:00    "
), Destination = c("             ", " B           ", "             ", 
" A           ", "             ", " B           ", "             ", 
" A           ")), .Names = c("Date", "Checkin", "Origin", "Checkout", 
"Destination"), row.names = c(NA, -8L), class = "data.frame")

Related Posts:

  1. How to remove outliers from a dataset
  2. dplyr: “Error in n(): function should not be called directly”
  3. Error in eval(expr, envir, enclos) : object not found
  4. How do I convert a factor into date format?
  5. Write lines of text to a file in R
  6. scale_fill_discrete and scale_fill_manual – legend options confusion
  7. ‘Incomplete final line’ warning when trying to read a .csv file into R
  8. Conditional mean statement
  9. Warning in GLM analysis
  10. What does ‘length of ‘dimnames’ [1] not equal to array extent’ mean?
  11. How do I flip rows and columns in R
  12. How to catch integer(0)?
  13. “no function to return from, jumping to top level”
  14. r random forest error – type of predictors in new data do not match
  15. env=baseenv() in R
  16. Removing punctuations from text using R
  17. How to find out which package version is loaded in R?
  18. How to solve it. error:Error in data[[rowvar]] : attempt to select less than one element
  19. Gradient of n colors ranging from color 1 and color 2
  20. How to prevent scientific notation in R?
  21. What is the difference between require() and library()?
  22. How to declare a vector of zeros in R
  23. R Sweave: NO TeX installation detected
  24. ERROR: [on_request_read] connection reset by peer in R shiny
  25. Error in as.vector(x, mode) : cannot coerce type ‘closure’ to vector of type ‘any’
  26. Suppress output of a function
  27. Error in G * t(hat) : non-conformable arrays
  28. Error: isTRUE(gpclibPermitStatus()) is not TRUE
  29. How to counter the ‘non-numeric matrix extent’ error in R?
  30. What does is.na() applied to non-(list or vector) of type ‘NULL’ mean?
  31. error r: invalid subscript type “closure” in a simple regression
  32. r function unzip error 1 in extracting from zip file
  33. Get the list of installed packages by user in R
  34. Colour points in a plot differently depending on a vector of values
  35. How to access the last value in a vector?
  36. increase legend font size ggplot2
  37. Mask output of `The following objects are masked from….:` after calling attach() function
  38. How To Create Vector of Vector In R
  39. Use of ~ (tilde) in R programming Language
  40. Construct a manual legend for a complicated plot
  41. Code to clear all plots in RStudio
  42. Error: x must be atomic for ‘sort.list’
  43. Installing R on Android
  44. Transposing in dplyr
  45. Does the c command create a row vector or a column vector by default in R
  46. Convert data.frame column to a vector?
  47. Error in summary.connection(connection) : invalid connection
  48. Converting from a character to a numeric data frame
  49. How to create lag variables
  50. When trying to replace values, “missing values are not allowed in subscripted assignments of data frames”
  51. R Hex to RGB converter
  52. Counting the number of elements with the values of x in a vector
  53. Non-numeric Argument to Binary Operator Error in R
  54. Error in ggplot.data.frame : Mapping should be created with aes or aes_string
  55. Error in file(file, “rt”) : invalid ‘description’ argument in complete.cases program
  56. SummarySE (Rmisc package) to produce a barplot with error bars (ggplot2)
  57. Editing legend (text) labels in ggplot
  58. Logistic Regression on factor: Error in eval(family$initialize) : y values must be 0 <= y <= 1
  59. R – longer object length is not a multiple of shorter object length
  60. Error: attempt to use zero-length variable name
  61. Plot multiple lines in one graph
  62. Replace a value in a data frame based on a conditional (`if`) statement
  63. How to read in .HTM into R as a data frame?
  64. Create empty data frame with column names by assigning a string vector?
  65. Changing font size and direction of axes text in ggplot2
  66. How to randomize ggplot factor color scheme, keeping same default distances on color wheel?
  67. Count number of occurences for each unique value
  68. Warning message: line appears to contain embedded nulls [duplicate]
  69. Find duplicate values in R
  70. How to change line width in ggplot?
  71. Error in library(ggplot2) : There is no package called ‘ggplot2’
  72. Transpose a data frame
  73. How to drop columns by name in a data frame
  74. How to reshape data from long to wide format
  75. Change size of axes title and labels in ggplot2
  76. Multiple If Statements in R
  77. ggplot geom_text font size control
  78. What’s the difference between lapply and do.call?
  79. ggplot2, change title size
  80. Combine two or more columns in a dataframe into a new column with a new name
  81. Initial value in ‘vmmin’ is not finite even when changing the starting value
  82. Insert picture/table in R Markdown
  83. Test if a vector contains a given element
  84. R “Error: unexpected ‘}’ in “}”
  85. Insert a blank column in dataframe
  86. “length of ‘dimnames’ [2] not equal to array extent” on one of two very similar sets
  87. Mean per group in a data.frame
  88. How to install RHadoop packages (Rmr, Rhdfs, Rhbase)?
  89. Error in dev.off() : cannot shut down device 1 (the null device)
  90. How to create an empty matrix in R?
  91. standard deviation on dataframe does not work
  92. Warning message: In `…` : invalid factor level, NA generated
  93. “non-numeric argument to binary operator” error in R
  94. How to increase font size in a plot in R?
  95. What is the difference between = and ==?
  96. Merge r brings error “‘by’ must specify uniquely valid columns”
  97. Replace all particular values in a data frame
  98. Subscripts in plots in R
  99. promise already under evaluation: recursive default argument reference or earlier problems?
  100. What does the error “arguments imply differing number of rows: x, y” mean?

Leave a Comment