Extracting data from several columns by indexing?
2 次查看(过去 30 天)
显示 更早的评论
Hi, I'm a bit new with MatLab and my problem concerns extracting and indexing. I have a large datafile, which has columns month, day, hour, minute, measurement1, measurement2...measurementN e.g.: data=
[2009 1 1 10 100 120 150 120 120
2009 1 1 10 362 323 300 554 654
2009 1 1 11 419 540 640 550 540
...]
I need to extract data at certain hour (e.g. 10) from all columns. (With excel this would be sorting with hour = 10.) I tryed indexing, but I managed only get data from one column not all. How can I extract all hour10 rows from all columns?
Thank you for your help, Liisa
0 个评论
采纳的回答
Oleg Komarov
2011-8-1
idx = data(:,4) == 10;
data(idx,:)
% Or specific columns
cols = [1:4 7,9];
data(idx,cols)
0 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!