In this toy data, each of the tables should sum to 1111
None of the tables shows NA columns or rows.
> ################################
> ToyData <- read.table("C:/Data/R/Toy.csv", header=TRUE, sep=",",
> na.strings="NA", dec=".", row.names="ID_Num")
> ToyData
Data1 Data2 Data3 Weight
101 Sam Red Banana 1
102 Sam Green Banana 2
103 Sam Blue Orange 2
104 Fred Red Orange 2
105 Fred Green Guava 2
106 Fred Blue Guava 2
107 <NA> Red Pear 50
108 <NA> Green Pear 50
109 <NA> Blue <NA> 1000
> xtabs(Weight ~ Data1 + Data2, exclude=NULL, na.action=na.pass, ToyData)
Data2
Data1 Blue Green Red
Fred 2 2 2
Sam 2 2 1
> xtabs(Weight ~ Data1 + Data2, exclude=NULL,
> na.action=na.pass,drop.unused.levels = FALSE, ToyData)
Data2
Data1 Blue Green Red
Fred 2 2 2
Sam 2 2 1
> xtabs(Weight ~ Data1 + Data3, exclude=NULL,
> na.action=na.pass,drop.unused.levels = FALSE, ToyData)
Data3
Data1 Banana Guava Orange Pear
Fred 0 4 2 0
Sam 3 0 2 0
>
Robert Farley
Metro
www.Metro.net
-----Original Message-----
From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] On
Behalf Of Dieter Menne
Sent: Thursday, May 28, 2009 05:46
To: r-help@r-project.org
Subject: Re: [R] Still can't find missing data
Farley, Robert wrote:
>
> I can't get the syntax that will allow me to show NA values (rows) in the
> xtabs.
>
> lengthy non-reproducible example removed
>
If you want a reproducible answer, prepare a reproducible result. And check
that the
syntax is
na.action=na.pass
Dieter
--
View this message in context:
http://www.nabble.com/Still-can%27t-find-missing-data-tp23730627p23761006.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
R-help@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.
______________________________________________
R-help@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.
