Hi-
Tabular data have been provided to me within .csv files. I need to transform
the data from tabular format into a dataframe with three
columns. The columns need to be the table row id, table column id, and the
tabulated variable. An example dataset can be downloaded here:
https://docs.google.com/leaf?id=0B0d3zfSSPFQsOGFkYThhYTYtOTE2Zi00NTNkLThmMzYtNDEyMTY5MjRiN2Qy&sort=name&layout=list&num=50
So I need that to be like:
Season Area Variable
2009-10 38 5
2008-09 38 NA
...etc
2009-10 39 1
2008-09 39 3
...etc
>From there I need to show 'Variable' as a series of bubbles scaled
to
summary categories of 'Variable'.
If x is my object storing the data frame above, something like:
x$var.cat[x$Variable %in% 1:5] <- 1
x$var.cat[x$Variable %in% 6:10] <- 2
plot(x=x$Area, y=x$Season, type='n')
points(x=x$Area, y=x$Season, pch=1, cex=x$var.categ)
Transforming tabular data has turned out to be trickier than I expected and
I would appreciate advice. Although my bubble plot
scheme should work, it would be nice to hear of better ways on that too...
Thanks,
Tim
[[alternative HTML version deleted]]
