How to convert string to numeric variable in if statement

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.

Answer 1

[Jos (10584)]

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

Answer 2

[Chandrasekhar]

for i =1:length(Team)

    if Team(i)== str2num(C1)

        Team(i) = 1

    elseif Team(i)==str2num(C2)

        Team(i) = 2

    end
end

[Ot]

If I do this I get the error:

??? Undefined function or variable 'C1'.

If I then put C1 between the '' marks I get again error

??? Undefined function or method 'eq' for input arguments of type 'cell'.

[Chandrasekhar]

the variables C1,C2 etc should contain some values for eg: C1 =1; C2 = 2; etc

what do C1, C2 represent in your script?

[Ot]

They represent the Teams in which players play.

The C1 en C2 are string values in the Variable: Team. Which shows for each player in which team they play.

[Chandrasekhar]

Ok..can you explain the logic clearly

what does the array team contain? and what exactly you want to find?

[Ot]

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.

Answer 3

[Giorgos Papakonstantinou]

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.

[Giorgos Papakonstantinou]

OR maybe:

I made a fake Team

A=randi(4, 1,801);

Team=cell(1,801);
for ii=1:length(A)
    if A(ii)==1
        Team{ii}='B1';
    elseif A(ii)==2
        Team{ii}='B2';
    elseif A(ii)==3
        Team{ii}='C1';
    else
        Team{ii}='C2';
    end
end

You do maybe this:

 [~,B] = ismember(Team, {'B1' 'B2' 'C1' 'C2'})

[Ot]

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.