Patients code to text for table

3 次查看（过去 30 天）
Luis Eduardo Cofré Lizama
评论： Walter Roberson 2018-8-31
Hi All. Cannot get to read numbers from a matrix and make them into a text to be inserted in a table. The latter to be used in a ranova test. For example.
Injection = [1;1;2;2;3]
Table (1:5,x) = ['Upper_limb', 'Upper_limb','Lower_limb','Lower_limb','Back'];
cheers
Eduardo
  1 个评论
Walter Roberson
Walter Roberson 2018-8-20
Is Table intended to be a table() object? Is x intended to be a column number in the table object?
Are you trying to do something like
Injection = [1;1;2;2;3]
Table = table(Injection);
Table(1:5,2) = {'Upper_limb', 'Upper_limb','Lower_limb','Lower_limb','Back'} .';

请先登录，再进行评论。

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

采纳的回答

Stephen23
Stephen23 2018-8-31
编辑：Stephen23 2018-8-31
"Lets say that somewhere in a 630x38 matrix there is a "1". I need a table with the same dimensions but where (place) there is a "1" it will now say "Upper_limb" (text)..... same location as in the matrix."
Where X is your matrix:
C = {'Upper_limb', 'Lower_limb', 'Back'};
X = [1,2,1,3,1]
C(X)

更多回答（4 个）

Luis Eduardo Cofré Lizama
编辑：Walter Roberson 2018-8-21
Thanks Walter, actually more like (probably this is wrong):
for i = 1:5
if Injection (i) == 1
Table (i) == 'Upper_Limb'
elseif Injection (i) == 2
Table (i) == 'Lower_Limb'
end
  1 个评论
Walter Roberson
Walter Roberson 2018-8-21
Injection = [1;1;2;2;3]
limbs = {'Upper_limb', 'Upper_limb','Lower_limb','Lower_limb','Back'} .';
Table = limbs(Injection);
See also categorical()

请先登录，再进行评论。

Ben Morrow
Ben Morrow 2018-8-21

just re-format before calling it

    %lets say 
      Injection = [1;1;2;2;3]
        %Sort into names that you want
        Upper_limb1 = Injection(1);
        Upper_limb2 = Injection(2);
        Lower_limb1 = Injection(3);
        Lower_limb2 = Injection(4);
        Back = Injection(5);
      injTable = table(Upper_limb1, Upper_limb2,Lower_limb1,Lower_limb2,Back)
    %now just call your table as "injTable" when you need it
%--------------------------------------------------------------
    %now lets say its a row of data...
      Injection = [1,1;1,1;2,2;2,2;3,3]
      Injection = transpose(Injection);
        %Sort into names that you want
        Upper_limb1 = Injection(:,1);
        Upper_limb2 = Injection(:,2);
        Lower_limb1 = Injection(:,3);
        Lower_limb2 = Injection(:,4);
        Back = Injection(:,5);
Table = table(Upper_limb1, Upper_limb2,Lower_limb1,Lower_limb2,Back   

    %now just call "Table" for your column table
Luis Eduardo Cofré Lizama
编辑：Walter Roberson 2018-8-21
Thanks again, however, I think I am not asking in the right way. The output I need is a column in a table that reads. Also considering I have more than 200 1,2 and 3s to replace, I thought in using a loop.
Column title: Injection site
'Upper_limb';
'Upper_limb';
'Lower_limb';
'Lower_limb';
'Back';
I'll append next to it all the values for all the rest of the variables
  1 个评论
Walter Roberson
Walter Roberson 2018-8-21
Injection = [1;1;2;2;3]
limbs = {'Upper_limb', 'Upper_limb','Lower_limb','Lower_limb','Back'} .';
Injection_site = limbs(Injection);
Table = table(Injection_site);

请先登录，再进行评论。

Luis Eduardo Cofré Lizama
Maybe I am still not expressing well what I need. Lets say that somewhere in a 630x38 matrix there is a "1". I need a table with the same dimensions but where (place) there is a "1" it will now say "Upper_limb" (text)..... same location as in the matrix.
Cheeeeers

类别

在 Help Center 和 File Exchange 中查找有关 Text Files 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by