Combine Text and number in a matrixs

Question

aymeric neige 2020-11-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/632914-combine-text-and-number-in-a-matrixs

回答： Ameer Hamza 2020-11-1

Hi, I have a simple question about a script that i wrote.

My problem is this:

I have 4 matrice : A B C D and each of them has (10x1 cells).

I want to combine text and number in a matrixe like:

'A' 'B' 'C' 'D'

2 3 4 5

4 5 6 7

... ... ... ...

so i wrote this one :

Total = [{'LLO'},LLO;{'LLF'},LLF;{'RLO'},RLO;{'RLF'},RLF]';

but when i run it i have :

'A' 'B' 'C' 'D'

(2,4,...) (3,5,...) (4,6,...) (5,7,...)

As i want to export my matrix to excel, i can't.

Any Ideas ?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Ameer Hamza 2020-11-1

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/632914-combine-text-and-number-in-a-matrixs#answer_530619

在 MATLAB Online 中打开

Try something like this

LLO = randi([1 10], 1, 10);
LLF = randi([1 10], 1, 10);
RLO = randi([1 10], 1, 10);
RLF = randi([1 10], 1, 10);
result = [{'LLO', 'LLF', 'RLO', 'RLF'}; num2cell([LLO(:), LLF(:), RLO(:), RLF(:)])]

Result

>> result
result =
  11×4 cell array
    {'LLO'}    {'LLF'}    {'RLO'}    {'RLF'}
    {[  1]}    {[  1]}    {[  4]}    {[ 10]}
    {[  9]}    {[  4]}    {[ 10]}    {[ 10]}
    {[  9]}    {[  7]}    {[  3]}    {[  6]}
    {[  6]}    {[  9]}    {[  6]}    {[  2]}
    {[  8]}    {[  7]}    {[  8]}    {[  4]}
    {[  6]}    {[  7]}    {[  3]}    {[  3]}
    {[  6]}    {[  7]}    {[  9]}    {[  3]}
    {[  2]}    {[  8]}    {[  6]}    {[  3]}
    {[  6]}    {[  7]}    {[ 10]}    {[  1]}
    {[  1]}    {[  6]}    {[  4]}    {[  9]}

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

madhan ravi 2020-11-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/632914-combine-text-and-number-in-a-matrixs#answer_530559

在 MATLAB Online 中打开

  Wanted = {'A'              'B'             'C'            'D'
          2                3              4               5
           4               5              6               7} % as cell array
Wanted = 3x4 cell array
    {'A'}    {'B'}    {'C'}    {'D'}
    {[2]}    {[3]}    {[4]}    {[5]}
    {[4]}    {[5]}    {[6]}    {[7]}