[R] Would you please help me to create a table in R?

[Jim Lemon]

Hi Marna,
A bit hard to understand. If raw.data is a record of 11 individuals
released at site A at Time 1 and recaptured at either A or B or neither at
Time2 or Time3, it doesn't seem to bear any consistent relationship to the
numeric coding in table.format or the output at the bottom. Could you
explain what the correspondence between the tables is?

Jim


On Fri, Dec 18, 2015 at 2:33 PM, Marna Wagley <marna.wagley at gmail.com>
wrote:

> Hi R users,
> I am struggling to create a table in R. I did in Excel but I have a lots of
> data and thought it might be easy in  R  but  I am new in R. How to get
> "output table" for this example data?
>
> This is an example.
>
> #####
> raw.data<-structure(list(Time1 = structure(c(1L, 1L, 1L, 1L, 1L, 1L, 1L,
> 1L, 1L, 1L, 1L), .Label = "SiteA", class = "factor"), Time2 =
> structure(c(1L,
> 4L, 2L, 1L, 2L, 1L, 2L, 1L, 3L, 3L, 3L), .Label = c("0", "SiteA",
> "SiteB", "SiteC"), class = "factor"), Time3 = structure(c(2L,
> 2L, 2L, 1L, 2L, 1L, 1L, 3L, 3L, 1L, 3L), .Label = c("0", "SiteA",
> "SiteB"), class = "factor")), .Names = c("Time1", "Time2", "Time3"
> ), class = "data.frame", row.names = c(NA, -11L))
>
> raw.data
>
> #####
> table.format<-structure(list(Time1 = structure(c(NA, NA, NA, NA, NA, 1L,
> NA,
> NA, NA, NA, NA, NA, NA, NA, NA, NA), .Label = "Released A", class =
> "factor"),
>     Time2 = structure(c(NA, NA, 2L, NA, NA, NA, 3L, NA, NA, NA,
>     4L, NA, NA, NA, 1L, NA), .Label = c("Dead", "Re-captured.at.A",
>     "Re-captured.at.B", "Re-captured.at.C"), class = "factor"),
>     Time3 = structure(c(2L, 3L, 4L, 1L, 2L, 3L, 4L, 1L, 2L, 3L,
>     4L, 1L, 2L, 3L, 4L, 1L), .Label = c("Dead", "Re-captured.at.A",
>     "Re-captured.at.B", "Re-captured.at.C"), class = "factor")), .Names =
> c("Time1",
> "Time2", "Time3"), class = "data.frame", row.names = c(NA, -16L
> ))
>
> table.format
>
> ###
> output<-structure(list(Time1 = c(NA, NA, NA, NA, NA, 11L, NA, NA, NA,
> NA, NA, NA, NA, NA, NA, NA), Time2 = c(NA, NA, 3L, NA, NA, NA,
> 3L, NA, NA, NA, 1L, NA, NA, NA, 4L, NA), Time3 = c(2L, NA, NA,
> 1L, NA, 2L, NA, 1L, 1L, NA, NA, NA, 1L, 1L, NA, 2L)), .Names = c("Time1",
> "Time2", "Time3"), class = "data.frame", row.names = c(NA, -16L
> ))
>
> output
>
> I want to get the table like "output". Any possibility to get it in R?
>
> I will really appreciate for your help. I am struggling to create  this
> type of table.
>
>
> Sincerely,
> Marna
>
>         [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at 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.
>

	[[alternative HTML version deleted]]