How Normalize each column to itself mean value
조회 수: 3 (최근 30일)
이전 댓글 표시
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
채택된 답변
Enrico Gambini
2022년 4월 13일
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')
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Tables에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!