skip to Main Content

Add an index or id value to JSON

I've got a JSON file similar to this: { "Name": "a1", "Notes": "b1", "Active": "c1" }, { "Name": "a2", "Notes": "b2", "Active": "c2" }, { "Name": "a3", "Notes": "b4", "Active": "c3" } I need to transform it using Python by…

VIEW QUESTION

Pyspark – JSON string column explode into multiple without mentioning schema

I have below JSON string as a column in a pyspark dataframe. { "result":{ "version":"1.2", "timeStamp":"2023-08-14 14:00:12", "description":"", "data":{ "DateTime_Received":"2023-08-14T14:01:10.4516457+01:00", "DateTime_Actual":"2023-08-14T14:00:12", "OtherInfo":null, "main":[ { "Status":0, "ID":111, "details":null } ] }, "tn":"aaa" } } I want to explode the above one…

VIEW QUESTION
Back To Top
Search