Issue with finding row ID in a data table in R

Question

I have a data frame like below. How can I get the row id when all elements are present in a data table.

For example,

Table:

    L001 044 N   004 E   036 NA   NA  NA  NA  NA  NA
    L001 086 N   016 E   016 NA   NA  NA  NA  NA  NA
    L001 092 N   011 E   026 L002 044 N   006 E   022
    L001 056 N   036 E   061 NA   NA  NA  NA  NA  NA

I need to obtain the row id in "Table" when all elements are filled. For example in this example row id is 3 since all columns in "Table" has a value.

Any help is appreciated.

Where is this table stored? A text file? Relational database? — YetiCGN, Dec 10 '18 at 16:07
Then you need to read it line by line anyway, so you can just count the line number and test every line. If all the fields are set, return / exit with the current line number. — YetiCGN, Dec 10 '18 at 16:18
Please, NUdu, unambiguous data: https://stackoverflow.com/questions/53672753/issue-with-pasting-5-columns-groups-in-r/53672956#comment94203877_53672753 — r2evans, Dec 13 '18 at 21:40

score 0 · Answer 1 · answered Dec 10 '18 at 21:23

Where df equals:

df = read.table(
  text = "
  L001 044 N   004 E   036 NA   NA  NA  NA  NA  NA
  L001 086 N   016 E   016 NA   NA  NA  NA  NA  NA
  L001 092 N   011 E   026 L002 044 N   006 E   022
  L001 056 N   036 E   061 NA   NA  NA  NA  NA  NA
  "
)

You can do:

rownames(df[complete.cases(df)==TRUE,])

Resulting in:

[1] "3"

Issue with finding row ID in a data table in R

1 Answers1