Sunday, March 8, 2020

What is the difference between NaN and NULL and NA

NaN  : means 0/0 -- Stands for Not a Number
NA   : is generally interpreted as a missing, does not exist.
NULL : is for empty object. 
Infinity : 1/0 is infinity.

No comments:

Post a Comment

Recent Post

Databricks Delta table merge Example

here's some sample code that demonstrates a merge operation on a Delta table using PySpark:   from pyspark.sql import SparkSession # cre...