Using the csv module

Question

I am using the csv module to create a file then write to it. However, nothing is being written to the .csv file.

Here is my code:

import csv
with open('eggsandham.csv', 'wb') as csvfile:
    spamwriter = csv.writer(csvfile, delimiter=' ',
                            quotechar='|', quoting=csv.QUOTE_MINIMAL)
    spamwriter.writerow(['Spam'] * 5 + ['Baked Beans'])
    spamwriter.writerow(['Spam', 'Lovely Spam', 'Wonderful Spam'])

Does anyone know why this is happening?

A more descriptive title would be nice!

dorvak
– dorvak

2014-04-24 08:42:16 +00:00
Commented Apr 24, 2014 at 8:42 — dorvak
– dorvak, Commented Apr 24, 2014 at 8:42

paarth batra · Accepted Answer · 2014-04-24 03:33:46Z

1

in my case this code is working and writing to a csv file in current directory . Output or file is :

May be try giving absolute path

answered Apr 24, 2014 at 3:33

paarth batra

1,4125 gold badges32 silver badges54 bronze badges

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

Comments

vamosrafa · Accepted Answer · 2014-04-24 05:57:42Z

1

I wrote this code:

>>> with open('/host/rk/Python27/eggsandham.csv', 'wb') as csvfile:
...     spamwriter = csv.writer(csvfile, delimiter = ' ',quotechar = '|', quoting = csv.QUOTE_MINIMAL)
...     spamwriter.writerow(['Spam'] * 5 + ['Baked Beans'])
...     spamwriter.writerow(['Spam', 'Lovely Spam','Wonderful Spam'])

It produces output like this:

Spam Spam Spam Spam Spam |Baked Beans|
Spam |Lovely Spam| |Wonderful Spam|

in the.csv file

answered Apr 24, 2014 at 5:57

vamosrafa

6955 gold badges12 silver badges35 bronze badges

Collectives™ on Stack Overflow

Using the csv module

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related