メインコンテンツにスキップ
eLearner.app
モジュール 8 · レッスン 2 / 4コース内の 30/32~15 min
モジュールのレッスン (2/4)

課題: CSV パーサー

The CSV format (Comma-Separated Values) is everywhere: exports from Excel, database dumps, output from command-line tools. Parsing it is a small challenge that combines split, map, destructuring, and object construction.

The format

A minimal CSV is a multi-line string: the first row is the header (column names), then one row per record with fields separated by commas.

Code
nome,eta,citta
Alice,30,Roma
Bob,25,Milano

The classic goal is to turn it into an array of objects:

JS
[
  { nome: 'Alice', eta: '30', citta: 'Roma' },
  { nome: 'Bob', eta: '25', citta: 'Milano' },
];

The 3-step recipe

  1. Split the string by lines: csv.split('\n')
  2. Extract the header row: the first line, split by comma
  3. Map each remaining line to an object, pairing each field with the matching header
JS
function parseCSV(csv) {
  const righe = csv.split('\n');
  const intestazione = righe[0].split(',');
  return righe.slice(1).map((riga) => {
    const campi = riga.split(',');
    const record = {};
    intestazione.forEach((nome, i) => {
      record[nome] = campi[i];
    });
    return record;
  });
}

More modern alternatives:

JS
const record = Object.fromEntries(intestazione.map((nome, i) => [nome, campi[i]]));

Converting types

Parsed fields are always strings. If you know that some columns are numbers:

JS
record.eta = Number(record.eta);

Or write a small "schema":

JS
const numeriche = new Set(['eta', 'prezzo']);
intestazione.forEach((nome, i) => {
  const v = campi[i];
  record[nome] = numeriche.has(nome) ? Number(v) : v;
});

Try it

運動#js.m8.l2.e1
試行回数: 0読み込み中…

Define `parseCSV(csv)` that takes a CSV string (first row = header, commas as separator). Return an array of objects with the header keys. All values stay as strings. Ignore empty rows.

エディターを読み込み中…
ヒントを表示

split on newline, first row = header, map over the rest, Object.fromEntries.

3 回の試行後に解決策が利用可能になります

Review exercise

運動#js.m8.l2.e2
試行回数: 0読み込み中…

Define `columnMean(csv, columnName)` that parses the CSV, converts the column values to numbers, and returns their mean (a number). If there are no data rows return 0.

エディターを読み込み中…
ヒントを表示

Find the column index, map rows → Number, reduce to sum, divide by length.

3 回の試行後に解決策が利用可能になります