Alphanumeric sorting of data

2021 1 19
1 个回答
回答已采纳
更新时间：2021 1 25
12 次查看（30 天）

0 个投票

Hello,
I have data which is extracted from various excel fiels in a folder. I want to sort the data based on the data in the first column. The issue is the data in this column is for ex, '10000 Rest', '3200 Rest', '2000 Rest', etc.. I need the data to be in ascending form. The output I receive is '10000 Rest', '2000 Rest', '3200 Rest', etc. The required output for me is '2000 Rest', '3200 Rest', '10000 Rest'.. etc.
Is there a way to change the sorting type.
Thanks

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

 采纳的回答

Rishabh Mishra
Rishabh Mishra 2021-1-22
编辑：Rishabh Mishra 2021-1-22

0 个投票

Hi,
Based on my understanding of the issue, I suggest you to implement the 'sort_nat' function. The function is used to sort array of strings in natural alphabetcial order. I have added a reference example code below to demonstrate the use of sort_nat function.
arr = {'10000 Rest','3200 Rest','2000 Rest'};
sort_nat(arr);
Hope this helps!

4 个评论
显示 2更早的评论 隐藏 2更早的评论

Prathamesh Halagi
Prathamesh Halagi 2021-1-24
The problem for me with this is I have large data so doing this wont be very helpful.
Prathamesh Halagi
Prathamesh Halagi 2021-1-25
clear
clc
ds_2 = spreadsheetDatastore('*dir', 'Sheets', 'sheet3', 'Range', 'A1:D20', 'FileExtensions', '.xls', 'ReadVariableNames', true);
ds_2 = readall(ds_2)
C = unique(ds_2)
[C,ia] = unique(ds_2.Var1);
B = ds_2(ia,:)
----
This is my code I have been using for now - I extract the data from multiple .xls files and then remove recurring data. I tried using natsort but it is not working I might be doing some mistake. I want to sort all the data based on the data in first column. I have 468x4 data.
Walter Roberson
Walter Roberson 2021-1-25
编辑：Walter Roberson 2021-1-25
Can the alphabetic part always be ignored for sorting purposes? For example, no "2000 Checkpoint" along with "2000 Rest" ?
[~, idx] = sort(arrayfun(@(S) sscanf(S, '%d', 1), ds_2.Var1));
Prathamesh Halagi
Prathamesh Halagi 2021-1-25
Yes, I think it can be ignored as all data has number followed by REST.

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Shifting and Sorting Matrices 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by