Add column in specific number range to available table
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
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.
0 comentarios
Respuestas (2)
Fangjun Jiang
el 27 de Mzo. de 2024
Editada: Fangjun Jiang
el 27 de Mzo. de 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])
help randi
0 comentarios
VBBV
el 27 de Mzo. de 2024
A.B(:,1) = (400:2970).'; % use transpose
1 comentario
VBBV
el 27 de Mzo. de 2024
Editada: VBBV
el 27 de Mzo. de 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
Ver también
Categorías
Más información sobre Creating and Concatenating Matrices 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!