i have cell whoes 1st column has names of countries and 2nd have population
i want to arrage it alphabetical oder in such a way so that population of counteries donot misplaced
for example
burundi 11890781 donot change means row wise data donot alter

4 Comments

Note that SORT uses the character code order, which is not the same as alphabetic order.
In your example, "Réunion" would sort after "Rwanda", because "é" has a higher character code than "w":
S = ["Angola","Réunion","Rwanda","Zambia"];
T = sort(S) % wrong order!
T = 1×4 string array
"Angola" "Rwanda" "Réunion" "Zambia"
But in English and also in standard French, the letter "é" comes before "w" because the diacritic is considered as a modifier of the "e" character. Note however that in some other languages letters with diacritics are considered to be separate letters, and that the same characters can be positioned in different locations by different countries and languages. Some languages even count digraphs (two graphemes) as one letter, with "its" own position in the alphabet.
In short, sorting "alphabetically" is nowhere near as trivial as people think:
it should sort in English alphatical oder
@Muhammad SULAMAN: then you will need to handle the diacritics yourself (e.g. remove them before sorting and then use the sort index to sort the original data).
Addendum: an easy way to sort Réunion into the expected position is to use ARBSORT:
For example:
S = ["Réunion","Zambia","Rwanda","Angola"];
sort(S) % for comparison
ans = 1×4 string array
"Angola" "Rwanda" "Réunion" "Zambia"
arbsort(S)
ans = 1×4 string array
"Angola" "Réunion" "Rwanda" "Zambia"

Sign in to comment.

 Accepted Answer

Rik
Rik on 1 Jun 2021
You can use sortrows directly, or use code like this:
[~,order]=sort(population(:,1));
population=population(order);

4 Comments

but it doesnot have population in 2 column
Small typo:
[~,order]=sort(population(:,1));
population=population(order,:);
output of your code
it doesnot have populatioin

Sign in to comment.

More Answers (0)

Categories

Asked:

on 1 Jun 2021

Edited:

on 14 Aug 2023

Community Treasure Hunt

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

Start Hunting!