Function for reading cage xml data from NewDEPOMOD and bringing it into a Pandas DataFrame and generating a csv file which can be read into QGIS as a delmited text layer

read_depomod_cage_xml.py

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

def read_cage_xml(cages_xml_file_path):
    xml_cages = ET.fromstring(open(cages_xml_file_path).read())
    cage_details = []
    for x in xml_cages[0]:
        if (x.tag[-4:]) == 'cage':
            cage_details.append({'easting':float(x[1].text),'northing':float(x[2].text),'cageType':x[0].text,'length':x[4].text,'width':x[5].text})
    cages_df = pd.DataFrame(cage_details)
    cages_df.to_csv(cages_xml_file_path[:-3] + '.csv')
    return cages_df

read_cage_xml('path/to/cages.xml')