from xml.dom import minidom
import pandas as pd
mydoc = minidom.parse(path)
item1 = mydoc.getElementsByTagName("AIN")
item2=mydoc.getElementsByTagName("REG")
item3=mydoc.getElementsByTagName("MFN")
columns = ["AIN", "REG", "MFN"]
datatframe = pd.DataFrame(columns = columns)
for elem1,elem2,elem3 in zip(item1,item2,item3):
AIN = elem1.firstChild.data
REG = elem2.firstChild.data
MFN = elem3.firstChild.data
dataframe = datatframe.append(pd.Series([AIN, REG, MFN], index = columns), ignore_index = True)
dataframe.to_csv('SQ190820_2.csv')