R help - Dec 2010 - transposing panel data

I am currently trying to transpose some large panel data set ie transposing
multiple rows in into a single column. instead the transpose functionality
transposes all rows into columns. my sample data set looks like below:

 
 
 
 
 
 
  ACCT_NUM
  ACCOUNT_NAME
  TRAN_AMT
  DATE
  EMPLOYER
 
 
  101913
  GK
  7489
  30-Apr-10
  PENSION
 
 
  101913
  GK
  7489
  30-May-10
  PENSION
 
 
  101913
  GK
  7489
  30-Jun-10
  PENSION
 
 
  101913
  GK
  7489
  31-Jul-10
  PENSION
 
 
  101913
  GK
  7489
  31-Jan-10
  PENSION
 
 
  101913
  GK
  7489
  28-Feb-10
  PENSION
 
 
  101913
  GK
  7489
  31-Mar-10
  PENSION
 
 
  101913
  GK
  7489
  30-Oct-10
  PENSION
 
 
  101913
  GK
  7489
  30-Aug-10
  PENSION
 
 
  101913
  GK
  7489
  23-Sep-10
  PENSION
 
 
  101913
  GK
  53772
  30-Sep-10
  MKU
 
 
  101920
  CKM
  22739.7
  31-Jul-10
  POLICE
 
 
  101920
  CKM
  18327.6
  30-Sep-10
  POLICE
 
 
  101920
  CKM
  8840.4
  31-Mar-10
  POLICE
 
 
  101920
  CKM
  8986.25
  24-May-10
  POLICE
 
 
  101920
  CKM
  34252.2
  30-Jun-10
  POLICE
 
 
  101920
  CKM
  8913.35
  30-Apr-10
   POLICE
 

 
Ideally i would like a row to have one row of  ACCT_NUM and TranAmount and Date
be transposed to columns.

Thanks









Kind regards,
  Tabitha Mundia ,      Project Management  Office,       Equity Bank
Limited,P.O. Box 75104-00200
       Head Office, Upper  hill,       NHIF BLDG, 14th  Floor,   Nairobi, Kenya 
Direct Extension : +254732112721          Mobile: +254722309538       Email:
tabitha.mundia@equitybank.co.keSkype ID: twamaeYahoo ID: tabygathoni@yahoo.com


An idea not coupled with action will never get any bigger than the brain cell it
occupied.
Arnold Glasgow
......
"Attempt something large enough that failure is guaranteed…unless God steps
in!"


--- On Mon, 12/20/10, Kohleth Chia <kohleth@gmail.com> wrote:

From: Kohleth Chia <kohleth@gmail.com>
Subject: [R] package "arules" - 'transpose' of the
transactions
To: r-help@r-project.org
Date: Monday, December 20, 2010, 8:41 AM

Suppose this is my list of
 transactions:


set.seed(200)

tran=random.transactions(100,3)

inspect(tran)

  items    transactionID
1 {item80}        trans1
2 {item8,
   item20}        trans2
3 {item28}        trans3


I want to get the 'transpose' of the data, i.e.

  transactionID  items
1 {trans2}        item8
2 {trans2}        item20
3 {trans3}        item28
4 {trans1}        item80


I tried converting tran into a matrix, then transpose it, then convert it
back to transactions. But my dataset is actually very very large, so I
wonder if there is any faster method?

Thanks

-- 
KC

    [[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.









      


      
	[[alternative HTML version deleted]]

taby gathoni <tabieg <at> yahoo.com> writes:
> 
> I am currently trying to transpose some large panel data set 
> ie transposing multiple rows in into a single
> column. instead the transpose functionality transposes
> all rows into columns. my sample data set looks
> like below:
  Try the melt and cast functions in the reshape (or reshape2)
packages (reshape2 may be faster).  It may take a bit of work
to get the syntax right (try it out on a small subset of your
data).

  Ben Bolker