How to write a list to a file with two items per row

Question

I'm trying to save the following list to a CSV file:

import csv

list = ['52.26.17.68', 'TotalPhysicalMemory : 4294361088', '10.12.15.14', 'TotalPhysicalMemory : 6546534654']

with open('testing.csv', 'w', newline='') as r:
        writer = csv.writer(r, delimiter='\t')
        writer.writerows(list)

With this my CSV file looks like:

How can I get "TotalPhysicalMemory" into column B so it looks like below?

Also: [How to print several array elements per line to text file](https://stackoverflow.com/q/14941854/7851470) — Georgy, Nov 29 '19 at 11:43

score 1 · Accepted Answer · answered Nov 29 '19 at 11:34

1

Use zip with list slicing

Ex:

import csv

lst = ['52.26.17.68', 'TotalPhysicalMemory : 4294361088', '10.12.15.14', 'TotalPhysicalMemory : 6546534654']

with open('testing.csv', 'w', newline='') as r:
    writer = csv.writer(r, delimiter='\t')
    writer.writerows(zip(lst[::2], lst[1::2]))

answered Nov 29 '19 at 11:34

Rakesh

81,458
17
76
113

This puts the data in one column for me. – Posteingang Nov 29 '19 at 11:56
You probably need to use delimiter as tab while opening the file in excel – Rakesh Nov 29 '19 at 12:05
1

changing delimiter to "," worked. Thanks for your help. – Posteingang Nov 29 '19 at 13:17

How to write a list to a file with two items per row

1 Answers1