How do I delete rows in a data frame?

by

The key idea is you form a set of the rows you want to remove, and keep the complement of that set.

In R, the complement of a set is given by the ‘-‘ operator.

So, assuming the data.frame is called myData:

myData[-c(2, 4, 6), ]   # notice the -

Of course, don’t forget to “reassign” myData if you wanted to drop those rows entirely—otherwise, R just prints the results.

myData <- myData[-c(2, 4, 6), ]

More Related Contents:

  1. Reshaping data.frame from wide to long format
  2. Quickly reading very large tables as dataframes
  3. Combine two data frames by rows (rbind) when they have different sets of columns
  4. Counting unique / distinct values by group in a data frame
  5. How to combine multiple conditions to subset a data-frame using “OR”?
  6. cbind a dataframe with an empty dataframe – cbind.fill?
  7. Split a large dataframe into a list of data frames based on common value in column
  8. Splitting a dataframe string column into multiple different columns [duplicate]
  9. Convert data.frame column format from character to factor
  10. How to convert a table to a data frame
  11. How do I combine two data-frames based on two columns? [duplicate]
  12. R Apply() function on specific dataframe columns
  13. Count NAs per row in dataframe [duplicate]
  14. Changing Column Names in a List of Data Frames in R
  15. Subset of rows containing NA (missing) values in a chosen column of a data frame
  16. rbind dataframes with a different column name
  17. Converting two columns of a data frame to a named vector
  18. Collapsing data frame by selecting one row per group
  19. Creating a new variable from a lookup table
  20. Practical limits of R data frame
  21. R: Assign variable labels of data frame columns
  22. rbind data frames based on a common pattern in data frame name
  23. How I can select rows from a dataframe that do not match?
  24. Join two data frames in R based on closest timestamp
  25. How to append a whole dataframe to a CSV in R
  26. Convert a data frame to a data.table without copy
  27. How can I merge more than 2 dataframes in R by rownames?
  28. Shifting a column down by one
  29. Identifying where value changes in R data.frame column
  30. What is the first column in R’s mtcars dataset?

Leave a Comment