converting a string of variables to numbers

3 views (last 30 days)
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
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
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)

Categories

Find more on Characters and Strings in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!