How to select specific row in a matrix

Question

AKHILESH KUMAR 2018-3-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/389313-how-to-select-specific-row-in-a-matrix

评论： Akira Agata 2018-3-21

i have data like

                     doy          time           aod
                     5           05:46:46  0.62800    
                     5           05:46:56  0.62100
                     5           05:47:07  0.61600
                     7           06:47:06  0.53600
                     7           06:47:16  0.53200
                     7           06:47:27  0.53500
                    11           08:31:35  0.64000
                    11           08:31:46  0.63400
                    11           08:31:57  0.62600

and i want this data like(for minimum aod in group)

                    5           05:47:07  0.61600
                    7           06:47:16  0.53200 
                    11           08:31:57  0.62600

2 个评论
显示无隐藏无

James Tursa 2018-3-19

How do you currently have the data stored? In a table variable? Or ...?

AKHILESH KUMAR 2018-3-20

data are stored in table

请先登录，再进行评论。

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

Answer 1

Akira Agata 2018-3-20

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/389313-how-to-select-specific-row-in-a-matrix#answer_310829

在 MATLAB Online 中打开

Assuming your data is stored in table format, say T, the following code can do that.

func = @(x) T(T.aod == min(x),:);
Tout = splitapply(func,T.aod,findgroups(T.doy));

The result is like this:

>> Tout
Tout =
3×3 table
  doy      time       aod 
  ___    ________    _____
   5     05:47:07    0.616
   7     06:47:16    0.532
  11     08:31:57    0.626