I need help in arranging my data

2 次查看（过去 30 天）
SAMUEL AYINDE
SAMUEL AYINDE 2018-8-16
评论： SAMUEL AYINDE 2018-8-17
Please, find the attached matlab file The first column is the x_coordinates, second column is the y coordinates, the third column and fourth column are the data I want to plot. For my data to be correctly plotted, I need to rearrange my data such that x column will be from 0-2, 0-2, 0-2 ... and the corresponding y-coordinates and other data on the previous rows will go with x to the new rows.
For example
Initial matrix
0 0.4 0.6 0.8
1.5 0.3 0.5 0.7
1.8 0.5 0.8 0.4
1 0.7 0.9 0.5
1 0.5 0.4 0.3
2 0.2 0.1 0.6
0 0.8 0.9 0.4
1.5 0.2 0.1 0.6
2 0.2 0.4 0.1
0 0.3 0.4 0.6
1.5 0.2 0.1 0.9
1.8 0.4 0.5 0.7
1.8 0.1 0.2 0.4
1 0.2 0.4 0.5
2 0.3 0.2 0.3
What I want to acheive
0 0.4 0.6 0.8
1 0.7 0.9 0.5
1.5 0.3 0.5 0.7
1.8 0.5 0.8 0.4
2 0.2 0.1 0.6
0 0.8 0.9 0.4
1 0.5 0.4 0.3
1.5 0.2 0.1 0.6
1.8 0.4 0.5 0.7
2 0.2 0.4 0.1
0 0.3 0.4 0.6
1 0.2 0.4 0.5
1.5 0.2 0.1 0.9
1.8 0.1 0.2 0.4
2 0.3 0.2 0.3
Please, I need a code that can help me to achieve this. My original data is the phi.mat attached. Thank you so much.
  2 个评论
