Problems Sorting a Table using sortrows

13 次查看（过去 30 天）
Sebastian Cornejo
Sebastian Cornejo 2017-3-28
编辑： Guillaume 2017-3-28
I have this table of data I need to sort based on the values in the 'Odometer' column. Here is the code I'm using.
%%Odometer Sort Algorithm
s2 = 'Odometer';
num_cols = size(data,2);
num_rows = size(data,1);
% Finds the 'Odometer' column
% starts at 2 so header doesn't get sorted
for k = 2:1:num_cols
s1 = data{1,k};
if strcmp(s1,s2)
break
end
end
for j = 2:1:num_rows
data{j,k} = str2double(data{j,k});
end
data = sortrows(data,k);
When I run the code, I get the following error:
Error using char
Cell elements must be character arrays.
Error in sortrows>sort_cell_back_to_front (line 135)
tmp = char(x(ndx,k));
Error in sortrows (line 87)
ndx = sort_cell_back_to_front(x_sub, col);
Error in Test (line 29)
data = sortrows(data,k);
I think this is a result of the first element in the 'Odometer' column being a char. How can I properly sort the rows below the first element??

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

采纳的回答

Guillaume
Guillaume 2017-3-28
编辑：Guillaume 2017-3-28
You kind of inadvertantly answered your question in your title.
The simplest way is to actually use a table instead of a cell array. tables are a lot easier to work with as well.
%convert cell array into table:
datatable = cell2table(data(2:end, :), 'VariableNames', matlab.lang.makeValidName(data(1, :)));
%sort rows according to odometer column:
sortedtable = sortrows(datatable, 'Odometer')
That's all that is needed. No searching for the odometer column. The table knows where it is.
If you don't want to use a table and want to keep using a cell array, then sort your rows ignoring the first one:
sorteddata = [data(1, :); sortrows(data(2:end, :), k)];
Note: the loop for finding the odometer column wasn't needed, this would have achieved the same:
k = find(strcmp(data(1, :), 'Odometer'));

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by