thr3ads.net - R help - [R] Columns and rows [Oct 2012]

If this information is useful, please help other people find it:
Share via:

Santana Sarma

2012-Oct-12 00:55 UTC

[R] Columns and rows

Hi,

Could you please advice some easy way to do the following for a dataframe
(header=F) having unequal column- & row- length.

1. Combine/stack/join contents from -
              a) multiple rows into one column.
              b) multiple columns into one row.

2. Stack contents from multiple columns (or, rows) into one column (or,
row).

Thank you.

Cheers,

Santana

	[[alternative HTML version deleted]]

Jeff Newmiller

2012-Oct-12 02:17 UTC

head link

[R] Columns and rows

Data frames don't have unequal column or row lengths within a single object.
Your terminology is obscuring your intent. Perhaps you should read the posting
guide for guidance on posting here and then generate a reproducible example.
Since you seem to be having difficulty with the "how", at least
provide sample input and desired output following the recommendations here:

 http://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example

Are you aware of

?cbind
?rbind
?merge

?
---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live
Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
--------------------------------------------------------------------------- 
Sent from my phone. Please excuse my brevity.

Santana Sarma <aimanusarma at gmail.com> wrote:
>Hi,
>
>Could you please advice some easy way to do the following for a
>dataframe
>(header=F) having unequal column- & row- length.
>
>1. Combine/stack/join contents from -
>              a) multiple rows into one column.
>              b) multiple columns into one row.
>
>2. Stack contents from multiple columns (or, rows) into one column (or,
>row).
>
>Thank you.
>
>Cheers,
>
>Santana
>
>	[[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.

David Winsemius

2012-Oct-12 02:32 UTC

head link

[R] Columns and rows

On Oct 11, 2012, at 5:55 PM, Santana Sarma wrote:
> Hi,
> 
> Could you please advice some easy way to do the following for a dataframe
> (header=F) having unequal column- & row- length.
> 
> 1. Combine/stack/join contents from -
>              a) multiple rows into one column.
>              b) multiple columns into one row.
> 
> 2. Stack contents from multiple columns (or, rows) into one column (or,
> row).
Could _you_ please produce an example.

Dataframes do not have headers. They do have column names and column names are
required.

-- 
David Winsemius, MD
Alameda, CA, USA

David L Carlson

2012-Oct-12 21:20 UTC

head link

[R] Columns and rows

This should also work:

Using the dat1 data frame that arun created:

#1> dat2 <- t(dat1[,2:4])
> dim(dat2) <- prod(dim(dat2))
> dat2 <- data.frame(Col1=dat2, stringsAsFactors=FALSE)
> dat2   Col1
1     A
2     E
3     H
4     B
5     F
6     I
7     C
8     G
9     J
10    D
11    K
12     

#2> dat3 <- as.matrix(dat1[, 2:4])
> dim(dat3) <- prod(dim(dat3))
> dat3 <- data.frame(Col1=dat3, stringsAsFactors=FALSE)
> dat3   Col1
1     A
2     B
3     C
4     D
5     E
6     F
7     G
8     K
9     H
10    I
11    J
12     

#3> d4 <- data.frame(t(dat2), stringsAsFactors=FALSE)
> d4     X1 X2 X3 X4 X5 X6 X7 X8 X9 X10 X11 X12
Col1  A  E  H  B  F  I  C  G  J   D   K  

----------------------------------------------
David L Carlson
Associate Professor of Anthropology
Texas A&M University
College Station, TX 77843-4352

> -----Original Message-----
> From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-
> project.org] On Behalf Of arun
> Sent: Thursday, October 11, 2012 11:26 PM
> To: Santana Sarma
> Cc: R help
> Subject: Re: [R] Columns and rows
> 
> HI,
> Try this:
> dat1<-read.table(text="
> Names Colx Coly Colz
> rowName1 A E H
> rowName2 B F I
> rowName3 C G J
> rowName4 D K
> ",sep="",header=TRUE,stringsAsFactors=FALSE,fill=TRUE)
> ?dat2<-t(dat1)
> dat3<-dat2[2:4,]
> dat4<-do.call(rbind,sapply(dat3,list)))
> 
> row.names(dat4)<-1:nrow(dat4)
> ?dat4
> ?dat4
> #?? [,1]
> #1? "A"
> #2? "E"
> #3? "H"
> #4? "B"
> #5? "F"
> #6? "I"
> #7? "C"
> #8? "G"
> #9? "J"
> #10 "D"
> #11 "K"
> #12 ""
> 
> data.frame(col1=stack(dat1[,2:4])[,1])
> #?? col1
> #1???? A
> #2???? B
> #3???? C
> #4???? D
> #5???? E
> #6???? F
> #7???? G
> #8???? K
> #9???? H
> #10??? I
> #11??? J
> #12
> 
> 
> dat5<-do.call(data.frame,sapply(dat3,list))
> ?dat5
> #? A E H B F I C G J D K X..
> #1 A E H B F I C G J D K
> A.K.
> 
> 
> 
> 
> ----- Original Message -----
> From: Santana Sarma <aimanusarma at gmail.com>
> To: David Winsemius <dwinsemius at comcast.net>
> Cc: r-help at r-project.org
> Sent: Thursday, October 11, 2012 11:07 PM
> Subject: Re: [R] Columns and rows
> 
> Hi,
> 
> Trying to give an example here.
> Say, I have read in a .csv file using read.csv (), and the file
> contains
> the following info.
> 
> 
> Names Col x Col y Col z
> rowName1 A E H
> rowName2 B F I
> rowName3 C G J
> rowName4 D K
> 
> 
> 
> Now, this is what is required:
> 
> 1. Combine/stack/join contents from -
> ? ? ? ? ? ? ? a) multiple rows into one column.
> 
> 
> That is:
> 
> A
> E
> H
> B
> F
> I
> C
> G
> J
> D
> K
> 
> ? ? ? ? ? ? ? b) multiple columns into one row.
> 
> A B C D E F G H I J K
> 
> 
> 2. Stack contents from
> 
> A) multiple columns into one column.
> 
> A
> B
> C
> D
> E
> F
> G
> H
> I
> J
> K
> 
> 
> B) Multiple rows into one row.
> 
> A E H B F I C G J D
> 
> 
> Thank you.
> 
> Cheers,
> Santana
> 
> ===============================> 
> 
> On Fri, Oct 12, 2012 at 1:32 PM, David Winsemius
> <dwinsemius at comcast.net>wrote:
> 
> >
> > On Oct 11, 2012, at 5:55 PM, Santana Sarma wrote:
> >
> > > Hi,
> > >
> > > Could you please advice some easy way to do the following for a
> dataframe
> > > (header=F) having unequal column- & row- length.
> > >
> > > 1. Combine/stack/join contents from -
> > >? ? ? ? ? ? ? a) multiple rows into one column.
> > >? ? ? ? ? ? ? b) multiple columns into one row.
> > >
> > > 2. Stack contents from multiple columns (or, rows) into one
column
> (or,
> > > row).
> >
> > Could _you_ please produce an example.
> >
> > Dataframes do not have headers. They do have column names and column
> names
> > are required.
> >
> > --
> > David Winsemius, MD
> > Alameda, CA, USA
> >
> >
> 
> ??? [[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.
> 
> 
> ______________________________________________
> 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.

Possibly Parallel Threads

Search for more apparently analagous threads

R help - Oct 2012 - Columns and rows

[R] Columns and rows

[R] Columns and rows

[R] Columns and rows

[R] Columns and rows

Possibly Parallel Threads