我在R中遇到了麻烦,我试图通过使用dplyr包使用带有条件IF-ELSE逻辑的多个Mutations 语句逐步构建一个列.具体地说,我希望根据应用于另一列的各种条件,在我的数据框中创建一个名为‘Issues’的新列.
mutate语句中的每个条件判断行信息是否基于特定条件向"Issues"列添加描述(例如"Missing Address").然而,我在实现"问题"列的顺序构建方面遇到了麻烦.
我试过这样的方法:
df <- data.frame(
PreferredName = "",
FirstName = c("Mary", "Harold (Harry)", "Ben", "Tristian (Tri)", "Julia"),
County = c("", "Other", "Warren", "Butler", ""),
Date = as.Date(2024-02-15),
Address = c("123 Street", "42 Ave", "", "", "520 Road")
)
df_cor <- df %>%
mutate(Issues = ifelse((PreferredName == "" & grepl("\\(", FirstName)), "Preferred Name", "")) %>%
mutate(Issues = ifelse(((County == "USA" | County == "" | County == "Other" | County == "N/A" )& Date >= as.Date("2023-08-01")), c(Issues, "County"), Issues)) %>%
mutate(Issues = ifelse((Address == "" & Date >= as.Date("2023-08-01")), c("Address", Issues), Issues))
然而,这并没有像预期的那样奏效.当应该有后续问题被标记时,我得到一个空白列.
我希望有一个名为Issues=c("Address"、"Addresse"、"Address"、"Address")或类似名称的新列.
我非常感谢任何见解或替代方法(理想情况下使用dyplr).