[R] collapse a data column into a row

[Ista Zahn]

Hi,

On Wed, Mar 9, 2011 at 3:35 PM, Fahim Mohammad <fahim.md at gmail.com> wrote:
> I have a file with a data in columnar format like below:
>
> probeID
> rc_AI104113_at
> rc_AI178259_f_at
> rc_AI179134_i_at
> rc_AI179134_f_at
> rc_AI104113_at
> rc_AA819429_f_at
>
> How can I rewrite it in the  format below:
> 'rc_AI104113_at', 'rc_AI178259_f_at', 'rc_AI179134_i_at',
> 'rc_AI179134_f_at', 'rc_AI104113_at', 'rc_AA819429_f_at'

It's not clear to me what exactly this format is or what you want to
do with it (but see below)
>
>
> Is there any function to do this. I can do it by using iterative paste but
> I just want to avoid it for efficiency reason as number of probes is very
> high.

paste() doesn't care how many probes you have:

dat <- read.table(textConnection("probeID
rc_AI104113_at
rc_AI178259_f_at
rc_AI179134_i_at
rc_AI179134_f_at
rc_AI104113_at
rc_AA819429_f_at"), header=TRUE)
closeAllConnections()

cat(paste("'", dat$probeID, "'", sep=""))

Best,
Ista

>
> Thanks
>
> --Fahim
>
>        [[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