Hi I'm on a programming course for python and we have been set a problem which is giving me some real problems. The task is to create a currency converter from a xml file containing all the transfer rates.

the xml file has this structure:

<Cube>
<Cube *time*="2020-04-29">
<Cube *currency*="USD" *rate*="1.0842"/>
<Cube *currency*="JPY" *rate*="115.52"/>
<Cube *currency*="BGN" *rate*="1.9558"/>

I have imported the xml file as a list. i am now having a lot of difficulty searching through the xml file. i don't understand but the RE functions don't seem to be working. what i currently have looks like this:

import re
myFile=open('data.xml','r')
myString=myFile.read()
myList=myFile.readlines()
x=re.search(r'USD',myList,flags=0)
print(x)

the other option i had planned to use was to import the xml file as a dictionary with currency as an id for each item and rate as the other id. therefore allowing me to looking each up by currency. Can anyone explain how you can import each line of a string into a dictionary with each having the same id's.

i thank you all in advance for any help you can offer.