/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

8 votes111 views2 answers
Append two list of number to one python
Python
1 vote96 views1 answer
Combining series to a dataframe
Python
0 vote96 views1 answer
Python .on event triggers
Python
0 vote104 views1 answer
How to check if digit in int python
Python
18 votes104 views3 answers
Select specific rows from dataframe in python
Python
0 vote103 views1 answer
Python string: string concatenation
Python
4 votes110 views3 answers
Pandas df by row index
Python
3 votes114 views5 answers
Pytorch check gpu
Python
0 vote104 views1 answer
From .cv2 import * ImportError: /home/pi/.local/lib/python3.7/site-packages/cv2/cv2.cpython-37m-arm-linux-gnueabihf.so: undefined symbol: __atomic_fetch_add_8
Python
0 vote120 views1 answer
While my_input != "exit":
Python