find data with same name
3 views (last 30 days)
Show older comments
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 Comments
Ilya Dikariev
on 20 May 2022
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
Accepted Answer
KSSV
on 20 May 2022
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.
More Answers (0)
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!