Parse XML with azure synapse spark pool

Question

Hello

I'm looking to parse an XML file with azure synapse spark pool
i ve installed the librairies for XML but i don' know how to call it into my python code

thanks for help

Answer 1

Hello @Ahmed ELHOULA and welcome to Microsoft Q&A

From the screenshot it looks like you tried to import a scala library while doing python. That's a bit mix and match. Try removing the "import scala.xml" line. You already have some other stuff going on.

There are several routes you could take. Depends what you want to do. Is your data relatively flat, or is it super deep heirarchical? Do you want it in a pandas dataframe, or do you want to process it in a specific way?

The "import xml" line is not enought if you want to use just python to read your xml. You will either want xml.parsers.expat or xml.etree.ElementTree. Neither of these will accept "abfss" paths, so you will need to first mount the blob so they can pretend it is normal file.

Take a look at how-to-convert-an-xml-file-to-nice-pandas-dataframe , pandas.read_xml.html ,

Answer 2

Hello @MartinJaffer-MSFT

Thanks for your reply
I wan to flatten my xml file and put int into a dataframe