This is my data frame:
Cites_Dogs Dog_Number
DOG45555 DOG123
DOG127 DOG123
DOG7760 DOG126
DOG45 DOG126
DOG559 DOG126
DOG760 DOG126
DOG123 DOG127
DOG789 DOG127
DOG860 DOG127
I have converted to list by this code:
all_cites_dog = all_cites_dog.groupby('Dog_Number')['Cites_Dogs'].apply(list)
I would like to remove the item in the list which is not matched with the index DOG123, DOG126, DOG127.
DOG123 [ 'DOG45555' , 'DOG127']
DOG126 [ 'DOG7760', 'DOG456' , 'DOG559' , 'DOG760']
DOG127 [ 'DOG123' , 'DOG789' , 'DOG860']
I would like to see the results like this:
DOG123 [ 'DOG127']
DOG126 ['']
DOG127 [ 'DOG123']
What should I do TT?