更新时间: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;
}