Trying to copy one CSV data to another CSV file

Question

I have 2 CSV files, say 'a.csv' and 'b.csv'. I want to copy the data of 'a.csv' into 'b.csv'. The whole of 'a.csv' data should be added at the end of the 'b.csv'

import csv
ifile = open('/Users/avtarsingh/Downloads/StocksProject-master/data/nasdaq.csv', 'w', newline='')
read = csv.reader(ifile)
writer = csv.writer(ifile)
for row in ifile.readlines():
    writer.writerow(['Avtar'])
    print(row)
ifile.close()

=================================================================

New Code:-

with open('/Users/avtarsingh/Downloads/StocksProject-master/data/procter.csv', 'r') as f:
    # f = list(f)
    for row in f:
        print(row)
time.sleep(2)
with open('/Users/avtarsingh/Downloads/StocksProject-master/data/sp.csv', 'r') as g:
    for row1 in g:
        # g.writerow(f)
        print(row1)
with open('/Users/avtarsingh/Downloads/StocksProject-master/data/nasdaq.csv', 'w') as h:
    writer = csv.writer(h)
    writer.writerows(f)

You open file in *write* mode and trying to read and then write at the same time. Smells bad. — vishes_shell, Dec 12 '17 at 07:26
What you're doing doesn't appear to be "copying" files. What is it you're trying to achieve? — cs95, Dec 12 '17 at 07:45
You could use the copy function in the shutil module. https://stackoverflow.com/questions/123198/how-do-i-copy-a-file-in-python — chrisfs, Dec 20 '17 at 06:40

chrisfs · Answer 1 · 2017-12-20T06:34:44.497

There's a few things that appear to be wrong here. You may want to review the docs for the CSV module. There are likely to be some good examples you can follow.

First, in line 2, if that is the data file that you want to read in, then you need to open it in read mode 'r', not write mode 'w'.

Then depending on how you approach, you will want to open a second file in write mode , 'w'. This is your target file , the file you are copying the data to.

Consult csv module and file opening docs and try again using the suggestions above. If you have problems ask again, giving specific error messages or problems you are encountering and people will be happy to help.

No documentation didn't solve my problem. Let me describe once more : — S...R... T, Dec 12 '17 at 10:28

Trying to copy one CSV data to another CSV file

1 Answers1