Import correctly

Module 2 quiz

Practice questions: choose an answer and check it to see the explanation. Nothing here is timed or graded.

1. 1. A German export is read with the default comma delimiter and every row lands in one column. What is the likely cause?

   The file is emptyThe file uses semicolons as the delimiter because the comma is the decimal separatorpandas can't read German textThe header row is missing
   Check
2. 2. A UTF-8 file containing "José" is read as Windows-1252. What appears?

   JoséJoseJoséAn error is always raised
   Check
3. 3. How should a raw CSV be loaded so that no value changes before your rules run?

   Let the reader infer typesRead every column as text, keep the raw file untouched, then convert each column with explicit rulesOpen it in a spreadsheet and save it againRead only the columns you think you need
   Check
4. 4. A CSV field is "Smith, Jane" with quotes. A script splits each line on commas. What happens?

   One field: Smith, JaneTwo fields, shifting every later columnAn errorThe quotes are removed correctly
   Check
5. 5. Why record the file name, delivery date and row count of each import?

   For decorationProvenance: you can trace rows to a delivery and detect truncated or duplicated filesTools need itIt speeds loading
   Check
6. 6. A date column arrives as Excel serial numbers (45292). What is the safe approach?

   Treat them as amountsConvert with the documented Excel epoch and validate the resulting rangeDelete the columnRead them as text forever
   Check