topic Re: Converting column of XML strings to column of Jsons in Data Engineering

Converting column of XML strings to column of Jsons

Ankith — Wed, 28 Jun 2023 05:35:59 GMT

Hi,

I want to convert column of XML strings to column of Json in PySpark., using withcolumn and xmltodict method as UDF, is giving Json with '=' instead of ':' in the dictionary. Please let me know if there is any alternative for this.

Re: Converting column of XML strings to column of Jsons

DessertKid — Wed, 28 Jun 2023 19:30:25 GMT

To convert a column of XML strings to a column of JSON in PySpark, you can use the `from_json` function along with the `xmltodict` library. However, instead of using a UDF with `withColumn`, you can use the `select` function to transform the column.