MATLAB: How to arrange the y-values in xyz-data in ascending order

sort

How can i change the values:

23.2 54.23 354.43

12.2 15.43 324.42

54.2 33.43 376.43

43.3 76.34 365.34

…

reorder so that the values in the second column are arranged in ascending order, but the (xyz)-triple still exists:

12.2 15.43 324.42

54.2 33.43 376.43

23.2 54.23 354.43

43.3 76.34 365.34

…

Thank you so much!

Harry

Best Answer

You can use

sortrows(A, column)

where A is your array and column is the column you wish to sort.

Related Solutions

MATLAB: How to make each pair of pixels from the matrix in a row major order

Hello Subroto. I have used a couple of steps to convert A into a vector of paired up pixels and stored it in A_paired.

>> A=[43   36   31   35   35   29   29   25
      33   33   32   29   25   25   22   22
      33   33   31   32   31   27   25   29
      28   33   35   27   25   29   32   51
      23   26   30   38   31   43   47   57
      27   29   30   37   40   52   63   61
      23   24   32   42   52   62   72   66
      24   30   44   54   65   71   70   74 ];
>> A_transpose = A';
>> A_vector = A_transpose(:);
>> A_paired = reshape(A_vector, 2, length(A_vector) / 2)'
A_paired =
    43    36
    31    35
    35    29
    29    25
    33    33
    32    29
    25    25
    22    22
    33    33
    31    32
    31    27
    25    29
    28    33
    35    27
    25    29
    32    51
    23    26
    30    38
    31    43
    47    57
    27    29
    30    37
    40    52
    63    61
    23    24
    32    42
    52    62
    72    66
    24    30
    44    54
    65    71
    70    74

I hope this was helpful. :)

MATLAB: Error using textscan to read a csv file with number and text and date in one file

Fan, leave the commas out fo the format and use readtable:

>> t = readtable('test1_V6.csv','Format','%{HH:mm:ss}D%f%C%f%f%f%f%f%f%f%{HH:mm:ss}D%f%f%f%f','Header',3)
Warning: Variable names were modified to make them valid MATLAB identifiers. The original names are saved in the
VariableDescriptions property. 
t =
      Time      Comment    ModuleID    Alt_m_    P_mbar_    T_degC_    x_RH    Wind_degrees_    Wind_m_s_    Supply_V_    UTCTime     Latitude_deg_    Longitude_deg_    Course_deg_    Speed_m_s_
    ________    _______    ________    ______    _______    _______    ____    _____________    _________    _________    ________    _____________    ______________    ___________    __________
    23:09:10    NaN        F667D9      54.2      999.9      16.3       39.2    236              4.1          11.8         23:09:00    70.495           -149.89           78             0.02      
    23:09:11    NaN        F667D9      54.2      999.9      16.3         39    237              3.9          11.8         23:09:05    70.495           -149.89           78             0.01      
    23:09:15    NaN        F667D9      54.2      999.8      16.3       39.1    236              4.1          11.8         23:09:10    70.495           -149.89           78             0.01      
    23:09:20    NaN        F667D9      54.2      999.9      16.3       38.9    236              4.1          11.8         23:09:15    70.495           -149.89           78             0.01      
    23:09:25    NaN        F667D9      54.2      999.8      16.3       38.8    236              3.9          11.8         23:09:20    70.495           -149.89           78             0.02      
    23:09:30    NaN        F667D9      54.2      999.8      16.3       38.7    236              4.1          11.8         23:09:25    70.495           -149.89           78             0.02      
    23:09:32    NaN        F667D9      54.2      999.7      16.3       38.8    236              3.9          11.8         23:09:30    70.495           -149.89           78             0.02      
    23:09:36    NaN        F667D9      54.2      999.8      16.3       39.4    235              4.1          11.8         23:09:35    70.495           -149.89           78             0.01      
    23:09:41    NaN        F667D9      54.2      999.7      16.3       38.8    236              3.9          11.8         23:09:40    70.495           -149.89           78             0.01      
    23:09:46    NaN        F667D9      54.2      999.8      16.3         39    236              4.1          11.8         23:09:45    70.495           -149.89           78             0.01      
    23:09:51    NaN        F667D9      54.2      999.9      16.3       38.8    235              3.9          11.8         23:09:50    70.495           -149.89           78                0      
    23:09:56    NaN        F667D9      54.2      999.8      16.3       39.1    235              4.1          11.8         23:09:55    70.495           -149.89           78             0.01

