Airplane Route Histogram

Please refer to the sight Open Flights. This gives us the databases for both airline locations and airline route details. Please download the files airplane.dat and routes.dat from the source http://www.openflights.org/data.html We have 2 files airplane.dat and routes.dat. Latter file stores every unique flight route that open flights know. With the help of the source data our aim is to calculate how far each route travels and then plot a histogram for the same. There are 3 tasks: 1) First task is to map the unique id to the geographical coordinates. Hence we can look up the location of each airport by the id. 2) Through the latter source file routes.dat we would get the id of the source and destination airport . Based on the latitudes and longitudes we would be able to know the length of the route and append it to the list of all route length 3) Plot a histogram based on the rou...