How Normalize each column to itself mean value

1 view (last 30 days)
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_norm a= normalize((t{2:end, 2:end}),'norm')
This is my table

Accepted Answer

Enrico Gambini
Enrico Gambini on 13 Apr 2022
Hi, you can try this:
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
% Then, if you want to export the new table

More Answers (0)




Community Treasure Hunt

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

Start Hunting!