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]]

