Info

This question is closed. Reopen it to edit or answer.

How can I remove particular row as defined

1 view (last 30 days)
Kanakaiah Jakkula
Kanakaiah Jakkula on 26 Dec 2015
Closed: Azzi Abdelmalek on 26 Dec 2015
I have the folloing table:
Tool1 Mek Ar 10.0 40.5
Tool1 Lahi BM2 13.0 89.4
Tool1 Ar Ar 34.0 67.8
Tool1 Puni Raj 41.0 89.9
Tool1 Jak Ar 20.0 78.3
Tool1 Lahi Lahi 12.0 99.0
Tool1 N2 BM2 14.0 89.0
Tool1 Ar Mek 25.0 95.7
Tool1 Puni Puni 17.0 90.6
Tool1 Raj Jak 20.0 100.0
uncommon list:
Ar
BM2
N2
I want to remove a particular row:
1. If the name in second column & third column (of any row) is equal (I mean same)
2. If the name in third column (of any row) belongs to uncommon list
As in rows 1,2,3,5,&7 of third column belongs to uncommon list (so the rows 1,2,3,5,7 should be removed), and in rows 6 & 9 the names in columns 2 & 3 are equal (same), agani these rows 6&9 should be removed. Therefore, finally I should get the below answer,
Tool1 Puni Raj 41.0 89.9
Tool1 Ar Mek 25.0 95.7
Tool1 Raj Jak 20.0 100.0
Many thanks in advance.

Answers (0)

Community Treasure Hunt

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

Start Hunting!