How to read some csv files in a folder in python

Question

There are 40 csv files; file1.csv, file2.csv. ..., file40.csv in a folder called pathImage. I want to read them, and put them in another csv file sequentially that we called 'output.csv'. The following code does not work for me.

im_list=[]
for i in pathImage:
    f= open(i, 'rb') 
    reader = csv.reader(f, delimiter=',')
    header = reader.next()
    zipped = zip(*reader)
    for j in zipped[0]:       #zipped[0] is the name of images
        im_r=misc.imread("%s.png" %j)
        im_list.append(im_r)

I already read the previous questions, but I do not know how can I put them into another csv file?

I appreciate any help

A.P. · Accepted Answer · 2015-07-24 22:47:26Z

0

import pandas as pd
df = pd.concat([pd.read_csv('file%d.csv' % x) for x in range(1,41)])
df.to_csv('output.csv')

answered Jul 24, 2015 at 22:47

A.P.

1,1449 silver badges6 bronze badges

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

Collectives™ on Stack Overflow

How to read some csv files in a folder in python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related