PDA

View Full Version : Filter Data in Matlab/Octave


in_flu_ence
January 2nd, 2009, 08:23 PM
I have an output as follows

E.g
output=[Time1 Data1 Count1
Time1 Data2 Count2
Time1 Data3 Count3
Time2 Data1 Count1
Time2 Data2 Count2
Time2 Data3 Count3
Time3 Data1 Count1
Time3 Data2 Count2
Time3 Data3 Count3]

How can I filter my data and just having an output1 only with rows having Count3?
i.e.
output1=[Time1 Data3 Count3
Time2 Data3 Count3
Time3 Data3 Count3]?

Thanks

stumbleUpon
January 3rd, 2009, 04:48 AM
I have an output as follows

E.g
output=[Time1 Data1 Count1
Time1 Data2 Count2
Time1 Data3 Count3
Time2 Data1 Count1
Time2 Data2 Count2
Time2 Data3 Count3
Time3 Data1 Count1
Time3 Data2 Count2
Time3 Data3 Count3]

How can I filter my data and just having an output1 only with rows having Count3?
i.e.
output1=[Time1 Data3 Count3
Time2 Data3 Count3
Time3 Data3 Count3]?

Thanks


[nrows ncols]=size(output);

output1 = output(3:3:nrows, 1:ncols)

jpkotta
January 3rd, 2009, 06:55 PM
idx = find((output(:,3) == Count3));
output_filtered = output(idx,:);