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

