how to write multiple csv files in python

Question

I need to convert excel to csv. But i can't multi write the csv file

import sys,os

sys.path.insert(0,'D:/apera/Python27/xlrd-0.9.3')

import xlrd
import csv

path = "D:/apera/Workspace/Sounding"

CSVFile1 = "D:/apera/Workspace/Sounding/sounding001.csv"
CSVFile2 = "D:/apera/Workspace/Sounding/sounding002.csv"


for root,dirs,files in os.walk(path):
    xlsfiles=[ _ for _ in files if _.endswith('.xls') ]
    for xlsfile in xlsfiles:
        wb = xlrd.open_workbook(os.path.join(root,xlsfile))
        n = len(wb.sheets())
        ws = wb.sheet_by_name("INPUT")

        with open(CSVFile1, 'wb') as csvfile:
            wr = csv.writer(csvfile, quoting=csv.QUOTE_ALL, delimiter=';')
            for rownum in xrange(ws.nrows):
                wr.writerow(list(x.encode('latin1')for x in ws.row_values(rownum)))

        with open(CSVFile2, 'wb') as csvfile:
            wr = csv.writer(csvfile, quoting=csv.QUOTE_ALL, delimiter=';')
            for rownum in xrange(ws.nrows):
                wr.writerow(list(x.encode('latin1')for x in ws.row_values(rownum)))

        csvfile.close()

This the edited question. I need to write the csv files. This is only 2 files that needs to write. So I write it two times. So is there a way to make it simpler. So I don't need to with open csvfile3, 4, 5 and so on.. Thanks

use pandas... read in as pandas.ExcelFile object, and then use DataFrame.to_csv() function to write to csv. Much easier I'd say. — Woody Pride
– Woody Pride, Commented Dec 15, 2014 at 7:22

Community · Accepted Answer · 2017-05-23 12:20:32Z

2

If your question is about how to open multiple files using the "*" wildcard, then I think you could use the glob module (as you have already mentioned):

import glob


file_names = glob.glob("*.txt")

for file_name in file_names:
    f = open(file_name, 'wb')

    f.write("AAA")

And similar question regarding the filename wildcards in python was already discussed here.

edited May 23, 2017 at 12:20

CommunityBot

11 silver badge

answered Dec 15, 2014 at 8:03

bmk

1,5689 silver badges17 bronze badges

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

Comments

sgp · Accepted Answer · 2014-12-15 09:46:11Z

0

You can do something like this (for writing to multiple csv files):

import sys,os,xlrd,csv

sys.path.insert(0,'D:/apera/Python27/xlrd-0.9.3')

path = "D:/apera/Workspace/Sounding"

files_to_write = ["D:/apera/Workspace/Sounding/sounding1.csv","D:/apera/Workspace/Sounding/sounding2.csv"] 

for root,dirs,files in os.walk(path):
    xlsfiles=[ _ for _ in files if _.endswith('.xls') ]
    for xlsfile in xlsfiles:
        wb = xlrd.open_workbook(os.path.join(root,xlsfile))
        n = len(wb.sheets())
        ws = wb.sheet_by_name("INPUT")
        for z in files_to_write:    
            with open(z, 'wb') as csvfile:
                wr = csv.writer(csvfile, quoting=csv.QUOTE_ALL, delimiter=';')
                for rownum in xrange(ws.nrows):
                    wr.writerow(list(x.encode('latin1')for x in ws.row_values(rownum)))

edited Dec 15, 2014 at 9:46

answered Dec 15, 2014 at 8:09

sgp

1,7787 gold badges17 silver badges32 bronze badges

6 Comments

user1907906 Over a year ago

Indention with one space? That's unusual.

lalalala Over a year ago

I don't mean to get all csv files. In my folder all of my files is in .xls. And i need to print all of them to csv files. So in the code have open(csvfile, 'wb'). It must open first then he can write it. So is there a way to multi open and write it?

sgp Over a year ago

Please check the edited answer. Is this what you want?

lalalala Over a year ago

not only that. The most important is csvfile = open(CSVFile, 'wb')

sgp Over a year ago

Can you please be a bit more specific as to what csv files do you want to write? Do you have a specific pattern? I tried to answer as per what I understood.

|

Collectives™ on Stack Overflow

how to write multiple csv files in python

2 Answers 2

Comments

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related