Formatting data to .csv using python

Question

I have the following string

string = "First Name | Last Name | Age"

when I print it looks like this:

First Name | Last Name | Age

When I print to csv file

writer.writerow(datac[0])

looks like this:

F, i, r, s, t and so on...

How do I get to to print in single row? like this

Row1 

First Name | Last Name | Age

Are First Name, Last Name, and Age supposed to be separate columns? — Matthew Adams
– Matthew Adams, Commented Nov 1, 2012 at 20:03

recursive · Accepted Answer · 2012-11-01 18:56:02Z

2

writer.writerow() is expecting a sequence. Since strings are sequences of characters, it's being interpreted that way.

If your row contains only a single element, you could indicate that like this: writer.writerow([datac[0]]) or writer.writerow(datac[0:1])

answered Nov 1, 2012 at 18:56

recursive

86.5k36 gold badges155 silver badges246 bronze badges

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

2 Comments

Steven Rumbalski Over a year ago

This is correct, but possibly missing something. The very last line of his question shows that he may be expecting to write three (pipe delimeted?) columns, not one. (Incidentally, a csv file with one column doesn't need a separator.) If datac contains three items, what he really needs would be writer.writerow(datac).

Steven Rumbalski Over a year ago

If pipe-delimited is desired, pass the delimiter to the csv writer constructor: writer = csv.writer(a_file, delimiter='|')

anijhaw · Accepted Answer · 2012-11-01 19:10:40Z

1

writer.writerow() expects a sequence and when you give it a string it treats it as a sequence of charecters. Try doing this.

writer = csv.writer(csvfile, delimiter=' ')
string = "First Name | Last Name | Age"
writer.writerow(string.split('|'))

edited Nov 1, 2012 at 19:10

answered Nov 1, 2012 at 19:00

anijhaw

9,4927 gold badges37 silver badges37 bronze badges

1 Comment

recursive Over a year ago

Unless you set your csv separator as '|', this will output using commas as delimiters, which seems to be different from what is desired.

Collectives™ on Stack Overflow

Formatting data to .csv using python

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related