/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 vote219 views1 answer
Python attributes from string
Python
0 vote233 views1 answer
How to wirte something 100 times with python
Python
1 vote216 views1 answer
How to print not equal to in python
Python
1 vote257 views1 answer
Telnet python
Python
0 vote211 views1 answer
How to capture video in google colab with python
Python
0 vote278 views1 answer
Multiplication table for number python codewars
Python
14 votes242 views5 answers
Python trim whitespace from end of string
Python
6 votes240 views3 answers
Python moving average pandas
Python
2 votes222 views1 answer
Import validation error in django
Python
19 votes225 views5 answers
List to dictionary
Python