How to change character in multiple cells in to number 0 and 1?
6 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Wenyi Xiao
el 19 de Abr. de 2019
Respondida: Wenyi Xiao
el 19 de Abr. de 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?
Respuesta aceptada
Jos (10584)
el 19 de Abr. de 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)
Más respuestas (1)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!