Python: writing list of list in a csv file

Question

I have a list of list with this elements:

listes = [["a","b"],["c","d"],["e","f"]]

I used to this code for writing my csv:

with open("result.csv", "wb") as f:
    writer = csv.writer(f, delimiter=';')
    writer.writerows(listes)

The result:

a;b
c;d
e;f

But i would like:

a;c;d
b;e;f

Thanks

huh, I can make no relation to your input and output. Do you mean you would like 'a;c;e' en 'b;d;f' ? — RvdK, Jul 17 '14 at 09:58
how would the writer know what you want. You should feed it correctly... (So recreate arrays for the writer) — RvdK, Jul 17 '14 at 12:02

Ashoka Lella · Answer 1 · 2014-07-17T10:37:00.103

0

Transpose your list and write to file

with open("result.csv", "wb") as f:
    writer = csv.writer(f, delimiter=';')
    writer.writerows(zip(*listes))

edited Jul 17 '14 at 10:37

answered Jul 17 '14 at 09:59

Ashoka Lella

1

Why the `map()` call? – Ashwini Chaudhary Jul 17 '14 at 10:22
@undefinedisnotafunction not sure if writerows operates on sets as well. Casted it to list for safety – Ashoka Lella Jul 17 '14 at 10:36
`zip()` returns list of tuples in Python 2 not set and it'll work in Python 3 as well where zip returns an iterator. – Ashwini Chaudhary Jul 17 '14 at 10:39
your code returns 'a;c;e' en 'b;d;f', but i would like 'a;c;d' en 'b;e;f' – Chattam Jul 17 '14 at 11:56

1 Answers1