Remove Rows From Data Frame where a Row matches a String

by

Just use the == with the negation symbol (!). If dtfm is the name of your data.frame:

dtfm[!dtfm$C == "Foo", ]

Or, to move the negation in the comparison:

dtfm[dtfm$C != "Foo", ]

Or, even shorter using subset():

subset(dtfm, C!="Foo")

More Related Contents:

  1. Filter data.frame rows by a logical condition
  2. Split column at delimiter in data frame [duplicate]
  3. Pass a data.frame column name to a function
  4. How to convert a list consisting of vector of different lengths to a usable data frame in R?
  5. Select groups based on number of unique / distinct values
  6. Assign multiple columns using := in data.table, by group
  7. Filtering a data frame on a vector [duplicate]
  8. How to replace NA values in a table for selected columns
  9. Remove an entire column from a data.frame in R
  10. Selecting multiple odd or even columns/rows for dataframe
  11. Sample n random rows per group in a dataframe
  12. Deleting reversed duplicates with R
  13. Select every nth row from dataframe
  14. Growing a data.frame in a memory-efficient manner
  15. R list of lists to data.frame
  16. Remove columns from dataframe where some of values are NA
  17. Check whether values in one data frame column exist in a second data frame
  18. How do you remove columns from a data.frame?
  19. Deleting columns from a data.frame where NA is more than 15% of the column length [duplicate]
  20. Using lapply to apply a function over list of data frames and saving output to files with different names
  21. DT[!(x == .)] and DT[x != .] treat NA in x inconsistently
  22. Return df with a columns values that occur more than once [duplicate]
  23. Row-wise sum of values grouped by columns with same name
  24. Replicate each row of data.frame and specify the number of replications for each row?
  25. Count unique values for every column
  26. Numbers as column names of data frames
  27. Divide each value by the sum of values by group
  28. Convert all data frame character columns to factors
  29. What you can do with a data.frame that you can’t with a data.table?
  30. Override column types when importing data using readr::read_csv() when there are many columns

Leave a Comment