/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 vote305 views1 answer
How to convert a axis label to non scientific notation in matploltlib
Python
39 votes304 views4 answers
Round off float to 2 decimal places in python
Python
3 votes339 views5 answers
Remove unnamed 0 column pandas
Python
0 vote286 views1 answer
Find highest value in array python
Python
0 vote289 views1 answer
Def areEquallyStrong(yourLeft, yourRight, friendsLeft, friendsRight):python execution
Python
0 vote320 views2 answers
Method get first last name python
Python
10 votes316 views3 answers
Get reactions from message discord.py
Python
58 votes299 views2 answers
What is join use for in python
Python
4 votes313 views1 answer
Sort dict by value
Python
4 votes286 views1 answer
Server on python with address and port
Python