Hi all,
I am using ftable and xtabs to get total counts of species per location per
hight category (understory, midstory and overstory). i can save the data in
almost the format i would like it to be - but not quite. Here it is an example
of what i get:
x - is a dataframe with the following columns: LocationID, Species,
PercentCover, Category
where Category tells if the Species belongs to understory, midstory or
overstory
y1 <- ftable(xtabs(PercentCover ~ LocationID + Species + Category, data=x))y2
<- format(y1, quote = FALSE, sep = ,)write.table(y2, test1.csv, row.names =
FALSE, col.names = FALSE, sep = ,)If i read the test1.csv it will look like
that: Category
Midstory Overstory Understory
LocationID Species
Loc1 A
0 0 10
B
10 20 0
C
55 0 10
.
Loc2 A
0 0 0
B
5 60 0
C
35 0 25
What i would like: (1) eliminate the column (Category) because it is empty
anyway (i suppose i can create a new data.frame from y2 in which i skip column
"Category"); (2) have LocationID, Species, Midstory, Overstory, and Understory
on the same row; (3) have the column LocationIDfilled in between Loc1 and Loc2
with Loc1 and not an empty string, and so on for each location.Any suggestions
will be very greatly appreciated, thanks,Monica
_________________________________________________________________
GLM_CPC_VideoChat_distantfamily_012008
[[alternative HTML version deleted]]
______________________________________________
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.
