You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Haejoon Lee (Jira)" <ji...@apache.org> on 2021/08/30 07:52:00 UTC

[jira] [Created] (SPARK-36610) Add `thousands` argument to `ps.read_csv`.

Haejoon Lee created SPARK-36610:
-----------------------------------

             Summary: Add `thousands` argument to `ps.read_csv`.
                 Key: SPARK-36610
                 URL: https://issues.apache.org/jira/browse/SPARK-36610
             Project: Spark
          Issue Type: Improvement
          Components: PySpark
    Affects Versions: 3.2.0
            Reporter: Haejoon Lee


When reading csv file in pandas, pandas automatically detect the thousand separator if `thousands` argument is specified.
{code:java}
>>> pd.read_csv(path, sep=";")
    name  age        job      money
0  Jorge   30  Developer  1,000,000
1    Bob   32  Developer    1000000

>>> pd.read_csv(path, sep=";", thousands=",")
    name  age        job    money
0  Jorge   30  Developer  1000000
1    Bob   32  Developer  1000000{code}
However, pandas-on-Spark doesn't support it.



--
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