批量将行转置为R中的列

由给不了告白发布于 2020-05-09 21:38:43

My data.frame df looks like this:

我希望它看起来像这样：

I have tried spread() but probably not in the right way. Any ideas?

emagni

2020-05-09 21:38:43

We can use unstack from base R

unstack(df1, col2 ~ col1)
#  A B C
#1 1 2 3
#2 2 3 7
#3 5 4 9

Or if we use spread or pivot_wider, make sure to create a sequence column

library(dplyr)
library(tidyr)
df1 %>%
  group_by(col1) %>%
  mutate(rn = row_number()) %>%
  ungroup %>%
  pivot_wider(names_from = col1, values_from = col2) %>%
  # or use
  # spread(col1, col2) %>%
  select(-rn)
# A tibble: 3 x 3
#      A     B     C
#  <int> <int> <int>
#1     1     2     3
#2     2     3     7
#3     5     4     9

数据

df1 <- structure(list(col1 = c("A", "A", "A", "B", "B", "B", "C", "C", 
"C"), col2 = c(1L, 2L, 5L, 2L, 3L, 4L, 3L, 7L, 9L)),
   class = "data.frame", row.names = c(NA, 
-9L))

给不了告白

这家伙很懒，什么都没留下

积分
0
话题
0
评论
3192
注册排名
2714