getting info from a unique ID in a 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?

Answer 1

[dpb]

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        
>> 

[Jorge Young]

This is fantastic, thank you very much!

[dpb]

Yeah, read up on grouping variables and the rowfun, varfun functions. There's whole section on splitapply for more discussion as well.