| Duplicates - a new twist [message #39453] |
Mon, 17 May 2004 14:24 |
m.doyle
Messages: 6
Registered: January 2004
|
Junior Member |
|
|
Hello all,
I have a problem which I've searched everywhere to try and
solve...many posters on this newsgroup have had _similar_ problems but
the resolutions didn't help me...anyway, here goes;
I have a dataset which consists of 3 columns: longitude, latitude and
a value for an emission of an air pollutant. European countries report
the emission of this pollutant for the latitude longitude coordinates
which are within their countries. However, some of the latitude,
longitude coordinates lie on the borders of countries and therefore an
emission is sometimes reported by 2 or more countries for the same
coordinate (i,e. There are multiple instances of the same coordinate
within the dataset).
What I need to do is to look through the dataset and sum the emissions
when the coordinate is the same, resulting in a dataset with unique
coordinates and a total emission for each grid point.
Does anyone have any ideas about how to go about this? I've seen posts
on this newsgroup which have had problems with duplicate values in one
column of data, but I'm unsure about how to go about it when there are
2 columns which need to be examined.
Thanks guys...
All the best,
Martin
|
|
|
|
comp.lang.idl-pvwave archive
Members
Search
Help
Login
Home
