How do I Convert Cells containing Binary Values into Cells of Decimal Values and Decimal Values into Strings?

Question

William Collants 2020-6-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/540591-how-do-i-convert-cells-containing-binary-values-into-cells-of-decimal-values-and-decimal-values-into

评论： William Collants 2020-6-4

Hi Guys,

Let's say I've a Matrix A with 5 Rows and 1000 Columns, consisting mostly of 0s and 1s. Maybe every ~50th or ~100th Column or so contains a Number

other than 0 or 1. Their distribution seems to be totally random. They're infrequent, but they're there.

Here's the thing:

I'd like to convert those Columns of 0s and 1s from their 5 digit binary values into a decimal value. So,

A = mat2cell(A,size(A,1),ones(1,size(A,2))); %Convert A to Cell Array with each Column its own Cell
B = cellfun(bi2de(A')) %Convert the Content of each Cell from Binary to Decimal

would, I guess, do the trick, if it weren't for the monkey wrench thrown in there of those occasional Non-Binary Values.

Is there a function to tell Matlab to, if a cell contains only 0s and 1s, convert its content into Decimal,

but if it contains other integers, simply output "Unknown", yielding a Cell array with the same number of cells as the Input Array.

Kind regards,

Tim

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Image Analyst 2020-6-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/540591-how-do-i-convert-cells-containing-binary-values-into-cells-of-decimal-values-and-decimal-values-into#answer_445127

在 MATLAB Online 中打开

Try this:

% Create sample data.
A = zeros(5, 1000);
A(randperm(numel(A), 200)) = nan;
A(randperm(numel(A), 800)) = 1;
[rows, columns] = size(A);
% Find out which columns have nan's so we can skip them.
columnsWithNan = any(isnan(A), 1);
numbers = zeros(1, columns); % Preallocate output
% Now process getting decimal number for each column
for col = 1 : columns
	if columnsWithNan(col)
		continue;
	end
	thisCol = sprintf('%d%d%d%d%d', A(:,col));
	numbers(col) = bin2dec(thisCol);
end

3 个评论
显示 1更早的评论隐藏 1更早的评论

Image Analyst 2020-6-4

编辑：Image Analyst 2020-6-4

在 MATLAB Online 中打开

If that's what you wanted, you would just simply instantiate numbers to nan's rather than the less direct way (more kludgy) of instantiating them to 9999 and then checking if all elements encountered prior to the current element are still 9999 and setting them to nan. And of course removing comments is almost never a good idea because they explain the code so that later when you look at it you'll understand what you did.

% Find out which columns have nan's so we can skip them.
columnsWithNan = any(isnan(A), 1);
numbers = nan(1, columns); % Preallocate output
% Now process getting decimal number for each column
for col = 1 : columns
	if columnsWithNan(col)
		continue; % Skip this element if it's a nan.
	end
	thisCol = sprintf('%d%d%d%d%d', A(:,col)); % Get binary string.
	numbers(col) = bin2dec(thisCol); % Convert string to a number.
end

William Collants 2020-6-4

oh totally that kinda thing keeps cropping up in my code all over the place, doing in 2, 3, 5, 89 steps what can be done in 1. Hopefully that'll all get weeded out as I become more adept at Matlab over the coming years.

Thank you for the correction. Good protection against the formations of bad habits ☝️

Kind Regards,

T

请先登录，再进行评论。