getting info from a unique ID in a csv

Question

Jorge Young 2020-12-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678713-getting-info-from-a-unique-id-in-a-csv

评论： dpb 2020-12-4

elevatorexample.csv

Thank you in advance for help on this.

I am fairly new to matlab, and I am trying to figure out how to find values in a .csv relating to each individual ID. For example, how can I find the time that each elevator ID reaches the 2nd floor for the first time?

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

请先登录，再进行评论。

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

Answer 1

dpb 2020-12-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678713-getting-info-from-a-unique-id-in-a-csv#answer_565743

编辑：dpb 2020-12-4

在 MATLAB Online 中打开

Power of the MATLAB table comes fore...

tElev=readtable('elevatorexample.csv');
FindFloor=2;                           % the floor to find
rowfun(@(f,t) t(find(f==FindFloor,1)),tElev,'InputVariables',{'floor','time'}, ...
                                            'GroupingVariables','elevatorID', ...
                                            'OutputVariableNames',"FirstTimeToFloor "+FindFloor)
ans =
  6×3 table
    elevatorID    GroupCount    FirstTimeToFloor 2
    __________    __________    __________________
        1             6                 2        
        2             5                 2        
        3             5                 1        
        4             5                 2        
        5             4                 1        
        6             4                 1        
>> 