log10

Calcula el logaritmo del valor especificado en Base 10. Soporta Spark Connect.

Para obtener la función SQL de Databricks correspondiente, consulte log10 function.

Syntax

from pyspark.databricks.sql import functions as dbf

dbf.log10(col=<col>)

Parámetros

Parámetro	Tipo	Description
col	pyspark.sql.Column or column name	columna para la que se va a calcular el logaritmo.

Devoluciones

pyspark.sql.Column: logaritmo del valor especificado en Base 10.

Examples

from pyspark.databricks.sql import functions as dbf
df = spark.createDataFrame([(1,), (10,), (100,)], ["value"])
df.select("*", dbf.log10(df.value)).show()

+-----+------------+
|value|LOG10(value)|
+-----+------------+
|    1|         0.0|
|   10|         1.0|
|  100|         2.0|
+-----+------------+

from pyspark.databricks.sql import functions as dbf
spark.sql("SELECT * FROM VALUES (-1), (0), (FLOAT('NAN')), (NULL) AS TAB(value)").select("*", dbf.log10("value")).show()

+-----+------------+
|value|LOG10(value)|
+-----+------------+
| -1.0|        NULL|
|  0.0|        NULL|
|  NaN|         NaN|
| NULL|        NULL|
+-----+------------+