Problem 1120. Visualization of experimental data across a surface

Created by Carl

Solve Later

{"relationships":[{"relationshipType":"http://schemas.mathworks.com/matlab/code/2013/relationships/document","targetMode":"","relationshipId":"rId1","target":"/matlab/document.xml"},{"relationshipType":"http://schemas.mathworks.com/matlab/code/2013/relationships/output","targetMode":"","relationshipId":"rId2","target":"/matlab/output.xml"}],"parts":[{"partUri":"/matlab/document.xml","relationship":[],"contentType":"application/vnd.mathworks.matlab.code.document+xml","content":"<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<w:document xmlns:w=\"http://schemas.openxmlformats.org/wordprocessingml/2006/main\"><w:body><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>Assume that you have taken data across the surface of a sample, for example sheet resistance. The data is stored in a Nx3 matrix, where the columns are: [X,Y,data]. Assume that the lower-left corner of the sample is (X,Y) = (0,0), and the upper right corner of the sample is (X,Y) = (3,3), and the data is taken only at integers between 0:3 (4x4 or max of 16 locations across the sample).</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>The goal is to find the simplest way to take the data and construct a 2-dimensional matrix, where the data at (0,0) is in the lower-left and the data at (3,3) is in the upper right. Any locations with no data specified should end up as NaN in the final matrix. If any location is listed twice in the data, the LAST value (the one with the highest row index) should be used. It is possible that there is no data (i.e. data = []);</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>For example, if the input data is:</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"code\"/></w:pPr><w:r><w:t><![CDATA[data = [\n0 0 5\n1 1 2\n2 2 7\n3 3 8\n1 1 6\n];]]></w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>Then the output should be:</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"code\"/></w:pPr><w:r><w:t><![CDATA[output = [\nNaN NaN NaN 8\nNaN NaN 7 NaN\nNaN 6 NaN NaN\n5 NaN NaN NaN\n];]]></w:t></w:r></w:p></w:body></w:document>"},{"partUri":"/matlab/output.xml","contentType":"text/xml","content":"<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"no\" ?><embeddedOutputs><metaData><evaluationState>manual</evaluationState><layoutState>code</layoutState><outputStatus>ready</outputStatus></metaData><outputArray type=\"array\"/><regionArray type=\"array\"/></embeddedOutputs>"}]}

Assume that you have taken data across the surface of a sample, for example sheet resistance. The data is stored in a Nx3 matrix, where the columns are: [X,Y,data]. Assume that the lower-left corner of the sample is (X,Y) = (0,0), and the upper right corner of the sample is (X,Y) = (3,3), and the data is taken only at integers between 0:3 (4x4 or max of 16 locations across the sample).The goal is to find the simplest way to take the data and construct a 2-dimensional matrix, where the data at (0,0) is in the lower-left and the data at (3,3) is in the upper right. Any locations with no data specified should end up as NaN in the final matrix. If any location is listed twice in the data, the LAST value (the one with the highest row index) should be used. It is possible that there is no data (i.e. data = []);For example, if the input data is:<pre class="language-matlab">data = [
0 0 5
1 1 2
2 2 7
3 3 8
1 1 6
];
</pre>Then the output should be:<pre class="language-matlab">output = [
NaN NaN NaN 8
NaN NaN 7 NaN
NaN 6 NaN NaN
5 NaN NaN NaN
];
</pre>

Assume that you have taken data across the surface of a sample, for example sheet resistance.  The data is stored in a Nx3 matrix, where the columns are: [X,Y,data].  Assume that the lower-left corner of the sample is (X,Y) = (0,0), and the upper right corner of the sample is (X,Y) = (3,3), and the data is taken only at integers between 0:3 (4x4 or max of 16 locations across the sample).

The goal is to find the simplest way to take the data and construct a 2-dimensional matrix, where the data at (0,0) is in the lower-left and the data at (3,3) is in the upper right.  Any locations with no data specified should end up as NaN in the final matrix.  If any location is listed twice in the data, the LAST value (the one with the highest row index) should be used.  It is possible that there is no data (i.e. data = []);

For example, if the input data is:

data = [
  0 0 5
  1 1 2
  2 2 7
  3 3 8
  1 1 6
  ];

Then the output should be:

output = [
  NaN NaN NaN 8
  NaN NaN 7   NaN
  NaN 6   NaN NaN
  5   NaN NaN NaN
  ];

Solve

Solution Stats

67 Solutions
23 Solvers

Last Solution submitted on May 05, 2021

Last 200 Solutions

Problem Comments

1 Comment

1 Comment

goc3 on 31 Dec 2014

I had no idea that the function isequalwithequalnans exists. That makes me wonder how many functional variants of isequal exist.

Problem Recent Solvers23

Problem Tags

data matrix

Community Treasure Hunt

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

Start Hunting!