Format Converter xml to csv V2.py

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

path1 = 'D:/Note_Database/Subject/IITF Industrial Innovation and Technology Foresight/IITF Final Project/IITFFP AI Training/IITFFPAIT Rendered Image/IITFFPAITV Image2/xml'
path2 = 'D:/Note_Database/Subject/IITF Industrial Innovation and Technology Foresight/IITF Final Project/IITFFP AI Training/IITFFPAIT AI/FRCNNRCF/110-PR/csv/train2.csv'
xml_list = []
for xml_file in glob.glob(path1 + '/*.xml'):
    tree = ET.parse(xml_file)
    root = tree.getroot()
    for member in root.findall('object'):
        value = (root.find('filename').text,
                 int(os.path.splitext(root.find('filename').text)[0]),#Image file name needs to be purely with numbers!! No space is allowed.
                 member[0].text,
                 int(member[4][0].text),
                 int(member[4][1].text),
                 int(member[4][2].text),
                 int(member[4][3].text)
                 )
        xml_list.append(value)
column_name = ['filename',  'PicIndex', 'type', 'xmin', 'ymin', 'xmax', 'ymax']
#print('data gathered')
xml_df = pd.DataFrame(xml_list, columns=column_name)
#print(xml_df, ' execute successful, dataframe data gathered')
xml_df_sort = xml_df.sort_values(by=['PicIndex'])
#print(xml_df_sort, ' execute successful, dataframe sorted')
xml_df_sort_less = xml_df_sort.drop("PicIndex", axis=1)
#print(xml_df_sort_less, ' execute successful, dataframe droped PicIndex')
xml_df_sort_less.to_csv(path2, index=False)
print(xml_df_sort_less, '\n\nexecute successful, csv file exported')