Apply Cellfun to only first column but keep second

2019 1 11
2 个回答
回答已采纳
更新时间：2019 1 11
2 次查看（30 天）

0 个投票

Im starting with a two column cell array that Ive manipulated to clean up the data I have, pulled certain characters out of string text using regexp which created a 1 column array but I could concatenate its matching second column back. Now within this 2 column array the first column that I manipulated has some empty cells. I would liked to get rid of those empty cells in the first column and their correspnding row in the second column but keep both columns within an array.
Ex. I want to get ride of the first two rows since they are empty but keep the others along with their corresponding numbers in column 2.
[] 1
[] 1
'VWVPSSVMVV' 3
'RWAREVLQFA' 1
'ASLQQWVQVA' 4

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

 采纳的回答

madhan ravi
madhan ravi 2019-1-11
编辑：madhan ravi 2019-1-11

0 个投票

Anytime :) , if you got the answer to your orignal question about removing empty row make sure to accept the answer.
Note: You can adapt the any two methods below according to your version.
Requires 2015b or later:
mycell={'VWVPSSVMVV' 3
'VWVPSSVMVV' 3
'RWAREVLQFA' 1
'ASLQQWVQVA' 4};
T=cell2table(mycell);
C=unique(T);
T.Properties.VariableNames={'Names','IDs'};
G=findgroups(T);
C.IDs=splitapply(@sum,T.IDs,G);
NewTable=C(:,[1 end]);
NewTable.Properties.VariableNames={'uniqueNames','sumIDs'}
Requires 2018a or later:
mycell={'VWVPSSVMVV' 3
'VWVPSSVMVV' 3
'RWAREVLQFA' 1
'ASLQQWVQVA' 4};
T=cell2table(mycell);
T.Properties.VariableNames={'Names','IDs'};
G = groupsummary(T,'Names','sum');
NewTable=G(:,[1 end])

2 个评论
显示 无 隐藏 无

Jacob Larson
Jacob Larson 2019-1-11
Thank you that is perfect! much more efficient than the loop I was trying

请先登录，再进行评论。

更多回答（1 个）

madhan ravi
madhan ravi 2019-1-11

0 个投票

mycell={[] 1
[] 1
'VWVPSSVMVV' 3
'RWAREVLQFA' 1
'ASLQQWVQVA' 4};
EXPECTED=mycell(all(~cellfun('isempty',mycell),2),:)
Gives:
EXPECTED =
3×2 cell array
{'VWVPSSVMVV'} {[3]}
{'RWAREVLQFA'} {[1]}
{'ASLQQWVQVA'} {[4]}

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

Jacob Larson
Jacob Larson 2019-1-11
Awesome, very helpful! Also is there a way to sum the second column values based on the IDs in the first and get rid of the repeated IDs?
Meaning for the examples below the ID 'VWVPSSVMVV' would sum to 6 in the second column and the ID would only appear one time.
{'VWVPSSVMVV'} {[3]}
{'RWAREVLQFA'} {[1]}
{'VWVPSSVMVV'} {[3]}
{'ASLQQWVQVA'} {[4]}

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Characters and Strings 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by