I am a beginner in python. How do I modify the code below to write out the list to a csv file with 2 columns of output as below.
1 1
2 1
3 1
4 1
5 1
Right now, the output is below
(1, 1)
(2, 1)
(3, 1)
(4, 1)
(5, 1)
list = [(1,1),(2,1),(3,1),(4,1),(5,1)]
with open(test.csv, 'wb') as testfile:
csv_writer = csv.writer(testfile)
for i in list:
csv_writer.writerow([i])
Greatly appreciate your help.
import csv
list = [(1,1),(2,1),(3,1),(4,1),(5,1)]
with open('test.csv', 'wb') as testfile:
csv_writer = csv.writer(testfile)
for i in list:
csv_writer.writerow(str(i[0])+' '+str(i[1]))
You are writing the tuple to the file and not each element of the tubple to the file. Try this below. Let me know if that gives you an error.
list = [(1,1),(2,1),(3,1),(4,1),(5,1)]
with open(test.csv, 'wb') as testfile:
csv_writer = csv.writer(testfile)
for i in list:
csv_writer.writerow(i[0] + ' ' + i[1])
The csv.writer method takes an iterable. The i variable is already a tuple, so you don't need to make it a list. By enclosing i in [], you're turning it into a list of tuples: [(1, 2)]. Then csv.writer takes your list and splits it into a tuple of (1, 2) for the first item in the row.
Assuming you want to have a space for a delimiter instead of a comma, you'll need to do the following: 1) Add a delimiter parameter to the call to csv.writer and 2) get rid of the brackets.
Also, you might want to change the way you open the file to just 'w'. CSV files are supposed to be plain text, so you probably don't want to write it as binary.
Here's how I would change the code.
list = [(1,1),(2,1),(3,1),(4,1),(5,1)]
with open('test.csv', 'w') as testfile:
csv_writer = csv.writer(testfile, delimiter=' ')
for i in list:
csv_writer.writerow(i)
Your list is made of pairs, just iterate on it and pass the pair to a string template for formatting:
import csv
list = [(1,1),(2,1),(3,1),(4,1),(5,1)]
with open('test.csv', 'wb') as testfile:
csv_writer = csv.writer(testfile)
for pair in list:
csv_writer.writerow('%d %d' % pair)
csv_writer.writerow(i)would get rid of the parens, but the comma would still be there... Is that close enough?