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

Question

Ganesh Naik 2022-4-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1688684-assign-same-number-of-elements-to-the-column-data-based-on-number-of-elements-each-row-of-the-othe

编辑： Ganesh Naik 2022-4-5

Sample_Data.xlsx

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.

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

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2022-4-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1688684-assign-same-number-of-elements-to-the-column-data-based-on-number-of-elements-each-row-of-the-othe#answer_934769

编辑：Walter Roberson 2022-4-5

在 MATLAB Online 中打开

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

Ganesh Naik 2022-4-5

编辑：Ganesh Naik 2022-4-5

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

请先登录，再进行评论。