Transpose a data frame

You’d better not transpose the data.frame while the name column is in it – all numeric values will then be turned into strings!

Here’s a solution that keeps numbers as numbers:

# first remember the names
n <- df.aree$name

# transpose all but the first column (name)
df.aree <- as.data.frame(t(df.aree[,-1]))
colnames(df.aree) <- n
df.aree$myfactor <- factor(row.names(df.aree))

str(df.aree) # Check the column types

Related Posts:

  1. Plot multiple lines in one graph
  2. Create empty data frame with column names by assigning a string vector?
  3. Changing font size and direction of axes text in ggplot2
  4. How to randomize ggplot factor color scheme, keeping same default distances on color wheel?
  5. Count number of occurences for each unique value
  6. Warning message: line appears to contain embedded nulls [duplicate]
  7. Find duplicate values in R
  8. How to change line width in ggplot?
  9. Error in library(ggplot2) : There is no package called ‘ggplot2’
  10. How to reshape data from long to wide format
  11. Change size of axes title and labels in ggplot2
  12. Multiple If Statements in R
  13. ggplot geom_text font size control
  14. What’s the difference between lapply and do.call?
  15. ggplot2, change title size
  16. Initial value in ‘vmmin’ is not finite even when changing the starting value
  17. R “Error: unexpected ‘}’ in “}”
  18. How to remove outliers from a dataset
  19. Mean per group in a data.frame
  20. Error in dev.off() : cannot shut down device 1 (the null device)
  21. standard deviation on dataframe does not work
  22. How to increase font size in a plot in R?
  23. What is the difference between = and ==?
  24. Merge r brings error “‘by’ must specify uniquely valid columns”
  25. Subscripts in plots in R
  26. promise already under evaluation: recursive default argument reference or earlier problems?
  27. Aggregate multiple columns at once
  28. Error in model.frame.default: variable lengths differ
  29. R – Concatenate two dataframes?
  30. Producing subscripts in R markdown
  31. ggplot geom_text font size control
  32. How do you use “<<-" (scoping assignment) in R?
  33. Re-ordering factor levels in data frame
  34. Is it possible to have a multi-line comments in R?
  35. Understanding the result of modulo operator: %%
  36. R – error “variable lengths differ”
  37. Simple manual RMarkdown tables that look good in HTML, PDF and DOCX
  38. Select rows from a data frame based on values in a vector
  39. how to increase the limit for max.print in R
  40. dplyr: “Error in n(): function should not be called directly”
  41. In R formulas, why do I have to use the I() function on power terms, like y ~ I(x^3)
  42. backward elimination in R
  43. Error in eval(expr, envir, enclos) : object not found
  44. Filter data.frame rows by a logical condition
  45. How do I convert a factor into date format?
  46. Error while creating heatmaps – NA/NaN/Inf in foreign function call (arg 11)
  47. Write lines of text to a file in R
  48. How to compute summation in r
  49. Plot multiple boxplot in one graph
  50. R will plot but won’t draw abline
  51. scale_fill_discrete and scale_fill_manual – legend options confusion
  52. R – argument is of length zero in if statement
  53. ‘Incomplete final line’ warning when trying to read a .csv file into R
  54. How to solve ‘protection stack overflow’ issue in R Studio
  55. Conditional mean statement
  56. Warning in GLM analysis
  57. Error in 2:n : NA/NaN argument
  58. Error in generating boxplot two variable data frame: adding class “factor” to an invalid object
  59. What does ‘length of ‘dimnames’ [1] not equal to array extent’ mean?
  60. How do I flip rows and columns in R
  61. Remove NA values from a vector
  62. How to catch integer(0)?
  63. Print string and variable contents on the same line in R
  64. Does R have a wildcard expression (such as an asterisk (*))?
  65. env=baseenv() in R
  66. Simple for loop in R producing “replacement has length zero” in R
  67. How to find out which package version is loaded in R?
  68. How to solve it. error:Error in data[[rowvar]] : attempt to select less than one element
  69. What does Continuous x aesthetic — did you forget aes(group=…) mean?
  70. use first row data as column names in r
  71. Gradient of n colors ranging from color 1 and color 2
  72. How to prevent scientific notation in R?
  73. What is the difference between require() and library()?
  74. Launching R help: Error in file(out, “wt”) : cannot open the connection
  75. R Sweave: NO TeX installation detected
  76. R avoiding “restarting interrupted promise evaluation” warning
  77. How to increase the font size of ggtitle in ggplot2
  78. do-while loop in R
  79. Error in as.vector(x, mode) : cannot coerce type ‘closure’ to vector of type ‘any’
  80. Suppress output of a function
  81. Error in G * t(hat) : non-conformable arrays
  82. Get dplyr count of distinct in a readable way
  83. Error: isTRUE(gpclibPermitStatus()) is not TRUE
  84. Merge two rows in data.frame
  85. r function unzip error 1 in extracting from zip file
  86. Get the list of installed packages by user in R
  87. How to access the last value in a vector?
  88. increase legend font size ggplot2
  89. How To Create Vector of Vector In R
  90. Round down a numeric
  91. Use of ~ (tilde) in R programming Language
  92. Code to clear all plots in RStudio
  93. Error: x must be atomic for ‘sort.list’
  94. Installing R on Android
  95. Transposing in dplyr
  96. Does the c command create a row vector or a column vector by default in R
  97. Can dplyr join on multiple columns or composite key?
  98. Error in summary.connection(connection) : invalid connection
  99. Converting from a character to a numeric data frame
  100. How to create lag variables

Leave a Comment