Dear all,
Thank you so much for all the replies.
The following worked exactly as needed:
> library("HSAUR2", lib.loc="/home/liv/R/i686-pc-linux-gnu-library/3.0")
> library("reshape2", lib.loc="/usr/local/lib/R/site-library")
> data(womensrole)
> zzz <- melt(womensrole,id.var=c("education","gender"))
> zzzz <- zzz[rep(1:nrow(zzz), zzz$value), 1:4 ]
> zzzz$agree <- zzzz$variable == 'agree'
> zzzz[ zzzz$education %in% 0:1, ]
education gender variable value agree
1 0 Male agree 4 TRUE
1.1 0 Male agree 4 TRUE
1.2 0 Male agree 4 TRUE
1.3 0 Male agree 4 TRUE
2 1 Male agree 2 TRUE
2.1 1 Male agree 2 TRUE
22 0 Female agree 4 TRUE
22.1 0 Female agree 4 TRUE
22.2 0 Female agree 4 TRUE
22.3 0 Female agree 4 TRUE
23 1 Female agree 1 TRUE
43 0 Male disagree 2 FALSE
43.1 0 Male disagree 2 FALSE
64 0 Female disagree 2 FALSE
64.1 0 Female disagree 2 FALSE
Regards,
Liviu
On Mon, Nov 25, 2013 at 8:26 PM, Thomas Stewart
<tgs.public.m...@gmail.com> wrote:
> I do not think Carl's solution answers your question. Try this:
>
> z <- textConnection(
> "education gender agree disagree sexe
> 1 0 Male 4 2 0
> 2 1 Male 2 0 0
> 3 2 Male 4 0 0
> 4 3 Male 6 3 0
> 5 4 Male 5 5 0
> 6 5 Male 13 7 0"
> )
>
> zz <- read.table(z,header=TRUE, stringsAsFactors=FALSE);
> close(z)
>
> zzz <- melt(zz,id.var=c("education","gender","sexe"))
> zzzz <- zzz[rep(1:nrow(zzz), zzz$value), 1:4 ]
> zzzz$agree <- zzzz$variable == 'agree'
>
> zzzz
>
> -tgs
>
>
> On Mon, Nov 25, 2013 at 4:24 AM, Liviu Andronic <landronim...@gmail.com>
> wrote:
>>
>> Dear all,
>> I am trying to convert the following data frame into a format more
>> useful for me:
>> > library("HSAUR2", lib.loc="C:/Program Files/R/R-3.0.2/library")
>> Loading required package: tools
>>
>> Attaching package: ‘HSAUR2’
>>
>> The following object is masked _by_ ‘.GlobalEnv’:
>>
>> womensrole
>>
>> > head(womensrole)
>> education gender agree disagree sexe
>> 1 0 Male 4 2 0
>> 2 1 Male 2 0 0
>> 3 2 Male 4 0 0
>> 4 3 Male 6 3 0
>> 5 4 Male 5 5 0
>> 6 5 Male 13 7 0
>>
>>
>> In 'womensrole', how do I convert 'agree' and 'disagree' variables
>> into one proper binary variable, say:
>> education gender agree sexe
>> 1 0 Male TRUE 0
>> 2 0 Male TRUE 0
>> 3 0 Male TRUE 0
>> 4 0 Male TRUE 0
>> 5 0 Male FALSE 0
>> 6 0 Male FALSE 0
>> 7 1 Male TRUE 0
>> 8 1 Male TRUE 0
>> 9 2 Male TRUE 0
>> 10 2 Male TRUE 0
>> 11 2 Male TRUE 0
>> 12 2 Male TRUE 0
>> [..]
>>
>> I'm sure there is an easy way to do this (in the form of 'melt',
>> 'cast', etc.), but I'm not sure how to approach the problem.
>>
>> Regards,
>> Liviu
>>
>> --
>> Do you know how to read?
>> http://www.alienetworks.com/srtest.cfm
>> http://goodies.xfce.org/projects/applications/xfce4-dict#speed-reader
>> Do you know how to write?
>> http://garbl.home.comcast.net/~garbl/stylemanual/e.htm#e-mail
>>
>> ______________________________________________
>> R-help@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.
>
>
--
Do you know how to read?
http://www.alienetworks.com/srtest.cfm
http://goodies.xfce.org/projects/applications/xfce4-dict#speed-reader
Do you know how to write?
http://garbl.home.comcast.net/~garbl/stylemanual/e.htm#e-mail
______________________________________________
R-help@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.
