How to remove rows from csv based on matching data

How to remove rows from csv based on matching data

I have a large list of data in csv format which I need to remove rows
from, based on matching two parameters.
my list of data to be removed would appear as follows:
London,James Smith
London,John Oliver
London,John-Smith-Harrison
Paris,Hermione
Paris,Trevor Wilson
New York City,Charlie Chaplin
New York City,Ned Stark
New York City,Thoma' Becket
New York City,Ryan-Dover
Then the main csv would remove a row based on matching the city name with
the second column as well as matching the name with a name in the 9th
column.
If both matched were achieved, delete the row in the main csv (note this
csv hasn't been provided an example here).
Many thanks in advance, AEA