[R] casting help please

[hadley wickham]

Hi David,

Does getting rid of the missings help?

prices <- prices[complete.cases(prices), ]

Also, you shouldn't need  add.missing=TRUE - what are you trying to do?

Hadley

On Fri, Sep 5, 2008 at 12:12 PM,  <davidr at rhotrading.com> wrote:
> I have a data.frame which I believe is melted already and am having
> trouble casting it to 'wide' format.
>
> It looks something like
>
>
>
>> (x <- data.frame(ticker=c(rep("A",5),rep("B",6)), date=c(1:5, 1:6),
> value=c(NA,100*exp(rnorm(10,0,.1)))))
>
>> cast(x, date ~ ticker) # this does what I want with toy data
>
>
>
> But when I use my real data frame
>
>
>
>> str(prices)
>
> 'data.frame':   308188 obs. of  3 variables:
>
>  $ Ticker: chr  "ticker1" " ticker1" " ticker1" " ticker1" ...
>
>  $ Date    :Class 'Date'  num [1:308188] 12296 12297 12298 12299 12300
> ...
>
>  $ Price   : num  NA NA NA NA NA NA NA NA NA NA ...
>
>
>
> I get
>
>
>
>> prices.wide <- cast(prices, Date ~ Ticker, add.missing=TRUE)
>
> Error in data.frame(data[, c(variables), drop = FALSE], result =
> data$value) :
>
>  arguments imply differing number of rows: 308188, 0
>
>
>
> (I tried various other arguments to cast - all gave the same error
> message.)
>
> It is a fact that the various tickers have data for different date
> ranges in the data frame and there are lots of NA's,
>
> but the toy example above has different date ranges for the two tickers
> and an NA, so I don't know what else to look for in my data,
>
> or what args to cast might make it work.
>
>
>
> Any insights or direction would be much appreciated.
>
>
>
> David L. Reiner, PhD
>
> Head Quant
>
> Rho Trading Securities, LLC
>
>
>
>
>        [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org 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.
>



-- 
http://had.co.nz/