R语言中用read.csv读取数据后，筛选全科目Pass学生的方法问询

Hey there! I get you—you've got your student data loaded with read.csv(), and now you need to narrow it down to only those who passed every subject. Let's walk through a few straightforward ways to do this.

First, let's assume your data frame is called student_data (adjust the name to match what you used): #

student_data <- read.csv("your_file_name.csv")

Method 1: Base R (no extra packages needed) #

If you prefer sticking to base R, you can use logical conditions with the & operator (which means logical AND) to check each subject column:

all_passed <- student_data[student_data$Math == "Pass" & student_data$Science == "Pass" & student_data$Art == "Pass", ]

The comma at the end keeps all columns, and the & ensures every subject condition is satisfied.

Method 2: Using dplyr (cleaner syntax for larger datasets) #

If you're using the tidyverse, the filter() function makes this super readable. First load the package if you haven't:

library(dplyr)

all_passed <- student_data %>%
  filter(Math == "Pass", Science == "Pass", Art == "Pass")

In filter(), multiple conditions separated by commas are treated as logical AND checks—perfect for your needs.

Bonus: Generic method for many subject columns #

If you had more than 3 subjects and didn't want to type every column name, try these:

• Base R: Use rowSums() to count how many columns have "Fail", then keep rows where that count is 0:

# Assuming subject columns are 2 to 4 (adjust indices if needed)
all_passed <- student_data[rowSums(student_data[, 2:4] != "Pass") == 0, ]

• dplyr: Use across() to apply the condition to multiple columns at once:

all_passed <- student_data %>%
  filter(across(c(Math, Science, Art), ~ .x == "Pass"))

Let's test this with a sample dataset:

Name,Math,Science,Art
Alice,Pass,Fail,Pass
Mick,Pass,Pass,Pass
Mark,Pass,Pass,Pass
Bob,Fail,Pass,Pass

After filtering, all_passed will only include Mick and Mark—exactly what you wanted!

内容的提问来源于stack exchange，提问作者Mark K.