pyspark: counter part of like() method in dataframe

It worked :)

I had to use the negation operator (~) instead of the 'not' keyword.

df.where(~ col("_c2").like("XY6%")).show(5)

Or you can do :

df.where( col("_c2").like("XY6%") == False ).show(5)