Well, it seems a simple "c" will do. e.g.
df <- matrix(rnorm(100), ncol=4) c(t(df[1:10,])) # concatenate rows c(df) # concatenate columns > >From: santana sarma <aimanusa...@gmail.com> >To: "Shi, Tao" <shida...@yahoo.com>; r-help@r-project.org >Sent: Thu, May 20, 2010 11:45:25 PM >Subject: Re: Concatenation > > >Ok -let's forget about the dataframe. > > >Say, I have this (huge) spreadsheet that has some rows and columns, with >unique rownames and column names. > >Using R, I wish to FINALLY have a spreadsheet where the values of the first 10 >rows remain in a single row. And, the values of the next 10 rows remain in the >next row .... and so on. > > >Example: > > >row1 = 2, 3.4, 5, 6 >row2 = 3, 4.3, 0, 2 >....... >row 10 = 1,3, 4, 5 > > >new_row_should_be_like = 2, 3.4, 5, 6, 3, 4.3, 0, 2, ...... 1, 3, 4, 5 > > > > >Similarly, > >Similarly, for columns, the new spreadsheet should FINALLY contain : the >values of the columns coming one below the other (i.e., resulting in a single >column, without the identifiers). > > >col1 col2 col3......... col10 >2 3 4 5 >1 2 5 0 >........... >........... > > >new_column_should_be_like = >2 >1 >... >3 >2 >.... >4 >5 >... >5 >0 >..... >...... > > > > > > >Cheers, > > > > >= = = === = = = = = > > >On Fri, May 21, 2010 at 5:51 PM, Shi, Tao <shida...@yahoo.com> wrote: > >Still not clear. Follow the posting guide and some examples always help. >> >>>>Not sure how you "concatenate" numbers? >> >>>>You can try, for example, >> >>>>apply(df[1:10,], 2, paste, collapse=" ") >> >>>>but this will turn everything into strings. Is this what you want? >> >>>>..Tao >> >> >> >> >> >>>>----- Original Message ---- >>>>> From: santana sarma <aimanusa...@gmail.com> >>>>> To: David Winsemius <dwinsem...@comcast.net> >>>>> Cc: r-help@r-project.org >>>>> Sent: Thu, May 20, 2010 9:21:33 PM >>>>> Subject: Re: [R] Concatenation >>>>> >>>>> Hi David, >> >>>>SORRY - I am trying to be more clearer this time. >> >>>>Let's >>>>> say the dataframe has some rows and columns, with unique rownames and >>>>column >>>>> names. The rest of the data in the dataframe are just numbers. >> >>>>I wish to >>>>> concatenate those rows. That means : I wish to concatenate first >>>>10 rows' >>>>> values in one row, then next 20 rows's values in the next row .... >>>>and so >>>>> on. >> >>>>Similarly, for columns : The first 10 column's values will be one >>>>> below the >>>>other ... and so on. >> >>>>Cheers, >> >> >>>>= = = = = = = = >>>>> = = = >> >> >>>>On Fri, May 21, 2010 at 3:53 PM, David Winsemius < >>> ymailto="mailto:dwinsem...@comcast.net"; >>>>> href="mailto:dwinsem...@comcast.net";>dwinsem...@comcast.net>wrote: >> >> >>>>> >>>>> >>>>> On May 20, 2010, at 11:05 PM, santana sarma wrote: >>>>> >>>>> >>>>> Hi, >>>>>> >>>>>> I have a dataframe with some 800 rows and 14 >>>>> columns. >>>>>> >>>>>> Could you please advise how I can concatenate >>>>> the rows - one after >>>>>> another. >>>>>> Similarly for columns, one >>>>> below the other. >>>>>> >>>>> >>>>> Not sure exactly what you are >>>>> after: >>>>> >>>>> unlist might accomplish the second task. >>>>> >>>>> >>>>> Whether c(apply(df, 1, I)) would be satisfactory for the first task >>>>> might >>>>> depend on whether the columns in the dataframe were all of the >>>>> same type. >>>>> Now that I think of it, both soolutions would force the types >>>>> to be that >>>>> same. >>>>> >>>>> ?"c" >>>>> ?I >>>>> >>>>> ?apply >>>>> >>>>> df[1:nrow(df), ] ... would essentially give >>>>> you the first request, but >>>>> it would not be any different than just >>>>> typing df. So .... what do intend >>>>> this process to >>>>> accomplish? >>>>> >>>>> -- >>>>> >>>>> David Winsemius, MD >>>>> West >>>>> Hartford, CT >>>>> >>>>> >> >> [[alternative HTML >>>>> version deleted]] >> >>>>______________________________________________ >> >>>>> ymailto="mailto:R-help@r-project.org"; >>>>> href="mailto:R-help@r-project.org";>R-help@r-project.org mailing list >> >>>>> href="https://stat.ethz.ch/mailman/listinfo/r-help"; target=_blank >>>>> >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@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.
