Make a chart from two tables

1 次查看（过去 30 天）
Jose Mendoza Garcia
编辑： Yash 2023-8-29
I have two arrays that look like this. The other one has every gene name with an additional T. What i want to do is create a new array where row 1 and 2 are gene 1 from the first and second table. Then what i want to do is make a t test. Again id like to do this for all genes. Please help!!!

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

回答（1 个）

Yash
Yash 2023-8-29
编辑：Yash 2023-8-29
Ran in:
Hi Jose,
I think that you want the gene names with and without the additional T in consecutive rows.
For this you can follow these steps:
  1. Sort both the tables (As there is only an additional T, corresponding genes will be in the same row.).
  2. Now pick one row from each of the tables alternatively and create the third table.
Please see the code below:
% tumorexpression is T1 in your case
T1= table({'TSPAN6';'TNMD';'DPM1';'SCYL3';'C1orf112'},...
[2.5842; 0 ; 2.9005; 2.1092; 1.6231],...
'VariableNames',{'GENE_ID','Data'});
% Table with an additional T (It wont affect if T is at the end)
T2= table({'TDPM1';'TTNMD';'TC1orf112';'TSCYL3';'TTSPAN6'},...
[2.69; 0 ; 3.97; 2.5443; 1.6231],...
'VariableNames',{'GENE_ID','Data'});
T3 = table();
T1_sorted = sortrows(T1, 'GENE_ID');
T2_sorted = sortrows(T2, 'GENE_ID');
for i=1:size(T1)
T3 = [T3;T1_sorted(i,:)];
T3 = [T3;T2_sorted(i,:)];
end
T3
T3 = 10×2 table
GENE_ID Data _____________ ______ {'C1orf112' } 1.6231 {'TC1orf112'} 3.97 {'DPM1' } 2.9005 {'TDPM1' } 2.69 {'SCYL3' } 2.1092 {'TSCYL3' } 2.5443 {'TNMD' } 0 {'TTNMD' } 0 {'TSPAN6' } 2.5842 {'TTSPAN6' } 1.6231

类别

在 Help Center 和 File Exchange 中查找有关 Image Processing Toolbox 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by