https://community.databricks.com/t5/machine-learning/muliple-where-condition-vs-and-in-pyspark/m-p/25420#M1409 <P>You can use explain to see what type of physical and logical plans are getting created . This is the best way to see difference , but as mentioned in the question , it should give the same physical plan </P><P></P><P></P> Wed, 09 Jun 2021 10:04:39 GMT User16826994223 2021-06-09T10:04:39Z https://community.databricks.com/t5/machine-learning/muliple-where-condition-vs-and-in-pyspark/m-p/25419#M1408 <P>.where((col('state')==state) &amp; (col('month')&gt;startmonth)</P><P>I can do the where conditions both ways. I think the one below add readability. Is there any other difference and which is the best?</P><P>.where(col('state')==state)</P><P>.where(col('month')&gt;startmonth)</P><P></P> Wed, 09 Jun 2021 10:03:28 GMT https://community.databricks.com/t5/machine-learning/muliple-where-condition-vs-and-in-pyspark/m-p/25419#M1408 User16826994223 2021-06-09T10:03:28Z https://community.databricks.com/t5/machine-learning/muliple-where-condition-vs-and-in-pyspark/m-p/25420#M1409 <P>You can use explain to see what type of physical and logical plans are getting created . This is the best way to see difference , but as mentioned in the question , it should give the same physical plan </P><P></P><P></P> Wed, 09 Jun 2021 10:04:39 GMT https://community.databricks.com/t5/machine-learning/muliple-where-condition-vs-and-in-pyspark/m-p/25420#M1409 User16826994223 2021-06-09T10:04:39Z