How Normalize each column to itself mean value
4 views (last 30 days)
Show older comments
Rachele Franceschini
on 12 Apr 2022
Commented: Rachele Franceschini
on 13 Apr 2022
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
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/963050/image.png)
0 Comments
Accepted Answer
Enrico Gambini
on 13 Apr 2022
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')
More Answers (0)
See Also
Categories
Find more on Tables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!