spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Ayad (Jira)" <j...@apache.org>
Subject [jira] [Commented] (SPARK-30082) Zeros are being treated as NaNs
Date Mon, 02 Dec 2019 13:08:00 GMT

    [ https://issues.apache.org/jira/browse/SPARK-30082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16986041#comment-16986041
] 

John Ayad commented on SPARK-30082:
-----------------------------------

[~hyukjin.kwon] already working on a PR

> Zeros are being treated as NaNs
> -------------------------------
>
>                 Key: SPARK-30082
>                 URL: https://issues.apache.org/jira/browse/SPARK-30082
>             Project: Spark
>          Issue Type: Bug
>          Components: PySpark
>    Affects Versions: 2.4.4
>            Reporter: John Ayad
>            Priority: Major
>
> If you attempt to run
> {code:java}
> df = df.replace(float('nan'), somethingToReplaceWith)
> {code}
> It will replace all {{0}} s in columns of type {{Integer}}
> Example code snippet to repro this:
> {code:java}
> from pyspark.sql import SQLContext
> spark = SQLContext(sc).sparkSession
> df = spark.createDataFrame([(1, 0), (2, 3), (3, 0)], ("index", "value"))
> df.show()
> df = df.replace(float('nan'), 5)
> df.show()
> {code}
> Here's the output I get when I run this code:
> {code:java}
> Welcome to
>       ____              __
>      / __/__  ___ _____/ /__
>     _\ \/ _ \/ _ `/ __/  '_/
>    /__ / .__/\_,_/_/ /_/\_\   version 2.4.4
>       /_/
> Using Python version 3.7.5 (default, Nov  1 2019 02:16:32)
> SparkSession available as 'spark'.
> >>> from pyspark.sql import SQLContext
> >>> spark = SQLContext(sc).sparkSession
> >>> df = spark.createDataFrame([(1, 0), (2, 3), (3, 0)], ("index", "value"))
> >>> df.show()
> +-----+-----+
> |index|value|
> +-----+-----+
> |    1|    0|
> |    2|    3|
> |    3|    0|
> +-----+-----+
> >>> df = df.replace(float('nan'), 5)
> >>> df.show()
> +-----+-----+
> |index|value|
> +-----+-----+
> |    1|    5|
> |    2|    3|
> |    3|    5|
> +-----+-----+
> >>>
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org


Mime
View raw message