CSV rules

Questions 1 to 5 of 7

1. 1. How many fields does csv.reader return for the row Ravi,"likes tea, not coffee",78?

   2453
2. 2. Which text is the correct CSV way to write the value Said "thanks" as one field?

   "Said \"thanks\""Said ""thanks"""Said ""thanks""""Said "thanks""
3. 3. A spreadsheet shows 1234 in a cell whose file row is Ravi,01234. Why?

   The quotes in the file removed the zeroThe spreadsheet read 01234 as a number and dropped the leading zeroThe CSV reader dropped the zero when it split the rowThe file itself stored 1234, so the zero was never there
4. 4. Which argument tells csv.reader that the fields are separated by semicolons?

   sep=";"split=";"newline=";"delimiter=";"
5. 5. True or false: a quoted CSV field can contain a line break, and csv.reader still returns the whole field as one value in one row.

   False, because a line break always ends a CSV rowTrue, because the reader keeps reading until the closing quote