JavaScript中的CSV数据的数据操作（填充，最小，最大）？-Dataoperations(fill,min,max)onCSVdatainJavaScript?

2  

Lets Assume that you have the CSV data in a 2d array:

让我们假设你有一个2d数组的CSV数据:

var data = [[AF,1800,3280000],
[AF,1820,3280000],
[AF,1870,4207000],
[AG,1800,37000],
[AG,1851,37000],
[AG,1861,37000]]

For this example I will use jQuerys utility functions as it will make the job a lot easier without any real overhead.

对于这个例子,我将使用jQuerys实用程序函数,因为它将使工作更容易,没有任何实际开销。

// we will loop thru all the rows
// if the id does not belong to the entities then we will add the property.
// if the property does exist then we update the values

var entities = {}
$.each(data, function (i, n) {

    // set property
    if (!entities[n[0]]) {
        entities[n[0]] = {
            data : {
                n[1]: n[2]
            },
            entity_meta: {
                start: n[1],
                end: n[1]
                min: n[1]
                max: n[1]
            }
        }

    // update property
    } else {

        // add new data property
        entities[n[0]]['data'][n[1]] = n[2];

        // if the property should change then update it
        if ( entities[n[0]]['entity_meta']['min'] > n[1] ) {
             entities[n[0]]['entity_meta']['min'] = n[1];
        }
    }
});

That obviously isn't all the code but it should explain clearly the approach that should be taken.

这显然不是所有的代码,但它应该清楚地解释应该采取的方法。

Also not that your intended final object structure is very much over complicated you should really use arrays where appropriate, especially for entities and data.

也不是说你想要的最终对象结构非常复杂,你应该在适当的地方使用数组,特别是对于实体和数据。

1  

Use jQuery AJAX to get the CSV file.

使用jQuery AJAX获取CSV文件。

$.get("test_csv.csv", function(result){
    csvParseAndCalc(result);
});

Use a simple Javascript to parse the CSV and perform the calculations

使用简单的Javascript来解析CSV并执行计算

// assumes your sample data is how all data will look
// proper csv parsing (by the spec) is not used is favor is speed
function csvParseAndCalc(result) {
var entities = {};
var indicator_meta = {"start":null, "end":null, "min":null, "max":null};
var rows = result.split('\n'); //your data doesnt need proper (to spec) csv parsing
// run calculations ignore header row
for(var i=1; i yr) emeta.start = yr;
    if(emeta.end == null || emeta.end  val) emeta.min = val;
    if(emeta.max == null || emeta.max  yr)
        indicator_meta.start = yr;
    if(indicator_meta.end==null || indicator_meta.end  val)
        indicator_meta.min = val;
    if(indicator_meta.max==null || indicator_meta.max