Crosstab from sql dump

thanks for all the tips.

using 'unstack(read.table('/tmp/codes', header=TRUE))' gets me

  user1 user2
1   100   100
2   200   200
3   300   300

where /tmp/codes contains

code name
100 user1
200 user1
300 user1
100 user2
200 user2
300 user2

so unstack is exactly what i was looking for. for the record, it is
probably a good idea to specify which column is values and which is
group indicator like 'unstack(read.table('/tmp/crap', header=TRUE),
"code ~ name")' in case your columns are in a different order.

alan

Alan Gibson <alan.gibson <at> gmail.com> writes:

Im looking for a simple function to produce a crosstab from a dumped
sql query result.

xtabs in stats is a simple solution, but package reshape is much more flexible
and comes with a good introduction.pdf.

Dieter

______________________________________________
R-help at stat.math.ethz.ch 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.