Info

# Comparison of entries of one data set (just one column) with multiple columns of second data set

1 view (last 30 days)
aa on 12 Sep 2020
Closed: MATLAB Answer Bot on 20 Aug 2021
Hi everyone,
May someone help me here...
The picture below represent what I want to get. I think this needs 2 to 3 for loops and one if comand only ...
[Let me explain for more clerity:
May someone help me to perform the same calculation for all columns of first data set with the values of seocnd data se. 'a' reprsent the data set consists of 28 columns with diffrent data points; 'b' repsrent the data set of 76 enteries;
Initially, we pick first entry of 'b' suppose called as 'c' then we search in the first columns of 'a' with a condition that column consists of data points values greater than and less then the first vale of 'b'. If this condition not meet, then we look into the second column of 'a', third column and sop one...
When the condition meet... then we split the column into two parts: (1) consits of values greater than the first value of 'b' say 'e'; (2) consists of values less than the first value of b say 'f'. After that, we pick minimum value of 'e' say 'g' and maxium value of 'f' say 'h'. At the last step, I calcualte i=g-c and j=c-h,
later, I get my answer by this relation = i/(i+j)]

KSSV on 12 Sep 2020
To check whether all the values are less than or greather than a certain value/array. You can get the logical indices and use nnz. If nnz is equal to the length then the condition is met.
% Let a be any array and val be the value to check
a = rand(10,1) ;
val = 1 ;
n = length(a) ;
idx = a < val ;
if nnz(idx) == n
fprintf("all the elements in a are less than val\n")
end
aa on 12 Sep 2020
I think, I did not convey the question ... I try to summarzed the key points in this example ...
Data set 1 has 78 values and data set 2 has 28 column with multiple values ..
everytime , i just have to pick the values from data set 1 ,,,, then look for the imediate higher and lower values
in each colum of data set 2 ...
if our value is inbetween the values of the columns of data set 2 ... then we look for further analysis ...
like ..
first entry of data set 1 is 3 that is not present in first colum of data set 2 .. then we move towards the second column of data set 2 ..
and calculate the diffrence from the imediate higher(9-3)/(9-3)+(3-1) and lower value and so on ...
this is what is exactly, looking for

### Community Treasure Hunt

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

Start Hunting!