MATLAB Answers

converting a string of variables to numbers

7 views (last 30 days)
ektor
ektor on 21 May 2012
HI all I have the varible
Country
Austria
Austria
Austria
Austria
Austria
Austria
Austria
and I want to convert it to a numeric varable. Any help?
Thanks in advance

  5 Comments

Show 2 older comments
Oleg Komarov
Oleg Komarov on 21 May 2012
To be more precise you're grouping by location AND country AND date.
Oleg Komarov
Oleg Komarov on 21 May 2012
Now that I read your duplicated question: http://www.mathworks.com/matlabcentral/answers/38910-grouping-observations-with-specific-characteristics
I understand that you do NOT want to gather but sort.
Geoff already answered your question, you have to use sortrows.

Sign in to comment.

Accepted Answer

Walter Roberson
Walter Roberson on 21 May 2012
Use the multi-output form of unique() to convert string variables to numeric indices.
When you have the numeric indices, use accumarray() to sum the data into a 3D table (date, country, I-value).
Either compute further things with that table or output it, skipping the 0 entries (the ones for which there was no input data)

  5 Comments

Show 2 older comments
Walter Roberson
Walter Roberson on 21 May 2012
Easier:
[uniqueNames, junk, nameID] = unique(names);
Walter Roberson
Walter Roberson on 22 May 2012
Note: this solution is for adding together all of the values associated with a particular triple of attributes. If you only have one value for any given combination, then this approach is not appropriate, but sortrows() would be appropriate.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!

Translated by