How to convert string to numeric variable in if statement

2 次查看(过去 30 天)
I want to covert my string variable into numeric variables.
I have got string Variable Team that shows which players are in. For example C2, C1, B2, B1 etc.
I want to give each player a numeric value which represents the team.
I tried the following
for i =1:length(Team)
if Team(i) strcmp 'C1'
Team(i) = 1
elseif Team(i) strcmp 'C2'
Team(i) = 2
end
end
but get the error:
??? Conversion to logical from cell is not possible.

采纳的回答

Jos (10584)
Jos (10584) 2014-3-5
AllTeams = {'A1','B1','C1','C2','C3'} % all the teams
Team = {'A1','B1','C1','A1','C3','A1','unknown','C1'} % Team{k} is the team of player k is
% map team names to numbers
[~,TeamNumber] = ismember(Team, AllTeams)
X = find(TeamNumber <= 2) % players in team 1 or 2

更多回答(2 个)

Chandrasekhar
Chandrasekhar 2014-3-5
for i =1:length(Team)
if Team(i)== str2num(C1)
Team(i) = 1
elseif Team(i)==str2num(C2)
Team(i) = 2
end
end
  5 个评论
Chandrasekhar
Chandrasekhar 2014-3-5
Ok..can you explain the logic clearly
what does the array team contain? and what exactly you want to find?
Ot
Ot 2014-3-5
编辑:Ot 2014-3-5
The array team is an (801X1) cell. The Team cell tells for each of the 801 players in the Database in which team they play. The string values B1, B2, C1 and C2 are the names of the different team.
I want to adress an numeric value to each Team instead of this string value, so that I afterwards can sort the players based on their teams and calulate Mean Sprint times and STD of each Team's sprint times.
I hope it is clear now.

请先登录,再进行评论。


Giorgos Papakonstantinou
编辑:Giorgos Papakonstantinou 2014-3-5
If this is exactly what you want to do then try this:
Team = {'C1' 'C2' 'C3' 'C4'}
for ii=1:length(Team)
switch Team{ii}
case 'C1'
Team{ii} = 1;
case 'C2'
Team{ii} = 2;
case 'C3'
Team{ii} = 3;
case 'C4'
Team{ii}=4
otherwise
fprintf('hallo')
end
end
But you change the variable Team... Maybe you assign the numbering to a new variable.
  3 个评论
Ot
Ot 2014-3-5
This works, but then my variable Team is still considered as an cell while I want to transfer it into an double.
maybe with str2num? but I don't know how?
Giorgos Papakonstantinou
cell2mat(Team)
But in this way you alter the variable Team. Why don't you try this:
[~,B] = ismember(Team, {'B1' 'B2' 'C1' 'C2'})
It will have the same effect. You will not alter the cell Team. Instead you create a new variable B which is the same with the one you asked for.

请先登录,再进行评论。

类别

Help CenterFile Exchange 中查找有关 Database Toolbox 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by