title: Long rows get split while writing in csv file in Python
body: <p>I am using the following code to write a csv file in python:             </p>
  
  <pre><code>with open('..\Test.csv', 'w', newline='') as dest:
      writer = csv.writer(dest,dialect='excel')
      # header line
      writer.writerow(['ImageId', 'Class', 'WKT'])
      writer.writerow([image_name, int(c), prediction])
  </code></pre>
  
  <p>The problem in this case is the variable prediction contains a large string containing words and special characters, as a result of which the entire row gets truncated at some point and starts from a new row in the csv format. The new row contains a double quote at the end as well as now each word in the second row is entered into separate columns.</p>
  
  <p>Can someone please suggest what am I doing wrong here?</p>