/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 vote211 views1 answer
Print the multiple data types in a single program in list data structures
Python
0 vote166 views1 answer
Python read excel sheet name
Python
0 vote143 views1 answer
Checking if a string is in alphabetical order in python
Python
0 vote163 views1 answer
Write a python program to find table of a number using while loop
Python
0 vote151 views1 answer
Python clear stdout
Python
0 vote165 views1 answer
Is python idle an ide
Python
0 vote163 views1 answer
Django pass list of fields to values
Python
5 votes147 views6 answers
How to check a string in if statement python
Python
25 votes120 views4 answers
Python extract specific columns from pandas dataframe
Python
0 vote226 views1 answer
Write a Python program to accept two strings as input and check if they are identical copy of each other or if the second string is a substring of the first string.
Python