Excluding all missing values with dcast ("reshape2" package)
Thanks for the response. The drop option of dcast was the first thing I tried. Sorry for the lack of reproducibility, but my data set is large, I couldn't find anything in the package examples, and I had hoped the modification would be straightforward. Using dcast was my first choice because it returns a data frame. I was successful using xtabs; there was just the extra step of converting the returned table to a data frame. Thanks again! -M.L. This is not a reproducible example ;) anyways, dcast has an attribute: drop should missing combinations dropped or kept? does that not do what you want?
On 03.12.2012, at 16:07, Michael.Laviolette at dhhs.state.nh.us wrote:
Hello--I'm doing a simple crosstab using dcast:
rawfreq <- dcast(nh11brfs, race3~CHCCOPD, length)
with the results
race3 Yes No NA
1 White non-Hispanic 446 5473 21
2 Other non-Hispanic 29 211 0
3 Hispanic 6 81 1
4 <NA> 10 83 1
How would I modify this call to exclude all missing values; that is, to
obtain
race3 Yes No
1 White non-Hispanic 446 5473
2 Other non-Hispanic 29 211
3 Hispanic 6 81
Apologies if this has come up before, and thanks.
-M.L.