Python List append with respective index

Question

I need help on list append. I have to export it into CSV with the respective list index.

lst1 = ['a', 'b', 'c']
lst2 = ['w', 'f', 'g']
lst3 = ['e', 'r', 't']

ap = []

ap.append((lst1, lst2, lst3))

output: [(['a', 'b', 'c'], ['w', 'f', 'g'], ['e', 'r', 't'])]

Expected output:

[('a', 'w', 'e')
 ('b', 'f', 'r')
 ('c', 'g', 't')]

I need to export to Excel via Pandas, please help.

 col1   col2    col3
 a       w       e
 b       f       r
 c       g       t

jpp · Accepted Answer · 2018-07-09 16:49:14Z

3

You need a list of tuples, not a list of a tuple of lists. For your result, you can use zip with unpacking to extract items in an iterable of lists by index.

df = pd.DataFrame(list(zip(*(lst1, lst2, lst3))),
                  columns=['col1', 'col2', 'col3'])

print(df)

  col1 col2 col3
0    a    w    e
1    b    f    r
2    c    g    t

Then export to Excel as you normally would:

df.to_excel('file.xlsx', index=False)

answered Jul 9, 2018 at 16:49

jpp

166k37 gold badges301 silver badges363 bronze badges

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

Collectives™ on Stack Overflow

Python List append with respective index

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related