MATLAB Answers

How to assign strings and numbers to elements of the same matrix?

2 views (last 30 days)
I want to write the word "average" in the 5 element, first row on my matrix and I want to write numbers 1 to 3 into the second to fourth elements. But I am using wrong syntax:
ResultMtx(2:5,1) = [1; 2; 3; "average"];
How can I write this correctly? Thank you.

Accepted Answer

Walter Roberson
Walter Roberson on 9 Sep 2021
[1; 2; 3; "average"]
The first part of that, the 1; 2; 3, is establishing a numeric array -- in particular a double precision array.
The last part of that, the "average", is a string() scalar.
MATLAB cannot store string() scalars inside a numeric array. MATLAB numeric arrays do not store the datatype of each element separately: numeric arrays only store a single datatype that applies to the entire array.
You can create a cell array,
ResultMatx = num2cell(ResultMatx);
ResultMatx(2:5,1) = {1; 2; 3; "average"};
cell arrays can have a different datatype for each element. But you might not like the formatting for displaying them.
  3 Comments
Walter Roberson
Walter Roberson on 9 Sep 2021
You could also use a numeric array and put NaN values, and then later ask to writecell into that particular location in the existing table. This is not efficient, as it requires a separate writecell() for each text written into an otherwise numeric column (though adjacent items could be merged into one call.)

Sign in to comment.

More Answers (1)

Steven Lord
Steven Lord on 9 Sep 2021
Do you need your data stored with mixed-type columns or would mixed-type rows work? If the latter, consider a table array.
ResultTbl = table(1, 2, 3, "average")
ResultTbl = 1×4 table
Var1 Var2 Var3 Var4 ____ ____ ____ _________ 1 2 3 "average"
scores = ResultTbl{1, 1:3}
scores = 1×3
1 2 3
assessment = ResultTbl.Var4
assessment = "average"
  1 Comment
Walter Roberson
Walter Roberson on 9 Sep 2021
If I understand correctly, user is looking to store the results into Excel, not unlike the way it is common for people to have spreadsheets that say things like
Jan 5
Feb 2
Mar -4
Apr 7
total ====
10

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!