An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20101220/03666b6f/attachment.pl>
transposing panel data
2 messages · taby gathoni, Ben Bolker
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