Need Help plotting things from a table

2020 10 21
1 个回答
回答已采纳
更新时间：2020 10 23
4 次查看（30 天）

0 个投票

I have attached the table i am working from. I want the user to input a country and then i want to plot the deaths for every year in that country.
I though strcmp might work but it isnt. this is all I have so far.
clear all
clc
data = readtable('RiskFactorAnalysis (1).csv');
userinput = input('Enter a Country: ','s');
Country = data(:,1);

请先登录，再回答此问题。

 采纳的回答

VBBV
VBBV 2020-10-22
编辑：VBBV 2020-10-22

1 个投票

Try this
clearvars
clc
data = readtable('RiskFactorAnalysis (1).csv');
userinput = input('Enter a Country: ','s');
Country = data(:,1);
CC = table2cell(Country)
CC1 = table2cell(data)
[R C] = size(data);
for i = 1:R
if strcmp((CC(i)),(userinput));
deaths(i) = cell2mat(CC1(i,4));
year(i) = cell2mat(CC1(i,3));
end
end
deaths(deaths == 0) = [];
year(year == 0) = [];
plot(year,deaths)
xlabel('year')
ylabel('deaths')

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Kelsey Pettrone
Kelsey Pettrone 2020-10-22
That worked! thank you so much!
I'm Trying to do a bar graph of all the types of deaths now but it isnt working. I thought it would work the same way but it isnt. the error code is saying
"Error using bar (line 171)
X must be same length as Y.
Error in try1 (line 40)
bar(year,bpcombined,'grouped');"
Here is my code. I would be so greatful if you could help me again.
for i = 1:R
if strcmp((CC(i)),(userinput));
obesity(i) = cell2mat(CC1(i,5));
Drug(i) = cell2mat(CC1(i,6));
Alcohol(i) = cell2mat(CC1(i,7));
smoking(i) = cell2mat(CC1(i,8));
end
end
figure
hold on
grid on
obesity(obesity == 0) =[];
Drug(Drug == 0) =[];
Alcohol(Alcohol == 0) =[];
smoking(smoking == 0) =[];
bpcombined = [obesity, Drug, Alcohol, smoking]
bar(year,bpcombined,'grouped');
xlabel('year')
ylabel('deaths')
VBBV
VBBV 2020-10-23
bpcombined = [obesity; Drug; Alcohol; smoking];
yearall = [year.' year.' year.' year.'];
bar(yearall,bpcombined.')
xlabel('year')
legend('Obesity','Drug','Alcohol','Smoking')
Rik
Rik 2020-10-23
I suspect the variable names are tripping the spam filter. I had to remove both of the prior comments from the spam filter.

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Structured Data and XML Documents 的更多信息

产品

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by