https://community.databricks.com/t5/data-engineering/how-to-find-the-road-distance-between-two-cities-we-can-use/m-p/14174#M8712 <P>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.</P><P>TO find distance we want map, SO we should use Azure Map.</P><P></P><P>we should not use latitude and longitude because it is calculating flight distance.</P><P></P><P>Can someone help me regarding the same.</P><P></P><P>My mailid is dpkrj11.l@gmail.com</P> Thu, 29 Dec 2022 09:18:23 GMT Azure_databric1 2022-12-29T09:18:23Z https://community.databricks.com/t5/data-engineering/how-to-find-the-road-distance-between-two-cities-we-can-use/m-p/14174#M8712 <P>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.</P><P>TO find distance we want map, SO we should use Azure Map.</P><P></P><P>we should not use latitude and longitude because it is calculating flight distance.</P><P></P><P>Can someone help me regarding the same.</P><P></P><P>My mailid is dpkrj11.l@gmail.com</P> Thu, 29 Dec 2022 09:18:23 GMT https://community.databricks.com/t5/data-engineering/how-to-find-the-road-distance-between-two-cities-we-can-use/m-p/14174#M8712 Azure_databric1 2022-12-29T09:18:23Z https://community.databricks.com/t5/data-engineering/how-to-find-the-road-distance-between-two-cities-we-can-use/m-p/14175#M8713 <P>hey</P><P></P><P>without using latitude and longitude it is hard to find out but you can try some distance-based algorithm</P> Mon, 02 Jan 2023 17:12:30 GMT https://community.databricks.com/t5/data-engineering/how-to-find-the-road-distance-between-two-cities-we-can-use/m-p/14175#M8713 sher 2023-01-02T17:12:30Z