這個問題與標(biāo)題相似的帖子有關(guān)(用相鄰的值替換R向量中的NA)。我想掃描數(shù)據(jù)框中的一列,并用相鄰單元格中的值替換NA。在上述文章中,解決方案是不使用相鄰向量(例如,數(shù)據(jù)矩陣中的相鄰元素)的值替換NA,而是有條件地替換固定值。以下是我的問題的可復(fù)制示例:UNIT <- c(NA,NA, 200, 200, 200, 200, 200, 300, 300, 300,300)STATUS <-c('ACTIVE','INACTIVE','ACTIVE','ACTIVE','INACTIVE','ACTIVE','INACTIVE','ACTIVE','ACTIVE', 'ACTIVE','INACTIVE') TERMINATED <- c('1999-07-06' , '2008-12-05' , '2000-08-18' , '2000-08-18' ,'2000-08-18' ,'2008-08-18', '2008-08-18','2006-09-19','2006-09-19' ,'2006-09-19' ,'1999-03-15') START <- c('2007-04-23','2008-12-06','2004-06-01','2007-02-01','2008-04-19','2010-11-29','2010-12-30', '2007-10-29','2008-02-05','2008-06-30','2009-02-07')STOP <- c('2008-12-05','4712-12-31','2007-01-31','2008-04-18','2010-11-28','2010-12-29','4712-12-31', '2008-02-04','2008-06-29','2009-02-06','4712-12-31')這個問題與標(biāo)題相似的帖子有關(guān)(用相鄰的值替換R向量中的NA)。我想掃描數(shù)據(jù)框中的一列,并用相鄰單元格中的值替換NA。在上述文章中,解決方案是不使用相鄰向量(例如,數(shù)據(jù)矩陣中的相鄰元素)的值替換NA,而是有條件地替換固定值。以下是我的問題的可復(fù)制示例:UNIT <- c(NA,NA, 200, 200, 200, 200, 200, 300, 300, 300,300)STATUS <-c('ACTIVE','INACTIVE','ACTIVE','ACTIVE','INACTIVE','ACTIVE','INACTIVE','ACTIVE','ACTIVE', 'ACTIVE','INACTIVE') TERMINATED <- c('1999-07-06' , '2008-12-05' , '2000-08-18' , '2000-08-18' ,'2000-08-18' ,'2008-08-18', '2008-08-18','2006-09-19','2006-09-19' ,'2006-09-19' ,'1999-03-15') START <- c('2007-04-23','2008-12-06','2004-06-01','2007-02-01','2008-04-19','2010-11-29','2010-12-30', '2007-10-29','2008-02-05','2008-06-30','2009-02-07')STOP <- c('2008-12-05','4712-12-31','2007-01-31','2008-04-18','2010-11-28','2010-12-29','4712-12-31', '2008-02-04','2008-06-29','2009-02-06','4712-12-31')測試<-data.frame(UNIT,STATUS,TERMINATED,START,STOP)測試
- 3 回答
- 0 關(guān)注
- 677 瀏覽
添加回答
舉報
0/150
提交
取消