Subset / filter rows in a data frame based on a condition in a column

by

Here are the two main approaches. I prefer this one for its readability:

bar <- subset(foo, location == "there")

Note that you can string together many conditionals with & and | to create complex subsets.

The second is the indexing approach. You can index rows in R with either numeric, or boolean slices. foo$location == "there" returns a vector of T and F values that is the same length as the rows of foo. You can do this to return only rows where the condition returns true.

foo[foo$location == "there", ]

More Related Contents:

  1. Filter data.frame rows by a logical condition
  2. Subset data frame based on number of rows per group
  3. How to sum a variable by group
  4. How do I make a list of data frames?
  5. Aggregate / summarize multiple variables per group (e.g. sum, mean)
  6. Sort (order) data frame rows by multiple columns
  7. The difference between bracket [ ] and double bracket [[ ]] for accessing the elements of a list or dataframe
  8. Numbering rows within groups in a data frame
  9. Split data frame string column into multiple columns
  10. Calculate the mean by group
  11. Select the row with the maximum value in each group
  12. Why is `[` better than `subset`?
  13. Pass a data.frame column name to a function
  14. Drop data frame columns by name
  15. How to subset matrix to one column, maintain matrix data type, maintain row/column names?
  16. Sample random rows in dataframe
  17. Extracting specific columns from a data frame
  18. How to drop columns by name in a data frame
  19. How does one reorder columns in a data frame?
  20. How do I extract a single column from a data.frame as a data.frame?
  21. Subset dataframe by multiple logical conditions of rows to remove
  22. Filtering a data frame on a vector [duplicate]
  23. Rename multiple columns by names
  24. How to subset data in R without losing NA rows?
  25. Using grep to help subset a data frame
  26. Convert a dataframe to a vector (by rows)
  27. Filter data frame rows based on values in vector
  28. Should I use a data.frame or a matrix?
  29. Selecting columns in R data frame based on those *not* in a vector
  30. Return df with a columns values that occur more than once [duplicate]

Leave a Comment