Get XML element in list

Question

I am getting all values by scanning the tags

    list_values = []
    tags = ['Created', 'Comments', 'Name']
    for element in root.iter():
    if element.tag not in tags:
        continue
    print(element.text)
    list_values .append(element.text)

    print(list_values)

Getting all values in one array like ['12/2/2018','aa','John','13/2/2018','aa2','Tim','12/4/2018','aa','John','13/2/2018','gg','Kim']

Have to insert all these values in SQL. I want output like

('12/2/2018','aa','John')
('13/2/2018','aa2','Tim')
(12/4/2018','aa','John')

Juhil Somaiya · Accepted Answer · 2019-11-26 05:21:33Z

2

Simply use the iter() as below:

data = ['12/2/2018','aa','John','13/2/2018','aa2','Tim','12/4/2018','aa','John','13/2/2018','gg','Kim']
it = iter(data)
print(list(zip(it,it,it)))

Output:

[('12/2/2018', 'aa', 'John'), ('13/2/2018', 'aa2', 'Tim'), ('12/4/2018', 'aa', 'John'), ('13/2/2018', 'gg', 'Kim')]

answered Nov 26, 2019 at 5:21

Juhil Somaiya

9637 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

cxↄ Over a year ago

Cool solution! ;)

ExplodingGayFish · Accepted Answer · 2019-11-26 04:38:10Z

1

try this:

data = ['12/2/2018','aa','John','13/2/2018','aa2','Tim','12/4/2018','aa','John','13/2/2018','gg','Kim']
[data[i:i + 3] for i in range(0,len(data),3)]

Output:

[['12/2/2018', 'aa', 'John'],
 ['13/2/2018', 'aa2', 'Tim'],
 ['12/4/2018', 'aa', 'John'],
 ['13/2/2018', 'gg', 'Kim']]

To convert to list of tuple use this:

data = ['12/2/2018','aa','John','13/2/2018','aa2','Tim','12/4/2018','aa','John','13/2/2018','gg','Kim']
[tuple(data[i:i + 3]) for i in range(0,len(data),3)]

edited Nov 26, 2019 at 4:38

answered Nov 26, 2019 at 4:10

ExplodingGayFish

2,9071 gold badge8 silver badges14 bronze badges

4 Comments

Andrew Over a year ago

Thanks a lot. Can you please let me know how can I insert this into the SQL database. How can I read this one by one or in one go I can Insert. Thanks again.

ExplodingGayFish Over a year ago

Depends on what database you are using, there should be some libraries that help you insert many at once

Andrew Over a year ago

I am using SQL DB and import pyodbc. following this link, stackoverflow.com/questions/18244565/… . not able to figure out how can i read the above-genertaed array.

ExplodingGayFish Over a year ago

try the tuple way in my edited answer and see if that works

Collectives™ on Stack Overflow

Get XML element in list

2 Answers 2

1 Comment

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related