Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is causing 'object not found' error in filter() with the across() function?

Tags:

r

dplyr

tidyverse

This function filters/selects one or more variables from my dataset and writes it to a new CSV file. I'm getting an 'object not found' error when I call the function. Here is the function:

    extract_ids <-  function(filename, opp, ...) {
  
  #Read in data
  df <- read_csv(filename)
  
  #Remove rows 2,3
  df <- df[-c(1,2),]
    
    #Filter and select
    df_id <- filter(df, across(..., ~ !is.na(.x)) & gc == 1) %>%
      select(...) #not sure if my use of ... here is correct
    
    #String together variables for export file path
    path <- c("/Users/stephenpoole/Downloads/",opp,"_",...,".csv") #not sure if ... here is correct
    
    #Export the file
    write_csv(df_id, paste(path,collapse=''))
    
  
}

And here is the function call. I'm trying to get columns "rid" and "cintid."

extract_ids(filename = "farmers.csv",
            opp = "farmers",
            rid, cintid)

When I run this, I get the below error:

 Error: Problem with `filter()` input `..1`.
ℹ Input `..1` is `across(..., ~!is.na(.x)) & gc == 1`.
x object 'cintid' not found

The column cintid is correct and appears in the data. I've also tried running it with just one column, rid, and get the same 'object not found' error.

like image 245
Stephen Poole Avatar asked Dec 07 '25 06:12

Stephen Poole


1 Answers

If you are passing multiple values to across(), you need to collect them in the first parameter, otherwise they will spread into the other parameters of across(). Try

filter(df, across(c(...), ~ !is.na(.x)) 

Otherwise every value other than the first one will be passed along as a parameter to function you've specified in across()

like image 144
MrFlick Avatar answered Dec 08 '25 21:12

MrFlick



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!