How to change character in multiple cells in to number 0 and 1?

5 views (last 30 days)
I've got an excel file which contains a column for sex,'F' and 'M'. 'F' means female and 'M' means male. I used xlsread() to load this data, and got multiple cells( size is 1*n,n for number of people), each cell contains a character 'F' or 'M'. I want to transfer the character to number 0 or 1, 0 means 'F' and 1 means 'M'. How can I do it?

Accepted Answer

Jos (10584)
Jos (10584) on 19 Apr 2019
Sex = {'F','M','F','F','M','M','F'}
[~, SexNum] = ismember(Sex, {'F','M'})
SexNum = SexNum - 1 % 1 = 'M', 0 = 'F', -1 = other
% alternatively
SexNum2 = cellfun(@(c) double(c=='M')), Sex) % 1 is 'M', 0 = 'F' or other)

More Answers (1)

Wenyi Xiao
Wenyi Xiao on 19 Apr 2019
S = findgroups(Sex);
I used this code, it works too!!!!!
Thank you!

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!