필터 지우기
필터 지우기

I need help in arranging my data

조회 수: 4 (최근 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