且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何将tsv转换为Json

更新时间:2023-02-14 10:07:52

这里有一个小代码,您可以将tsv转换为JSON。它可以帮助你...



ps:这里是typcript,但是你可以很容易的将它转换成vanilla javascript;)

  //将数据集设置为格式对象
tsvToJson(datas:string):Array< Object> {
//将每行分开
让array_datas = datas.split(/ \\\
| \r | \\\
/ g);

//将每个值分成每行
var detailed_datas = []; (var i = 0; i detailed_datas.push(array_datas [i] .split(\t))

}

//创建索引
var index = [];
var last_index =; //如果我们正在读取的索引等于,这意味着它可能是一个数组,所以我们取最后一个索引
(var i = 0; i< detail_datas [0] .length; i ++ ){
if(detailed_datas [0] [i] ==)index.push(last_index);
else {
index.push(detailed_datas [0] [i]);
last_index = detailed_datas [0] [i];
}
}

//从索引
中分离数据detail_datas.splice(0,1);

//格式数据
var formated_datas = []; (var i = 0; i< detail_datas.length; i ++){
var row = {};

for(var j = 0; j< detail_datas [i] .length; j ++){
//检查值是否为空
if(detailed_datas [i] [j]!= ){
if(typeof row [index [j]] ==object){
//它已经设置为数组
row [index [j]]。 (detailed_datas [i] [j]);
} else if(row [index [j]]!= undefined){
//已经有一个值,所以它可能是一个数组
row [index [j]] = [ row [index [j]],detail_datas [i] [j]];
} else {
//现在是空的,所以我们先说一下它是一个字符串
row [index [j]] = detailed_datas [i] [j];
}
}
}
formated_datas.push(row);
}
console.log(formated_datas); // @TODO:remove this
return formated_datas;
}


I want to make a dynamic graph based on a json file. I have seen many examples with tsv but I donot how to convert it to json. That is the part that I want to change from tsv to json but I donot know how!

d3.tsv("data/data.tsv", function(error, data) {
  data.forEach(function(d) {
    d.date = parseDate(d.date);
    d.close = +d.close;
  });

when I use

d3.json("data/data.json", function(data) {
    data.forEach(function d) { 
        d.date = parseDate(d.date);
        d.close = +d.close;
    }

});

it gives this error: Uncaught type error: cannot call method 'forEach' of undefined!

Thanks for your suggestions :)

Here a small code where you'll be able to convert tsv to json. It could help you...

ps : here is typescript, but you can easily convert it to vanilla javascript ;)

// Set bunch of datas into format object
tsvToJson(datas: string): Array<Object>{
    // Separate each lines
    let array_datas = datas.split(/\r\n|\r|\n/g);

    // Separate each values into each lines
    var detailed_datas = [];
    for(var i = 0; i < array_datas.length; i++){
        detailed_datas.push(array_datas[i].split("\t"));
    }

    // Create index
    var index = [];
    var last_index = ""; // If the index we're reading is equal to "", it mean it might be an array so we take the last index
    for(var i = 0; i < detailed_datas[0].length; i++){
        if(detailed_datas[0][i] == "") index.push(last_index);
        else {
            index.push(detailed_datas[0][i]);
            last_index = detailed_datas[0][i];
        }
    }

    // Separate data from index
    detailed_datas.splice(0, 1);

    // Format data
    var formated_datas = [];
    for(var i = 0; i < detailed_datas.length; i++){
        var row = {};
        for(var j = 0; j < detailed_datas[i].length; j++){
            // Check if value is empty
            if(detailed_datas[i][j] != ""){
                if(typeof row[index[j]] == "object"){
                    // it's already set as an array
                    row[index[j]].push(detailed_datas[i][j]);
                } else if(row[index[j]] != undefined){
                    // Already have a value, so it might be an array
                    row[index[j]] = [row[index[j]], detailed_datas[i][j]];
                } else {
                    // It's empty for now, so let's say first that it's a string
                    row[index[j]] = detailed_datas[i][j];
                }
            }
        }
        formated_datas.push(row);
    }
    console.log(formated_datas); // @TODO : remove this
    return formated_datas;
}