I have a question that need your helps to solve it. I have a data frame like this :
| index | Column A | Column B | column c | column D |
|---|---|---|---|---|
| 1 | a | Cell 1 | b | 5 |
| 2 | a | Cell 1 | b | 5 |
| 3 | b | Cell 1 | c | 4 |
| 4 | b | Cell 1 | t | 9 |
| 5 | b | Cell 1 | t | 8 |
| 6 | g | Cell 1 | k | 4 |
| 7 | g | Cell 1 | h | 3 |
| 8 | g | Cell 1 | h | 1 |
in that dataframe i need to remove indexes that have same value** only in column A and column C.** for example i need to drop index 2 , 5 , 8. please help me. thanks.
I tried to use
duplicated()
function but it couldn't answer properly my question.
