R语言 将一列数据分割成三列数据(无分隔符)该如何办?
问题描述:
# wide data → long data
S1a_fs_lv <- S1a_fs_valence %>%
rownames_to_column(var = 'sample') %>%
pivot_longer(cols = c("S1V1R1":"S2V2R2"),
names_to = 'conditions',
values_to = 'Valence')
# 需要对第4列数据进行拆分,拆成三列(即,将S, V, R的数据拆开来),接下来如何拆分呢?
# 求大神解答
以下是拆成两列的办法,借鉴了论坛里的代码。但这个办法无法迁移到三列的情况中。
# wide data → long data
S1a_lv <- S1SG_valence %>%
rownames_to_column(var = 'sample') %>%
pivot_longer(cols = c("V1R1":"V2R2"),
names_to = 'conditions',
values_to = 'Valence')
# 将一列拆分成两列
S1a_long_v <- S1a_lv %>% separate(5, c("Va", "Relevant"), sep = "(?<=\\d)(?=[R])")