MATLAB Answers

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

1 ビュー (過去 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
  2 件のコメント
Kazi Alam
Kazi Alam 2021 年 5 月 6 日
P.ProjektID >> double
P.Typ >> Cell

サインインしてコメントする。

採用された回答

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 件)

Community Treasure Hunt

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

Start Hunting!

Translated by