find data with same name
显示 更早的评论
For this two data file, I need to plot population of each country in population file with correspond death in owid data file , but they are difference in size, how can I do it?
2 个评论
John fredson
2022-5-20
Ilya Dikariev
2022-5-20
You don't need Matlab to do it, it is much easier with excel itself. However, if you want to do it in matlab so strongly then small hint: you can use unique and sum, and extract that column. Or first create new table with filter+pivot table in excel so you can get the total number of death per country and use it in Matlab plot
采纳的回答
KSSV
2022-5-20
You can get the deaths of each country using:
T1 = readtable('https://in.mathworks.com/matlabcentral/answers/uploaded_files/1005245/owid-covid-data_2020-21.csv') ;
T2 = readtable('https://in.mathworks.com/matlabcentral/answers/uploaded_files/1005250/Population_data.xlsx') ;
[m,n] = size(T2) ;
C = T2.Location ; % countries
P = T2.Population_million_ ; % population
D = zeros(m,1) ; % deaths in each country
for i = 1:m
idx = strcmp(T1.Location,T2.Location{i}) ;
D(i) = sum(T1{idx,7}) ;
end
Now you can plot what you want.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
