Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The above code does not give <code>csv.writer.writerows</code> input that it expects. Specifically:</p> <pre><code>resultArray = results.split('\n') </code></pre> <p>This creates a list of strings. Then, you pass each string to your writer and tell it to writerows with it:</p> <pre><code>for row in resultArray: writer.writerows(row) </code></pre> <p>But <code>writerows</code> does not expect a single string. From the docs:</p> <blockquote> <p>csvwriter.writerows(rows)</p> <p>Write all the <code>rows</code> parameters (a list of row objects as described above) to the writer’s file object, formatted according to the current dialect.</p> </blockquote> <p>So you're passing a string to a method that expects its argument to be a list of row objects, where a row object is itself expected to be a sequence of strings or numbers:</p> <blockquote> <p>A row must be a sequence of strings or numbers for Writer objects</p> </blockquote> <p>Are you sure your listed example code accurately reflects your attempt? While it certainly won't work, I would expect the exception produced to be different.</p> <p>For a possible fix - if all you are trying to do is to write a big string to a file, you don't need the <code>csv</code> library at all. You can just write the string directly. Even splitting on newlines is unnecessary unless you need to do something like replacing Unix-style linefeeds with DOS-style linefeeds.</p> <p>If you need to use the <code>csv</code> module after all, you need to give your writer something it understands - in this example, that would be something like <code>writer.writerow(['A','bunch+of','multiline','CSV,LIKE,STRING'])</code>. Note that that's a true Python list of strings. If you need to turn your raw string <code>"'A','bunch+of','multiline','CSV,LIKE,STRING'"</code> into such a list, I think you'll find the <code>csv</code> library useful as a reader - no need to reinvent the wheel to handle the quoted commas in the substring 'CSV,LIKE,STRING'. And in that case you would need to care about your dialect.</p>
    singulars
    1. This table or related slice is empty.
    1. POPython csv writer : "Unknown Dialect" Error
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USPeter DeGlopper
    1. USPeter DeGlopper
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI have added a couple of lines from the original string, if that may be of help.
      singulars
      1. PO
      1. USSpikETidE
    2. CO@SpikETidE - assuming the line breaks in your triple-quoted string are `\n` characters in the original string, and that your closing "does+not" actually has a closing `"` character separate from the `"""`, I would expect most csv-aware tools to be able to open the results of just `f.write(results)`. What cleanup do you need to apply?
      singulars
      1. PO
      1. USPeter DeGlopper
    3. COThat is exaclty the problem..! If you see the third line there is this field : "Could+not:+{"url":"/all.json?status=ongoing,scheduled,conflict","code":0,"data":"","success":false,"error":true,"cached":false,"jqXhr":{"readyState":0,"responseText":"","status":0,"statusText":"error"}}" This field has ' , ' which is the same as the delimiter between the fields within the escaping ' " '. Excel truncated this field wrongly if I use the f.write method. So I need to make this csv compliant to make it work properly.
      singulars
      1. PO
      1. USSpikETidE
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload