First off, this is annoying question and also I request everyone reading this to read fully. This is an issue faced by me alone not by anyone else.
I've a csv file as follows:
1,a
2,b
3,c
4,d
I want to modify this file using Python 3.7.2 in my Windows 7.
import csv
row = [5,'e']
with open('modify_existing.csv')as readFile:
reader= csv.reader(readFile)
lines = list(reader)
lines[3] = row
with open('modify_existing.csv','w',newline='') as writeFile:
writer = csv.writer(writeFile)
writer.writerows(lines)
print(lines)
I can assure you that except me, for all others the output is correct I don't know why my output is wrong. the newline
parameter doesn't seem to work at all.
And the annoying thing, the output I get is not consistent. I get blank lines when executing for the first time and three blank lines when executing second time. Sometime, I didn't get blank lines at all. And furthermore, I get blank lines at the first time and not the second time.
I am actually fed up with this error. I don't know where to ask this. Sorry if I am asking something that doesn't happen for you. Even for me, in my other laptop having the same Windows 7 (64 bit) with the same Python 3.7.2, no blank lines appear.
But only in my laptop it occurs. For instance, I completely deleted the Python and installed 3.7.2 again. Same result.
Could anyone please help me with this issue?
EDIT : When I print that readfile
, I get the correct output. When there are blank lines in my csv file (first or second time when it appears). I can assure you that the mistake in writing the csv file
from newline='' doesn't seem to work for me alone
No comments:
Post a Comment