Data Sorting

Question

0 个投票

Hi, I am trying to sort some data which looks likes this:

750000 1.850000 0.665590 0.008090 0.001350 70.507415 0.477660 
740000 1.850000 0.636280 0.007960 0.000820 72.469248 0.496540 
730000 1.850000 0.616250 0.007850 0.000400 74.696970 0.458810 
720000 1.850000 0.599960 0.007740 0.000100 76.525510 0.164770  
710000 1.70000 0.585730 0.007660 0.000000 76.466057 0.150690 
700000 1.850000 0.573140 0.007590 0.000000 75.512516 0.111650 
690000 1.850000 0.561880 0.007530 0.000000 74.618858 0.124110 
680000 1.850000 0.551720 0.007470 0.000030 73.562667 0.058280  
760000 1.850000 0.695240 0.008480 0.004090 55.309467 0.571900 
770000 1.850000 0.708020 0.009050 0.006680 45.010807 0.627590  
775000 1.90000 0.706110 0.009370 0.007870 40.957657 0.645790

I have read the data in and I am trying to sort it. I switched the place of the first two columns as I wanted to look at the data that way. I want the data sorted in ascending order of the second column shown(which was switched to the first column), but I also want the corresponding row kept. The problem I am having is that as there are lots of '1.850000' figures, it sorts the data but then only associates the other columns with that of the first 1.85 figure, meaning that - that row is repeated. My code looks like:

data_Alpha_sort = sort(data_5230,1,'ascend');

for i = 1:(length(data_Alpha_sort)-1) ind = find(data_Alpha_sort(i,1) == data_5230(:,1)); Alpha_sa(i,1) = data_5230(ind(1),1); ...etc... end

Does anyone have any suggestions about how I can sort this out?

Many Thanks