Re: [R-sig-Geo] merging tables by columns AND row names (coordinates)

2006-09-09 Thread Mikkel Grum
Thanks Roger, I've been using this to bind rows together, where I don't necessarily have the exact same columns in each table. It seems to work fine for that, so I hadn't noticed that it didn't actually merge floating points. However, it looks like merging will work, if you can afford to round off

Re: [R-sig-Geo] merging tables by columns AND row names (coordinates)

2006-09-09 Thread Roger Bivand
On Fri, 8 Sep 2006, Mikkel Grum wrote: > merge(Table1, Table2, >by = intersect(c("XCOORD", "YCOORD"), >c("XCOORD", "YCOORD")), all = TRUE) > > It might not handle the amount of data you have, but, > if your tables are normal dataframes, it would do the > job with a smaller dataset. It d

Re: [R-sig-Geo] merging tables by columns AND row names (coordinates)

2006-09-08 Thread Mikkel Grum
merge(Table1, Table2, by = intersect(c("XCOORD", "YCOORD"), c("XCOORD", "YCOORD")), all = TRUE) It might not handle the amount of data you have, but, if your tables are normal dataframes, it would do the job with a smaller dataset. It doesn't work with Spatial*DataFrames (yet?). Mikkel -

Re: [R-sig-Geo] merging tables by columns AND row names (coordinates)

2006-09-08 Thread Roger Bivand
On Fri, 8 Sep 2006, Michael Sumner wrote: > Hello, I can think of a couple of simple-minded approaches that would > take some time - either relying on direct string-matching for the unique > coordinates, or by some contrived overlay. > > However, there's probably far better approaches - a coupl

Re: [R-sig-Geo] merging tables by columns AND row names (coordinates)

2006-09-07 Thread Michael Sumner
Hello, I can think of a couple of simple-minded approaches that would take some time - either relying on direct string-matching for the unique coordinates, or by some contrived overlay. However, there's probably far better approaches - a couple of questions: Can you predefine the set of all uni

[R-sig-Geo] merging tables by columns AND row names (coordinates)

2006-09-07 Thread isidora k
Hi everyone! I have 100 tables of the form: XCOORD,YCOORD,OBSERVATION 27.47500,42.52641,177 27.48788,42.52641,177 27.50075,42.52641,179 27.51362,42.52641,178 27.52650,42.52641,180 27.53937,42.52641,178 27.55225,42.52641,181 27.56512,42.52641,177 27.57800,42.52641,181 27.59087,42.52641,181 27.60375,