Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

Un fichier CSV écrit avec Python a des lignes vides entre chaque ligne

ayi

ayi_2

The <code>csv.writer</code> module directly controls line endings and writes <code>\r\n</code> into the file directly. In Python 3 the file must be opened in untranslated text mode with the parameters <code>'w', newline=''</code> (empty string) or it will write <code>\r\r\n</code> on Windows, where the default text mode will translate each <code>\n</code> into <code>\r\n</code>.
<pre><code class="lang-auto">#!python3
with open('/pythonwork/thefile_subset11.csv', 'w', newline='') as outfile:
writer = csv.writer(outfile)

</code></pre>
If using the <code>Path</code> module:
from pathlib import Path import csv with Path(‘/pythonwork/thefile_subset11.csv’).open(‘w’, newline=‘’) as outfile: writer = csv.writer(outfile) <pre><code class="lang-auto"> If using theStringIO` module to build an in-memory result, the result string will contain the translated line terminator:

</code></pre>
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)
<pre><code class="lang-auto">
If writing that string to a file later, remember to use newline='':

</code></pre>
<h1><a name="p-16770-built-in-open-1" class="anchor" href="#p-16770-built-in-open-1" aria-label="Heading link"></a>built-in open()</h1>
with open(‘/pythonwork/thefile_subset11.csv’, ‘w’, newline=‘’) as f: 
f.write(s.getvalue())
<h1><a name="p-16770-paths-open-2" class="anchor" href="#p-16770-paths-open-2" aria-label="Heading link"></a>Path’s open()</h1>
with Path(‘/pythonwork/thefile_subset11.csv’).open(‘w’, newline=‘’) as f: 
f.write(s.getvalue())
<h1><a name="p-16770-paths-write_text-added-the-newline-parameter-to-python-310-3" class="anchor" href="#p-16770-paths-write_text-added-the-newline-parameter-to-python-310-3" aria-label="Heading link"></a>Path’s write_text() added the newline parameter to Python 3.10.</h1>
Path(‘/pythonwork/thefile_subset11.csv’).write_text(s.getvalue(), newline=‘’)
<pre><code class="lang-auto">
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 module:

</code></pre>
#!python2 
with open(‘/pythonwork/thefile_subset11.csv’, ‘wb’) as outfile: 
writer = csv.writer(outfile)
<pre><code class="lang-auto">
Documentation

(Réponse tronquée)</code></pre>