How to compare two columns in a table and delete that row having same values in that columns?

1 次查看（过去 30 天）
Sanwal Zeb
Sanwal Zeb 2021-4-12
评论： dpb 2021-4-18
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

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

回答（2 个）

dpb
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...
Sanwal Zeb
Sanwal Zeb 2021-4-18
Hi, I want to do this in tables not in strings.

类别

在 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!

Translated by