'convert double column to string column pyspark
hello guyes i have a datframe with double column (named double) i want to convert it to StringType() but when casting the column to string, all values of double column trun to NULL
is there any trick to convert double column to string column ?
im using Pyspark 2.3
+------------------+--------------+------+----------+---------------------+----------------------+
|concat(", vide, ")|integer |double|dt_arrete |concat(", vide_de, ")|code_lei|
+------------------+--------------+------+----------+---------------------+---------------------+
|null |10000000000000|1.1 |2021-06-30|null |"r" |
|null |1 |1.1 |2021-06-30|null |"code_lei" |
|null |1 |1.1 |2021-06-30|null |"code_lei" |
|null |1 |1.1 |2021-06-30|null |"code_lei" |
|null |2 |2.2 |2021-06-30|null |"code_lei" |
|null |2 |2.2 |2021-06-30|null |"code_lei" |
|null |2 |2.2 |2021-06-30|null |"code_lei" |
|null |2 |2.2 |2021-06-30|null |"code_lei" |
+------------------+--------------+------+----------+---------------------+----------------------+
deptDF = deptDF.withColumn('double', F.col('double').cast('string'))
deptDF.show()
+------------------+--------------+------+----------+---------------------+----------------------+
|concat(", vide, ")| integer|double| dt_arrete|concat(", vide_de, ")|code_lei
+------------------+--------------+------+----------+---------------------+----------------------+
| null|10000000000000| null|2021-06-30| null| "code_lei"|
| null| 1| null|2021-06-30| null| "code_lei"|
| null| 1| null|2021-06-30| null| "code_lei"|
| null| 1| null|2021-06-30| null| "code_lei"|
| null| 2| null|2021-06-30| null| "code_lei"|
| null| 2| null|2021-06-30| null| "code_lei"|
| null| 2| null|2021-06-30| null| "code_lei"|
| null| 2| null|2021-06-30| null| "code_lei"|
+------------------+--------------+------+----------+---------------------+----------------------+
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|