How to compare two columns in a table and delete that row having same values in that columns?
1 回表示 (過去 30 日間)
古いコメントを表示
column1 column 2 columns3
ball bat gloves
bat gloves bat
ball gloves ball
Mow if I compare column1 and column3, I want to remove the rows having same values in that row of the columns
0 件のコメント
回答 (2 件)
dpb
2021 年 4 月 12 日
c=string({'column1' 'column 2' 'columns3'
'ball' 'bat' 'gloves'
'bat' 'gloves' 'bat'
'ball' 'gloves' 'ball'});
c=c(c(:,1)~=c(:,3),:);
returns
>> c
c =
2×3 string array
"column1" "column 2" "columns3"
"ball" "bat" "gloves"
>>
I kept the header row to have something else in the array as a result...
0 件のコメント
Sanwal Zeb
2021 年 4 月 18 日
1 件のコメント
dpb
2021 年 4 月 18 日
Well, we'll have to see what you really have to write actual syntax...we can't see your workspace from here...
参考
カテゴリ
Help Center および File Exchange で String Parsing についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!