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

1 view (last 30 days)
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.

Answers (1)

Walter Roberson
Walter Roberson on 5 Apr 2022
Edited: Walter Roberson on 5 Apr 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 Comment
Ganesh Naik
Ganesh Naik on 5 Apr 2022
Edited: Ganesh Naik on 5 Apr 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

Sign in to comment.

Categories

Find more on Tables in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by