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

조회 수: 6 (최근 30일)
Wenyi Xiao
Wenyi Xiao 2019년 4월 19일
답변: Wenyi Xiao 2019년 4월 19일
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?

채택된 답변

Jos (10584)
Jos (10584) 2019년 4월 19일
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)

추가 답변 (1개)

Wenyi Xiao
Wenyi Xiao 2019년 4월 19일
S = findgroups(Sex);
I used this code, it works too!!!!!
Thank you!

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by