Add column in specific number range to available table

4 Ansichten (letzte 30 Tage)
Phuong
Phuong am 27 Mär. 2024
Bearbeitet: VBBV am 27 Mär. 2024
Hi. I have a 1650x3001 table named A. I want to add a column named B in number from 400 to 2970 that fit the row size, how can I do that?
I have try this but not work, say "Unable to perform assignment because the size of the left side is 1650-by-1 and the size of the right side is 1-by-2571"
A.B(:,1) = (400:2970);
Thanks for your help.

Antworten (2)

Fangjun Jiang
Fangjun Jiang am 27 Mär. 2024
Bearbeitet: Fangjun Jiang am 27 Mär. 2024
try this
A.B(:,1) = randi([400,2970],[1650 1])
understand this. Generate a 3x1 matrix with random interger value that is between 1 and 10
randi([1 10],[3,1])
ans = 3x1
1 6 2
help randi

VBBV
VBBV am 27 Mär. 2024
A.B(:,1) = (400:2970).'; % use transpose
  1 Kommentar
VBBV
VBBV am 27 Mär. 2024
Bearbeitet: VBBV am 27 Mär. 2024
@Phuong If i understand your question right, you want to add a column within the range of columns, then you need to use position index and join functions to add the column
pos = 410; % e.g
if pos >=400 & pos <=2970
pos = pos;
else
disp('')
end
B = table(rand(1650,1));
A = join(A,B,'Keys',[pos 1])% join at the specific position

Melden Sie sich an, um zu kommentieren.

Kategorien

Mehr zu Creating and Concatenating Matrices finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by