converting a string of variables to numbers
1 次查看(过去 30 天)
显示 更早的评论
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 个评论
Oleg Komarov
2012-5-21
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.
采纳的回答
Walter Roberson
2012-5-21
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 个评论
Walter Roberson
2012-5-22
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.
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Numeric Types 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!