/Python/How to have framer read json timestamps

How to have framer read json timestamps

scala> val regex =  "([0-9\\-TZ\\.:]+) (\\{.*)"
regex: String = ([0-9\-TZ\.:]+) (\{.*)

scala> val dff = df.withColumn("tstamp", regexp_extract('json_content, regex, 1)).withColumn("json", regexp_extract('json_content, regex, 2)).drop("json_content")
dff: org.apache.spark.sql.DataFrame = [country: string, city: string ... 2 more fields]

scala> dff.show(false)
+-------+-------+------------------------+----------------------------------+
|country|city   |tstamp                  |json                              |
+-------+-------+------------------------+----------------------------------+
|america|chicago|2019-06-28T00:00:00.000Z|{ "a": 123, "b": "456", "c": 789 }|
|india  |mumbai |2019-06-28T00:00:00.000Z|{ "a": 123, "b": "456", "c": 789 }|
+-------+-------+------------------------+----------------------------------+

Source: stackoverflow.com

Similar codes

0 vote244 views1 answer
Removing a channel from aconda
Python
0 vote210 views1 answer
Numpy how to apply interpolation all rows
Python
0 vote253 views1 answer
Django.com
Python Django
-1 vote180 views2 answers
Python check if string has space
Python
1 vote190 views1 answer
Python truncate to integer
Python
86 votes208 views6 answers
Select random value from list python
Python
0 vote204 views1 answer
Label_map dict = label_map_util.get_label_map_dict(label_map)
Python
-1 vote196 views2 answers
Print tables in python
Python
0 vote227 views1 answer
How to know if the space button has been clicked in python pygame
Python
0 vote192 views1 answer
Delete history django simple
Python