Assign same number of elements to the column data based on number of elements (each row) of the other column

1 visualización (últimos 30 días)
Hi all, I have two column data (Please refer to the attached) where first column contains "Number of Elements" and the second column contains "Stages" data. I want to assign the same number of data elements of "Stages" data to the new column ("Required") column based on the "Number of Elements" (first column) data. Any help in this regard is highly appreciated. I have included sample data as well.
Note: Desired data does not exist and I want it to be created as third column. I need the third column result based on first two column data.

Respuestas (1)

Walter Roberson
Walter Roberson el 5 de Abr. de 2022
Editada: Walter Roberson el 5 de Abr. de 2022
This code creates the desired data.
I notice that the desired data already appears to exist inside the file -- though it might perhaps need to be converted from character. Is the actual requirement to convert the existing file, or is it to generate new output without reference to that existing column?
filename = 'https://www.mathworks.com/matlabcentral/answers/uploaded_files/952839/Sample_Data.xlsx';
T = readtable(filename, 'VariableNamingRule', 'preserve');
R = rowfun(@(NE, S) {repmat(S, 1, NE)}, T, 'InputVariables', 1:2, 'SeparateInputs', true, 'OutputFormat', 'table', 'OutputVariableName', 'Required')
R = 20×1 table
Required _______________________ {[ 0 0]} {[ 0]} {[ 0]} {[ 1 1]} {[ 1]} {[ 2]} {[ 2 2 2 2 2]} {[2 2 2 2 2 2 2 2 2 2]} {[2 2 2 2 2 2 2 2 2 2]} {[ 3 3]} {[ 0 0 0 0 0 0]} {[ 3 3]} {[ 3]} {[ 1 1 1 1 1 1 1 1 1]} {[1 1 1 1 1 1 1 1 1 1]} {[ 1 1 1]}
  1 comentario
Ganesh Naik
Ganesh Naik el 5 de Abr. de 2022
Editada: Ganesh Naik el 5 de Abr. de 2022
Hi Walter, thanks. Desired data does not exist and I want it to be created as third column. I should have made it clear earlier, sorry about it. I need the third column result based on first two column data. I have edited the same info in the orignal question. Thanks

Iniciar sesión para comentar.

Categorías

Más información sobre Tables en Help Center y File Exchange.

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by