Get Column Name if matrix row value is 1

Im creating a labeling for x axis of a graph that track change in value based on first row of a matrix as basevalue.

I had managed to code until validmatrix array but i dont know how to extract table label if valid index is "1".

validindexarray determines what element changes per row and the "parameterlabel" is the label name of the table. If validndex is 1 then desiredresult will get the parameter label from the table.

Thanks for your help.

parameterlabel={ 'A' 'B' 'C' 'D' 'E'}
parametervalue=[ 1 2 4 5 3; 2 2 4 5 3; 1 2 5 5 3; 1 2 3 5 2]
validindex=     [0 0 0 0 0; 1 0 0 0 0; 0 0 1 0 0; 0 0 1 0 1]
%%My code until here↑↑↑↑


%Need help beyond this line↓↓↓
desiredresult={'','A 1→2','C 4→5','C 4→3 ,E 3→2 '}
xticklabels(desiredresult)
xticklabels({'','A 1→2','C 4→5','C 4→3 ,E 3→2'})

[Steven Lord]

I think I see how you got the 1->2, 4->5, 4->3, and 3->2 pieces (the tail of the arrow is the value in the selected column and the previous row, the head is the value in the selected column and current row.) I'm not sure about the letters. If you were using the element of parameterlabel corresponding to the column in which the 1 value is located in validindex, it should be A, C, and C + E not A, C, and C + D.

Can you confirm my understanding of the arrow expressions and clarify how you selected which letter should be in which label?

[Raghunandan V]

Check the desired result again. I think it should be

desiredresult={'','A 1→2','C 4→5','C 5→3' ,'E 3→2 '}

Please check.

[joms]

validindexarray determines what element changes per row and the "parameterlabel" is the label name of the column where the value change. If validndex is 1 then desiredresult will get the parameter label from the table. ' 4→3,3→2' are the values that change C , E are columns name where the change occurs

[joms]

since there are 5 rows C and E will be combined like this

desiredresult={'','A 1→2','C 4→5','C 4→3 ,E 3→2 '}

Answer 1

[Stephen23]

First download Jos's excellent runindex:

https://www.mathworks.com/matlabcentral/fileexchange/56131-runindex

Data:

L = {'A','B','C','D','E'};
P = [1 2 4 5 3; 2 2 4 5 3; 1 2 5 5 3; 1 2 3 5 2]
X = [0 0 0 0 0; 1 0 0 0 0; 0 0 1 0 0; 0 0 1 0 1]

Method:

Z = cell2mat(cellfun(@runindex,num2cell(X,1),'uni',0));
[R,C] = find(X);
V = 1:nnz(X);
F = @(r,c)sprintf('%s %d->%d',L{c},P([r-Z(r,c),r],c));
D = arrayfun(F,R,C,'uni',0);
G = @(s)s(3:end);
H = @(d){G(sprintf(', %s',D{d}))};
D = accumarray(R,V(:),[],H);
D(cellfun('isempty',D)) = {''}

Giving:

D = 
    ''
    'A 1->2'
    'C 4->5'
    'C 4->3, E 3->2'

[joms]

Thank you very much this works exactly the way i want