使用nodejs转置CSV数据

npm install csv-parser csv-writer

const fs = require('fs');
const csv = require('csv-parser');
const createCsvWriter = require('csv-writer').createObjectCsvWriter;

function transposeCSV(inputFilePath, outputFilePath) {
  const rows = [];
  const headers = [];

  fs.createReadStream(inputFilePath)
    .pipe(csv())
    .on('headers', (headerList) => {
      headerList.forEach((header) => {
        headers.push(header);
        rows.push({});
      });
    })
    .on('data', (data) => {
      headers.forEach((header, index) => {
        rows[index][header] = data[header];
      });
    })
    .on('end', () => {
      const csvWriter = createCsvWriter({
        path: outputFilePath,
        header: headers.map((header) => ({ id: header, title: header })),
      });

      csvWriter.writeRecords(rows)
        .then(() => console.log('CSV transposed successfully'))
        .catch((error) => console.error('Error transposing CSV:', error));
    });
}

module.exports = transposeCSV;

const transposeCSV = require('./transpose');

const inputFilePath = 'input.csv'; // 输入CSV文件路径
const outputFilePath = 'output.csv'; // 输出CSV文件路径

transposeCSV(inputFilePath, outputFilePath);

node index.js