如果MAYBE
列的值为1
,我希望将MAYBE
列的值赋给NO_HIT
列,在其他情况下,我希望保留NO_HIT
列的原始值。
我的原始表:
GCA_id family `NO HIT` MAYBE HIT
<chr> <chr> <dbl> <dbl> <dbl>
GCA_000091205.1 Cyanidiaceae 1 NA NA
GCA_000341285.1 Cyanidiaceae NA 1 NA
GCA_000350225.2 Gigartinaceae NA 1 NA
GCA_000372725.1 Noelaerhabdaceae 1 NA NA
GCA_002049455.2 Bangiaceae 1 NA NA
GCA_002049455.2 Bangiaceae NA 1 1
GCA_002205965.3 Solieriaceae NA 1 1
但是当我尝试table %>% mutate(
NO HIT= ifelse(MAYBE == 1, 1,
NO HIT))
时,它忽略了列NO_HIT
的原始值,并且只分配MAYBE
列的值,结果是:
GCA_id family `NO HIT` MAYBE HIT
<chr> <chr> <dbl> <dbl> <dbl>
GCA_000091205.1 Cyanidiaceae NA NA NA
GCA_000341285.1 Cyanidiaceae 1 1 NA
GCA_000350225.2 Gigartinaceae 1 1 NA
GCA_000372725.1 Noelaerhabdaceae NA NA NA
GCA_002049455.2 Bangiaceae NA NA NA
GCA_002049455.2 Bangiaceae 1 1 1
GCA_002205965.3 Solieriaceae 1 1 1
1条答案
按热度按时间bqucvtff1#
根据评论中的回答,这是你要找的吗?