/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

-1 vote321 views1 answer
Http python lib
Python
8 votes310 views6 answers
Fizzbuzz python solution
Python
0 vote289 views1 answer
How to get a rectangular grid out of two given one-dimensional arrays
Python
0 vote318 views1 answer
Django queryset to instance
Python Django
24 votes278 views3 answers
Warning ignore python
Python
1 vote290 views1 answer
Slack send message python
Python
1 vote318 views1 answer
Running setup.py bdist_wheel for opencv-python: still running...
Python
0 vote274 views1 answer
I've a date column messed up with different date formats how to fix it in power bi
Python
0 vote288 views1 answer
Invalid literal for int() with base 10 python
Python
0 vote284 views1 answer
Python Command '['latexmk', '--pdf', '--interaction=nonstopmode', % returned non-zero exit status 2.
Python