/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

3 votes159 views3 answers
Python basename
Python
6 votes180 views3 answers
Flask cors
Python Flask
3 votes210 views2 answers
Division in python
Python
2 votes148 views1 answer
Selenium zoom out python
Python
0 vote176 views1 answer
Re_path(r'^logout/$',views.logout, {"next_page":'/'},name="logout"), AttributeError: module 'django.contrib.auth.views' has no attribute 'logout'
Python Django
0 vote156 views1 answer
Python mysqlclient not installing
Python
0 vote149 views1 answer
Python overwrite print on same line
Python
8 votes171 views4 answers
Python len
Python
6 votes111 views2 answers
Write a python program to print all unique values in a dictionary
Python
0 vote167 views1 answer
Compile python to exe bash
Python