How to make groups using latitude and longitude coordinates?

Question

I have a time series dataset where the pickup and drop off latitude and longitude coordinates are given. Since coordinates of a city hardly vary, how to categorize them in python?

I want to make groups so that Classification algorithm can be applied.

I am pasting a single row of pick up and drop off longitude and latitude coordinates of New York city.

-73.973052978515625 40.793209075927734 -73.972923278808594 40.782520294189453

I have fixed the range of latitude from 40.6 to 40.9 and longitude range from -73.9 to -74.25

Now, I want to make them into groups so that classification algorithm can be applied.

It sounds like you need a kind of group by on a geographical basis. Try to see [here](https://stackoverflow.com/questions/39254704/pandas-group-bins-of-data-per-longitude-latitude) or [here](https://gis.stackexchange.com/questions/132955/grouping-latitude-and-longitude-coordinates-by-city-neighborhood). It's just a blind try. Can you give us more details? — floatingpurr, Sep 12 '17 at 14:49
How about use KNN method in sklearn, it's a basic classifying method in machine learning. — Menglong Li, Sep 12 '17 at 14:52
@floatingpurr Latitude and longitude coordinates of New York City are given on the basis of pickup and drop off locations of trips. — Ashish Choudhary, Sep 12 '17 at 15:25
@AshishChoudhary I'm afraid that without a clear example about data and your desired output no one will be able to help you. — floatingpurr, Sep 12 '17 at 16:23
@floatingpurr Is it necessary to make groups of coordinates let's say 40.61 to 40.70, 40.71 to 40.80 for the classification algorithm to work. As I have done linear regression and accuracy is not that good, so thinking of random forest or can you suggest me a better alternative? — Ashish Choudhary, Sep 14 '17 at 06:30
@AshishChoudhary feel free to mark the answer if it helped :) — floatingpurr, Sep 14 '17 at 17:02

score 1 · Accepted Answer · answered Sep 14 '17 at 09:26

For example you can insert you coordinates in a list of tuples called coordinates. Please note that I have appended also a couple of coordinates out of range. Here is the code:

coordinates = [
    (-73.973052978515625,40.793209075927734),
    (-73.972923278808594,40.782520294189453), 
    (-75.9,40.7)
    ]

filtered = list()

# filtering coordinates
for c in coordinates:
    if  -74.25 <= c[0] <= -73.9 and 40.6 <= c[1] <= 40.9:
        filtered.append(c)

print filtered # here you have your filtered coordinates

Output:

[(-73.97305297851562, 40.793209075927734), (-73.9729232788086, 40.78252029418945)]

How to make groups using latitude and longitude coordinates?

1 Answers1