How to transpose a data frame in R in a way that the elements of a character variable become columns in the new data frame

Question

Here's an example of a data frame I am using.

ID <- c(1,1,2,3)
Type <- c('A', 'B', 'A', 'A')
Value <- c(2.5, 8, 10, 7)
df <- data.frame(ID,Type,Value)
df

And here's how df looks like:

I'm looking for a way to transpose df in a way that the elements of the character variable "Type" become columns in the new data frame.

Note that for IDs 2 and 3, where only type A values are present in df, I'd like to have zero values under column B in the new data frame.

score 1 · Accepted Answer · answered Oct 24 '21 at 01:38

We can use pivot_wider

library(dplyr)
library(tidyr)
df %>%
   pivot_wider(names_from = Type, values_from = Value, values_fill = 0)

-output

# A tibble: 3 × 3
     ID     A     B
  <dbl> <dbl> <dbl>
1     1   2.5     8
2     2  10       0
3     3   7       0

df <- data.frame(ID, Type, Value)

1 Answers1