I'm sorry everyone for the inconvenience of spamming the R-help...

Here's the complete post:


Hi everyone,
>
> Since it's quite a while that I used the reshape package, I now feel kind
> of rusty.
>
> I have a data.frame like this:
>
>
>
> id          Sample.Name               Marker           Allele.1
> Allele.2            sample_id            species
> 1            01_primer01                  Dalb01           165
>      179                  SH233             D. madagascariensis
> 2            01_primer04                  Dalb04            221
>       225                  SH233             D. madagascariensis
> 3            01_primer08                  Dalb08            218
>       218                  SH233             D. madagascariensis
> 4            01_primer10                  Dalb10            134
>       134                  SH233             D. madagascariensis
> 5            01_primer14                  Dalb14            250
>       250                  SH233             D. madagascariensis
> 6            01_primer16                  Dalb16            232
>       232                  SH233             D. madagascariensis
>
> this was just the head(), in fact, the sample_id col has in fact different
> ids, I would like to aggregate them into one
> and I would like to get something like this:
>
> species                           sample_id             Marker1_Allele1
>        Marker1_Allele2          Marker2_Allele1          Marker2_Allele2
>      Marker3_Allele1         Marker3_Allele2           etc. (with 35
> different markers)
>
> D. madagascariensis       SH233                 179
>               225                                  134
>      244
>
> I tried to prepare the cast() but didn't quite figure out how to achieve
> this. I wanted to create a col with the MarkerX_AlleleY 's, but didn't find
> any useful solutions. The sample_id's should be aggregated so that each
> sample_id needs just one row. Should I  just merge columns Allele.1,
> Allele.2 and sample_id?
>

I'm kind of stuck, but would appreciate any help on the columns to be
merged.

Thanks a lot
Martin Schilling



>
>

	[[alternative HTML version deleted]]

