5. Count rows in each column where Nulls are present | PySpark | SQL | Data Engineering Interview

If you like this video please do like,share and subscribe my channel.

1 Subscriber, 1👍🏻, 1Comment = 100 Motivation 🙏🏼
🙏🏻Please Subscribe 🙏🏼

#pyspark #databricks #sql #interview #cognitivecoders

[prajju]

null_df=null_df.agg(sum(when(col('id')=='Null', 1).otherwise(0)).alias('id'), sum(when(col('name')=='Null', 1).otherwise(0)).alias('name'), sum(when(col('age')=='Null', 1).otherwise(0)).alias('age'))
null_df.display()