0

Kinda knew to Python:

I have the following code:

def printCSV(output, values, header):
 63     """
 64         prints the output data as comma-separated values
 65     """
 66 
 67     try:
 68         with open(output, 'w') as csvFile:
 69             #print headers
 70             csvFile.write(header)
 71 
 72             for value in values:
 73                 #print value, "\n"
 74                 csvFile.write(",".join(value))
 75                 csvFile.write("\n")
 76     except:
 77        print "Error occured while writing CSV file..."



Values is a list constructed somewhat like this:

values = []

for i in range(0,5):
    row = "A,%s,%s,%s" % (0,stringval, intval)
    values.append(row)

When I open the file created by the above function, I expect to see something like this:

Col1,Col2,Col3,Col4
A,0,'hello',123
A,0,'foobar',42

Instead, I am seeing data like this:

Col1,Col2,Col3,Col4
A,0,'h','e','l','l','o',1,2,3
A,0,'f','o','o','b','a','r',4,2

Anyone knows what is causing this?

I even tried to use fopen and fwrite() directly, still the same problem exists.

Whats causing this?

skyeagle
  • 3,211
  • 11
  • 39
  • 41
  • Why are you doing `csvFile.write(",".join(value))`? Please explain this line of code more fully in your question. – S.Lott Jan 06 '11 at 21:37
  • Ah I think you have pointed me to the problem. This function is used in different parts of the script. It looks like it is normally passed a list of list of values. whereas when I call it, I am passing it a list of Comma separated values... Can someone vote for this to be closed... – skyeagle Jan 06 '11 at 21:41
  • 4
    In case you don't already know, there's a perfectly good csv module in Python: just do `import csv`. – Thomas K Jan 06 '11 at 21:44

1 Answers1

3

The problem you're encountering is that you're doing ",".join(value) with value being a string. Strings act like a collection of characters, so the command translates to "Join each character with a comma."

What you could do instead is use a tuple instead of a string for your row values you pass to printCSV, like this:

values = []

for i in range(0,5):
    row = ('A', 0, stringval, intval)
    values.append(row)
Jacob
  • 77,566
  • 24
  • 149
  • 228