javascript - Removing rows when reading data D3 - Stack Overflow

admin管理员组

文章数量:1308570

Say I have a sample file sample.csv:

row,col,value
1,1,2
1,2,3
1,3,NA

When reading data in d3 you do something like:

d3.csv("sample.csv", function(data) {
    data.forEach(function(d) {
    d.value = +d.value;
});

However, for the NA value +d.value will return NaN. How can I exclude NaN values from my data. i.e. read the data, and only take rows which have a number value

Thanks!

Say I have a sample file sample.csv:

row,col,value
1,1,2
1,2,3
1,3,NA

When reading data in d3 you do something like:

d3.csv("sample.csv", function(data) {
    data.forEach(function(d) {
    d.value = +d.value;
});

However, for the NA value +d.value will return NaN. How can I exclude NaN values from my data. i.e. read the data, and only take rows which have a number value

Thanks!

• javascript
• csv
• d3.js

Share Improve this question Follow asked Oct 16, 2012 at 19:38 Omar WagihOmar Wagih 8,74477 gold badges6464 silver badges7575 bronze badges

Add a ment  | 

1 Answer 1

Sorted by: Reset to default 9

You can call isNaN on the data before you try to add it:

d3.csv('sample.csv', function(data) {
    data = data.filter(function(d){
        if(isNaN(d.value)){
            return false;
        }
        d.value = parseInt(d.value, 10);
        return true;
    });
});

This assumes your numbers will all be base-10 integers.

本文标签： javascriptRemoving rows when reading data D3Stack Overflow