Remove rows based on the rownames in list

Question

I have a list and I want to remove all the rows with "Volvo 142E" from data. any help will be appriciated.

data("mtcars")
rownames(mtcars)
data <- list(mtcars ,mtcars, mtcars, mtcars);data

out1 <- NULL
for(i in seq_along(data)) {
  out1[[i]] <- data[[i]][!(rownames(data[[i]]) %in% data[[i]] == "Volvo 142E" ), ]
}
out1

many thanks in advance

Try `lapply(data, function(i){rownames(i) <- NULL; i})` – Sotos Aug 04 '20 at 09:03 — Sotos, Aug 04 '20 at 09:03

score 1 · Accepted Answer · answered Aug 04 '20 at 09:07

1

You can use lapply to iterate over list and then subset the rows :

lapply(data,function(x) x[rownames(x) != "Volvo 142E", ])

Equivalent "tidy" option would be :

library(dplyr)
library(purrr)

map(data, ~.x %>% filter(rownames(.) != "Volvo 142E"))

answered Aug 04 '20 at 09:07

Ronak Shah

377,200
20
156
213

out1 <- NULL for(i in seq_along(data)) { out1[[i]] <- data[[i]][rownames(data[[i]]) != "Volvo 142E", ] } out1 – Seyma Kalay Aug 04 '20 at 09:58

Remove rows based on the rownames in list

1 Answers1