https://community.databricks.com/t5/data-engineering/unable-to-replace-null-with-0-in-dataframe-using-pyspark/m-p/29591#M21314 <P>I bet that it is not real null but the string "null". Please check what is in the source and try luck with replacing it.</P> Mon, 03 Oct 2022 19:44:45 GMT Hubert-Dudek 2022-10-03T19:44:45Z https://community.databricks.com/t5/data-engineering/unable-to-replace-null-with-0-in-dataframe-using-pyspark/m-p/29590#M21313 <P>Hello Experts,</P><P></P><P>I am unable to replace nulls with 0 in a dataframe ,please refer to the screen shot</P><P></P><PRE><CODE>from pyspark.sql.functions import col emp_csv_df = emp_csv_df.na.fill(0).withColumn("Total_Sal",col('sal')+col('comm')) display(emp_csv_df)</CODE></PRE><P></P><P>erorr</P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="unable to fill nulls with 0 in dataframe using PySpark in databricks"><img src="https://community.databricks.com/t5/image/serverpage/image-id/1412i9619CFA7B7F6A394/image-size/large?v=v2&amp;px=999" role="button" title="unable to fill nulls with 0 in dataframe using PySpark in databricks" alt="unable to fill nulls with 0 in dataframe using PySpark in databricks" /></span>&nbsp;</P><P>desired output</P><P><span class="lia-inline-image-display-wrapper" image-alt="Screenshot 2022-10-03 at 20.26.23"><img src="https://community.databricks.com/t5/image/serverpage/image-id/1421i5C390980620E88F3/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2022-10-03 at 20.26.23" alt="Screenshot 2022-10-03 at 20.26.23" /></span>&nbsp;</P><P>any suggestions ?</P><P></P><P>Regards,</P><P>Rakesh</P> Mon, 03 Oct 2022 14:58:41 GMT https://community.databricks.com/t5/data-engineering/unable-to-replace-null-with-0-in-dataframe-using-pyspark/m-p/29590#M21313 db-avengers2rul 2022-10-03T14:58:41Z https://community.databricks.com/t5/data-engineering/unable-to-replace-null-with-0-in-dataframe-using-pyspark/m-p/29591#M21314 <P>I bet that it is not real null but the string "null". Please check what is in the source and try luck with replacing it.</P> Mon, 03 Oct 2022 19:44:45 GMT https://community.databricks.com/t5/data-engineering/unable-to-replace-null-with-0-in-dataframe-using-pyspark/m-p/29591#M21314 Hubert-Dudek 2022-10-03T19:44:45Z