Un fichier CSV écrit avec Python a des lignes vides entre chaque ligne
Source : Stack Overflow [windows]
The csv.writer module directly controls line endings and writes \r\n into the file directly. In Python 3 the file must be opened in untranslated text mode with the parameters 'w', newline='' (empty string) or it will write \r\r\n on Windows, where the default text mode will translate each \n into \r\n.
#!python3
with open('/pythonwork/thefile_subset11.csv', 'w', newline='') as outfile:
writer = csv.writer(outfile)
If using the Path module:
`from pathlib import Path
import csv
with Path(‘/pythonwork/thefile_subset11.csv’).open(‘w’, newline=‘’) as outfile:
writer = csv.writer(outfile)
If using the `StringIO` module to build an in-memory result, the result string will contain the translated line terminator:
from io import StringIO
import csv
s = StringIO()
writer = csv.writer(s)
writer.writerow([1,2,3])
print(repr(s.getvalue())) # ‘1,2,3\r\n’ (Windows result)
If writing that string to a file later, remember to use `newline=''`:
built-in open()
with open(‘/pythonwork/thefile_subset11.csv’, ‘w’, newline=‘’) as f:
f.write(s.getvalue())
Path’s open()
with Path(‘/pythonwork/thefile_subset11.csv’).open(‘w’, newline=‘’) as f:
f.write(s.getvalue())
Path’s write_text() added the newline parameter to Python 3.10.
Path(‘/pythonwork/thefile_subset11.csv’).write_text(s.getvalue(), newline=‘’)
In **Python 2**, use binary mode to open `outfile` with mode `'wb'` instead of `'w'` to prevent Windows newline translation. Python 2 also has problems with Unicode and requires other workarounds to write non-ASCII text. See the Python 2 link below and the `UnicodeReader` and `UnicodeWriter` examples at the end of the page if you have to deal with writing Unicode strings to CSVs on Python 2, or look into the 3rd party [unicodecsv](https://pypi.org/project/unicodecsv/) module:
#!python2
with open(‘/pythonwork/thefile_subset11.csv’, ‘wb’) as outfile:
writer = csv.writer(outfile)
Documentation
*(Réponse tronquée)*