Writing to a tsv file from multiple list in Python

Question

I have two lists

ids = [1,2,3]
values = [10,20,30]

I need to create a tsv file with two columns - id and result and put the ids and values in there. The output should look like this

id result
1  10
2  20
3  30

I wrote below code

output_columns = ['id','result']
data = zip(output_columns, ids, values)
    with open('output.tsv', 'w', newline='') as f_output:
        tsv_output = csv.writer(f_output, delimiter='\t')
        tsv_output.writerow(data)

But this gives me an output like below which is wrong

('id', '1', '10') ('result', '2','20')

I understand that this wrong output is because the way I did zip to create a row of data. But I am not sure how to solve it.

Please suggest.

Onyambu · Accepted Answer · 2020-07-27 01:18:43Z

2

output_columns = ['id','result']
data = zip(ids, values)
    with open('output.tsv', 'w', newline='') as f_output:
        tsv_output = csv.writer(f_output, delimiter='\t')
        tsv_output.writerow(output_columns)
        for id, val in data:
            tsv_output.writerow([id, val])

edited Jul 27, 2020 at 1:18

answered Jul 27, 2020 at 0:51

Onyambu

80.3k3 gold badges29 silver badges65 bronze badges

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

1 Comment

nad Over a year ago

Little typo - tsv.writerow(output_columns) should be tsv_output.writerow(output_columns). Otherwise good

bigbounty · Accepted Answer · 2020-07-27 00:59:23Z

2

It's easier using pandas

In [8]: df = pd.DataFrame({"ids":[1,2,3], "values":[10,20,30]})

In [9]: df
Out[9]:
   ids  values
0    1      10
1    2      20
2    3      30

In [10]: df.to_csv("data.tsv", sep="\t", index=False)

answered Jul 27, 2020 at 0:59

bigbounty

17.5k7 gold badges45 silver badges76 bronze badges

Collectives™ on Stack Overflow

Writing to a tsv file from multiple list in Python

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related