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

2 次查看（过去 30 天）
Kazi Alam
Kazi Alam 2021-5-6
回答： Kazi Alam 2021-5-7
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

请先登录，再回答此问题。

采纳的回答

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

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Cell Arrays 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by