R help - Oct 2011 - repeating categorical variable codes

I would appreciate help in knowing how to repeat categorical variable code
given in column=A, by the number in a matching column=B.
For example, I have a categorical variable code attributed to a household=A
and want to replicate the code for all member of the household, as given in
column=B. I would like to have one sequence of categorical variable codes
for individuals in column C. I have ~9000 values in A and my C will be
~52000.

E.g
(A)    (B)      (C)
1       1         1
2       2         2
1       1         2
2       3         1
                    2
                    2
                    2

Any ideas would be gratefully accepted by a novice R user.

Ric

	[[alternative HTML version deleted]]

Hi
> 
> I would appreciate help in knowing how to repeat categorical variable 
code
> given in column=A, by the number in a matching column=B.
> For example, I have a categorical variable code attributed to a 
household=A
> and want to replicate the code for all member of the household, as given 
in
> column=B. I would like to have one sequence of categorical variable 
codes
> for individuals in column C. I have ~9000 values in A and my C will be
> ~52000.
> 
> E.g
> (A)    (B)      (C)
> 1       1         1
> 2       2         2
> 1       1         2
> 2       3         1
>                     2
>                     2
>                     2
> 
> Any ideas would be gratefully accepted by a novice R user.
I am not sure if I understand your problem but does rep(A, B)

give you what you want?

rep(letters[1:3], 1:3)
[1] "a" "b" "b" "c" "c"
"c"

Regards
Petr

> 
> Ric
> 
>    [[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.

> 
> Hi Petr,
> 
> Thank you for the reply. Unfortunately my repetition is not uniform, but 
> dependent on values given in column B, which varies by each row.
> 
> Does this make it any clearer?
Not much. 

let say
> A <- letters[1:10]
> B <- sample(1:3, 10, replace =TRUE)
> A
 [1] "a" "b" "c" "d" "e"
"f" "g" "h" "i"
"j"
> B
 [1] 2 3 2 3 1 1 1 3 1 1

Than 
> rep(A,B)
 [1] "a" "a" "b" "b" "b"
"c" "c" "d" "d" "d"
"e" "f" "g" "h" "h"
"h" "i"
"j"

gives you repeating letters according to values in second vector. If this 
is not what you want, try to send some artificial example which 
illustrates what you really have and what is desired result.

Regards
Petr
> 
> Ric
> On 5 October 2011 23:44, Petr PIKAL <petr.pikal at precheza.cz>
wrote:
> Hi
> 
> >
> > I would appreciate help in knowing how to repeat categorical variable
> code
> > given in column=A, by the number in a matching column=B.
> > For example, I have a categorical variable code attributed to a
> household=A
> > and want to replicate the code for all member of the household, as 
given
> in
> > column=B. I would like to have one sequence of categorical variable
> codes
> > for individuals in column C. I have ~9000 values in A and my C will be
> > ~52000.
> >
> > E.g
> > (A)    (B)      (C)
> > 1       1         1
> > 2       2         2
> > 1       1         2
> > 2       3         1
> >                     2
> >                     2
> >                     2
> >
> > Any ideas would be gratefully accepted by a novice R user.
> I am not sure if I understand your problem but does rep(A, B)
> 
> give you what you want?
> 
> rep(letters[1:3], 1:3)
> [1] "a" "b" "b" "c" "c"
"c"
> 
> Regards
> Petr
> 
> 
> >
> > Ric
> >
> >    [[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.
> 
>