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

5 vues (au cours des 30 derniers jours)
Wenyi Xiao
Wenyi Xiao le 19 Avr 2019
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?

Réponse acceptée

Jos (10584)
Jos (10584) le 19 Avr 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)

Plus de réponses (1)

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

Catégories

En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by