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. Editing legend (text) labels in ggplot
  54. Error: attempt to use zero-length variable name
  55. Create empty data frame with column names by assigning a string vector?
  56. Changing font size and direction of axes text in ggplot2
  57. How to randomize ggplot factor color scheme, keeping same default distances on color wheel?
  58. Count number of occurences for each unique value
  59. How to change line width in ggplot?
  60. Error in library(ggplot2) : There is no package called ‘ggplot2’
  61. How to reshape data from long to wide format
  62. Combine two or more columns in a dataframe into a new column with a new name
  63. R “Error: unexpected ‘}’ in “}”
  64. What is the difference between = and ==?
  65. Merge r brings error “‘by’ must specify uniquely valid columns”
  66. Subscripts in plots in R
  67. What does the error “arguments imply differing number of rows: x, y” mean?
  68. Non-numeric argument to mathematical function
  69. data.table vs dplyr: can one do something well the other can’t or does poorly?
  70. R – Concatenate two dataframes?
  71. R multiple conditions in if statement
  72. Re-ordering factor levels in data frame
  73. Understanding the result of modulo operator: %%
  74. Simple manual RMarkdown tables that look good in HTML, PDF and DOCX
  75. Select rows from a data frame based on values in a vector
  76. how to increase the limit for max.print in R
  77. How can I convert Json to data frame in R
  78. backward elimination in R
  79. Plot multiple boxplot in one graph
  80. R will plot but won’t draw abline
  81. R – argument is of length zero in if statement
  82. Merging data – Error in fix.by(by.x, x)
  83. R error: “New Column would leave holes after existing columns”
  84. Convert R code into Python code using rpy2
  85. Error in generating boxplot two variable data frame: adding class “factor” to an invalid object
  86. Error : Unable to start png() device
  87. Remove NA values from a vector
  88. How to set axis range R
  89. Sample random rows in dataframe
  90. What does the error “object not interpretable as a factor” mean?
  91. use first row data as column names in r
  92. Deleting rows that are duplicated in one column based on the conditions of another column
  93. Replace all 0 values to NA
  94. Boolean operators && and ||
  95. R avoiding “restarting interrupted promise evaluation” warning
  96. do-while loop in R
  97. Get dplyr count of distinct in a readable way
  98. Round down a numeric
  99. How can I change the name of a data frame
  100. In R, dealing with Error: ggplot2 doesn’t know how to deal with data of class numeric

Leave a Comment