Stephen23
Stephen23 2018-8-17
@SAMUEL AYINDE: why does the first line disappear from your data? You show it in the input matrix, but not in the output matrix.
SAMUEL AYINDE
SAMUEL AYINDE 2018-8-17
@Stephen Cobeldick, It was a mistake. The first line should not be there in the first place. Thank you so much.

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Stephen23
Stephen23 2018-8-17
编辑：Stephen23 2018-8-17
The simplest solution is to use sortrows. Your real data (attached) has some floating point errors which mean that values that look the same are not actually the same at all. I dealt with that using round:
>> [~,idx] = sortrows(round(phi(:,1:2)*1e4),[2,1]);
>> out = phi(idx,:);
>> out(1:100,:) % the first one hundred rows
ans =
0.00000 0.00000 0.12500 4.35415
0.02500 0.00000 0.12625 3.87539
0.05000 0.00000 0.12995 -6.60861
0.07500 0.00000 0.13333 -32.63957
0.10000 0.00000 0.10833 -15.64291
0.12500 0.00000 0.08333 -3.38352
0.15000 0.00000 0.05833 0.99885
0.17500 0.00000 0.03333 6.29332
0.20000 0.00000 0.00833 7.43663
0.22500 0.00000 -0.01667 9.02729
0.25000 0.00000 -0.04167 11.19658
0.27500 0.00000 -0.06667 13.11854
0.30000 0.00000 -0.09167 20.88033
0.32500 0.00000 -0.11667 66.35252
0.35000 0.00000 -0.10833 39.24750
0.37500 0.00000 -0.08333 16.96182
0.40000 0.00000 -0.05833 12.69074
0.42500 0.00000 -0.03333 10.41462
0.45000 0.00000 -0.00833 8.43611
0.47500 0.00000 0.01667 7.01445
0.50000 0.00000 0.04167 5.98383
0.52500 0.00000 0.06667 -2.22252
0.55000 0.00000 0.09167 -6.89060
0.57500 0.00000 0.11667 -23.43924
0.60000 0.00000 0.13374 -33.44865
0.62500 0.00000 0.12845 0.60804
0.65000 0.00000 0.12555 4.44767
0.67500 0.00000 0.12514 4.45818
0.70000 0.00000 0.12721 3.00757
0.72500 0.00000 0.13172 -17.72344
0.75000 0.00000 0.12500 -29.57837
0.77500 0.00000 0.10000 -9.43113
0.80000 0.00000 0.07500 -1.13979
0.82500 0.00000 0.05000 4.74838
0.85000 0.00000 0.02500 6.63524
0.87500 0.00000 0.00000 7.90819
0.90000 0.00000 -0.02500 9.68690
0.92500 0.00000 -0.05000 11.98908
0.95000 0.00000 -0.07500 13.08059
0.97500 0.00000 -0.10000 25.11572
1.00000 0.00000 -0.12500 80.30814
1.02500 0.00000 -0.10000 25.11572
1.05000 0.00000 -0.07500 13.08059
1.07500 0.00000 -0.05000 11.98908
1.10000 0.00000 -0.02500 9.68690
1.12500 0.00000 -0.00000 7.90819
1.15000 0.00000 0.02500 6.63524
1.17500 0.00000 0.05000 4.74838
1.20000 0.00000 0.07500 -1.13979
1.22500 0.00000 0.10000 -9.43113
1.25000 0.00000 0.12500 -29.57837
1.27500 0.00000 0.13172 -17.72344
1.30000 0.00000 0.12721 3.00757
1.32500 0.00000 0.12514 4.45818
1.35000 0.00000 0.12555 4.44767
1.37500 0.00000 0.12845 0.60804
1.40000 0.00000 0.13374 -33.44865
1.42500 0.00000 0.11667 -23.43924
1.45000 0.00000 0.09167 -6.89060
1.47500 0.00000 0.06667 -2.22252
1.50000 0.00000 0.04167 5.98383
1.52500 0.00000 0.01667 7.01445
1.55000 0.00000 -0.00833 8.43611
1.57500 0.00000 -0.03333 10.41462
1.60000 0.00000 -0.05833 12.69074
1.62500 0.00000 -0.08333 16.96182
1.65000 0.00000 -0.10833 39.24750
1.67500 0.00000 -0.11667 66.35252
1.70000 0.00000 -0.09167 20.88033
1.72500 0.00000 -0.06667 13.11854
1.75000 0.00000 -0.04167 11.19658
1.77500 0.00000 -0.01667 9.02729
1.80000 0.00000 0.00833 7.43663
1.82500 0.00000 0.03333 6.29332
1.85000 0.00000 0.05833 0.99885
1.87500 0.00000 0.08333 -3.38352
1.90000 0.00000 0.10833 -15.64291
1.92500 0.00000 0.13333 -32.63957
1.95000 0.00000 0.12995 -6.60861
1.97500 0.00000 0.12625 3.87539
2.00000 0.00000 0.12500 4.35415
0.00000 0.02500 0.10000 4.64482
0.02500 0.02500 0.10138 4.45428
0.05000 0.02500 0.10549 3.43575
0.07500 0.02500 0.11217 -27.11467
0.10000 0.02500 0.10967 -48.24988
0.12500 0.02500 0.08483 -3.38557
0.15000 0.02500 0.06003 5.46925
0.17500 0.02500 0.03529 6.33332
0.20000 0.02500 0.01066 7.51564
0.22500 0.02500 -0.01382 9.21827
0.25000 0.02500 -0.03800 11.81698
0.27500 0.02500 -0.06154 15.89211
0.30000 0.02500 -0.08333 21.18223
0.32500 0.02500 -0.09865 46.15575
0.35000 0.02500 -0.09495 32.23685
0.37500 0.02500 -0.07641 19.42267
0.40000 0.02500 -0.05380 14.33840
0.42500 0.02500 -0.02999 10.81766
0.45000 0.02500 -0.00568 8.57450

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Annotations 的更多信息

标签

产品


版本

R2017a

Community Treasure Hunt

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

Start Hunting!

Translated by