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

采纳的回答

Oleg Komarov
Oleg Komarov 2011-8-1
idx = data(:,4) == 10;
data(idx,:)
% Or specific columns
cols = [1:4 7,9];
data(idx,cols)

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Logical 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by