Writing data in two columns using CSV format in Python

Question

Using CSV format, I want to write the data in two columns. The current and the desired output are attached.

import csv  
A=[1,2,3]
B=[4,5,6]
header = ['1', '2']
data = [str(A), str(B)]

with open('Test.csv', 'w', encoding='UTF8') as f:
    writer = csv.writer(f)

    # write the header
    writer.writerow(header)

    # write the data
    writer.writerow(data)

Current output:

Desired output:

blhsing · Accepted Answer · 2022-03-07 07:42:59Z

2

You can transpose rows an columns with the zip function:

writer = csv.writer(f)
writer.writerow(header)
writer.writerows(zip(A, B))

answered Mar 7, 2022 at 7:42

blhsing

109k9 gold badges88 silver badges132 bronze badges

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

Collectives™ on Stack Overflow

Writing data in two columns using CSV format in Python

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