Separate multi-word comma separated cell into rows

Question

Maddie Long 2022-3-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1672369-separate-multi-word-comma-separated-cell-into-rows

编辑： Peter Perkins 2022-3-17

I would like to seperate the name of a business and the number attached to the name into 2 columns and then at the comma start a new row in the table:

My input:

{'Business Name One[5],Business Name Two[3],Business Name Three[2]'}

{'Business Name One[5]'}

{'Business Name Two[3],Business Name Three[2]'}

and I need it to output:

'Business Name One' | 5

'Business Name Two' | 3

...

I have tried

unqValue=unique(a.data);

cell_dat_split = cellfun(@(x) sscanf(x, '%s %s %s, '), unqValue, 'Uniform', false);

But its just not doing quite what I want, any help would be great!

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

请先登录，再进行评论。

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

Answer 1

Stephen23 2022-3-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1672369-separate-multi-word-comma-separated-cell-into-rows#answer_918409

在 MATLAB Online 中打开

More efficient than using CELLFUN:

C = {'Business Name One[5],Business Name Two[3],Business Name Three[2]'; ...
    'Business Name One[5]'; ...
    'Business Name Two[3],Business Name Three[2]'};
D = regexp(sprintf('%s,',C{:}),'([^,]+)\[(\d+)\]','tokens');
D = vertcat(D{:})
D = 6×2 cell array
    {'Business Name One'  }    {'5'}
    {'Business Name Two'  }    {'3'}
    {'Business Name Three'}    {'2'}
    {'Business Name One'  }    {'5'}
    {'Business Name Two'  }    {'3'}
    {'Business Name Three'}    {'2'}

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Maddie Long 2022-3-15

Thank you so much!

请先登录，再进行评论。

Answer 2

Peter Perkins 2022-3-17

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1672369-separate-multi-word-comma-separated-cell-into-rows#answer_920524

编辑：Peter Perkins 2022-3-17

在 MATLAB Online 中打开

[Edited to be even modern by using split, not strsplit, join, not strjoin, and double, not str2double.]

Here's a more modern version, using string and patterns, which are really the best way to go these days. There's a bit of trickiness at the beginning, going from ragged cellstr to string, but after that it's smooth sailing.

C = {'Business Name One[5],Business Name Two[3],Business Name Three[2]';
     'Business Name One[5]';
     'Business Name Two[3],Business Name Three[2]'}
C = 3×1 cell array
    {'Business Name One[5],Business Name Two[3],Business Name Three[2]'}
    {'Business Name One[5]'                                            }
    {'Business Name Two[3],Business Name Three[2]'                     }

Turn that "ragged" cell array into one long string, then split at the commas.

S = join(string(C),',')
S = "Business Name One[5],Business Name Two[3],Business Name Three[2],Business Name One[5],Business Name Two[3],Business Name Three[2]"
S = split(S,","); S = S(:)
S = 6×1 string array
    "Business Name One[5]"
    "Business Name Two[3]"
    "Business Name Three[2]"
    "Business Name One[5]"
    "Business Name Two[3]"
    "Business Name Three[2]"

Now it's just a matter of pulling out the text and the numbers. Pattern is much easier to use than regexp.

pat = "[" + digitsPattern(1) + "]";
biz = extractBefore(S,pat)
biz = 6×1 string array
    "Business Name One"
    "Business Name Two"
    "Business Name Three"
    "Business Name One"
    "Business Name Two"
    "Business Name Three"
buz = extract(S,digitsPattern)
buz = 6×1 string array
    "5"
    "3"
    "2"
    "5"
    "3"
    "2"

Now convert them to more useful types and put them in a table.

biz = categorical(biz);
buz = double(buz);
t = table(biz,buz)
t = 6×2 table
            biz            buz
    ___________________    ___

    Business Name One       5 
    Business Name Two       3 
    Business Name Three     2 
    Business Name One       5 
    Business Name Two       3 
    Business Name Three     2 

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

请先登录，再进行评论。

Answer 3

Voss 2022-3-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1672369-separate-multi-word-comma-separated-cell-into-rows#answer_918354

在 MATLAB Online 中打开

C = { ...
    'Business Name One[5],Business Name Two[3],Business Name Three[2]'; ...
    'Business Name One[5]'; ...
    'Business Name Two[3],Business Name Three[2]'; ...
    }
C = 3×1 cell array
    {'Business Name One[5],Business Name Two[3],Business Name Three[2]'}
    {'Business Name One[5]'                                            }
    {'Business Name Two[3],Business Name Three[2]'                     }
C = cellfun(@(x)strsplit(x,','),C,'UniformOutput',false);
C = [C{:}].'
C = 6×1 cell array
    {'Business Name One[5]'  }
    {'Business Name Two[3]'  }
    {'Business Name Three[2]'}
    {'Business Name One[5]'  }
    {'Business Name Two[3]'  }
    {'Business Name Three[2]'}
C = regexp(C,'([^\[]+)\[(\d+)\]','tokens');
C = [C{:}]
C = 1×6 cell array
    {1×2 cell}    {1×2 cell}    {1×2 cell}    {1×2 cell}    {1×2 cell}    {1×2 cell}
C = vertcat(C{:})
C = 6×2 cell array
    {'Business Name One'  }    {'5'}
    {'Business Name Two'  }    {'3'}
    {'Business Name Three'}    {'2'}
    {'Business Name One'  }    {'5'}
    {'Business Name Two'  }    {'3'}
    {'Business Name Three'}    {'2'}