MATLAB: Hello Everyone, I’m looking for your help for the following problem

max

Use the matrix given on the first link.I need a matlab code that can generate on the second link. Thanks!

Best Answer

The second image you uploaded is not the correct maximum value array for each column... Anyway, let me try to do this without using for-loop:

A = [17 14 18 15 14 19;...
  1 5 3 30 8 14;...
  20 2 16 7 13 11];
idx = bsxfun(@eq,A,max(A));
A(~idx) = NaN;

The result is:

>> A
A =
 NaN    14    18   NaN    14    19
 NaN   NaN   NaN    30   NaN   NaN
  20   NaN   NaN   NaN   NaN   NaN

Related Solutions

MATLAB: Fill in missing NaNs

Try this:

x = [1;2;3;4;nan;nan;nan;nan;nan;5;7;8;nan;nan;nan;nan;11;11;12;nan;nan;nan;15];
bb = regionprops(isnan(x));
idx_nnan = find(~isnan(x));
idx_nan = find(isnan(x));
[~,idx] = min(abs(idx_nan - idx_nnan'), [], 2);
x(idx_nan) = x(idx_nnan(idx));
a = [bb.Centroid];
a(1:2:end) = [];
bb = bb(a==fix(a));
for i=1:numel(bb)
    idx_center = bb(i).Centroid(2);
    idx = cumsum(bb(i).BoundingBox([2 4])) + [-0.5 0.5];
    x(idx_center) = mean(x(idx));
end

Original x:

x =
     1
     2
     3
     4
   NaN
   NaN
   NaN
   NaN
   NaN
     5
     7
     8
   NaN
   NaN
   NaN
   NaN
    11
    11
    12
   NaN
   NaN
   NaN
    15

New x:

x =
    1.0000
    2.0000
    3.0000
    4.0000
    4.0000 % <--- nearesr value








    4.0000 % <--- nearesr value
    4.5000 % average

    5.0000 % <--- nearesr value
    5.0000 % <--- nearesr value
    5.0000
    7.0000
    8.0000
    8.0000 % <--- nearesr value
    8.0000 % <--- nearesr value
   11.0000 % <--- nearesr value 
   11.0000 % <--- nearesr value
   11.0000
   11.0000
   12.0000
   12.0000 % <--- nearesr value
   13.5000 % average
   15.0000 % <--- nearesr value
   15.0000

MATLAB: How to rearrange data in matrix rows

reshape, like pretty much all MATLAB operations, works columnwise. So you just need to transpose, reshape, transpose:

X = [20031119 1 2 3 4 5 6 7 8 9;
10 11 12 13 14 15 16 17 18 19;
20 21 22 23 24 25 26 27 28 29;
30 31 NaN NaN NaN NaN NaN NaN NaN NaN;
20031120 1 2 3 4 5 6 7 8 9;
10 11 12 13 14 15 16 17 18 19;
20 21 22 23 24 25 26 27 28 29;
30 31 NaN NaN NaN NaN NaN NaN NaN NaN];
out = reshape(X.',[],size(X,1)/4).';

creates this output matrix:

>> out
out =
 Columns 1 through 9:
   20031119          1          2          3          4          5          6          7          8
   20031120          1          2          3          4          5          6          7          8
 Columns 10 through 18:
          9         10         11         12         13         14         15         16         17
          9         10         11         12         13         14         15         16         17
 Columns 19 through 27:
         18         19         20         21         22         23         24         25         26
         18         19         20         21         22         23         24         25         26
 Columns 28 through 36:
         27         28         29         30         31        NaN        NaN        NaN        NaN
         27         28         29         30         31        NaN        NaN        NaN        NaN
 Columns 37 through 40:
        NaN        NaN        NaN        NaN
        NaN        NaN        NaN        NaN

Best Answer

Related Solutions

MATLAB: Fill in missing NaNs

MATLAB: How to rearrange data in matrix rows

Related Question