[R] reduce three columns to one with the colnames

arun smartpink111 at yahoo.com
Mon May 13 17:37:08 CEST 2013


HI,
May be:
dat1<- read.table(text="
male female transsexuals
0 1 0
1 0 0
0 0 1
0 1 0
1 0 0
1 0 0
0 1 0
",sep="",header=TRUE)

 dat1$sex<-colnames(dat1)[apply(dat1,1,function(x) which(x==1))]
 dat1
#  male female transsexuals          sex
#1    0      1            0       female
#2    1      0            0         male
#3    0      0            1 transsexuals
#4    0      1            0       female
#5    1      0            0         male
#6    1      0            0         male
#7    0      1            0       female


A.K.



----- Original Message -----
From: David Studer <studerov at gmail.com>
To: Bert Gunter <gunter.berton at gene.com>
Cc: r-help at r-project.org
Sent: Monday, May 13, 2013 11:22 AM
Subject: Re: [R] reduce three columns to one with the colnames

OK, seems like nobody understood my question ;-)

Let's make another example:

I have three variables:
data$male and data$female and data$transsexuals

All the three of them contain the values 0 and 1.

Now I'd like to create another variable data$sex. Now in all cases where
data$female==1 the variable data$sex should be set to 'female', all in all
cases
where data$male==1 the variable data$sex should be set to 'male' and so
on...

Thank you!

David




2013/5/13 Bert Gunter <gunter.berton at gene.com>

> No -- my answer is wrong. I'll leave it to others to correct. Obvious
> question to OP: What if more than one of your colors variables
> simultaneously have a 1?
>
> -- Bert
>
> On Mon, May 13, 2013 at 8:09 AM, Bert Gunter <bgunter at gene.com> wrote:
> > Cute answer, Pascal. It may even be the answer to the question the OP
> > should have asked, but I don't think it answered the question that was
> > asked. That might be:
> >
> > c("red"[red], "green"[green], "blue"[blue])
> >
> > Cheers,
> > Bert
> >
> > On Mon, May 13, 2013 at 7:36 AM, Pascal Oettli <kridox at ymail.com> wrote:
> >> Hi,
> >>
> >> ?rgb
> >>
> >> HTH
> >> Pascal
> >>
> >>
> >> 2013/5/13 David Studer <studerov at gmail.com>
> >>
> >>> Hello everybody,
> >>>
> >>> I have three variables "blue", "green" and "red" containing values 0
> (no)
> >>> and 1 (yes).
> >>>
> >>> How can I easily create another variable "colors" with the values
> "blue",
> >>> "green" and "red"?
> >>>
> >>> I hope that you can understand my question and appreciate any
> solutions or
> >>> hints!
> >>>
> >>> Thank you!
> >>> David
> >>>
> >>>         [[alternative HTML version deleted]]
> >>>
> >>> ______________________________________________
> >>> R-help at r-project.org mailing list
> >>> https://stat.ethz.ch/mailman/listinfo/r-help
> >>> PLEASE do read the posting guide
> >>> http://www.R-project.org/posting-guide.html
> >>> and provide commented, minimal, self-contained, reproducible code.
> >>>
> >>
> >>         [[alternative HTML version deleted]]
> >>
> >> ______________________________________________
> >> R-help at r-project.org mailing list
> >> https://stat.ethz.ch/mailman/listinfo/r-help
> >> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> >> and provide commented, minimal, self-contained, reproducible code.
> >
> >
> >
> > --
> >
> > Bert Gunter
> > Genentech Nonclinical Biostatistics
> >
> > Internal Contact Info:
> > Phone: 467-7374
> > Website:
> >
> http://pharmadevelopment.roche.com/index/pdb/pdb-functional-groups/pdb-biostatistics/pdb-ncb-home.htm
>
>
>
> --
>
> Bert Gunter
> Genentech Nonclinical Biostatistics
>
> Internal Contact Info:
> Phone: 467-7374
> Website:
>
> http://pharmadevelopment.roche.com/index/pdb/pdb-functional-groups/pdb-biostatistics/pdb-ncb-home.htm
>

    [[alternative HTML version deleted]]

______________________________________________
R-help at r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.




More information about the R-help mailing list