bioinformatic
Technical User
Hi all,
I am working on a bioinformatics database and need help in creating a filter. There are 23000 genes with 4 columns with numerical values. I would like to keep the genes that have a value >50 in at least one of the columns. If the gene has two columns with value >50 then the gene is kept, if the gene has no columns with value >50 then the gene is not kept.
ex.
Alpha-amylase 10 20 10 20 <--Filtered Out
ABA 50 05 02 10 <--Keep
GA 100 50 20 10 <--Keep
Calmodulin 100 100 100 100 <--Keep
I've tried working with "or" but it only works within the same column.
All help is greatly appreciated.
-Randy W.
I am working on a bioinformatics database and need help in creating a filter. There are 23000 genes with 4 columns with numerical values. I would like to keep the genes that have a value >50 in at least one of the columns. If the gene has two columns with value >50 then the gene is kept, if the gene has no columns with value >50 then the gene is not kept.
ex.
Alpha-amylase 10 20 10 20 <--Filtered Out
ABA 50 05 02 10 <--Keep
GA 100 50 20 10 <--Keep
Calmodulin 100 100 100 100 <--Keep
I've tried working with "or" but it only works within the same column.
All help is greatly appreciated.
-Randy W.