Connect the input tables from Access directly and remove the need to use locally saved csv files
To Do:
The code will generate a copy of the step-free scoring spreadsheet where:
a. Upgraded stations will be taken off the list using Excel's filter function.
b. All stations within 20' of upgraded stations will belong to the bottom category for isolation. Check
Export the scenario_1 dataframe to a folder where Power BI is already pointing so that we can visualise the new categories in a PowerBI Map.
Done:
To Do:
The code will generate a copy of the step-free scoring spreadsheet where: a. Upgraded stations will be taken off the list using Excel's filter function. b. All stations within 20' of upgraded stations will belong to the bottom category for isolation. Check
Export the scenario_1 dataframe to a folder where Power BI is already pointing so that we can visualise the new categories in a PowerBI Map.