Das deutsche Python-Forum

Code: Alles auswählen

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

Data = ET.parse('xml_file.xml')
root = Data.getroot()

## Read excel list
df = pd.read_excel('ReplaceList_UUID.xlsx')
print(df)

## Preparation of searchList
searchList = pd.concat([df['Code_alphanumeric']], axis=0, ignore_index=False)
searchList = searchList.reset_index(drop=True)            # reset index from 0 .. i
searchList = searchList.astype(str)
print(searchList)

## Preparation of output expressions
resultList = pd.concat([df['Code_numeric']], axis=0, ignore_index=False)
resultList = resultList.reset_index(drop=True)
resultList = resultList.astype(str)
print(resultList)

## Replacement function Codes
############################################
for i in range(len(searchList)):
    for Code in root.iter('Code'):                              # iterates over the child named 'Code' and builds callable object
        if Code.text == searchList[i]:                    # condition for replacement
           Code.text = str(resultList[i])                  # what to replace with
           ET.tostring(root)                                              # described input string should replace child value
        else:
            pass

Data.write(str('Code'))                                      # overwrites the defined child Code's
# Check if replacements worked
# for Code in root.iter('Code'):
#     print(Code.text)

## Write output xml file with Codes
#############################################
Data.write('xml_file.xml', encoding='utf-8')

Code: Alles auswählen

from xml.dom import minidom
xmldoc = minidom.parse("GeologyModelLookUp_V3.0_00.xml")
cl = xmldoc.getElementsByTagName('GeologyModelLookUp_V3_0.Geology_Catalogues.Unconsolidated_Deposits_PT_Kind')
for i in range(3930):                                                # beste Lösung bisher
    if cl_object.attributes['TID'].value == searchList[i]:
        cl_object.attributes['TID'].value = uuidList[i]
    else:
        pass
print(cl_object.attributes['TID'].value)

Code: Alles auswählen

<?xml version="1.0" encoding="UTF-8"?>
<TRANSFER> 
  <DATASECTION>
    <Model.Catalogues BID="b001">
      <Model.Catalog.Class1 TID="Runc101001">
        <Code>Runc101001</Code>
        <Kind>
            <Text>erratischer Block</Text>
        </Kind>
      </Model.Catalog.Class1>
      <Model.Catalog.Class1 TID="Runc101002">
        <Code>Runc101002</Code>
        <Kind>
            <Text>Schwarm erratischer Blöcke</Text>
        </Kind>
      </Model.Catalog.Class1>
      <Model.Catalog.Class2 TID="Runc104001">
        <Code>Runc104001</Code>
        <Rock_Spe>
          <Text>Konglomerat</Text>
        </Rock_Spe>
      </Model.Catalog.Class2>
      <Model.Catalog.Class2 TID="Runc104002">
        <Code>Runc104002</Code>
        <Rock_Spe>
            <Text>Gabbro</Text>
        </Rock_Spe>
      </Model.Catalog.Class2>
	</Model.Catalogues>
  </DATASECTION>
</TRANSFER>

Code: Alles auswählen

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

data = et.parse('xml_file.xml')
root = data.getroot()

df = pd.read_excel('ReplaceList_UUID.xlsx')
df = df.set_index("Code_alphanumeric")
for code in root.findall('.//Code'):
    try:
        code.text = str(df.loc[code.text].Code_numeric)
    except KeyError:
        pass
data.write('code.xml')

Code: Alles auswählen

data = et.parse("GeologyModelLookUp_V3.0_00.xml")
root = data.getroot()
for element in root.findall('.//GeologyModelLookUp_V3_0.Geology_Catalogues.Unconsolidated_Deposits_PT_Kind'):
    try:
        element.attrib['TID'] = df.loc[element.attrib['TID']].UUID
    except KeyError:
        pass

Code: Alles auswählen

data = et.parse("Model.xml")
root = data.getroot()
for element in root.findall('.//Model.Catalog1.Class1'):
    try:
        element.attrib['TID'] = df.loc[element.attrib['TID']].UUID
    except KeyError:
        pass

Code: Alles auswählen

data = et.parse("Model.xml")
root = data.getroot()
for element in root.findall('.//Model.Catalog1'):
    try:
    	cla = element.getchildren()
        cla.attrib['TID'] = df.loc[cla.attrib['TID']].UUID
    except KeyError:
        pass