from-xml | fromXML - Pure JavaScript XML Parser | Parser library

I'm trying to retrieve multiple attribute values (foo and bar) with one single xpath query.

This is my XML content (test.xml):

In the oracle table there is a column that stores XML below is the value:

I need to convert XML file to a Map.
Accordingly to described here I'm trying to read some repository XML file and convert it into a Map.
But this gives me

[Fatal Error] :1:1: Content is not allowed in prolog.

error.
My XML file doesn't contain ? signs on the first line, I already removed them.
My code is

I'm currently ingesting an XML file with lxml and then creating a pandas dataframe from the root element. I'm essentially using this example. I'm doing this so I can do some math / undertake some modelling on the data.

The next step I'd like to achieve is being able to write the data back to the xml document. In other places in my script I've used root.insert since I can force inserting at a particular position index in order to keep the xml document neat and coherent.

Is there a way I can write out each row of the dataframe using something like root.insert(position, data) for each row in the dataframe, where the dataframes column header is the tag?

Example XML

I have tried to apply the code originally published here, in order to remove all the XML tags and strip the spaces left after the XML tags' removal with the lxml library:

I'm trying to parse a wide, nested XML file into a DataFrame using the spark-xml library.

Here is an abbreviated schema definition (XSD):

How to transform values below from multiple XML files to spark data frame :

• attribute Id0 from Level_0
• Date/Value from Level_4

Required output:

I have several sql statements that produce a list of elements that 'should' be columns in a database but are not. I wish to use these lists to drive transforming an xml file into the same minus various specific children elements that reference those columns. so for example for TABLE WO I have the list: 'NORMDATE','ORIGRATE','ORIGUNITCOST','PREVRATE','PREVUNITCOST'

I wish to transform this:

I've been trying for days to read a value from XML file into a text box. I searched relevant questions:

Reading values from xml file with Linq
C# Reading from XML files
Getting values from xml file using C#
How to Read values from XML file
and videos:
https://www.youtube.com/watch?v=4dPWkEARptI
https://www.youtube.com/watch?v=-DwANN5_BoE

Still, I couldn't correctly read the "Background" value and always get this Error: (I doubt it has to do with hierarchy of the XML file and I'm not choosing the correct Element \ Node) What did I miss?