How to reduce time of calculation? (code includes 'for' loop with cell function)

Hallo ;), Thanks in advance

I have a data table 'P' (2772774x17) and generated another table 'aT' where the length is the unique elments from column 1 of 'P' and unique values from column 2 of 'P' as width(header). My purpose is to count the occurence of column 2 values of 'P' for each column 1 unqiue values of 'P' and save the occurences in 'aT'. This takes a very long time. Is there a possiblity to do it in a different way to save the time. Code given below:

for i=1:length(uniqueP)
count_string = cellfun(@(x) sum(ismember(P.Typ(ismember(P.ProjektID,...
    uniqueP(i)),:),x)),  aT.Properties.VariableNames(2:end));

% Replacing rows of a table
aT(i,2:end) = num2cell(count_string);
end

[Sergey Kasyanov]

What data types are stored in P.ProjektID and P.Typ columns?

[Kazi Alam]

Hi @Sergey Kasyanov

P.ProjektID >> double

P.Typ >> Cell

Answer 1

[Kazi Alam]

I changed the data search order. Earlier, the code was checking the uniqueness of the duble array then the string array. Now, the process is reveresed and it saved me hours.