How can one make this extraction?

Question

alpedhuez 2022-7-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1761065-how-can-one-make-this-extraction

评论： Torsten 2022-7-15

I have a 3-D array where the first column is month, the second column is city, and the third column is a vector of temperature of the city in that month. I have previosuly sorted the temperature in the descending order. Then I now want to create a 3-D array where the first column is month, the second column is city, and the third columnis the n-th highest temperature of the month of the city. Please advise how to proceed.

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

请先登录，再进行评论。

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

Answer 1

Steven Lord 2022-7-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1761065-how-can-one-make-this-extraction#answer_1008400

I have a 3-D array where the first column is month, the second column is city, and the third column is a vector of temperature of the city in that month.

So the array has size [N 3] for some value of N? That's not a 3-dimensional array. That's a matrix with three columns.

Then I now want to create a 3-D array where the first column is month, the second column is city, and the third columnis the n-th highest temperature of the month of the city.

I'm going to assume you mean that you want another matrix with three columns. As you've described it, you should use the groupsummary function. You can use the "Multiple Grouping Variables" or "Multiple Grouping Vectors for Vector Input" examples on that documentation page as a model.