<?xml version="2.0" encoding="UTF-8" ?><timestamp="20220113">
<defintions>
<defintion id="1" old_id="0">Lang</defintion>
<defintion id="7" old_id="1">Eng</defintion>
How can I parse an XML file that looks like this? Here, I have multiple values within a single tag. I want to extract values such as "ID", and "OLD_ID" in a list or dataframe format.
You could use BeautifulSoup and xml parser to get your goal, simply select the elements needed and iterate ResultSet to extract attribute values via .get().
with open('filename.xml', 'r') as f:
file = f.read()
soup = BeautifulSoup(file, 'xml')
from bs4 import BeautifulSoup
import pandas as pd
xml = '''<?xml version="2.0" encoding="UTF-8" ?><timestamp="20220113">
<defintions>
<defintion id="1" old_id="0">Lang</defintion>
<defintion id="7" old_id="1">Eng</defintion>
'''
soup = BeautifulSoup(xml,'xml')
pd.DataFrame(
[
(e.get('id'),e.get('old_id'))
for e in soup.select('defintion')
],
columns = ['id','old_id']
)
| id | old_id | |
|---|---|---|
| 0 | 1 | 0 |
| 1 | 7 | 1 |
Using python Beautiful Soup, you could parse the .xml file to a Beatuful soup object and then use .findAll('defintions'). Then loop through the tags you find and get the desired values
object.findAll('defintions')
for defintion in defintions:
old_id = defintions['old_id']
id = defintions['id']
references: https://www.crummy.com/software/BeautifulSoup/bs4/doc/ https://linuxhint.com/parse_xml_python_beautifulsoup/
findAll() instead use find_all() or select() with css selectors - For more take a minute to check docs
If you have a valid XML like (timestamp tag can't have a value like an attribute):
<?xml version='1.0' encoding='utf-8'?>
<root timestamp='20220113'>
<defintions>
<defintion id="1" old_id="0">Lang</defintion>
<defintion id="7" old_id="1">Eng</defintion>
</defintions>
</root>
Than you can use pandas:
import pandas as pd
df = pd.read_xml('x89.xml', xpath='.//defintion')
print(df.to_string(index=False))
Output:
id old_id defintion
1 0 Lang
7 1 Eng
