C3.js从CSV中排除列 [英] C3.js exclude columns from CSV
问题描述
我通过从提供的CSV文件加载数据来创建与C3.JS的多系列线图。我可以绘制图形,但我还没有发现,如果可能只从CSV中的某些列,我的图形绘制所有CSV列。
I am creating a multiple series line graph with C3.JS by loading the data from a provided CSV file. I can plot the graph however I have not found yet if it is possible to only plot certain columns from the CSV, my graph is plotting all the CSV columns.
我的CSV看起来像这样:
My CSV look like this:
Sex,Age,L,M,S,P3,P5,P10,P25,P50,P75,P90,P95,P97
2,0,-1.298749689,34.7115617,0.046905108,31.93019666,32.25089861,32.75948527,33.65186554,34.7115617,35.85124044,36.9534983,37.65137722,38.12110271
2,0.5,-1.440271514,36.03453876,0.042999604,33.38070525,33.68743507,34.17345861,35.02508397,36.03453876,37.11806755,38.16405088,38.82535049,39.27005698
2,1.5,-1.581016348,37.97671987,0.038067862,35.48627093,35.77560367,36.23325692,37.03281566,37.97671987,38.9853304,39.95458524,40.56517149,40.97482424
2,2.5,-1.593136386,39.3801263,0.035079612,36.98550023,37.26521982,37.70685493,38.47603153,39.3801263,40.34145495,41.2606303,41.83732218,42.22321458
并且我只绘制百分位数列(P *列)的行,将Age作为X轴,并排除Sex,L,M和S列
And I which to only plot the lines for the percentiles (P* columns) columns with the Age as the X axis, and exclude the Sex, L, M and S columns from being plotted.
目前我的图形如下所示:
currently my graphs looks like this:
一个解决方案是从CSV文件中删除列,但这不可能,因为我需要其他值我希望将所有数据保存在一个文件中。
One solution is to remove the columns from the CSV file however this will not be possible as I will need the other values latter for other computations and I wish to keep all data in one file.
我的C3.js代码如下所示:
My C3.js code looks like this:
var chart = c3.generate({
data: {
x: 'Age',
url: '/data/cdc/cdc_female_hcageinf.csv',
type: 'line'
},
tooltip: {
show: false
},
point: {
show: false
}
});
我不知道是否有一个c3.js配置或方法,方法将是必要的。
I am not sure if there is a c3.js configuration or method to do so, or a javascript method will be necessary.
推荐答案
启发由@Armani我结束了这样做,这是使用d3的组合。 csv函数与c3,因为我没有找到一个方法来做它与c3的URL。
Inspired by @Armani I've ended up doing this, which is a combination of using d3.csv function with c3, as I didn´t find a way to do it with c3 URL.
- 首先我使用D3加载CSV
- 使用json对象提供C3
- 使用c3调用中的keys属性只显示我想要的字段。
d3.csv( _dataPath, function ( d ) {
var data = d;
if ( configdata.axis.x.source_units == "meses" && configdata.axis.x.units == "años" )
{
data[ configdata.axis.x.property_key ] = data[ configdata.axis.x.property_key ] / 12;
}
return data;
}, function( error, data ) {
if (!error)
{
var percentiles = [];
configdata.percentilesData.forEach( function( p ) {
percentiles.push( p.name );
});
var x_axis_label = configdata.axis.x.label + ' (' + configdata.axis.x.units + ')';
var y_axis_label = configdata.axis.y.label + ' (' + configdata.axis.y.units + ')';
var chart = c3.generate({
bindto: '#chart',
data: {
json: data,
type: 'line',
keys: {
x: configdata.axis.x.property_key,
value: percentiles
}
},
axis: {
y: {
label: y_axis_label
},
x: {
label: x_axis_label
}
},
tooltip: {
show: false
},
point: {
show: false
}
});
}
});
<script src="https://cdnjs.cloudflare.com/ajax/libs/d3/3.4.11/d3.min.js"></script>
这篇关于C3.js从CSV中排除列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!