Here is my problem:
I created a matrix that has N number of rows and M columns. No I want to match the n-th row with the m-th coumn but each row_index can have only one coumn_index as a match. Here is how the matrix looks like:
| 1 2 3 4 5 6 7 8 9 10
-----|-----------------------------------------------------------------------------
1 | 8 9 1 6 4 19 12 9 3 1
2 | 20 21 11 18 16 31 NaN 21 15 NaN
3 | NaN NaN NaN NaN NaN NaN NaN NaN 14 NaN
4 | 11 12 2 9 7 22 NaN 12 6 NaN
5 | 11 12 2 9 7 22 9 12 6 4
6 | 8 9 1 6 4 19 12 9 3 1
7 | 8 9 1 6 4 19 12 9 3 1
8 | 14 15 5 12 10 25 6 15 9 7
9 | 4 5 5 2 0 15 16 5 1 3
10 | 4 5 5 2 0 15 16 5 1 3
For instance row index 3 has only one match with column index 9, but row 1 can be match with all coumns. I want to do this matching with the following rule:
- Each column can have only one row match
The final result should be something like this :
Row_Index Column_Index
1 7
2 8
3 9
4 6
5 5
6 4
7 2
8 1
9 3
10 10
I have no idea where to start.
Thank you for your help!
