我从CSV导入的数据集中有一个列data$Floor
,据说包含公寓的楼层。下面是一个示例数据:
Floor |
---|
Ground out of 2 |
1 out of 3 |
您可以使用tidyr::separate
:
tidyr::separate(data, Floor, c('Floor', 'Total Floors'), sep = ' out of ')
#> Floor Total Floors
#> 1 Ground 2
#> 2 1 3
数据使用
data <- data.frame(Floor = c("Ground out of 2", "1 out of 3"))
data
#> Floor
#> 1 Ground out of 2
#> 2 1 out of 3
使用strsplit
from base r
strsplit(data$Floor, ' out of ') |> rbind.data.frame() |> setNames(c('Floor', 'Total Floors'))
# Floor Total Floors
# 1 Ground 1
# 2 2 3