Replacing unassigned values in a vector with nans instead of zeros
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Morning everyone,
I'm resizing vectors in a loop. Not good I know and probably why it takes 30 minutes to run, but beside from reading through all the files a first time to determine the correct length of the vectors and then reading through a second time to fill in the vectors I can't see a better way. As there is no easy method of determining the length I need.
However, currently if a file can't be read - some of the files are dodgy and I put a try-catch statement around them - then unassigned values in the vector automatically equal zero. Is there a way to change that behaviour so that an unassigned vector value is a nan?
For example
r(1) = 2;
r(3) = 4;
>> r
r =
1 0 2
is there a way to make r(2) a nan without explicitly assigning it?
2 comentarios
Chad Greene
el 20 de Sept. de 2016
Is preallocating r an option? I'm thinking something like this:
r = nan(1,3);
r(1) = 2;
r(3) = 4
Respuestas (2)
Steven Lord
el 20 de Sept. de 2016
Preallocate r to be a NaN vector with a number of elements equal to some upper bound on the number of elements that it could possibly contain (for instance, if you have 10 files and each could add 7 elements to the vector preallocate it to be nan(1, 70)) then fill it in and trim off the excess elements after the for loop is complete.
5 comentarios
Guillaume
el 21 de Sept. de 2016
The reading is efficient, but I don't see how that portion of code links to your question. Assuming you're concatenating the tables vertically and you want nans for the missing files, this is how I'd do it:
%...
ML = cell(numel(files));
for filenumber = 1:numel(files)
try
ML{filenumber} = readtable(...);
catch
...
end
end
failedread = cellfun(@isempty, ML);
maxheight = max(cellfun(@height, ML(~failedread)));
width = cellfun(@width, ML(~failedread));
assert(numel(width) > 0 && all(width == width(1)), 'table concatenation will fail')
ML{failedread} = array2table(nan(maxheight, width(1)));
allML = vertcat(ML{:});
Jonathan Avesar
el 17 de Sept. de 2019
I also have this question. I can't pre-allocate because I don't know how large the matrix will be in advance.
0 comentarios
Ver también
Categorías
Más información sobre Performance and Memory en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!