> On 20-12-2014, at 05:45, Kristi Glover <kristi.glo...@hotmail.com> wrote:
>
> Hi R User, Would you suggest me on how I can build a pivot table using two
> variables? I want to put "text" in the table instead of value. I have
> attached an example data and the type of table (FinalTable) I was looking
> for. I am looking for your suggestions. ThanksKG=====dat<-structure(list(tag
> = structure(c(1L, 1L, 1L, 2L, 3L, 4L, 5L, 6L, 6L, 7L, 7L, 8L), .Label =
> c("x1", "x2", "x3", "x4", "x5", "x6", "x7", "x8"), class = "factor"), time =
> structure(c(1L, 2L, 3L, 1L, 4L, 5L, 5L, 5L, 8L, 4L, 7L, 6L), .Label =
> c("2010-May 27", "2011-June 27", "2011-June 28", "2012-June 25", "2013-June
> 21", "2014-Jan 05", "2014-July 27", "2015-April 07"), class = "factor"),
> states = structure(c(1L, 2L, 2L, 1L, 4L, 3L, 2L, 5L, 1L, 3L, 5L, 2L),
> .Label = c("A", "B", "C", "D", "Out"), class = "factor")), .Names = c("tag",
> "time", "states"), class = "data.frame", row.names = c(NA, -12L))
> dat###table(dat$tag,dat$time)# it gives value but I want the name of the
> states in the table instead of value.#For
> examplefinalTable<-structure(list(tag = structure(1:8, .Label = c("x1", "x2",
> "x3", "x4", "x5", "x6", "x7", "x8"), class = "factor"), X2010.May.27 =
> structure(c(2L, 2L, 1L, 1L, 1L, 1L, 1L, 1L), .Label = c("0", "A"), class =
> "factor"), X2011.June.27 = structure(c(2L, 1L, 1L, 1L, 1L, 1L, 1L, 1L
> ), .Label = c("0", "B"), class = "factor"), X2011.June.28 = structure(c(2L,
> 1L, 1L, 1L, 1L, 1L, 1L, 1L), .Label = c("0", "B"), class = "factor"),
> X2012.June.25 = structure(c(1L, 1L, 3L, 1L, 1L, 1L, 2L, 1L ), .Label =
> c("0", "C", "D"), class = "factor"), X2013.June.21 = structure(c(1L, 1L,
> 1L, 3L, 2L, 4L, 1L, 1L), .Label = c("0", "B", "C", "Out" ), class =
> "factor"), X2014.Jan.05 = structure(c(1L, 1L, 1L, 1L, 1L, 1L, 1L, 2L),
> .Label = c("0", "B"), class = "factor"), X2014.July.27 = structure(c(1L,
> 1L, 1L, 1L, 1L, 1L, 2L, 1L ), .Label = c!
("!
> 0", "Out"), class = "factor"), X2015.April.07 = c(0L, 0L, 0L, 0L, 0L, 1L,
> 0L, 0L)), .Names = c("tag", "X2010.May.27", "X2011.June.27", "X2011.June.28",
> "X2012.June.25", "X2013.June.21", "X2014.Jan.05", "X2014.July.27",
> "X2015.April.07"), class = "data.frame", row.names = c(NA,-8L))
> finalTable
> #How is it possible to get the finalTable as shown above?Any suggestions?
>
Since you used html for your mail, it is a complete mess and not usable.
You are requested to not post in HTML. See the posting guide.
Berend
> [[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.
