Pyspark，添加冒号以分隔字符串 [英] Pyspark, add colon to separate string

问题描述

我有以下字符串 103400 我需要使用 pyspark 将它写成 10:34:00.以以下列为例

I have the following string 103400 I need to write it like 10:34:00 using pyspark. let take the following column as an example

time
130045
230022

我希望它变成这样:

time
13:00:45
23:00:22  

推荐答案

可以用regexp_replace试试

you can try with regexp_replace

df.withColumn("time", regexp_replace(col("time") ,  "(\\d{2})(\\d{2})(\\d{2})" , "$1:$2:$3" ) ).show()

+--------+
| time   |
+--------+
|13:00:45|
|23:00:22|
+--------+

这篇关于Pyspark，添加冒号以分隔字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！