以下是代码和生成的数据帧
category <- c("East","BLANK","NorthEast","BLANK","BLANK")
subcat <- c("East","North","SW","NE","SE")
data1 <- as.data.frame(category)
data1$subcat <- subcat
**Category** **Subcat**
East East
BLANK North
NorthEast SW
BLANK NE
BLANK SE
东部类别包括亚类别东部和北部.东北类包括亚cat 西南、东北、东南部. 如您所见,每个类别都有空格.如何才能使类别中的第二个值是东部,第四行和第五行是东北?我在实际数据中有更多的行,所以这样做会很有帮助.
结果应该是
**Category** **Subcat**
East East
*East* North
NorthEast SW
*NorthEast* NE
*NorthEast* SE