我用來papaparse讀取 csv 文件,然后將該文件轉換為對象數組。我用來react-dropzone上傳文件,然后將其轉換為對象數組。但我需要所有標題均為小寫,某些列之間沒有空格才能以數組形式存儲數據。這是我的 csv 文件| Name | Age | Data one | Data two |-------|-----|----------|----------|| John | 23 | A, B | C |-------|-----|----------|----------|| Jane | 40 | E, F | G, H |-------|-----|----------|----------|這是我的代碼:import React from "react";import Dropzone from "react-dropzone";import Papa from 'papaparse';const App = () => { const handleOnDrop = (acceptedFiles) => { // acceptedFiles is the actual file uploaded by user Papa.parse(acceptedFiles[0], { header: true, complete: (results) => { console.log(results) } }) }}OutPut:[ { Name: "John", Age: "23", Data one: "A, B", Data two: "C" }, { Name: "Jane", Age: "40", Data one: "E, F", Data two: "G, H" }]我需要的輸出是:[ { name: "John", age: "23", dataone: ["A", "B"], // Each individual data should be a string datatwo: ["C"] }, { name: "Jane", age: "40", dataone: ["E", "F"], datatwo: ["G", "H"] }]我是新手papaparse,不確定它是如何完成的
React - 使用 papaparse 將一些 csv 列轉換為數組
陪伴而非守候
2024-01-18 20:40:39