I cannot get the extraction of this xml data to dataframe to work properly.
This is my xml sample. In reality I have multiple stacks of “Entity” which represent one line of data in the desired result. To save space I only pasted one instance of “Entity” here:

I cannot get the extraction of this xml data to dataframe to work properly.
This is my xml sample. In reality I have multiple stacks of “Entity” which represent one line of data in the desired result. To save space I only pasted one instance of “Entity” here:

I cannot get the extraction of this xml data to dataframe to work properly.
This is my xml sample. In reality I have multiple stacks of “Entity” which represent one line of data in the desired result. To save space I only pasted one instance of “Entity” here:

I cannot get the extraction of this xml data to dataframe to work properly.
This is my xml sample. In reality I have multiple stacks of “Entity” which represent one line of data in the desired result. To save space I only pasted one instance of “Entity” here:

I cannot get the extraction of this xml data to dataframe to work properly.
This is my xml sample. In reality I have multiple stacks of “Entity” which represent one line of data in the desired result. To save space I only pasted one instance of “Entity” here:

I cannot get the extraction of this xml data to dataframe to work properly.
This is my xml sample. In reality I have multiple stacks of “Entity” which represent one line of data in the desired result. To save space I only pasted one instance of “Entity” here:

Just wondering if someone might be able to help figure out where I’ve gone wrong on this Python script. I’m trying to read the US light list weekly changes xml (found here: https://www.navcen.uscg.gov/sites/default/files/xml/lightLists/weeklyUpdates/v7d09WeeklyChanges.xml) into a Pandas Data frame. I don’t program very often so I’m just starting off slowly, trying to write the ‘District’ field for each aid to an empty list. When I run the script it shows ‘None’ in the District column. How can I output the ‘District’ field to the dataframe? Thanks.

My code:

I am using the below code to parse an xml and get the different attributes of an element. I need the name,datatype,length,is_autonumber and ismandatory properties of each attribute. Some attributes don’t have some of these properties. Iam parsing and storing the values in lists and then creating a dataframe and converting it into an xml. Since my original xml is very complex I am using this code to get a simplified xml with only the entities and attributes I need.
When I run this code I get “All Arrays must be of the same length”. Please find the screenshot.