我有一個看起來像這樣的資料框：
structure(list(RFM_Score_Meaning.x = c("Dropped", "Dropped",
"Dropped", "Dropped", "Dropped", "Dropped", "Dropped", NA, NA,
NA, NA, NA, NA, NA, NA, NA), RFM_Score_Meaning.y = c(NA, NA,
NA, NA, NA, NA, NA, "Need Encouragement", "Need Encouragement",
"Need Encouragement", "Need Encouragement", "Need Encouragement",
"Need Encouragement", "Need Encouragement", "Need Encouragement",
"Need Encouragement")), row.names = c(NA, -16L), class = c("tidytable",
"data.table", "data.frame"), .internal.selfref = <pointer: 0x000002470fabbfe0>)
RFM_Score_Meaning.x
<chr>
RFM_Score_Meaning.y
<chr>
Dropped NA
Dropped NA
Dropped NA
Dropped NA
Dropped NA
Dropped NA
Dropped NA
NA Need Encouragement
NA Need Encouragement
NA Need Encouragement
這個資料框是兩列。第一列中為 NA 的位置在第二列中具有值，反之亦然。
如何擺脫這兩列，而是讓一列包含所有值而沒有任何 NA 值？
uj5u.com熱心網友回復：
我們可以使用coalesce：
library(dplyr)
df %>%
transmute(RFM_Score_Meaning = coalesce(RFM_Score_Meaning.x, RFM_Score_Meaning.y))
RFM_Score_Meaning
1: Dropped
2: Dropped
3: Dropped
4: Dropped
5: Dropped
6: Dropped
7: Dropped
8: Need Encouragement
9: Need Encouragement
10: Need Encouragement
11: Need Encouragement
12: Need Encouragement
13: Need Encouragement
14: Need Encouragement
15: Need Encouragement
16: Need Encouragement
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/525510.html
標籤：r