cell2mat has a very specific condition

2 views (last 30 days)
hey all! so i've been playing with cells and structures etc.
i have a structure 'students' with fields:name,id,grades.
in grades i have a nx1 cell array where n is the number of grades per students. the grades are in string and not numbers.
i wanted to calculate every student's avarage. i used a for loop and cell2mat and it gave me an nx2 matrix of char objects.
the problem is the last students, one of his grades is 100 which is 3 letters instead of 2 and because of that cell2mat has no idea how to compensate for it.
i know i could have made things easier for myself if i made a more normal structure in the first place but i'm too far in the excercise now lol.
any idea how to work with this?
  2 Comments
DGM
DGM on 20 Jun 2022
Show us what code you have and provide an example of your data so that we can see what's going on.
daniel slama
daniel slama on 20 Jun 2022
of course, my bad.
this is my attempt to calculate every student's avarage with notes of what i tried to to every line.
[a b]=size(students)
for i = [1:1:b]
charmat=cell2mat(students(i).grades) %creates the nx2 matrix and gets stuck with the last student
[c d]=size(charmat)
nummat=[]
for x = [1:1:c]
temp=str2num(charmat(x,:)
nummat=[nummat ; temp] %makes a number matrix out of the char matrix
end
students(i).avarage=mean(nummat)
end

Sign in to comment.

Accepted Answer

dpb
dpb on 20 Jun 2022
Indeed, you made dereferencing the data about as hard as could by putting it into cell array -- a struct could/can hold an ordinary array; it shouldn't be too hard to change the code to make the grades arrays numeric to start with...but one way to your objective here is\
>> arrayfun(@(i)mean(str2double(students(i).grades)),1:numel(students),'UniformOutput',true)
ans =
84.0000 98.5000 86.1667 57.3333 87.2500
>>
  2 Comments
daniel slama
daniel slama on 20 Jun 2022
this is incredible. i did mess up with the struct, guess i still need to work on that.
thank you so much!
dpb
dpb on 20 Jun 2022
Will become familiar idiom (along with the companion functions for cell arrays and sructure fields) with time...

Sign in to comment.

More Answers (0)

Categories

Find more on Startup and Shutdown in Help Center and File Exchange

Products


Release

R2020b

Community Treasure Hunt

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

Start Hunting!