/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 vote206 views1 answer
Abrir notebooks jupyter administrador de archivos
Python
0 vote288 views1 answer
Using a generic exception block
Python
3 votes204 views2 answers
Python Tkinter button Image
Python
0 vote208 views1 answer
Python n range num list
Python
0 vote235 views3 answers
Flask models
Python Flask
0 vote218 views1 answer
Python use orange
Python
39 votes208 views2 answers
Create text in python if not exists
Python
6 votes201 views2 answers
Python check if value is undefined
Python
2 votes205 views2 answers
AttributeError: module 'tensorflow._api.v2.train' has no attribute 'RMSPropOptimizer' site:stackoverflow.com
Python
1 vote211 views1 answer
Pandas row from dict
Python