Dec-07-2022, 08:11 AM
Hi Team,
I want to merge two csv files, data1.csv and data2.csv , and create Output.csv
via command line this script works.
copy /b D:\output\data\data1.csv+D:\output\data\data2.csv D:\output\data\output.csv
how to achieve above code via python.
below is attempted code.
I want to merge two csv files, data1.csv and data2.csv , and create Output.csv
via command line this script works.
copy /b D:\output\data\data1.csv+D:\output\data\data2.csv D:\output\data\output.csv
how to achieve above code via python.
below is attempted code.
import subprocess from pathlib import Path import shlex src1 = str(Path("D:\output\data\data1.csv")) src2 = str(Path("D:\output\data\data2.csv")) output = str(Path("D:\output\data\output.csv")) CMD = "copy /b D:\\output\\data\\header.csv+D:\\output\\data\\data.csv D:\\output\\data\\output.csv" args = shlex.split(CMD) print(args) subprocess.run(["scp", "copy", "/b",src1+src2, output]) subprocess.run(["scp", "copy","/b", "D:\\output\\data\\data1.csv"+"D:\\output\\data\\data2.csv", "D:\\output\\data\\output.csv"])