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]]
