I have a table with 50x10. In the table, first column is Genes and the second column will be reference column for normalization. Other 8 column will divide reference column. Afterward, this table will be normalized and each column will be averaged after normalization. Therefore there will be one row and 8 columns. How can I do this process in a table. Is it necessary to convert this table to a matrix or dataset, or can we solve it with a simle loop?
I m trying this code for table:
data = readtable("data.xlsx", "UseExcel", false);
for i = 2:10
res(:,i-1) = data(:,i)./data(:,1);
res_m = mean(res);
Bu code is not working as I want and I want to try this with table or dataset form