array: concatenate two columns of integers to one colum

a = randi([1 100],[5 4])  % a 5x4 integer matrix
b = cellfun(@num2str,{a(:,2:3)},'UniformOutput',false)
c = cellfun(@(x) strrep(x,' ',''), cellstr(b{1}),'UniformOutput',false)
a(:,2) = str2double(c)
a(:,3) = []

2 个评论
显示无隐藏无

Jan 2012-9-13

编辑：Jan 2012-9-13

在 MATLAB Online 中打开

Faster:

b = sprintf('%d%d*', a(:, 2:3).');
c = sscanf(b, '%d*');  [EDITED, thanks Honglei]

STRREP operates on cell string directly, so there is usually no need to create a time-consuming anonymous function inside CELLFUN.

Honglei Chen 2012-9-13

@Jan, thanks for the tip. That's a good one. I think you missed a b in your second expression.

请先登录，再进行评论。

Answer 2

Tom 2012-9-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/48089-array-concatenate-two-columns-of-integers-to-one-colum#answer_58720

编辑：Tom 2012-9-13

在 MATLAB Online 中打开

 A=[1 2 3;3 5 7];
B=[7 8 9;4 5 6];
%
C=[A B];
w=size(C,2);
D=10.^(w-1:-1:0);
Out=sum(bsxfun(@times,D,[A B]),2)

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

请先登录，再进行评论。

Answer 3

Jan 2012-9-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/48089-array-concatenate-two-columns-of-integers-to-one-colum#answer_58721

编辑：Jan 2012-9-13

在 MATLAB Online 中打开

A = [1234, 567;  1, 234];
B = A(:, 1) .* nextpow10(A(:, 2)) + A(:, 2);
function Y = nextpow10(X)
Y = 10 .^ floor(log10(abs(n)) + 1);  % [EDITED]

Please test this before using, I cannot run Matlab currently.

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

Andrei Bobrov 2012-9-13

编辑：Andrei Bobrov 2012-9-13

在 MATLAB Online 中打开

A=randi(67,6,4)
n = ceil(log10(A(:,2:end)));
out = sum(A(:,1:end-1).*(10.^fliplr(cumsum(fliplr(n),2))),2)+ A(:,end)

请先登录，再进行评论。

Answer 4

William Sampson 2012-9-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/48089-array-concatenate-two-columns-of-integers-to-one-colum#answer_58725

Yeah - so

1) I'm not getting it and

2) I seem to not have been clear enough (sorry...)

what I have is a data array with 59 columns and an indeterminate number of rows and I want to combine 2 (for example) columns as described above. In reality it is 5 columns, 8 - 12, of 16 digits each, but I'll start with getting 2 of them done.

So I have, e.g., rawData(:,9) and rawData(:,10) to combine

2 个评论
显示无隐藏无

Honglei Chen 2012-9-13

It's the same. I updated my answer to show an example of combining 2nd and 3rd column of a matrix

Jan 2012-9-13

编辑：Jan 2012-9-13

在 MATLAB Online 中打开

See my suggestion:

B = rawData(:, 9) .* nextpow10(rawData(:, 10)) + rawData(:, 10)
result = [rawData(:, 1:8), B, rawData(:, 11:end)]

I do not see, why the suggested method should not work.

Btw. What do you expect as result of two 16 digit numbers? You can store only 16 digits in variables of the type DOUBLE.

请先登录，再进行评论。

Answer 5

Ryan 2012-9-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/48089-array-concatenate-two-columns-of-integers-to-one-colum#answer_58726

编辑：Ryan 2012-9-13

在 MATLAB Online 中打开

A = [1234, 567;  1, 234]; %Sample Data
% Figure out how many spaces to shift the left column
C = ceil(log10(A(:,2)));
% Find areas where the value is a multiple of 10 or is 1
idx = A(:,2) == 1 | rem(A(:,2),10) == 0;
C(idx) = C(idx) + 1; % Handle the exception
% Determine how much to shift the left column
C = 10.^C;
% Add in the right column
A = A(:,1).*C + A(:,2);