/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

1 vote203 views1 answer
How to find permutation of three numbers in python list
Python
0 vote187 views1 answer
Art library in python spyder
Python
0 vote195 views1 answer
Pandas backward fill after upsampling
Python
3 votes180 views1 answer
Iteration
Python
16 votes222 views3 answers
How to find if a value is even or odd in python
Python
0 vote174 views1 answer
How to repeat code in python until a condition is met
Python
1 vote245 views1 answer
How to run the server in django
Python Django
0 vote266 views1 answer
Num=operator.index(num) name 'num' is not defined
Python
6 votes196 views6 answers
Ternary operator in python
Python
1 vote189 views1 answer
Tf.contrib.layers.xavier_initializer() tf2
Python