const fs = require('fs');

const csvData = fs.readFileSync("data.csv", "utf-8");

function parseRows(data) {
  let lines = data.split("\n");
  let headers = lines.shift().split(",");

  const out = [];
  for (const line of lines) {
    if (!line)
      continue;

    const row = line.split(",");
    const moves = [];
    for (let i = 0; i <= 7; i++) {
      let step = row[headers.indexOf(`step_${i}_moves`)];
      step = step.replace(/^[xyz]2 /, "");

      moves.push(step);
    }

    out.push({
      scramble: row[headers.indexOf("scramble")],
      moves: moves.join(" ")
    });
  }
  return out;
}

console.log(JSON.stringify(parseRows(csvData)));