How to select all rows that have the same value in each column using tidyverse?

Question

I'm working on data quality analysis for a questionnaire where respondents were asked to check mark every bit of food that they ate. Some respondents left the form blank so I'm trying to figure out a way to select or count all rows where each column is blank.

In this particular dataset, the value of "No" indicates that the box was not checked on the form. A value of "Yes" means that the box was checked. They are currently character variables in the dataset. It's easy to count the number of yes and no responses in a particular column, but I'm interested in counting rows where every single response is "NO."

To make things simple, let's say that there are 5 columns representing different foods on the chart: Apple, Banana, Sandwich, Yogurt, Strawberry (the actual dataset has over 40 different food items). How would I select every row where "No" is the response for each food item?

This is what I've tried so far and it isn't working:

food_history <- food %>%
     filter(Apple:Strawberry=="No")

please post the output from `dput(head(food))` (or some row-selection that includes some rows to keep, some rows to drop). — r2evans, Mar 07 '23 at 18:40
and btw, it sounds like you're looking for a `filter` operation (choose rows) and not `select` (choose columns), is that right? — r2evans, Mar 07 '23 at 18:41

score 3 · Accepted Answer · answered Mar 07 '23 at 18:41

3

We can use if_all

library(dplyr)
food %>%
   filter(if_all(Apple:Strawberry, ~ .x == "No"))

answered Mar 07 '23 at 18:41

akrun

874,273
37
540
662

How to select all rows that have the same value in each column using tidyverse?

1 Answers1