How to make this text string column program faster?
显示 更早的评论
Accessions here are text strings with a length between 3 and 8. Here is my current program to process them:
% Accession:
ACCN = [];
c = length(Sta{i}.depth); % 1-column data
if isfield(Sta{i}, 'accession')
[ACCN{1:c}] = deal(Sta{i}.accession);
else
[ACCN{1:c}] = deal('N/A');
end
ACCESSION = [ACCESSION; ACCN'];
I'd want to convert the above program to a more effective way like the below program for processing numerical values:
Latitude = NaN(1000000, 1);
lastIndex = 0;
c = length(Sta{i}.depth); % 1-column data
if isfield(Sta{i}, 'lat')
Latitude([lastIndex+1:lastIndex+n],1) = ones(c,1) * Sta{i}.lat;
end
Latitude = Latitude([1:lastIndex],1);
How would I do this?
Thanks.
3 个评论
dpb
2020-3-1
Give us some sample data to work on and illustrate clearly what your inputs/desired outputs are...don't make us guess and then try to make up test data. "Help us help you..."
Leon
2020-3-2
dpb
2020-3-2
So what are we to make of that? What's the intended output? Every struct has the field so why the test?
Are you just trying to return the values of the field with the indices of the locations that don't have value for the field? Or is the field actually missing in the real dataset? If that's the case, looks like you should fix that instead and initialize the struct with a missing value instead and avoid the whole issue.
采纳的回答
dpb
2020-3-2
Dunno how much better; still think to build the struct so all fields are extant would be far better; then you can use an array of struct as well instead of having to dereference the cell array. Remove as many levels of indirection as possible.
for i=1:numel(A)
d=numel(A{i}.depth);
try
ACCN=repmat({A{i}.accension},d,1);
catch
ACCN=repmat({'NA'},d,1);
end
end
If the size is large, the biggest overhead hit yet in both is the dynamic reallocation -- precompute the output size and store into the output array instead.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Translated by 
