what changes can be done in the code

Question

Manav Divekar 2021-12-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1605380-what-changes-can-be-done-in-the-code

评论： Olivia Alia 2022-4-15

i have to return values of diff between drug and placebo for given exel either for systolic or diastolic

http://sacan.biomed.drexel.edu/ftp/bmeprog/clinicaltrialbp.xlsx

function [diffdrug,diffplacebo] = xls_clinicaltrialbp(filename, bptype)
%by Manav Divekar, 2021-12-07
if ~exist('bptype','var')
	bptype = 'Systolic';
end
treatment = readtable(filename,'sheet','Sheet1');
drugs = 0;
beforedia = 0;
beforesys = 0;
afteredia = 0;
aftersys = 0;
d = strcmpi(treatment.Properties.VariableNames,'Treatment');
drugs = treatment{:,d};
bd = strcmpi(treatment.Properties.VariableNames,'DiastolicBefore');
ad = strcmpi(treatment.Properties.VariableNames,'DiastolicAfter');
bs = strcmpi(treatment.Properties.VariableNames,'SystolicBefore');
as = strcmpi(treatment.Properties.VariableNames,'SystolicAfter'); 
beforedia = treatment{:,bd};
beforesys = treatment{:,bs};
afteredia = treatment{:,ad};
aftersys = treatment{:,as};
beforediap = beforedia(strcmpi(drugs,'Placebo'));
beforesysp = beforesys(strcmpi(drugs,'Placebo'));
afterediap = afteredia(strcmpi(drugs,'Placebo'));
aftersysp = aftersys(strcmpi(drugs,'Placebo'));
beforediad = beforedia(strcmpi(drugs,'drugs'));
beforesysd = beforesys(strcmpi(drugs,'drugs'));
afterediad = afteredia(strcmpi(drugs,'drugs'));
aftersysd = aftersys(strcmpi(drugs,'drugs'));
if (bptype == 'systolic')
	diffdrug = beforesysd - aftersysd; 
	diffplacebo = beforesysp - aftersysp;
end
if (bptype == 'diastolic')
	diffdrug = beforediad - afterdiad; 
	diffplacebo = beforediap - afterdiap;
end

Input :

[diffdrug,diffplacebo] = xls_clinicaltrialbp('clinicaltrialbp.xlsx')

or

[diffdrug,diffplacebo] = xls_clinicaltrialbp('clinicaltrialbp.xlsx','DIAStolic')

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Image Analyst 2021-12-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1605380-what-changes-can-be-done-in-the-code#answer_853075

在 MATLAB Online 中打开

You need to use contains:

if contains(bptype, 'sys', 'IgnoreCase', true)
    diffdrug = beforesysd - aftersysd; 
    diffplacebo = beforesysp - aftersysp;
end
if contains(bptype, 'dia', 'IgnoreCase', true)
    diffdrug = beforediad - afterdiad; 
    diffplacebo = beforediap - afterdiap;
end