cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

How to find the road distance between two cities? We can use Azure databricks and azure map.

Azure_databric1
New Contributor II

We will be given an excel file, in which we can see column sender_city and destination_city. We have to find the distance between these two cities and the distance calculated should be written in a column total_distance. All these processes should be automated. If we upload file, every process should be done automatically.

TO find distance we want map, SO we should use Azure Map.

we should not use latitude and longitude because it is calculating flight distance.

Can someone help me regarding the same.

My mailid is dpkrj11.l@gmail.com

1 REPLY 1

sher
Valued Contributor II

hey

without using latitude and longitude it is hard to find out but you can try some distance-based algorithm

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.