/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

12 votes245 views6 answers
Python convert date to timestamp
Python
68 votes267 views6 answers
Python clear console
Python
1 vote319 views2 answers
Multiply two list in python using lambda
Python
0 vote233 views1 answer
Mechanize python XE #27
Python
-2 votes252 views1 answer
Start django project in windows
Python Django
16 votes247 views1 answer
Python reload function from file
Python
2 votes273 views1 answer
Matplotlib 3D plots reduce margins
Python
0 vote245 views1 answer
Are angles of a parallelogram equal?
Python
20 votes267 views3 answers
Python sort list in reverse
Python
0 vote294 views1 answer
Pandas convert numbers in parentheses to negative
Python