block first row of a cell

Question

Alberto Acri 2023-6-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1988248-block-first-row-of-a-cell

评论： Stephen23 2023-6-26

在 MATLAB Online 中打开

Hi. I would like to sort the columns alphabetically or in ascending number order while keeping the rows unchanged.

Example:

I have this code:

value = {'Value';'8126';'5354';'1406';'4265'};
name = {'Name';'B';'A';'N';'R'};
union = [name,value];

I would like to sort the numbers present in 'value' resulting in this:

value_1 = {'Value';'1406';'4265';'5354';'8126'};
name_1 = {'Name';'N';'R';'A';'B'};
union_1 = [name_1,value_1];

Or sort 'name' alphabetically:

value_2 = {'Value';'5354';'8126';'1406';'4265'};
name_2 = {'Name';'A';'B';'N';'R'};
union_2 = [name_2,value_2];

I tried using respectively:

B = sortrows(union,2);

and this:

B = sortrows(union,1);

however, it also sorts me the first row that I do not want to move. Is there any way to lock the first row?

Or, once 'B' is calculated, move to the first row 'Value' & 'Name'.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Stephen23 2023-6-26

The best solution would be to use a table.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Fangjun Jiang 2023-6-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1988248-block-first-row-of-a-cell#answer_1262718

在 MATLAB Online 中打开

value = {'Value';'8126';'5354';'1406';'4265'};
name = {'Name';'B';'A';'N';'R'};
union = [name,value];
B = sortrows(union(2:end,:),1);
B=[union(1,:);B]
B = 5×2 cell array
    {'Name'}    {'Value'}
    {'A'   }    {'5354' }
    {'B'   }    {'8126' }
    {'N'   }    {'1406' }
    {'R'   }    {'4265' }

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Alberto Acri 2023-6-26

编辑：Alberto Acri 2023-6-26

在 MATLAB Online 中打开

Thank you for the answer.

While in the case of the cell:

value = {'Value';'50';'80';'45';'66'};
name = {'Name';'B';'A';'B';'A'};
charact = {'Object';'home';'car';'money';'toys'};
union = [name,value,charact];

I would like to get this result:

value_3 = {'Value';'66';'80';'45';'50'};
name_3 = {'Name';'A';'A';'B';'B'};
charact_3 = {'Object';'toys';'car';'money';'home'};
union_3 = [name_3,value_3,charact_3];