使用多列从CSV文件中过滤d3.js [英] d3.js filter from csv file using multiple columns
本文介绍了使用多列从CSV文件中过滤d3.js的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想使用来自csv的多个列值进行过滤.我首先要按城市过滤,然后再按重要性列过滤.我想过滤临界度(高/中/低).
I want to filter using multiple column values from csv. I first want to filter by city and then criticality columns. I would like to filter Criticality (high/medium/low).
如何使用AND/OR进行过滤?
How to filter using AND/OR ?
City和Criticality是复选框,根据选择,我想从相应的csv列中过滤数据.寻找有效的过滤器方法.
City and Criticality are checkboxes and based on the selections i want to filter the data from the respective csv columns. looking at efficient way of filter.
我可以给类似
(d["Criticality]=="High" || d["Criticality"]=="Low")
当前这是我在做什么:
var City="London";
var strSevText="High";
d3.csv("Status.csv", function(consdata) {
var filtercitydata = consdata.filter(function(d, i)
{
if (d["City"] == City)
{
return d;
}
})
var filtersevdata = filtercitydata.filter(function(d, i)
{
if (d["Criticality"] == strSevText)
{
return d;
}
})
})
我的CSV文件数据:
Application_Id,Application Name,Status,Name,City,Criticality
200009,OARINK,RED,Jen,London,High
200039,3000 DEALING,RED,Marc,London,High
200044,KON,RED,Martin,London,High
200067,D3 MATCHING,RED,Marc,London,Medium
200070,Next Generation,RED,Marc,London,High
200088,ONE,RED,Jonathan,London,High
200097,R-CHECK,RED,Graham,Paris,High
200097,D-CHECK-I,RED,Graham,Mumbai,Low
200107,CON,RED,Cary Fel,Paris,High
推荐答案
您可以准确地提出自己的建议:
You can write exactly what you have as a suggestion in your question:
var filteredData = consdata.filter(function(d)
{
if( d["City"] == "City") || (d["Criticality"]=="High" || d["Criticality"]=="Low")
{
return d;
}
})
这篇关于使用多列从CSV文件中过滤d3.js的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文