writing to csv from cursor.fetchall() in python

Question

i am trying to write fetchall result to csv file using writerow, using sqlite3 package of python

import sqlite3
import time,csv
s=time.time()
con = sqlite3.connect("dreamtool.db")
cur = con.cursor()

cur.execute("select * from result3")
result = cur.fetchall()

c = csv.writer(open("temp.csv","wb"))
c.writerow(result)

e=time.time()

con.close()
print(e-s)

i am getting error as a bytes-like object is required, not 'str'

M Z · Accepted Answer · 2020-08-07 21:08:42Z

3

Use:

c = csv.writer(open("temp.csv","w"))
c.writerows(result)

To have the mode as "wb" means you want to write byte-level information, which is not what you have.

edited Aug 7, 2020 at 21:08

answered Aug 7, 2020 at 21:03

M Z

4,8392 gold badges15 silver badges28 bronze badges

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

4 Comments

anonymous_coder Over a year ago

the data is being added to the right side of previous cell, is there any way to avoid that? writerow is writing whole data into single row

M Z Over a year ago

I've updated it to use writerows, missed the fact you're using fetchall, take a crack at it now

anonymous_coder Over a year ago

how can i add column names while creating csv file

M Z Over a year ago

have a single c.writerow(listOfColumnNames) before you call c.writerows(result)

Collectives™ on Stack Overflow

writing to csv from cursor.fetchall() in python

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related