How Normalize each column to itself mean value

Question

Rachele Franceschini 2022-4-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1695060-how-normalize-each-column-to-itself-mean-value

评论： Rachele Franceschini 2022-4-13

Cartel3.xlsx

I have one table with in y the regions, while in x several years (2010, 2011, 2012, 2013 etc). Each year has one value for each region. I would like to nomalize the data of each column. Here, there is file excel. it is possible to normalize using the mean of the year? I tried this, but I am not sure.

t=readtable('Cartel3.xlsx')
t_norm a= normalize((t{2:end, 2:end}),'norm')

This is my table

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

请先登录，再进行评论。

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

Answer 1

Enrico Gambini 2022-4-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1695060-how-normalize-each-column-to-itself-mean-value#answer_941840

在 MATLAB Online 中打开

Hi, you can try this:

T=readtable('Cartel3.xlsx');
n_years=10; %In your file you've got 10 years, you can obvioysly change it if needed
Tnorm=T; %Initialize the table with normalized values
for i=2:(n_years+1) %starts from the second row, because in the first a character is present
Tnorm{:,i}=T{:,i}/mean(T{:,i});
end
% Then, if you want to export the new table
writetable(Tnorm,'Tnorm.xlsx')