Message-ID: <397199E9-3B29-498C-907E-BCAE6574B748@comcast.net>
Date: 2010-01-30T21:26:17Z
From: David Winsemius
Subject: "should be" easy data frame manipulation
In-Reply-To: <1264870827975-1457518.post@n4.nabble.com>
On Jan 30, 2010, at 12:00 PM, Brad Patrick Schneid wrote:
>
> I have a data.frame with the following:
>
> ID Species Count
> 1 A 3
> 1 B 2
> 1 E 12
> 2 A 13
> 2 C 5
> 2 F 4
> 3 B 5
> 3 D 3
>
> I need it in this format:
>
> ID A B C D E F
> 1 3 2 0 0 12 0
> 2 13 0 5 0 0 4
> 3 0 5 0 3 0 0
Assuming the dataframe is called dtt:
> xtabs(Count ~ ID + Species, data=dtt)
Species
ID A B C D E F
1 3 2 0 0 12 0
2 13 0 5 0 0 4
3 0 5 0 3 0 0
>
David Winsemius, MD
Heritage Laboratories
West Hartford, CT