The times had no date portion, so they were read as "today", but the file header indocates that they're from 6/11/2016. Modify the two time variables accordingly:

>> t.Time = datetime(2016,6,11) + timeofday(t.Time);
>> t.UTCTime = datetime(2016,6,11) + timeofday(t.UTCTime)
t =
            Time            Comment    ModuleID    Alt_m_    P_mbar_    T_degC_    x_RH    Wind_degrees_    Wind_m_s_    Supply_V_          UTCTime           Latitude_deg_    Longitude_deg_    Course_deg_    Speed_m_s_
    ____________________    _______    ________    ______    _______    _______    ____    _____________    _________    _________    ____________________    _____________    ______________    ___________    __________
    11-Jun-2016 23:09:10    NaN        F667D9      54.2      999.9      16.3       39.2    236              4.1          11.8         11-Jun-2016 23:09:00    70.495           -149.89           78             0.02      
    11-Jun-2016 23:09:11    NaN        F667D9      54.2      999.9      16.3         39    237              3.9          11.8         11-Jun-2016 23:09:05    70.495           -149.89           78             0.01      
    11-Jun-2016 23:09:15    NaN        F667D9      54.2      999.8      16.3       39.1    236              4.1          11.8         11-Jun-2016 23:09:10    70.495           -149.89           78             0.01      
    11-Jun-2016 23:09:20    NaN        F667D9      54.2      999.9      16.3       38.9    236              4.1          11.8         11-Jun-2016 23:09:15    70.495           -149.89           78             0.01      
    11-Jun-2016 23:09:25    NaN        F667D9      54.2      999.8      16.3       38.8    236              3.9          11.8         11-Jun-2016 23:09:20    70.495           -149.89           78             0.02      
    11-Jun-2016 23:09:30    NaN        F667D9      54.2      999.8      16.3       38.7    236              4.1          11.8         11-Jun-2016 23:09:25    70.495           -149.89           78             0.02      
    11-Jun-2016 23:09:32    NaN        F667D9      54.2      999.7      16.3       38.8    236              3.9          11.8         11-Jun-2016 23:09:30    70.495           -149.89           78             0.02      
    11-Jun-2016 23:09:36    NaN        F667D9      54.2      999.8      16.3       39.4    235              4.1          11.8         11-Jun-2016 23:09:35    70.495           -149.89           78             0.01      
    11-Jun-2016 23:09:41    NaN        F667D9      54.2      999.7      16.3       38.8    236              3.9          11.8         11-Jun-2016 23:09:40    70.495           -149.89           78             0.01      
    11-Jun-2016 23:09:46    NaN        F667D9      54.2      999.8      16.3         39    236              4.1          11.8         11-Jun-2016 23:09:45    70.495           -149.89           78             0.01      
    11-Jun-2016 23:09:51    NaN        F667D9      54.2      999.9      16.3       38.8    235              3.9          11.8         11-Jun-2016 23:09:50    70.495           -149.89           78                0      
    11-Jun-2016 23:09:56    NaN        F667D9      54.2      999.8      16.3       39.1    235              4.1          11.8         11-Jun-2016 23:09:55    70.495           -149.89           78             0.01

Best Answer

Related Solutions

MATLAB: How to make each pair of pixels from the matrix in a row major order

MATLAB: Error using textscan to read a csv file with number and text and date in one file

Related Question