How to load the data in this case?

As shown in the image there are two data sets 'a' and 'b'. How to load the data of 'b' into another variable, if a>0.1 and a<0.8?

Thanks

Thanks

Answer 1

[Salaheddin Hosseinzadeh]

Hi,

Is that a excel file?! I don't get what you mean by loading.

If you just want to select some values do it like this.

c = a.*(a>0.1 & a<0.8);

So in variable c you will have what you want!

[R7 DR]

Hi I loaded the data from excel to matlab. For example, I have the data like b=[ 1 2 3 4 5 6 7 8] a=[0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8]

now I have to load the data from 'b' to another variable 'c' if the values in 'a'>0.2 &<0.7. in this case; the c=[3 4 5 6 7]

Thanks

[Salaheddin Hosseinzadeh]

So your data is already loaded into MATLAB. your question is not on how to load the data to MATLAB.

f = a.*(a>0.2 & a<0.7)
c =  find(logical(f) == 1)

something like this should give you an answer

or

f = a.*(a>0.2 & a<=0.7) % if you also want 7 to be in c
c =  find(logical(f) == 1)

[R7 DR]

Hi Thanks..its working. But I have one more question.

How to modify the code if we have multiple variables. For example: 'b', 'c', 'd' and 'e' are the variables and the IF condition is same. Data is imported to matlab from excel.

In this case how to load the data from the specific variable for example:'e'

Thanks