for loop data frame in r scripting

Question

i have the following dataframe stored inside a variable:

  project_name task_name
6              TPV

This dataframe is stored in variable called isPNfound.

If the task name is queried in the dataframe, i'm supposed to get back the project name. But when the project name is empty, the following code is suppose to catch that and alert:

if(isPNfound$project_name == "") {
    dataStatus <- paste("Task [", projectTaskName, "] has no Project assigned to it!!!")
    print(dataStatus)
    chkstatus <- 0
}

The above code works if there is only one taskname in the dataframe matching "TPV". But suppose there are multiple lines in the data frame, I need to run a loop on it. But im clueless on how to do that.

Sample content of dataframe:

  project_name task_name
6 Rice TPV
7 Beans TPV
8       TPV

I need to somehow run my code in a loop against this dataframe. Here's my attempt:

isPNfound <- dataframeContent
if (length(isPNfound) > 1) {
    for (eachtask in isPNfound){
        dataStatus <- paste("Task [", projectTaskName, "] has no    Project assigned to it!!!")
        print(dataStatus)
        chkstatus <- 0
    }
 }

Why loop? dataStatus <- ifelse( isPNfound$project_name == "", paste("Task [", isPNfound$TaskName, "] has no Project assigned to it!!!"), NA) — zx8754
– zx8754, Commented Sep 18, 2018 at 6:09
if(isPNfound$project_name == "") is identical with if(isPNfound$project_name[1] == ""). You should get a related warning: stackoverflow.com/questions/4367177/… — jogo
– jogo, Commented Sep 18, 2018 at 6:25

Rui Barradas · Accepted Answer · 2018-09-18 06:52:45Z

2

Something like this?

chkstatus <- isPNfound$project_name != ""
dataStatus <- ifelse(chkstatus,
              "OK",
              paste("Task [", isPNfound$task_name, "] has no Project assigned to it!!!")
)

chkstatus <- as.integer(chkstatus)

chkstatus
#[1] 1 1 0

dataStatus
#[1] "OK"                                           
#[2] "OK"                                           
#[3] "Task [ TPV ] has no Project assigned to it!!!"

DATA.

isPNfound <-
structure(list(project_name = c("Rice", "Beans", ""), 
task_name = c("TPV", 
"TPV", "TPV")), row.names = c("6", "7", "8"), class = "data.frame")

edited Sep 18, 2018 at 6:52

answered Sep 18, 2018 at 6:34

Rui Barradas

78k8 gold badges41 silver badges75 bronze badges

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

1 Comment

Rui Barradas Over a year ago

@jogo Right. And coerce to integer as the OP wants only after ifelse. Will edit.

Collectives™ on Stack Overflow

for loop data frame in r scripting

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related