I'm working on importing a data set which has a column with categories "PR","CG","SH","CF","SC","PI","PA". However, some rows have multiple values (e.g. PR,CG). I was able to split those strings into lists using FFG=str_split(FFG,pattern=","), but when I try to factor using df<-df%>%(FFG=col_factor(levels=c("PR","CG","SH","CF","SC","PI","PA"))) I get "Error in function_list[k] : attempt to apply non-function" back. I'm new to R so if I missed any important information, just let me know. Any advice would be incredibly helpful, thank you!
Asked
Active
Viewed 35 times
1 Answers
2
One option is to use separate_rows
to split the 'FFG' column and then convert to factor
with levels
specified
library(dplyr)
library(tidyr)
df %>%
separate_rows(FFG, sep=",") %>%
mutate(FFG = factor(FFG, levels=c("PR","CG","SH","CF","SC","PI","PA")))
![](../../users/profiles/3732271.webp)
akrun
- 674,427
- 24
- 381
- 486