How to sort a dot indexed array by rows based on one column

Question

chaker ben salem 2022-5-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1724120-how-to-sort-a-dot-indexed-array-by-rows-based-on-one-column

评论： Seth Furman 2022-5-30

采纳的回答： Jan

i made a dot indexed array called "pop" using repmat like the following

pop.X = [];

pop.V = [];

pop.F = [];

pop.pBestX = [];

pop.pBestF = [];

pop = repmat(pop, N, 1)

and wanted to sort it by rows based on the columne "pop.F"

what i mean is when pop.F(3) change position to pop.F(5) all other pop.X/pop.V in the same row will follow it

the pop array i have looks like this one

if there's a better way to make this kind of table and sort it, it would be greatly apreciated

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Jan 2022-5-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1724120-how-to-sort-a-dot-indexed-array-by-rows-based-on-one-column#answer_968695

在 MATLAB Online 中打开

[~, index] = sort([pop.F]);
pop2       = pop(index);

2 个评论
显示无隐藏无

chaker ben salem 2022-5-21

i was thinking it could be done within the same table but that works perfectly.

thank you,

Seth Furman 2022-5-30

在 MATLAB Online 中打开

It's also worth mentioning that we can convert the struct array to a table using struct2table and sort the rows using sortrows.

https://www.mathworks.com/help/matlab/ref/struct2table.html

https://www.mathworks.com/help/matlab/ref/double.sortrows.html

s = [];
s(1).a = [1 2 3 4];
s(1).b = 2;
s(2).a = [5 6 7 8];
s(2).b = 1;
t = struct2table(s)
t = 2×2 table
           a            b
    ________________    _

    1    2    3    4    2
    5    6    7    8    1
sortrows(t,"b")
ans = 2×2 table
           a            b
    ________________    _

    5    6    7    8    1
    1    2    3    4    2