Python - Create a tool using Graphs to calculate Train-km's

The goal of this project is to create a tool that allows us to calculate the total amount of kilometers all trains on a rail network drive during an average week day. In order to achieve this goal the following steps can be taken: 1. Create an adjacency matrix. 2. Create a weighted graph from this matrix, where the nodes represent the stations, the edges a direct connection between the stations and the weights the distances between these direct connections. A nice addition would be to show this graph visually. 3. Using the train schedule dataset, model all the trains on the network in order to calculate the total amount of kilometers all the trains on the network ride. This can be done using an algorithm; however, as the dataset contains all the stops between the departure and end station, we can use that information to know which edge to take. 4. This tool will be used by people who are not familiar with IT, so preferably we can create some form of a button to launch the program and show the final result. In a later phase, we can extend this to include some GUI. At the moment, we have the following data available: - A pdf file "NV_E-1_stations-knooppunten" containing station and interchange names together with the distances between them. - An Excel file "[login to view URL]" containing the same information, though it has not been verified. - The file "temp_distances_matrix" where I myself converted some stations into the matrix format, which should be the base for the graph representation. Ideally, we can find a way to automatically convert the first or the second file to this representation. - The file "20200812 - JDB - Export dienstregeling December2020" containing the train schedules. This file contains a lot of information. Feel free to ask when something is unclear or if you would like to get more information. Column B shows the train number, column J the origin and column K the destination stations. As you can see, multiple rows are used for the same train number to denote the different stops a train takes (shown in column E, column D shows a short hand notation). In a later phase, it should be possible to alter the number of trains driving a route. This means, when we change the schedule, e.g. add more trains to a route or between stations that it should be reflected correctly. Deadline 26 March!