Hi Abraham,
Just take it step by step. Paste the values together, combine them,
and assign them to a data.frame column. Like this perhaps:
df.1.2.3 <- data.frame(Var1 c(with(df1, paste(Var1, Var2, Var3)),
with(df2, paste(Var1, Var2)),
with(df3, paste(Var1, Var2))))
Best,
Ista
On Mon, Jun 6, 2011 at 12:22 PM, Abraham Mathew <abraham at
thisorthat.com> wrote:> I have the following data:
>
> prefix <- c("cheap", "budget")
> roots <- c("car insurance", "auto insurance")
> suffix <- c("quote", "quotes")
>
> prefix2 <- c("cheap", "budget")
> roots2 <- c("car insurance", "auto insurance")
>
> roots3 <- c("car insurance", "auto insurance")
> suffix3 <- c("quote", "quotes")
>
> df1 <- expand.grid(prefix, roots, suffix)
> df2 <- expand.grid(prefix2, roots2)
> df3 <- expand.grid(roots3, suffix3)
> df1; df2; df3
>
> df1, df2, and df3 are seperate data structures with seperate columns for
> root, prefix, and suffix.
>
> ?Var1 ? ? ? ? ? Var2 ? Var3
> 1 ?cheap ?car insurance ?quote
> 2 budget ?car insurance ?quote
> 3 ?cheap auto insurance ?quote
> 4 budget auto insurance ?quote
> 5 ?cheap ?car insurance quotes
> 6 budget ?car insurance quotes
> 7 ?cheap auto insurance quotes
> 8 budget auto insurance quotes
> ? ?Var1 ? ? ? ? ? Var2
> 1 ?cheap ?car insurance
> 2 budget ?car insurance
> 3 ?cheap auto insurance
> 4 budget auto insurance
> ? ? ? ? ? ?Var1 ? Var2
> 1 ?car insurance ?quote
> 2 auto insurance ?quote
> 3 ?car insurance quotes
> 4 auto insurance quotes
>
>
> I want to merge df1, df2, and df3, into one data frame column which looks
> like.
>
> ? ? ? ? ? ? ? ? ? ?Var1
> ?'cheap ?car insurance ?quote'
> ?'budget ?car insurance ?quote'
> ?'cheap auto insurance ?quote'
> ?'budget auto insurance ?quote'
> ?'cheap ?car insurance quotes'
> ?'budget ?car insurance quotes'
> ?'cheap auto insurance quotes'
> ?'budget auto insurance quotes'
> ? ? ? ? 'cheap ?car insurance'
> ? ? ? ? 'budget ?car insurance'
> ? ? ? ?'cheap auto insurance'
> ? ? ? ?'budget auto insurance'
> ? ? ? ?'car insurance ?quote'
> ? ? ? ? 'auto insurance ?quote'
> ? ? ? ?'car insurance quotes'
> ? ? ? ?'auto insurance quotes'
>
>
> Help!
> WebRep
> Overall rating
>
> ? ? ? ?[[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.
>
--
Ista Zahn
Graduate student
University of Rochester
Department of Clinical and Social Psychology
http://yourpsyche.org