Ajay-Pandey
Databricks MVP

‎03-13-2023 06:14 AM

Hi @Saswata Dutta​ ,

Please use blow code this will work-

df.filter((F.col("state").isNull())| (F.col("state")=="")| (F.col("state").contains(""))| (F.col("number").isNull())).show()

Ajay Kumar Pandey