How to compare two columns in a table and delete that row having same values in that columns?
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposte (2)
dpb
il 12 Apr 2021
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 Commenti
Sanwal Zeb
il 18 Apr 2021
1 Commento
dpb
il 18 Apr 2021
Well, we'll have to see what you really have to write actual syntax...we can't see your workspace from here...
Vedere anche
Categorie
Scopri di più su String Parsing in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!