how to use if else statement

Question

Cside 2023-8-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2003802-how-to-use-if-else-statement

评论： Cside 2023-8-3

dummy.mat

Hello,

I have a list of participants (A, B, C, D...) and would like to extract their data from the dataset X. This dataset has numerous missing data. As there are multiple rows for the same participant, I would like to

to filter all the rows containing specified participant
have an if else statement - if column 4 contains a 'Yes', to insert column 5 'Male' into an array Y. else if column 4 is 'No', to insert column 7 'Female' into the same array Y
ideally, the output should look like a 4x2 array with each unique participant matched to their gender

A Male

B Male

C Female

D Female

I have attached the sample data here.

Thank you very much for your help.

2 个评论
显示无隐藏无

Dyuman Joshi 2023-8-2

"how to use if else statement"

I strongly recommend you take the free MATLAB Onramp tutorial to learn the essentials of MATLAB.

Cside 2023-8-3

thank you!

请先登录，再进行评论。

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

Answer 1

Clay Swackhamer 2023-8-2

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2003802-how-to-use-if-else-statement#answer_1282472

在 MATLAB Online 中打开

Hope this helps. It uses an example built in dataset (carbig) to demonstrate some basics of working with data in tables. As with many things there is more than one way to solve this problem. Task 3 (reshaping the output) depends on your specific dataset but I think if you accomplish tasks 1 and 2 you will be able to solve it.

%% Load data
load carbig
% Put the data into a table
% First convert some variables to categorical
org = categorical(cellstr(org));
cyl4 = categorical(cellstr(cyl4));
cars = table(org,Model_Year,when,cyl4,Acceleration,Horsepower,Weight);
%% 1. Filter all rows containing specified participant
% Get all cars from Japan
japaneseCars = cars(cars.org == 'Japan',:)
%% 2. If/else statement
% If the car is a 4 stroke (YES) insert horsepower into an array called "output"
% If the car is is not a 4 stroke (NO) insert weight into the same array
% Go through the table one row at a time
for i = 1:height(japaneseCars)
    if japaneseCars.cyl4(i) == 'Four' % YES case
        output(i) = japaneseCars.Horsepower(i);
    else % NO case
        output(i) = japaneseCars.Weight(i);
    end
end