Thanks David and Bill.  I don't know how I couldn't think of that - maybe
because I'm working through a brutal flu right now.

Thanks for the help.  This list is a fantastic resource.
Trevor


On Fri, Nov 18, 2011 at 4:18 PM, David Winsemius <dwinsemius@comcast.net>wrote:

>
> On Nov 18, 2011, at 7:04 PM, Trevor Davies wrote:
>
>  A late friday afternoon coding question.  I'm having a hard time thinking
>> of the correct search terms for what I want to do.
>>
>> If I have a df like this:
>>
>> a <-
>> data.frame(name=c(rep('a',10),**rep('b',15)),year=c(1971:1980,**
>> 1971:1985),amount=1:25)
>>  name year amount
>> 1     a 1971      1
>> 2     a 1972      2
>> 3     a 1973      3
>> 4     a 1974      4
>> 5     a 1975      5
>> 6     a 1976      6
>> 7     a 1977      7
>> 8     a 1978      8
>> 9     a 1979      9
>> 10    a 1980     10
>> 11    b 1971     11
>> 12    b 1972     12
>> 13    b 1973     13
>> 14    b 1974     14
>> 15    b 1975     15
>> 16    b 1976     16
>> 17    b 1977     17
>> 18    b 1978     18
>> 19    b 1979     19
>> 20    b 1980     20
>> 21    b 1981     21
>> 22    b 1982     22
>> 23    b 1983     23
>> 24    b 1984     24
>> 25    b 1985     25
>>
>
> wide.a <- reshape(a , direction="wide", idvar="name", timevar="year")
>  names(wide.a) <- sub("amount", "x", names(wide.a) )
>  wide.a
> # -------------------
>   name x.1971 x.1972 x.1973 x.1974 x.1975 x.1976 x.1977 x.1978 x.1979
> x.1980 x.1981 x.1982 x.1983 x.1984 x.1985
> 1     a      1      2      3      4      5      6      7      8      9
> 10     NA     NA     NA     NA     NA
> 11    b     11     12     13     14     15     16     17     18     19
> 20     21     22     23     24     25
> >
>
>>
>>
>> and I'd like to reshape it so it is like this:
>> X.1971 X.1972 X.1973 X.1974 X.1975 X.1976 X.1977 X.1978 X.1979 X.1980
>> X.1981
>> a      1      2      3      4      5      6      7      8      9     10
>> NA
>> b     11     12     13     14     15     16     17     18     19     20
>> 21
>>  X.1982 X.1983 X.1984 X.1985
>> a     NA     NA     NA     NA
>> b     22     23     24     25
>>
>> Thanks for the assist.
>>
>>        [[alternative HTML version deleted]]
>>
>> ______________________________**________________
>> R-help@r-project.org mailing list
>> https://stat.ethz.ch/mailman/**listinfo/r-help<https://stat.ethz.ch/mailman/listinfo/r-help>
>> PLEASE do read the posting guide http://www.R-project.org/**
>> posting-guide.html <http://www.R-project.org/posting-guide.html>
>> and provide commented, minimal, self-contained, reproducible code.
>>
>
> David Winsemius, MD
> West Hartford, CT
>
>

	[[alternative HTML version deleted]]

