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.
