How to merge similar csv files wihtout opening?

Question

i have done a lot of research but i was unable to find an answer.

I have several similar CSV files without headers. I Would like to merge them but in the fastest possible way, if possible without opening the files and reading them.

I m looking for that, but in Python 2.7, the equivalen of the cmd(MS DOS) copy command:

copy *.csv output.csv

The best solution of mny problem would be some kind of command like

copy path/file1.csv .. path/file2.csv output.csv

output.csv would be the result of merging.

all csv are similar.

Thanks in advance!

How can you create a file without writing it? If you must write it, then how do you know what to write without reading it? — Cuadue, Jun 02 '15 at 00:11

score 0 · Answer 1 · edited May 23 '17 at 12:30

0

The best way may just be to call the command line rather than use python's file operation functions. Check this answer for info on how to do it:

https://stackoverflow.com/a/92395/4963066

edited May 23 '17 at 12:30

Community

1
1

answered Jun 01 '15 at 23:22

Eric

236
3
7

Thank you. I found the answer. Import os os.system("copy *.csv output.csv") – kaloapi15 Jun 02 '15 at 07:19

How to merge similar csv files wihtout opening?

1 Answers1