getting info from a unique ID in a csv
3 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
dpb
2020-12-4
编辑:dpb
2020-12-4
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
>>
2 个评论
dpb
2020-12-4
Yeah, read up on grouping variables and the rowfun, varfun functions. There's whole section on splitapply for more discussion as well.
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Workspace Variables and MAT-Files 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!