I
I. Miller
I have a large dataset (~5000 rows) that is tied to latitdue and longitude
(small portion below). For each latitude/longitude reading I have between 8
and 10 columns of other data (not shown). I would like to sort the data into
latitude/longitude bins and then analyze it. The bin size I'm looking for is
2 degrees latitude (from -90 to 90) and 4 degrees longitude (-180 to 180).
This will produce 8100 bins. Only about 1/5 of these bins will have data (I'm
interested in data over continents only). In each bin I plan to average
numbers in the other columns to come up with standard values for each bin.
latitude longitude
-38.35 141.6
-38.27 144.67
-25.63 118.72
49.05 51.87
28.63 121.42
25.85 -81.38
29.75 -81.53
29.92 -90.13
34.42 -119.68
38.57 -76.07
43.42 -124.25
Thank you!
Ian
(small portion below). For each latitude/longitude reading I have between 8
and 10 columns of other data (not shown). I would like to sort the data into
latitude/longitude bins and then analyze it. The bin size I'm looking for is
2 degrees latitude (from -90 to 90) and 4 degrees longitude (-180 to 180).
This will produce 8100 bins. Only about 1/5 of these bins will have data (I'm
interested in data over continents only). In each bin I plan to average
numbers in the other columns to come up with standard values for each bin.
latitude longitude
-38.35 141.6
-38.27 144.67
-25.63 118.72
49.05 51.87
28.63 121.42
25.85 -81.38
29.75 -81.53
29.92 -90.13
34.42 -119.68
38.57 -76.07
43.42 -124.25
Thank you!
Ian