Function parseCSV

src/csvLoader.js:49–78

(file)

}

export async function parseCSV(file) {
  return new Promise((resolve, reject) => {
    Papa.parse(file, {
      header: true,
      skipEmptyLines: true,
      dynamicTyping: false,
      complete(results) {
        const headers = (results.meta.fields || []).map(sanitizeHeader).filter(Boolean);
        const rows = results.data
          .map((entry) => {
            const row = {};
            headers.forEach((header) => {
              row[header] = entry[header];
            });
            return row;
          })
          .filter((row) => Object.values(row).some((value) => value !== null && value !== ""));

        resolve({
          headers,
          rows,
          columnStats: analyzeColumns(rows, headers)
        });
      },
      error(error) {
        reject(error);
      }
    });
  });
}

export function buildNumericColumnList(columnStats) {
  return columnStats.filter((column) => column.isNumeric).map((column) => column.name);