/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

9 votes196 views1 answer
Delete model object django
Python
1 vote170 views1 answer
Change every value in a np array
Python
0 vote247 views2 answers
Numpy np sign change in df pandas zero crossing
Python
0 vote173 views1 answer
Get a column of a csv python
Python
1 vote192 views1 answer
Write a python program to find gcd of two numbers
Python
0 vote186 views1 answer
Ciclo while python
Python
44 votes187 views5 answers
Python execute shell command
Python
0 vote279 views1 answer
Django fixtures. To dump data
Python
179 votes291 views10 answers
Minecraft
Python
0 vote230 views1 answer
Using default as none in django mdoels
Python Django