多列条件筛选DataFrame报错求助：numerical expression has XXX elements

Hey there, let's work through this DataFrame filtering issue you're having! The error you're seeing happens because your attempts to reference multiple columns aren't working the way you expect, and R can't resolve the logical conditions correctly for row-wise filtering.

Why your original attempts failed: #

• dat[,1:10]>x creates a logical matrix (n rows × 10 columns), but when you use dat[dat[,1:10]>x,], R tries to use this matrix as row indices—which doesn't work because it expects a single logical vector per row.
• dat$V1:dat$V10 doesn't select columns V1 to V10. Instead, it creates a numeric sequence from the value of dat$V1 to dat$V10, which is totally not what you want. That's why you get the "only the first used" error.
• subset(dat, dat$V1:dat$V10>x) has the same problem as above—you're not referencing columns correctly, so the condition is invalid.

Working solutions: #

Here are three reliable ways to filter rows where all columns 1 to 10 are greater than x:

1. Using rowSums (base R)

This counts how many columns per row meet the condition, then keeps rows where all 10 columns pass:

x <- 1 # Replace with your actual x value
filtered_dat <- dat[rowSums(dat[, 1:10] > x) == 10, ]

• dat[, 1:10] > x generates a logical matrix where each cell is TRUE if the value is greater than x.
• rowSums() adds up all the TRUE values (treated as 1) per row. If the sum equals 10, every column in that row meets the condition.

2. Using apply (base R)

This checks each row explicitly with all():

filtered_dat <- dat[apply(dat[, 1:10], 1, function(row) all(row > x)), ]

• apply(dat[, 1:10], 1, ...) runs the function on each row (the 1 means row-wise).
• function(row) all(row > x) returns TRUE only if every element in the row is greater than x.

3. Using dplyr (tidyverse approach)

If you prefer the tidyverse syntax, this is clean and readable:

library(dplyr)

filtered_dat <- dat %>%
  filter(across(1:10, ~ . > x))

• across(1:10, ~ . > x) applies the condition . > x to every column from 1 to 10.
• filter() keeps only rows where all these conditions are true.

All three methods will correctly filter your DataFrame to keep only rows where columns 1 through 10 are all greater than x.

内容的提问来源于stack exchange，提问作者Egon