how to delete a row

Asked Jun 18 '18 at 08:30

Active Jun 18 '18 at 08:38

Viewed 99 times

for (i in 2:nrow(fox)) {
  temp = fox[i,c(7:18)]
  check = (temp==0)
  if(all(check))
    new <- fox[-c(i),]
  else
print('okay')

}

I'm writing this block of R code to basically delete a row from the dataframe 'fox' if all the columns are 0. It seems to be working except for the fact the 'new' dataframe just is short of the first row, but has to omit many rows too. Any idea what could the error and how to rectify it.

edited Jun 18 '18 at 08:38

Sotos

51,121
6
32
66

asked Jun 18 '18 at 08:30

Sheetal Jadhav

1

Have a look at `rowSums`. Maybe something like `df[rowSums(df[7:18]) == 0,]` – Sotos Jun 18 '18 at 08:38
Read this: https://stackoverflow.com/questions/12328056/how-do-i-delete-rows-in-a-data-frame – SamAct Jun 18 '18 at 09:25
Thanks a lot. It worked ! – Sheetal Jadhav Jun 18 '18 at 12:45

how to delete a row

0 Answers0