如何将我的json结构转换为C3.js所需的列结构

这里有一个输入数据的转换函数。您不需要在每个数据集中输入每个日期。您也不需要输入每个日期的每个属性。

// provide the "data" attribute value (input.value) of your object to the function
console.log(convert(input.data));
function convert(input) {
    var data = {};
    var listOfAllColumnNames = {};
    // go through all the data and store it in this structure:
    // data = { "dateValue": { "key1": 1, "key2": 2 } }
    // it also saves a list of all column names for further processing
    for(var key in input) {
        if(input.hasOwnProperty(key)) {
            var dataset = input[key];
            listOfAllColumnNames[key] = true;
            for(var i = 0; i < dataset.length; i++) {
                if(!data.hasOwnProperty(dataset[i].Date)) {
                    data[dataset[i].Date] = {};
                }
                data[dataset[i].Date][key] = dataset[i].Amount;
            }
        }
    }
    // uses the list of all column names to check if the data structure has
    // the required columns in every date. if one is missing, null is added
    listOfAllColumnNames = Object.keys(listOfAllColumnNames);
    for(var dateKey in data) {
        if(data.hasOwnProperty(dateKey)) {
            for(var m = 0; m < listOfAllColumnNames.length; m++) {
                if(!data[dateKey].hasOwnProperty(listOfAllColumnNames[m])) {
                    data[dateKey][listOfAllColumnNames[m]] = null;
                }
            }
        }
    }
    // the dates may be sent in a random order, c3.js however displays the
    // columns in the given order. therefore, the dates are ordered here
    var temporaryDates = [];
    for(var date in data) {
        if(data.hasOwnProperty(date)) {
            temporaryDates.push(date);
        }
    }
    temporaryDates.sort(function(a, b) {
        return new Date(a) - new Date(b);
    });
    // the final data structure consists of a nested array with the first
    // column being the date column. While looping through the attributes of
    // the data, it needs to be checked, if the attributes are already (from
    // a previous date) are in the resulting column list
    var columns = [['Date']];
    for(var j = 0; j < temporaryDates.length; j++) {
        columns[0].push(temporaryDates[j]);
        for(var columnName in data[temporaryDates[j]]) {
            var index = -1;
            // check if the attribute is already in the resulting data structure
            for(var k = 1; k < columns.length; k++) {
                if(columns[k][0] === columnName) {
                    index = k;
                    break;
                }
            }
            // if the attribute is not yet in the resulting data structure, create a new column
            if(index === -1) {
                columns.push([columnName]);
                index = columns.length - 1;
            }
            columns[index].push(data[temporaryDates[j]][columnName]);
        }
    }
    return columns;
}