0

I have a simple data frame in R Studio that I would like to pivot. I have been using the 'gather()' and 'spread()' functions for more complex transposition, but I cannot figure out how to do a more simple pivot.

I have the following data:

structure(list(MeanExports = c(1581743294.4, 13114218975.85, 
376303283.26, 367309850000, 60019049993.7, 632530400000, 4276027773.125, 
3.63436e+11, 1530830933.675, 317033050000), Development = c("Less", 
"Less", "Less", "More", "More", "More", "Less", "More", "Less", 
"More")), row.names = c(331L, 2635L, 4363L, 13435L, 16171L, 16747L, 
17323L, 17755L, 18331L, 29563L), class = "data.frame")

I would like to be able to create a new data frame with the columns 'More Developed' and 'Less Developed' with five rows (there are five values for each of these categories). There is lots of advice online for more complicated procedures, but I am sure there will be a simple method that I am overlooking. Any help would be amazing.

elliotjameees
  • 21
  • 6
  • `df %>% group_by(Development) %>% mutate(row = row_number()) %>% pivot_wider(names_from = Development, values_from = MeanExports)` – Ronak Shah Jan 28 '21 at 10:16

1 Answers1

1

stack() and unstack() are (often overlooked) base R functions.

dfw <- unstack(df)
names(dfw) <- paste(names(dfw), 'Developed')

#   Less Developed More Developed
# 1     1581743294   367309850000
# 2    13114218976    60019049994
# 3      376303283   632530400000
# 4     4276027773   363436000000
# 5     1530830934   317033050000
s_baldur
  • 29,441
  • 4
  • 36
  • 69