Sorting operation on a string matrix
显示 更早的评论
Hi everyone,
My code for sorting string. Question in comment:
s = ["1 9:53.3";
"3 9:23.5";
"5 2:16.2";
"2 2:45.6";
"4 12:01.2"]
s = split(s," ",2);
stab = array2table(s);
stab.s1 = double(stab.s1);
stab = sortrows(stab,"s1","ascend");
stab.s1 = string(stab.s1);
stab = table2array(stab)
% Question : How do I get the sorted matrix as a 5X1 matrix now?
Required sorted output matrix :
s =[ "1 9:53.334"
"2 2:45.623"
"3 9:23.545"
"4 12:01.213"
"5 2:16.245"]
Suggestions, if any, for better/more effficient ways to this string data are welcome.
Thanks for your time in advance.
5 个评论
dpb
2021-5-5
>> sortrows(s)
ans =
5×1 string array
"1 9:53.3"
"2 2:45.6"
"3 9:23.5"
"4 12:01.2"
"5 2:16.2"
>>
Why create such a monstrosity to begin with?
Why not read the data in as numeric and datetime and then create a formatted output if needed?
"Didnt think MATLAB can recognize numerical data within strings. "
It doesn't. MATLAB sorts purely based on character code.
Try it with any "value" greater than 10, is that really the order you want?:
s = ["2 9:53.3";
"20 9:23.5";
"1 2:16.2";
"10 2:45.6";
"3 12:01.2"]
sort(s)
". it sorts data as 1,10,11...2,20,21... "
Of course it does; that was the point of asking why you're so stuck on trying to treat numeric data as character...note again that Stephen's solution has to convert to numeric first (as he also points to a better storage design) so why not just do that from the git-go instead of making it more difficult than needs be?
There is a lexical sort (and why TMW hasn't builtin one is anybody's guess) on FEX altho I don't have the link right now at hand...
采纳的回答
s = ["1 9:53.3";
"3 9:23.5";
"5 2:16.2";
"2 2:45.6";
"4 12:01.2"];
[~,X] = sort(str2double(extractBefore(s,' ')));
out = s(X,:)
Note that much better data design would store numeric data as a numeric type.
6 个评论
klb
2021-5-5
dpb
2021-5-5
"reading in a PDF. So everything is being imported first as text."
Still would be far easier going forward to first convert that text to the proper type instead of trying to fit square peg in round hole...
klb
2021-5-6
>> s=split(s);
>> data=table(str2double(s(:,1)), ...
duration(s(:,2),'InputFormat','mm:ss.S','Format','mm:ss.S'), ...
'VariableNames',{'N','T'})
data =
5×2 table
N T
_ _______
1 09:53.3
3 09:23.5
5 02:16.2
2 02:45.6
4 12:01.2
>> sortrows(data,'N')
ans =
5×2 table
N T
_ _______
1 09:53.3
2 02:45.6
3 09:23.5
4 12:01.2
5 02:16.2
>>
Or, alternatively, if were interested in the time/duration
>> sortrows(data,'T')
ans =
5×2 table
N T
_ _______
5 02:16.2
2 02:45.6
3 09:23.5
1 09:53.3
4 12:01.2
>>
Nothing could be easier; NB: the table is a wonderfully powerful container for mixed data types; much more flexible than just a cell array and far more convienent than holding in either separate arrays or to try to machinate on text when it really isn't text...
If you were to have begun with a text file instead of a string array, you surely would have used readtable or similar tool to import as the type of data in the file; the message is to treat the source text the same way despite its origin.
klb
2021-5-6
更多回答（1 个）
Chunru
2021-5-5
try the following:
s = stab(:,1) + " " + stab(:,2)
Not sure how can you get the additional digits not in the input.
类别
在 帮助中心 和 File Exchange 中查找有关 Large Files and Big Data 的更多信息
Translated by 
