The question is about calculating the minimum fee. I have a dataset called busfares, which contains different station code, the destation code, type of fares. So much thanks to all of you if you wish to spend some time on my question. The dataset looks like this. srt_na srt srt_id dest_na dest dest_id adult_pri student_pri child_pri eldery_pri
abcde abc 1 abcde abc 1 0 0 0 0
abcde abc 1 bbcde bbc 2 5 4 4 1
abcde abc 1 cbcde cbc 3 7 5 5 1
abcde abc 1 dbcde dbc 4 7 5 5 1
abcde abc 1 ebcde ebc 5 10 6 6 1
.
.
.
abcde abc 1 ooooo ooo 91 30.5 20 20 1
bbcde bbc 2 abcde abc 1 5 4 4 1
bbcde bbc 2 bbcde bbc 2 0 0 0 0
.
.
.
ooooo ooo 91 abcde abc 1 30.5 20 20 1
ooooo ooo 91 bbcde bbc 2 30.5 20 20 1
.
.
.
ooooo ooo 91 ooooo ooo 91 0 0 0 The question is how can I use four array to bulid the look up tables for different type of fares? The table should be look like that. And the row and column are representing different station name like row1 is representing abc, column1 is also representing abc as well adult 1 2 3 4 ...
1 0 5 7 7 ...
2 5 0 10 10 ...
3 7 10 0 5 ...
4 7 10 5 0 ...
... View more