write two values to csv row in python

Question

So I have a solved problem, but I don't like the solution :)

with open(outfile, 'a') as file:
    writer = csv.writer(file) #opens a csv writer
    #inserts ID to front of wordList
    wordList.insert(0,ID)
    writer.writerow(wordList)
    #removes ID
    wordList.remove(ID)

Right now it successfully writes an ID and a list of words into csv form (as far as I can tell-- I don't actually have excel on my computer). The part I don't like is that I have to insert and remove the ID, because I don't want it included later. This seems lame. Can I somehow do a double insert to the same row, easily?

I tried:

 writer.writerow([ID,wordList])

but it gave undesirable square brackets

This is for 2.7, if that matters! Thanks !

Hugh Bothwell · Accepted Answer · 2012-07-27 03:41:12Z

2

writer.writerow([ID] + wordList)

or

from itertools import chain

writer.writerow(chain([ID], wordList))

answered Jul 27, 2012 at 3:41

Hugh Bothwell

57k9 gold badges91 silver badges103 bronze badges

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

2 Comments

Ronald Dregan Over a year ago

I know in this situation these would function the same, but is there an advantage (performance or otherwise) that would make one better than the other for a larger scale? Thanks!

Lenna Over a year ago

itertools.chain will concatenate an arbitrary number of sequences doc.

BrenBarn · Accepted Answer · 2012-07-27 03:41:01Z

1

You could do writer.writerow([ID] + wordList).

answered Jul 27, 2012 at 3:41

BrenBarn

253k39 gold badges421 silver badges392 bronze badges

1 Comment

Ronald Dregan Over a year ago

Python never lets me down, neither does Stack Overflow!

cdtits · Accepted Answer · 2012-07-27 03:43:21Z

1

You can try as follow:

writer.writerow([ID] + wordlist)

answered Jul 27, 2012 at 3:43

cdtits

1,1286 silver badges7 bronze badges

1 Comment

Ronald Dregan Over a year ago

Great! I knew there was some python semantic wizardry that would do this

Collectives™ on Stack Overflow

write two values to csv row in python

3 Answers 3

2 Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related