1. Learn
  2. /
  3. Courses
  4. /
  5. Importing Data in Java

Connected

Exercise

Handling CSV parsing options

The employee performance file has "N/A" values from manual data entry errors. If not handled during import, these will be treated as text strings instead of missing values, causing incorrect column types and broken calculations. Properly identifying missing value indicators upfront saves hours of debugging later.

The Table and CsvReadOptions classes have been imported for you.

Instructions

100 XP
  • Print the structure of defaultParsing.
  • Load the file as customParsing with "N/A" handled as missing.
  • Print the structure of customParsing.