Named List To/From Data.Frame

by

Use stack and unstack in base R:

x <- data.frame(a=1:3, b=4:6)

x
  a b
1 1 4
2 2 5
3 3 6

Use stack to from wide to tall, i.e. stack the vectors on top of one another.

y <- stack(x)
y
  values ind
1      1   a
2      2   a
3      3   a
4      4   b
5      5   b
6      6   b

Use unstack to do the reverse.

unstack(y)
  a b
1 1 4
2 2 5
3 3 6

If your data structure is more complicated than you described, stack and unstack may no longer be suitable. In that case you’ll have to use reshape in base R, or melt and dcast in package reshape2.

More Related Contents:

  1. Dynamically select data frame columns using $ and a character value
  2. Simultaneously merge multiple data.frames in a list
  3. Count number of rows within each group
  4. Drop unused factor levels in a subsetted data frame
  5. Why is it not advisable to use attach() in R, and what should I use instead?
  6. Create an empty data.frame
  7. Merging a lot of data.frames [duplicate]
  8. Create a group number for each consecutive sequence
  9. Select rows with min value by group
  10. Shifting non-NA cells to the left
  11. Omit rows containing specific column of NA
  12. Repeat rows of a data.frame N times
  13. For each row in an R dataframe
  14. Get last row of each group in R [duplicate]
  15. Same function over multiple data frames in R
  16. Create empty data frame with column names by assigning a string vector? [duplicate]
  17. Add extra level to factors in dataframe
  18. Dataframe create new column based on other columns
  19. What is about the first column in R’s dataset mtcars?
  20. Last Observation Carried Forward In a data frame? [duplicate]
  21. finding close match from data frame 1 in data fame 2
  22. Combine several data frames in the global environment by row (rbind)
  23. What is difference between dataframe and list in R?
  24. Define dimensions of an empty dataframe
  25. use multiple columns as variables with sapply
  26. Merge overlapping ranges into unique groups, in dataframe
  27. Reshape a dataframe to long format with multiple sets of measure columns [duplicate]
  28. Count unique values for every column
  29. What you can do with a data.frame that you can’t with a data.table?
  30. Override column types when importing data using readr::read_csv() when there are many columns

Leave a Comment