Return result using if statement with for loop in r

Question

I would like to return the result in a vector based on the results of an if statement. My default value in the column would be "blank" and if both conditions are met ==FALSE I would like the vector/cell to have "some text". Here is what I have so far:

COMP30$Test_3<-"blank"
matches<-list(c(COMP30$PMPI_Has_Plan,COMP30$PMPI_Is_Eligible,COMP30$Test_3))
for (match in matches){if (match[1]==FALSE & match[2]==FALSE){match[3]<-"some text"}}

After running, I am showing only "blank" even though there are instances of ==FALSE & ==FALSE. Basically, either the condition is not evaluating or the result is not being returned. Just started learning R so I am not sure what I am missing. Thanks!

You are modifying the variable match in the loop that is erased at each iteration. Modify matches instead — Clemsang
– Clemsang, Commented Feb 20, 2020 at 13:01
Thanks. What code needs to change in order to modify matches? — Chris2015
– Chris2015, Commented Feb 20, 2020 at 13:06

Clemsang · Accepted Answer · 2020-02-20 14:47:19Z

1

From what I can guess about your dataset. Please provide your data using dput.

Using vectorisation:

COMP30$Test_3<-"blank"
matches <- cbind(COMP30$PMPI_Has_Plan, COMP30$PMPI_Is_Eligible, COMP30$Test_3)
matches[!matches[,1] & !matches[,2],3] <- "Some text"

Or with a for loop:

matches <- cbind(COMP30$PMPI_Has_Plan, COMP30$PMPI_Is_Eligible, COMP30$Test_3)
for (k in 1:nrow(matches)){
  if (!matches[k, 1] & !matches[k, 2]){
    matches[k, 3] <- "some text"
  }
}

edited Feb 20, 2020 at 14:47

answered Feb 20, 2020 at 13:14

Clemsang

5,5833 gold badges28 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

13 Comments

Chris2015 Over a year ago

I tried both solutions and I am still not returning the expected result or "some text". For example, I modified the vectorisation solution slightly to say: matches[matches[,1]==TRUE & matches[,2]==TRUE,3]<-"some text" but I only return "blank". I modified solution 2 similarly ==TRUE with the same result. Any ideas? Is it a syntax issue perhaps?

Clemsang Over a year ago

@Chris2015 Is your column boolean or string ? Using boolean == TRUE is equivalent to boolean as it is alread true or false

Chris2015 Over a year ago

I see. It is boolean. But if I use ==FALSE for both I still don't return a result. Does it matter that the first two columns in cbind are boolean and the third column is string?

Chris2015 Over a year ago

First two are logical and the third is character.

Clemsang Over a year ago

Code working :

matches <- data.frame(a=c(T, F), b = c(T, T), c= "blank", stringsAsFactors = F);matches[matches[,1] & matches[,2],3] <- "Some text";matches

. Edit your question and give us dput(head(matches))

|

Collectives™ on Stack Overflow

Return result using if statement with for loop in r

1 Answer 1

13 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

13 Comments

Your Answer

Sign up or log in

Post as a guest

Related