matlab中将文字转为数字

matlab中将文字转为数字。优秀为90分,良好为80分,中等为70分,合格为60分

img

数据量少的话用Excel提前处理好就行;也可以导入为cell后做处理,不过索引调起来比较麻烦,例:

clc,clear,close all;
a = {'优秀','良好';'合格','优秀'}
count = 1;
for i =1:2
    for j =1:2
        if any(a{j,i} == '优秀')
            a(count) = {90};
        elseif any(a{j,i} == '良好')
            a(count) = {80};
        else
            a(count) = {60};
        end
        count = count + 1;
    end
end
a

a =
2×2 cell 数组
{'优秀'} {'良好'}
{'合格'} {'优秀'}
a =
2×2 cell 数组
{[90]} {[80]}
{[60]} {[90]}