how to filter using matlab with multiple conditions.??

Question

sandy 2014-2-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/114924-how-to-filter-using-matlab-with-multiple-conditions

编辑： sandy 2014-2-11

time                  ch_1  ch_2  ch_3  ch_4
data_20140202_0000  1.00  10.00  12.00  89.00
data_20140202_0112  1.50  30.00  65.00  78.00
data_20140202_1200  4.00  50.00  32.00  87.00
data_20140202_1600  8.00  76.00  12.00  87.00
data_20140202_2304  3.00  32.00  11.00  67.00
 i want the whole files which
 my condition is ch_1 between 1 to 3 and ch_2 between 10 to 30 ,both should satisfy,

output like this below, which should save in separate excel file

 time                  ch_1  ch_2  ch_3  ch_4
data_20140202_0000  1.00  10.00  12.00  89.00
data_20140202_0112  1.50  30.00  65.00  78.00

2 个评论
显示无隐藏无

Amit 2014-2-5

what is the data structure? is it array, cell, struct?

sandy 2014-2-5

its a cell...

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

David Sanchez 2014-2-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/114924-how-to-filter-using-matlab-with-multiple-conditions#answer_123343

在 MATLAB Online 中打开

[data headings] = xlsread('your_file.xls');
ch1=data(:,1);
filt_data1 = find((ch1<=3) & (ch1>=1));
data = data(filt_data1,:);
headings = headings(filt_data1+1,:);
ch2=data(:,2);
filt_data2 = find((ch2<=25) & (ch2>=10));
data = data(filt_data2,:);
headings = headings(filt_data2+1,:);

Now you have your headings and data to write into the xls

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

sandy 2014-2-6

编辑：sandy 2014-2-11

在 MATLAB Online 中打开

thanks...but how to write in excel with two separate variables (data and heading)...also i have many channels in excel sheet.i am trying to create a GUI code by which if i give .......

INPUT:
1.two channels name
2.min limit and max limit(by which my values between this min &max limits should get as output)
output:
inbetween values with header in separate excel file(its like filtering with multiple conditions)

any ideas ???

请先登录，再进行评论。