gpt4 book ai didi

csv - D3 时间轴 CSV 数据

转载 作者:行者123 更新时间:2023-12-02 03:20:46 26 4
gpt4 key购买 nike

我正在使用 d3 Timeline 插件 ( https://github.com/jiahuang/d3-timeline ),我终于得到了可视化可以读取我的数据的地方。但是,我现在需要使特定学生的所有条目都显示在同一行上。该可视化项当前正在分别显示每个条目。

CSV 数据如下所示:

Start,End,Student,Event Type,tooltip
2015-May-27 20:08:15,2015-May-27 20:08:21,Student 338,Pretest,Student 338 spent 00:00:06 on Biological Chemistry test. Student scored 100%.
2015-May-27 20:08:21,2015-May-27 20:08:30,Student 338,Learning Path,Student 338 spent 00:00:09 on Biological Buffers Website.
2015-May-27 20:08:30,2015-May-27 20:08:34,Student 338,Learning Path,Student 338 spent 00:00:04 on Organic Molecules Textbook.
2015-May-27 20:08:34,2015-May-27 20:08:36,Student 338,Learning Path,Student 338 spent 00:00:03 on Nucleic Acid Structure and Function Textbook 2.

可视化文件如下所示:

<script type="text/javascript">
window.onload = function() {

var width = 800;
var height = 700;


var parseDate = d3.time.format("%Y-%b-%d %H:%M:%S").parse; //With parseDate, I define what my time data looks like for d3
d3.csv("https://dl.dropboxusercontent.com/u/42615722/LeaP/biology-course2.csv", function(d){
return {
label : d.Student,
eventType: d["Event Type"],
times:[{"starting_time" : parseDate(d.Start),
"ending_time" : parseDate(d.End)}], //the timeline plugin is looking for a times array of objects with these keys so they must be defined.
info: d.tooltip
};
}, function(data) {
console.log(data);


function timelineRect() {

var colorScale = d3.scale.ordinal().range(['#ed5565','#ffce54','#48cfad','#5d9cec','#ec87c0','#ac92ec','#4fc1e9','#fc6e51','#a0d468','#656d78'])
.domain(['Pretest','Learning Path','Supplemental Info','Questions','Test Me','Remedial Page','Search Query','Recommended Reading','Search Results','Practice Questions']);
var chart = d3.timeline()
.colors( colorScale )
.colorProperty('event_type')
.rotateTicks(45)
.stack(); //necessary to unstack all of the labels

var svg = d3.select("#timeline1").append("svg").attr("width", width)
.datum(data).call(chart);
}
timelineRect();

});

}
</script>
</head>
<body>

<div>
<div id="timeline1"></div>
</div>

</body>

没有一个示例为此定义域,不幸的是,所有示例数据都以数组形式给出,而不是来自 CSV。如何定义数据,使具有相同学生标签的每个条目都出现在同一时间轴行中?

最佳答案

问题1

您没有对您的 csv 数据进行分组,可以这样做:我的意思是

//this will do the grouping
var k = d3.nest()
.key(function(d) {
return d.label;
}).entries(data);
var b = [];
//this will make it in the format expected by d3 time line
k.forEach(function(d) {
var ob = {};
ob.label = d.key;
ob.times = [];
b.push(ob);
d.values.forEach(function(v) {
ob.times.push(v.times);//collecting all the times
});
ob.times = [].concat.apply([], ob.times);
});

问题2

您必须定义刻度格式

  .tickFormat({
format: d3.time.format("%d-%m"),
tickTime: d3.time.day,
tickInterval: 20,
tickSize: 6
})

请参阅 d3 时间 format

你的数据集在几秒钟内非常接近,所以矩形变得非常小..:(我尽了我的水平最好地跨越它..祝你好运:)

工作代码 here

希望这对您有所帮助!

关于csv - D3 时间轴 CSV 数据,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/33575451/

26 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com