Sorting elements according to an array

I will try my best to phrase this question, hope it makes sense

I have 2 arrays, DATA which has useful data and SCALE which has the scale where I am fitting the data to.

DATA has numbers from 1-100 in random order, and SCALE has distinct intervals of tens from 1-100, i.e. 1,10,20,30...90,100

My goal is the write a code which clumps the elements from DATA to SCALE to do calulations such as SCALE-DATA (for example, 36 is the DATA element, the SCALE element should be 40 and it would be 40-36)

example - 7 will be rounded up to 10, and 23 will be rounded down to 20.

I understand the commands ciel and floor, however I am not sure what is the most efficient way to match the rounded data to the scale?

Answer 1

[Star Strider]

I am not certain what you want.

Try this:

DATA = randi([1 100], 25, 1);                                           % Create  DATA 
SCALE = 10*round(DATA/10).*(DATA>=10) + 10*round(DATA/10).*(DATA<10);
Out = [DATA, SCALE];

.

[Hans123]

Hi StarStrider, thanks as always for the reply.

This is very close to what I want, but my scale is already pre-defined. and I want to match the rounded ones to the SCALE.

Your code creates the SCALE vector according to the DATA.

SCALE DATA

10 24~20 (goes to the second column)

20 ...

30 ...

40 ...

50 ...

Appreciate the help, as always!

[Star Strider]

My pleasure!

I am still not certain that I understand what you want, so I will give it another shot:

Out = sortrows([SCALE DATA],1)

the rest of the code is unchanged.

I do not understand this: 24~20 or what you want to do with it. It is not likely that it will work as a single column in MATLAB.

[Hans123]

Thanks Star Strider, I am sorry for not being articulate enough. I believe in your code -

SCALE = 10*round(DATA/10).*(DATA>=10) + 10*round(DATA/10).*(DATA<10)

- makes the SCALE array according to the DATA array, however SCALE is predefined before the elements of DATA are introduced. Hope that helps sort it out.

Basically, DATA elements get rounded up or down to get close to an induvidual element of SCALE and gets sorted.

So there should be a line that says

SCALE = linspace(0,100,10);

[Star Strider]

I am completely lost.

I will delete my Answer in a few minutes.

[Hans123]

Oh wow, I am sorry Star Strider. Let me try to rephrase it again

[Hans123]

Again, since I lost my command of the English language.

I have points scattered on the x axis, and I want the points to rounded up to the nearest division.

[Hans123]

Your code does exactly what I want, however the scale is defined from the data input. And with different data sets the scale changes. My scale is predefined and is indepenndent of the data set.

SCALE = 10*round(DATA/10).*(DATA>=10) + 10*round(DATA/10).*(DATA<10);

Something along the lines of this, but this is what I can't figure out

%predefined
DATA = [8 17 21 23 36]';  
SCALE = [10 20 30 40]';

rounddata = round(DATA);

%compare with SCALE to see where it belongs and output 

Out = [correctDATA, SCALE];

[Star Strider]

Try this:

DATA = randi([1 100], 1, 25);                                   % Create ‘DATA’
SCALEfcn = @(x) 10*round(x/10).*(x>=10) + 10*round(x/10).*(x<10);
SCALE = linspace(0,100,11);
for k = 1:numel(SCALE)-1
    Out{k,:} = [SCALE(k) DATA((SCALEfcn(DATA) >= SCALE(k)) & (SCALEfcn(DATA) < SCALE(k+1)))];
end

I still do not understand what you want. This sort of histogram approach is as close as I can get.

Experiment with it to get different results.

[Hans123]

Thank you for your time, I really appreciate it. I can tinker around with the helpful lines you have given me. I am glad to hear from you during these uncertain times. As always, thank you for the help Star Strider. Always a blessing to have you in this forum!

[Star Strider]

As always, my pleasure!

Thank you very much for your compliments and sentiments!