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

1 view (last 30 days)
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

Accepted Answer

Kazi Alam
Kazi Alam on 7 May 2021
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.

More Answers (0)

Products

Community Treasure Hunt

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

Start Hunting!