Oops, that should have been: stretch_df(tadf,"V1","V2")
Jim On Thu, Jul 6, 2017 at 8:38 AM, Jim Lemon <drjimle...@gmail.com> wrote: > Hi Tom, > Or perhaps: > > #assume the data frame is named "tadf" > library(prettyR) > stretch_df(tadf,1,2) > > Jim > > > On Thu, Jul 6, 2017 at 6:50 AM, Ista Zahn <istaz...@gmail.com> wrote: >> The reason it doesn't work easily with reshape/reshape2 is that the >> order of the rows is not determined. Your answer could be >> >> 1957 1958 ... 1985 1986 >> 0.8625000 0.7500000 ... 0.7307692 0.23750000 >> 0.0733945 0.6435644 ... NA 0.05769231 >> 0.5096154 NA ... NA 0.65137615 >> >> or >> >> 1957 1958 ... 1985 1986 >> 0.0733945 0.6435644 ... NA 0.05769231 >> 0.8625000 0.7500000 ... 0.7307692 0.23750000 >> 0.5096154 NA ... NA 0.65137615 >> >> or >> >> 1957 1958 ... 1985 1986 >> 0.8625000 0.6435644 ... NA 0.23750000 >> 0.0733945 NA 0.7307692 0.05769231 >> 0.5096154 0.7500000 ... NA 0.65137615 >> >> or any other combination of orders. You might not care about the >> order, but reshape does. >> >> The usual way around it is to just make up an order variable, e.g., >> assuming your data.frame is named "example_data" and the columns are >> named "year" and "score": >> >> example_data <- do.call(rbind, >> lapply(split(example_data, >> example_data$year), >> transform, >> obs = seq_along(year))) >> >> dcast(example_data, >> obs ~ year, >> value.var = "score") >> >> Best, >> Ista >> >> >> On Wed, Jul 5, 2017 at 2:16 PM, Thomas Adams <tea...@gmail.com> wrote: >>> Hi all: >>> >>> I'm struggling with getting my data re-formatted using functions in >>> reshape/reshape2 to get from: >>> >>> 1957 0.862500000 >>> 1958 0.750000000 >>> 1959 0.300000000 >>> 1960 0.287500000 >>> 1963 0.675000000 >>> 1964 0.937500000 >>> 1965 0.025000000 >>> 1966 0.387500000 >>> 1969 0.087500000 >>> 1970 0.275000000 >>> 1973 0.500000000 >>> 1974 0.362500000 >>> 1976 0.925000000 >>> 1978 0.712500000 >>> 1979 0.337500000 >>> 1980 0.700000000 >>> 1981 0.425000000 >>> 1982 0.212500000 >>> 1983 0.312500000 >>> 1986 0.237500000 >>> 1958 0.643564356 >>> 1963 0.250000000 >>> 1968 0.211538462 >>> 1976 0.317307692 >>> 1981 0.673076923 >>> 1985 0.730769231 >>> 1986 0.057692308 >>> 1957 0.073394495 >>> 1966 0.742574257 >>> 1961 0.082568807 >>> 1964 0.165137615 >>> 1965 0.137614679 >>> 1959 0.128712871 >>> 1968 0.587155963 >>> 1969 0.660550459 >>> 1970 0.477064220 >>> 1971 0.513761468 >>> 1973 0.449541284 >>> 1974 0.128440367 >>> 1968 0.415841584 >>> 1977 0.009174312 >>> 1979 0.339449541 >>> 1981 0.596330275 >>> 1982 0.348623853 >>> 1984 0.146788991 >>> 1986 0.651376147 >>> 1959 0.451923077 >>> 1965 0.750000000 >>> 1962 0.326732673 >>> 1964 0.782178218 >>> 1970 0.336538462 >>> 1975 0.277227723 >>> 1978 0.712871287 >>> 1957 0.509615385 >>> 1960 0.490384615 >>> 1961 0.721153846 >>> 1966 0.298076923 >>> 1969 0.413461538 >>> 1971 0.500000000 >>> 1972 0.692307692 >>> 1974 0.653846154 >>> 1984 0.049504950 >>> 1978 0.442307692 >>> 1973 0.079207921 >>> 1983 0.355769231 >>> 1984 0.038461538 >>> 1979 0.237623762 >>> 1982 0.564356436 >>> >>> to: >>> >>> 1957 1958 1959 1960 ... >>> 1985 1986 >>> 0.509615385 0.750000000 0.451923077 0.287500000 ... >>> 0.651376147 >>> 0.509615385 >>> >>> and so on. It's likely the column lengths will be different, so I'm >>> guessing padding with NAs will be needed. I have on the order of 1335 rows >>> with years spanning 1957 to 2016. >>> >>> Thank you... >>> Tom >>> >>> -- >>> >>> [[alternative HTML version deleted]] >>> >>> ______________________________________________ >>> R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see >>> 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. >> >> ______________________________________________ >> R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see >> 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. ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.
