Transposing in dplyr

I think you want tidyr rather than dplyr:

library(tidyr)
library(dplyr)
df %>% mutate(group = 1) %>%
       spread(HEADER, price)

  group AWAY_TEAM          AWAY_TRPM HOME_TEAM         HOME_TRPM
1     1       NOP -0.845186446996287       CHA 0.863104076023855

Using this, you can specify your groupings – and you can add on select(-group) to remove them later.

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. Get dplyr count of distinct in a readable way
  29. Error: isTRUE(gpclibPermitStatus()) is not TRUE
  30. How to counter the ‘non-numeric matrix extent’ error in R?
  31. What does is.na() applied to non-(list or vector) of type ‘NULL’ mean?
  32. error r: invalid subscript type “closure” in a simple regression
  33. Merge two rows in data.frame
  34. r function unzip error 1 in extracting from zip file
  35. Get the list of installed packages by user in R
  36. Colour points in a plot differently depending on a vector of values
  37. How to access the last value in a vector?
  38. increase legend font size ggplot2
  39. Mask output of `The following objects are masked from….:` after calling attach() function
  40. How To Create Vector of Vector In R
  41. Use of ~ (tilde) in R programming Language
  42. Construct a manual legend for a complicated plot
  43. Code to clear all plots in RStudio
  44. Error: x must be atomic for ‘sort.list’
  45. How can I change the name of a data frame
  46. Installing R on Android
  47. Does the c command create a row vector or a column vector by default in R
  48. Can dplyr join on multiple columns or composite key?
  49. Convert data.frame column to a vector?
  50. Error in summary.connection(connection) : invalid connection
  51. Converting from a character to a numeric data frame
  52. How to create lag variables
  53. When trying to replace values, “missing values are not allowed in subscripted assignments of data frames”
  54. R Hex to RGB converter
  55. Transpose/Unzip Function (inverse of zip)?
  56. Counting the number of elements with the values of x in a vector
  57. Non-numeric Argument to Binary Operator Error in R
  58. Error in file(file, “rt”) : invalid ‘description’ argument in complete.cases program
  59. Editing legend (text) labels in ggplot
  60. Logistic Regression on factor: Error in eval(family$initialize) : y values must be 0 <= y <= 1
  61. Replace a value in a data frame based on a conditional (`if`) statement
  62. How to read in .HTM into R as a data frame?
  63. How to randomize ggplot factor color scheme, keeping same default distances on color wheel?
  64. Count number of occurences for each unique value
  65. Transpose a data frame
  66. What’s the difference between lapply and do.call?
  67. Initial value in ‘vmmin’ is not finite even when changing the starting value
  68. Insert picture/table in R Markdown
  69. Test if a vector contains a given element
  70. Insert a blank column in dataframe
  71. Mean per group in a data.frame
  72. Error in dev.off() : cannot shut down device 1 (the null device)
  73. standard deviation on dataframe does not work
  74. What is the difference between = and ==?
  75. Merge r brings error “‘by’ must specify uniquely valid columns”
  76. Replace all particular values in a data frame
  77. What does the error “arguments imply differing number of rows: x, y” mean?
  78. Aggregate multiple columns at once
  79. Error in model.frame.default: variable lengths differ
  80. Non-numeric argument to mathematical function
  81. R – Concatenate two dataframes?
  82. KNN in R: ‘train and class have different lengths’?
  83. R multiple conditions in if statement
  84. Remove quotes from a character vector in R
  85. dplyr mutate with conditional values
  86. Simple manual RMarkdown tables that look good in HTML, PDF and DOCX
  87. Select rows from a data frame based on values in a vector
  88. Filter data.frame rows by a logical condition
  89. How to plot 3D scatter diagram using ggplot?
  90. Error: Invalid number of ‘breaks’ in R
  91. Print string and variable contents on the same line in R
  92. Does R have a wildcard expression (such as an asterisk (*))?
  93. Sample random rows in dataframe
  94. Batch convert columns to numeric type
  95. How to melt and cast dataframes using dplyr?
  96. use first row data as column names in r
  97. Launching R help: Error in file(out, “wt”) : cannot open the connection
  98. Boolean operators && and ||
  99. How to increase the font size of ggtitle in ggplot2
  100. Getting the IP address of the current machine using Java

Leave a Comment