This is a test version of Biostars. For the public version, visit https://www.biostars.org.
Delete rows in dataframe in R

Hi,

I have a dataframe with n columns and n rows. I need to search all cells (type string) that starts with "chr......" and I need to delete the corresponding row.

Did you help me ?

Thanks.

r dataframe rows dataframe r
• 34,231 views • link
written by mzezza • mzezza

This is more a programming question than bioinformatics...

So if a row contains one element which starts with "chr" the entire row has to be deleted?

• 0 views • link
written by WouterDeCoster WouterDeCoster

So do I - but it is not especially relevant to this problem.

• 0 views • link
written by Neilfws Neilfws

Fair enough. I thought filter() would easily address the problem but there's no straightforward way of filtering on all columns.

• 0 views • link
written by Dave Tang Dave Tang

Thanks you all, your advice has been useful. I solved with grepl function.

Now, another question: I need to delete from a dataframe rows of another dataframe (with the same structure) using, maybe, a common cell.

Thanks for your help.

• 0 views • link
written by mzezza • mzezza

Thanks you all, your advice has been useful. I solved with grepl function.

Now, another question: I need to delete from a dataframe rows of another dataframe (with the same structure) using, maybe, a common cell.

Thanks for your help.

• 0 views • link
written by mzezza • mzezza

It's advisable to create new threads for new questions. In addition, this is again not a bioinformatics question.

• 0 views • link
written by WouterDeCoster WouterDeCoster

1 answer

If your dataframe name is data, column is cell, try this: data[-grep('chr',data$cell),]

• 0 views • link
updated by Alex Reynolds Alex Reynolds • written by newbiebio newbiebio

don't forget "starts with"

• 0 views • link
written by Neilfws Neilfws

just change to:data[-grep("^chr",data$cell,perl=T),]

• 0 views • link
written by zjhzwang zjhzwang

Log in to answer this question.

More posts like this