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

53 ビュー (過去 30 日間)
Hannah
Hannah 2021 年 9 月 9 日
コメント済み: Hassan Bahy 2021 年 11 月 20 日
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.

採用された回答

Walter Roberson
Walter Roberson 2021 年 9 月 9 日
[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 件のコメント
Walter Roberson
Walter Roberson 2021 年 9 月 9 日
I recommend you use cell arrays, and use writecell(), provided that your MATLAB is new enough to have writecell()
data = randi(9, 6, 1)
data = 6×1
4 3 8 8 1 7
datacell = num2cell(data);
datacell{end-1,1} = "average";
datacell{end,1} = mean(cell2mat(datacell(1:end-2,:)))
datacell = 6×1 cell array
{[ 4]} {[ 3]} {[ 8]} {[ 8]} {["average"]} {[ 5.7500]}
Walter Roberson
Walter Roberson 2021 年 9 月 9 日
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.)

サインインしてコメントする。

その他の回答 (1 件)

Steven Lord
Steven Lord 2021 年 9 月 9 日
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"
  2 件のコメント
Walter Roberson
Walter Roberson 2021 年 9 月 9 日
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
Hassan Bahy
Hassan Bahy 2021 年 11 月 20 日
mr Walter Roberson could you help me to create a table consist of multi rows with two column the first column from data type string & second column is numbers, could you help me sir,please

サインインしてコメントする。

カテゴリ

Help Center および File ExchangeCharacters and Strings についてさらに検索

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by