MATLAB: Median Value of specific data by index

Hi, I have a matrix like the one attched, made by index and value, I want to obtain a matrix made by the the value of the index (non repeated ) [1,2,3,4,5,6…] and the average of the values that has the same index [147 (for index 1),112 (for index 2),119 (for index 3)…] , how I can do ?
Thanks


1   147
     1   153
     1   152
     1   151
     1   152
     1   154
     1   148
     1   152
     1   154
     1   154
     1   151
     1   146
     1   153
     1   156
     1   151
     1   160
     1   161
     1   158
     1   133
     1   160
     1   174
     1   162
     1   153
     1   153
     1   153
     1   153
     1   153
     1   153
     1   153
     1   153
     1   153
     1   153
     1   151
     1   151
     1   153
     1   150
     1   143
     1   137
     1   124
     1   128
     1   143
     1   133
     1   132
     1   125
     1   114
     1   111
     1   114
     2   114
     2   115
     2   147
     2   118
     2   114
     2   115
     2    80
     2    68
     2   111
     2   120
     2   121
     2   104
     2    91
     2    77
     2   148
     2   110
     2   191
     2   121
     2    92
     2    61
     2    61
     2    61
     2    61
     2    61
     2    61
     2    61
     2    61
     2   104
     2   102
     2    71
     2    72
     2    98
     2   111
     2   142
     2   150
     2   116
     2   110
     2   153
     2   171
     2   172
     2   187
     2   169
     2   167
     2   144
     2   132
     2   167
     2   109
     2   101
     3   127
     3   139
     3   146
     3   146
     3   139
     3   122
     3    76
     3   106
     3   112
     3   117
     3   113
     3   133
     3   119
     3   112
     3   111
     3   112
     3   119
     3    87
     3    84
     3   110
     3   111
     3   143
     3   150
     3   153
     3   156
     3   153
     3   155
     3   150
     3   146
     3   131
     3   119
     3   115
     3   122
     3   116
     3   114
     3   111
     3   110
     3   115
     3   117
     3    87
     3    85
     3   115
     3    78
     3   112
     3   111
     3   128
     3   118
     3   124
     4   131
     4   150
     4   154
     4   148
     4   107
     4   133
     4   135
     4   124
     4   146
     4   152
     4   116
     4   118
     4    88
     4   111
     4   102
     4    79
     4   116
     4   102
     4   104
     4   109
     4    89
     4   113
     4   123
     4   128
     4   127
     4   139
     4   155
     4   144
     4   118
     4   112
     4   150
     4   102
     4   132
     4   109
     4    80
     4   127
     4   108
     4   113
     4    84
     4    82
     4   104
     4   125
     4   126
     4   115
     4   114
     4   126
     4   113
     4   115
     5   114
     5   117
     5   105
     5   144
     5   125
     5   134
     5   151
     5   150
     5   148
     5   173
     5   158
     5   117
     5   132
     5   122
     5   104
     5   106
     5    88
     5    75
     5    82
     5    60
     5    57
     5    96
     5   116
     5   116
     5   116
     5   116
     5   123
     5   111
     5   111
     5   111
     5   111
     5   111
     5   111
     5   111
     5   111
     5   111
     5   111
     5   111
     5   111
     5   111
     5   112
     5   112
     5    98
     5    99
     5    90
     5   145
     5   124
     5   150
     6   116
     6   103
     6    84
     6    96
     6    92
     6    82
     6    89
     6    91
     6    97
     6    98
     6    82
     6    92
     6    92
     6    92
     6   115
     6   135
     6   135
     6   129
     6   125
     6   125
     6   125
     6   125
     6   125
     6   125
     6   125
     6   125
     6   113
     6   116
     6   148
     6   150
     6   148
     6   153
     6   153
     6   108
     6   118
     6   113
     6    82
     6   129
     6   131
     6    96
     6    83
     6   117
     6   109
     6    82
     6   104
     6   119
     6    86
     6    64
     7    81
     7   118
     7   124
     7   133
     7    76
     7    79
     7   128
     7   117
     7   135
     7   121
     7    81
     7   115
     7   120
     7   114
     7    74
     7   108
     7   138
     7   156
     7   130
     7   109
     7   109
     7   109
     7   109
     7   109
     7   132
     7   144
     7   127
     7   134
     7   152
     7   150
     7   154
     7   151
     7   156
     7   159
     7   157
     7   163
     7    96
     7   130
     7   126
     7   136
     7   120
     7   129
     7   124
     7   112
     7   135
     7   134
     7   151
     7   153
     8   128
     8   147
     8   147
     8   150
     8   157
     8   150
     8   146
     8   137
     8   118
     8    84
     8   105
     8   107
     8   122
     8   124
     8   110
     8   121
     8   135
     8   109
     8   118
     8   107
     8   140
     8    76
     8    68
     8    63
     8   103
     8   115
     8   115
     8   115
     8   115
     8   115
     8   115
     8   115
     8    39
     8   342
     8   348
     8   351
     8   322
     8   274
     8   274
     8   274
     8   279
     8   353
     8   359
     8     0
     8    26
     8   341
     8   287
     8   246
     9   344
     9    13
     9    14
     9    15
     9    12
     9    13
     9     6
     9    15
     9    14
     9    10
     9   343
     9   311
     9     6
     9     6
     9     1
     9   357
     9   356
     9   351
     9   335
     9   247
     9   233
     9   232
     9   169
     9   169
     9    92
     9   100
     9   105
     9   105
     9   105
     9   105
     9   105
     9   105
     9   105
     9   105
     9   105
     9   105
     9   109
     9   107
     9   126
     9   126
     9   126
     9   126
     9   126
     9   126
     9   126
     9   126
     9   126
     9   117
    10   116
    10   116
    10   116
    10   116
    10   116
    10   116
    10   117
    10   131
    10   136
    10   144
    10   134
    10   135
    10   141
    10   138
    10   103
    10   100
    10
            

            
            
            

    
        
	
    
        Best Answer
    

    
								
								xc=categorical(x(:,1));              % convert indices to categorical (not mandatory, sometimes convenient)
[G,grp]=findgroups(xc);              % find groups, group IDs
mnY=splitapply(@mean,x(:,2),G);      % compute desired statistic by group
See documentation for more details, examples, etc., ...
						    
								
    
        
    

Related Solutions
MATLAB: How to calculate the index of minimum value in each column cell array

								
								Mohammad, use cell2mat() to convert the cell array to an ordinary array (e.g. A) and then use
[val,loc] = min(A,[],1)
						    
						
MATLAB: Reshape an array into another

								
								a = [1    2    3    4  5   6    7  8;...
    9   10  11 12 13 14 15 16;...
    17 18 19 20 21 22  23 24;...
    25 26 27 28 29 30 31  32];
a = [a(:,1:end/2);a(:,end/2+1:end)]
						    
						
        
        
            
            
            Related Question
How to find all possible routes with a given node matrix
How to calculate the average for each row of cell array
How to rearrange data in matrix rows
Error using scatter . how to remove it
Create matrix with periodic increments