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 Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by