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?

[John fredson]

am using readtable function

[Ilya Dikariev]

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

Answer 1

[KSSV]

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.

[John fredson]

how to make the population not in 10^6 form?

[KSSV]

REad about format