In this notebook, I show you how to combine rows that are near-duplicates and remove true duplicate rows in Pandas. I recently ran into this problem while doing some data cleaning. I decided to simply combine the similar rows into one row. The below notebook details how to accomplish merging the rows into one.
Continue reading “How to Combine Duplicate or Similar Rows in Pandas”Vehicle Route Optimization in Python with OpenRouteService
In this tutorial, I cover vehicle route optimization using openrouteservice with the openrouteservice-py wrapper for Python. If you simply need to optimize a single route for a single vehicle with no service time restrictions, you can do this by using the directions API as described in my tutorial about getting directions with Python and ensuring you pass the optimize_waypoints=True parameter. The below notebook will guide you through doing some more complex optimization examples.