Python Forum
Parse the data in XML metadata field
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Parse the data in XML metadata field
#1
I'm trying to parse data from an XML file downloaded from https://scsanctions.un.org/resources/xml...idated.xml

Sample of the XML file is attached.

<?xml version="1.0" encoding="UTF-8"?>
<CONSOLIDATED_LIST xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="https://www.un.org/sc/resources/sc-sanctions.xsd" dateGenerated="2019-06-17T19:04:28.013-04:00">

I tried to parse the value for "dateGenerated" metadata, but it was not successful.

Appreciate if some can help on this.


import pandas as pd
import xml.etree.ElementTree as ET

file1 = ET.parse(r'scsanctions.un.org_copy.xml')

for node in file1.getroot():
    print(ET.tostring(node, encoding='utf8').decode('utf8'))
    print(node)
    for i in node:
        dataid= [dataid.text for dataid in i.findall('DATAID')]
        print(dataid)
    # Try 1
    d = node.findall('dateGenerated')
    print(d.text)

d1= file1.findall('dateGenerated')
print(d1)

Attached Files

.xml   scsanctions.un.org_copy.xml (Size: 17.13 KB / Downloads: 567)
Reply
#2
>>> doc = ET.parse('scsanctions.un.org_copy.xml')
>>> root = doc.getroot()
>>> root
<Element 'CONSOLIDATED_LIST' at 0x0000026D52CB0BD8>
>>> root.attrib['dateGenerated']
'2019-06-17T19:04:28.013-04:00'
Reply
#3
(Jun-19-2019, 10:12 AM)stranac Wrote:
>>> doc = ET.parse('scsanctions.un.org_copy.xml')
>>> root = doc.getroot()
>>> root
<Element 'CONSOLIDATED_LIST' at 0x0000026D52CB0BD8>
>>> root.attrib['dateGenerated']
'2019-06-17T19:04:28.013-04:00'

Thank you! Smile
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  parse json field from csv file lebossejames 4 668 Nov-14-2023, 11:34 PM
Last Post: snippsat
Question image manipulation (cropping and MetaData) SpongeB0B 4 1,099 Jul-03-2023, 06:35 PM
Last Post: SpongeB0B
  AttributeError: 'function' object has no attribute 'metadata 3lnyn0 5 4,522 Mar-28-2022, 04:42 PM
Last Post: Larz60+
  how to parse data fakka 2 1,464 Sep-22-2021, 10:50 PM
Last Post: bowlofred
  Bug ? when dataclass field name == field type Cyril 0 1,525 Oct-22-2020, 03:26 AM
Last Post: Cyril
  Parse BytesIO data GrahamL 2 2,107 Aug-19-2020, 05:09 PM
Last Post: bowlofred
  Adding Language metadata to a PDF programmatically bhargavi22 0 1,909 Aug-17-2020, 12:53 PM
Last Post: bhargavi22
  METADATA Errors millpond 0 1,876 Jul-21-2020, 08:22 AM
Last Post: millpond
  command line input (arg parse) and data exchange Simba 7 4,243 Dec-06-2019, 11:58 PM
Last Post: Simba
  How to sort image files according to a metadata file? Brahmslove 1 3,071 Dec-05-2019, 11:25 PM
Last Post: scidam

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020