title: How to filter multiple conditions in same column pyspark sql
body: <p>I have a column like below:</p>
  
  <pre><code>+-------+------------------+-------+
  |   name|             value|user_id|
  +-------+------------------+-------+
  
  | user 1|             view |      1|
  | user 1|         processed|      1|
  | user 2|             view |      3|
  | user 3|             view |      4|
  +-------+------------------+-------+
  </code></pre>
  
  <p>I want to get column like below. </p>
  
  <pre><code>+-------+------------------+-------+
  |   name|             value|user_id|
  +-------+------------------+-------+
  | user 2|             view |      3|
  | user 3|             view |      4|
  +-------+------------------+-------+
  </code></pre>
  
  <p>simply, eliminate ids which done both action. </p>
  
  <p>currently, I have two data frame like below</p>
  
  <pre><code>df1 = df.where(value=="processed").select("id").distinct()
  df2 = df.where(value=="view").select("id").distinct()
  </code></pre>
  
  <p>now, how to get only ids which only have view not processed.Or is there any better way to do it?</p>