Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I built an r script using stringr that should build 2 columns, Salesforce & CRM1. It is performing as expected except for in some rows, it is moving & deleting data from cells that are not being called in the following code:
library(stringr)
SFDC <- c("SFDC|Salesforce")
Dynamics <- c("Dynamics|Microsoft|365")
Oracle <-c("Oracle|On Demand|Ondemand")
SAP <- c("SAP|Siebel")
InHouse <- c("in house|internal|inhouse|proprietary")
Unknown <- c("don't know|unknown|not sure|not mention|can't remember")
None <- c("none|no crm|N/A")
dataset$salesforce <- str_replace_all(
str_replace_all(
str_replace_all(
str_replace_all(
str_replace_all(
str_replace_all(
str_replace_all(dataset$new_crmused, regex(SFDC, ignore_case=TRUE), "Salesforce"),
regex(Dynamics, ignore_case=TRUE), "Dynamics"),
regex(Oracle, ignore_case=TRUE), "Oracle"),
regex(SAP, ignore_case=TRUE), "SAP Siebel"),
regex(InHouse, ignore_case = TRUE), "In House System"),
regex(Unknown, ignore_case = TRUE), "Unknown"),
regex(None, ignore_case=TRUE), "None")
dataset$CRM1 <- str_extract(dataset$salesforce,"Salesforce|Dynamics|Oracle|SAP Siebel|In House System|Unknown|None")
Does anyone have any ideas why it is doing this?
I'm not the expert of R, please check if it works as expected on R side, if not, you could ask questions in R forums.
Best Regards
Maggie
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |