All Questions
Tagged with pandas geospatial
10 questions
0
votes
1
answer
97
views
What's the fastest way to get "postcodes" for thousands of coordinates (latitudes & longitudes) in Python? [closed]
I have a dataset that contains 750,000 rows. I want to query each row and get the postcodes using the latitudes and longitudes.
Problem:
The code is executing very fast when I query like 100 rows, and ...
4
votes
1
answer
191
views
Checking which polygon a set of coordinates lie inside
I have a massive set of latitude, longitude pairs. I also have a list of GeoJson formatted locations. I want to find out which location each pair of coordinates lies in.
I have some code to do this, ...
7
votes
2
answers
371
views
Parsing Addresses with GeoPanda's GeoDataFrame
Long time reader of Code Review with my first question. I'm self-taught and suspect this code can be improved. The project is really important to me and the team and I could really use the help.
I'm ...
6
votes
1
answer
169
views
Graphing refugee movements using plotly in Python
I've created a simple data visualization in python that shows the movement of refugees around the world. The code works but I feel it is a bit slow. it takes about 10 s (on my hardware at least) to ...
7
votes
1
answer
383
views
Get nearest major city of an image (using EXIF GPS data)
I am writing a program that will take images in a folder, get the GPS Coordinates (from the EXIF data), then return the closest "major city".
(I define a major city as one with an airport, so ...
3
votes
0
answers
2k
views
Function to calculate distances and nearest points between 2 GeoPandas dataframes
I have 2 geoPandas frames and want to calculate the distance and the nearest point (see functions below) from the geoSeries geometry from dataframe 1 (containing ...
7
votes
1
answer
1k
views
PANDAS nearest site algorithm
I have got CSVs full of property transactions in the UK from 1995 to 2017, separated by year such as "RS2015.csv". I have a 2nd CSV with a list of wind turbines in the UK. Both have coordinates in WGS ...
4
votes
1
answer
3k
views
PANDAS code for calculating distance between waypoints
I've written some python code designed to take a csv of waypoints for a series of trips, and calculate the distance of each trip by the sum of the distance between the waypoints.
An example csv might ...
5
votes
1
answer
2k
views
PANDAS spatial clustering
I'am writing on a spatial clustering algorithm using pandas and scipy's kdtree. I profiled the code and the .loc part takes most time for bigger datasets. I wonder ...
8
votes
1
answer
157
views
Querying houses similar to a given house
I was given this task as an interview coding challenge and was wondering If the code is well structured and follows Python guidelines. I chose to sort the houses based on a similarity metric and then ...