Re: [R] selecting the COLUMNS in a dataframe function of the numerical values in a ROW

2018-11-01 Thread Bogdan Tanasa
very helpful, thanks a lot ! On Thu, Nov 1, 2018 at 9:59 PM William Michels wrote: > Perhaps one of the following two methods: > > > zgene = data.frame( TTT=c(0,1,0,0), > +TTA=c(0,1,1,0), > + ATA=c(1,0,0,0), > + ATT=c(0,0,0,0), > +

Re: [R] selecting the COLUMNS in a dataframe function of the numerical values in a ROW

2018-11-01 Thread William Michels via R-help
Perhaps one of the following two methods: > zgene = data.frame( TTT=c(0,1,0,0), +TTA=c(0,1,1,0), + ATA=c(1,0,0,0), + ATT=c(0,0,0,0), + row.names=c("gene1", "gene2", "gene3", "gene4")) > zgene TTT TTA ATA ATT gene1 0 0 1

Re: [R] selecting the COLUMNS in a dataframe function of the numerical values in a ROW

2018-11-01 Thread Bogdan Tanasa
Dear Bill, and Bill, many thanks for taking the time to advice, and for your suggestions. I believe that I shall rephrase a bit my question, with a better example : thank you again in advance for your help. Let's assume that we start from a data frame : x = data.frame( TTT=c(0,1,0,0),

Re: [R] selecting the COLUMNS in a dataframe function of the numerical values in a ROW

2018-11-01 Thread William Michels via R-help
Hi Bogdan, Are you saying you want to drop columns that sum to zero? If so, I'm not sure you've given us a good example dataframe, since all your numeric columns give non-zero sums. Otherwise, what you're asking for is trivial. Below is an example dataframe ("ygene") with an example "AGA" column

Re: [R] selecting the COLUMNS in a dataframe function of the numerical values in a ROW

2018-11-01 Thread William Dunlap via R-help
This would be a bit simpler if 'gene' were the rownames of the data.frame. The '-4' is to remove the gene column from the calculations. > x[ x[,"gene"]=="gene2",] TTT TTA ATA gene 2 1 1 0 gene2 > colnames(x)[-4][ 1 == x[ x[,"gene"]=="gene2",-4] ] [1] "TTT" "TTA" > colnames(x)[-4][ 1 == x[

[R] selecting the COLUMNS in a dataframe function of the numerical values in a ROW

2018-11-01 Thread Bogdan Tanasa
Dear all, please may I ask for a suggestion : considering a dataframe that contains the numerical values for gene expression, for example : x = data.frame(TTT=c(0,1,0,0), TTA=c(0,1,1,0), ATA=c(1,0,0,0), gene=c("gene1", "gene2", "gene3", "gene4")) ho