Append a column to a cell variable if two conditions verify

Question

Maria 2014-8-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/147442-append-a-column-to-a-cell-variable-if-two-conditions-verify

编辑： Andrei Bobrov 2014-8-13

I have a cell variable with 7000 rows and 14 columns. There are no repeated rows. Example with only 9 columns:

A={1994 1440  5510  '4911'  '025537101'  'AEP'  1440  0  'AEP'
1994  1587  5510  '4941'  '030411102'  'AWK'  1587  556  'AWK'
1994  1837  5510  '4924'  '001204106'  'AGLT'  1837  969  'AGLT'}

And a cell variable with 60000 rows (no duplicates) and 3 columns. Example:

    c1     c2    c3
 B={1994 'ABCR'  101101
'AEP'  30504
'ADD'  40402
'AGLT'  40404
'ASIN'  100101
'AWK'  80801}

If the first and the last columns of A match with the first and second columns of B (c1 and c2), I would like to add a new column to A with the values from the last column of B (c3).

My new A would be:

A={1994 1440  5510  '4911'  '025537101'  'AEP'  1440  0  'AEP'  30504
1994  1587  5510  '4941'  '030411102'  'AWK'  1587  556  'AWK'  80801
1994  1837  5510  '4924'  '001204106'  'AGLT'  1837  969  'AGLT' 40404}

Thanks

2 个评论
显示无隐藏无

Nathan 2014-8-13

This is problematic and requires more information about what you would like to accomplish. does A or B contain doublicates? Do you want two additional columns period, but only write data into them if there is a match? Please be very specific so we can help.

Maria 2014-8-13

Nathan ok. I will edit my answer and be more specific. Thank you.

请先登录，再进行评论。

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

Answer 1

Andrei Bobrov 2014-8-13

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/147442-append-a-column-to-a-cell-variable-if-two-conditions-verify#answer_148497

编辑：Andrei Bobrov 2014-8-13

在 MATLAB Online 中打开

EDIT

[l1,i1] = ismember(A(:,end),B(:,2));
l2 = ismember([A{:,1}]',[B{:,1}]');
l3 = l1&l2;
A(l3,end+1) = B(i1(l3),3);

2 个评论
显示无隐藏无

Maria 2014-8-13

Andrei it gives this error: Subscripted assignment dimension mismatch. But I will edit my question now and make it more undertandable. Thank you

Andrei Bobrov 2014-8-13

编辑：Andrei Bobrov 2014-8-13

corrected

请先登录，再进行评论。

Append a column to a cell variable if two conditions verify

2 个评论
显示无隐藏无

采纳的回答

2 个评论
显示无隐藏无

更多回答（0 个）

另请参阅

类别

标签

产品

Community Treasure Hunt

Append a column to a cell variable if two conditions verify

2 个评论 显示 无隐藏 无

采纳的回答

2 个评论 显示 无隐藏 无

更多回答（0 个）

另请参阅

类别

标签

产品

Community Treasure Hunt

2 个评论
显示无隐藏无

2 个评论
显示无隐藏无