Find the header row in a data.frame
Details
If ... is missing, then the first row with no missing values is used.
When searching for a specified value or value within a column, the first row
with a match will be returned, regardless of the completeness of the rest of
that row. If ... has a single character argument, then the first
column is searched for that value. If ... has a named numeric
argument, then the column whose position number matches the value of that
argument is searched for the name (see the last example below). If more than one
row is found matching a value that is searched for, the number of the first
matching row will be returned (with a warning).
See also
Other Set names:
clean_names(),
mu_to_u,
row_to_names()
Examples
# the first row
find_header(data.frame(A = "B"))
#> [1] 1
# the second row
find_header(data.frame(A = c(NA, "B")))
#> [1] 2
# the second row since the first has an empty value
find_header(data.frame(A = c(NA, "B"), B = c("C", "D")))
#> [1] 2
# The third row because the second column was searched for the text "E"
find_header(data.frame(A = c(NA, "B", "C", "D"), B = c("C", "D", "E", "F")), "E" = 2)
#> [1] 3