CODEWITHSUNDEEP
pythonexport-to-csv
user3634601
user3634601

Reputation: 137

How to create a csv file in Python, and export (put) it to some local directory

This problem may be tricky.

I want to create a csv file from a list in Python. This csv file does not exist before. And then export it to some local directory. There is no such file in the local directory either. We just create a new csv file, and export (put) the csv file in some local directory.

I found that StringIO.StringIO can generate the csv file from a list in Python, then what are the next steps.

Thank you.

And I found the following code can do it:

import os
import os.path
import StringIO
import csv

dir = r"C:\Python27"
if not os.path.exists(dir):
    os.mkdir(dir)

my_list=[[1,2,3],[4,5,6]]

with open(os.path.join(dir, "filename"+'.csv'), "w") as f:
  csvfile=StringIO.StringIO()
  csvwriter=csv.writer(csvfile)
  for l in my_list:
          csvwriter.writerow(l)
  for a in csvfile.getvalue():
    f.writelines(a)

Upvotes: 8

Views: 50620

Answers (2)

corvid
corvid

Reputation: 11187

import csv

with open('/path/to/location', 'wb') as f:
  writer = csv.writer(f)
  writer.writerows(youriterable)

https://docs.python.org/2/library/csv.html#examples

Upvotes: 4

David
David

Reputation: 2620

Did you read the docs?

https://docs.python.org/2/library/csv.html

Lots of examples on that page of how to read / write CSV files.

One of them:

import csv
with open('some.csv', 'wb') as f:
    writer = csv.writer(f)
    writer.writerows(someiterable)

Upvotes: 3

Related Questions