英文:
How can I change the design of a data frame according to a particular column numbers in R?
问题
我需要根据特定的列数重新整理我的数据框。我的数据框有2列和1127行，如下所示：
Class Gluc1 3.71 3.81 3.51 3.94 4.24 5.14 5.84 4.94 5.79 6.69 6.99 8.19 8.811 7.411 8.311 9.8
我想要将第1列（Class）中的数字作为列名，并根据它们的类别号将葡萄糖值对齐在这些新列下面。如下所示：
1 4 9 113.7 4.2 6.6 7.43.8 5.1 6.9 8.33.5 5.8 8.1 9.83.9 4.9 8.85.7
我尝试使用 "group_by" 和 "mutate" 函数，但它们没有起作用，而且它们创建了一个列表。我想要一个数据框而不是一个列表。如果有人能帮助我，我将非常感激。
英文:
I need to reshape my data frame according to the particular column numbers. My data frame has 2 columns and 1127 rows and it is like that;
Class Gluc1 3.71 3.81 3.51 3.94 4.24 5.14 5.84 4.94 5.79 6.69 6.99 8.19 8.811 7.411 8.311 9.8
I want to do that the numbers in column 1 (Class) will be column names and glucose values will be align under these new column numbers according to their class number. Like this;
1 4 9 113.7 4.2 6.6 7.43.8 5.1 6.9 8.33.5 5.8 8.1 9.83.9 4.9 8.85.7
I used "group_by" and "mutate" functions but they didn't work and also they create a list. I want a data frame not a list.
If someone help me I will be very appreciated..
答案1
得分: 0
我们可以使用 pivot_wider() 进行操作，以使其运行顺畅，首先按 Class 进行分组并添加行号：
library(dplyr)library(tidyr)df %>%group_by(Class) %>%mutate(id = row_number()) %>%pivot_wider(names_from = Class, values_from = Gluc) %>%select(-id)
`1` `4` `9` `11`<dbl> <dbl> <dbl> <dbl>1 3.7 4.2 6.6 7.42 3.8 5.1 6.9 8.33 3.5 5.8 8.1 9.84 3.9 4.9 8.8 NA5 NA 5.7 NA NA
英文:
We could do it with pivot_wider() to get it work smooth we first group by Class and add row numbers:
library(dplyr)library(tidyr)df %>%group_by(Class) %>%mutate(id = row_number()) %>%pivot_wider(names_from = Class, values_from = Gluc) %>%select(-id)
`1` `4` `9` `11`<dbl> <dbl> <dbl> <dbl>1 3.7 4.2 6.6 7.42 3.8 5.1 6.9 8.33 3.5 5.8 8.1 9.84 3.9 4.9 8.8 NA5 NA 5.7 NA NA
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论