How to combine multiple csv files into one python

Question

Problem:

Hello guys, I have a big number of .csv file with full of data. I want to merge them all in a single file. It is a hectic job to copy all the data from each and compile into one single file. So, I am willing to combine multiple .csv files into one using a python program. Could anybody please help me to do it.

Thanks for your effort guys.

Note: I named all the .csv files under a series. Let say they are named with data1-data100

Answer 1

Let me assume, you want to merge all the data from other files into the first file data1.csv file. So, you need to open the first file and then copy all the data from others and gather it into the first file.

fout=open("out.csv","a")
for line in open("data1.csv"):
    fout.write(line)
for num in range(2,100):
    f = open("data"+str(num)+".csv")
    f.next()
    for line in f:
         fout.write(line)
    f.close()
fout.close()

GIve it a try and leave a comment below my answer if you have not overcome the problem.
Thanks