如何将特定格式字符串转换为矩阵并以表格形式展示？

Let's break this down step by step. The key issue with your current split result is that the labels (L10, L20) are disconnected from their corresponding data sets, and the data is stored as a flat list instead of paired x/y values. Here's how to fix this and build the matrix you need:

Step 1: Restructure the Initial Split to Pair Labels with Their Data #

Instead of flattening everything into a single array, we'll first group each ;-separated block into an object that links the label to its data points. This makes it much easier to work with later.

Step 2: Convert Flat Data Lists into Paired X/Y Entries #

Each data string (like "5.0, 100, 5.5, 101, 6.0, 102") is a sequence of x-value followed by y-value. We'll split these into pairs so we can map each x to its corresponding y for each label.

Step 3: Build the Matrix Structure #

We'll first collect all unique x-values (these become the first column of your table). Then, for each x-value, we'll pull the corresponding y-value from each label's data set to fill out the rows.

Here's the complete code implementation:

const input = "5.0, 100, 5.5, 101, 6.0, 102:L10;5.0, 99, 5.5, 100, 6.0, 101:L20";

function transformToTableMatrix(input) {
  // Step 1: Split into blocks and pair each block with its label
  const labeledDataBlocks = input.split(';').map(block => {
    const [dataStr, label] = block.split(':');
    // Split data and trim whitespace from each entry
    const rawData = dataStr.split(',').map(item => item.trim());
    return { label, rawData };
  });

  // Step 2: Convert raw data into {x, y} pairs for each label
  const pairedData = labeledDataBlocks.map(({ label, rawData }) => {
    const pairs = [];
    // Iterate 2 at a time to get x/y pairs
    for (let i = 0; i < rawData.length; i += 2) {
      pairs.push({
        x: rawData[i],
        y: rawData[i + 1]
      });
    }
    return { label, pairs };
  });

  // Step 3: Collect all unique x-values (assuming all labels have the same x's)
  const xValues = pairedData[0].pairs.map(pair => pair.x);

  // Step 4: Build the matrix
  const matrix = [];

  // Add header row (empty first cell + labels)
  matrix.push(['', ...pairedData.map(block => block.label)]);

  // Add data rows: x-value followed by corresponding y-values for each label
  xValues.forEach(x => {
    const row = [x];
    pairedData.forEach(block => {
      const matchingPair = block.pairs.find(pair => pair.x === x);
      row.push(matchingPair ? matchingPair.y : ''); // Handle missing x's gracefully
    });
    matrix.push(row);
  });

  return matrix;
}

// Test the function
const resultMatrix = transformToTableMatrix(input);
console.log('Final Matrix:');
resultMatrix.forEach(row => console.log(row.join('\t')));

What This Outputs #

When you run this code, the console will print:

L10     L20
5.0     100     99
5.5     101     100
6.0     102     101

Which matches exactly the structure you're targeting (you can adjust spacing/tabs as needed for your table generation).

Key Improvements Over Your Initial Code #

• Label-Data Pairing: By keeping labels linked to their data sets, we avoid mixing up which values belong to L10 vs L20.
• Paired X/Y Values: Converting the flat list into structured pairs makes it trivial to look up the y-value for any x across labels.
• Robustness: The code handles whitespace trimming (your initial split left spaces in entries like " 100") and includes a fallback for missing x-values (though your input has consistent x's across labels).

内容的提问来源于stack exchange，提问作者Thomas Gusewelle