how to parse csv by csv-jQuery and generate report?

Question

imagine that you have csv data like this that I can read them from a textarea on my web page:

A,10,USA
B,5,UK
A,2,USA

I am trying to use cs-jQuery to parse and process this data to get the following report:

A has ran 12 miles with average of 6. 
B has ran 5 miles with average of 5.

The code that I have written looks like this:

<script>
$(document).ready(function() {
    $('#calculate').click(function() {
        $('#report').empty();
        var data = $('#input').val();
        var values = $.csv.toObjects(data);
        $('#report').append(values);
        alert(values);
    });
});
</script>

but all I am getting is [object Object] [object Object]... any suggestion on what I should do? any way to do this with jQuery functionality?

Because values is an array of objects.

dfsq
– dfsq

2013-03-18 15:29:19 +00:00
Commented Mar 18, 2013 at 15:29 — dfsq
– dfsq, Commented Mar 18, 2013 at 15:29

Evan Plaice · Accepted Answer · 2016-01-21 14:53:47Z

2

this function $.csv.toObjects() return array of objects

Useful for parsing multi-line CSV data into an array of objects representing data in the form {header:value}. Unless overridden, the first line of data is assumed to contain the headers.

You don't have header so you should use $.csv.toArrays() instead and iterate over that array:

$.each($.csv.toArrays(data), function(_, row) {
   $('#report').append('<div>' + row[0] + ' has ran ' + row[1] + ' miles</div>');
});

if you want to use toObjects you need to put header

person,miles,country
A,10,USA
B,5,UK
A,2,USA

and access it using row.person row.miles and row.country

edited Jan 21, 2016 at 14:53

Evan Plaice

14.2k6 gold badges78 silver badges95 bronze badges

answered Mar 18, 2013 at 15:33

jcubic

67.1k58 gold badges252 silver badges466 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Payam Over a year ago

oh, nice. the documentation of csv-jQuery is so poor. This is very helpful.Thanks. I just have to find a way to create a Hashmap of the data to count for the average.

jcubic Over a year ago

you can count averge using something like: var sum = 0; for (var i=data.length;i--;) { sum+=data[i][1]; } var average = sum/data.length;

Payam Over a year ago

It might be too much, but I think you need to create a Hashmap that its index is the name (A,B,...) and the values are the total miles and the average.

jcubic Over a year ago

@user843681 if you still have problems you should ask another question.

Collectives™ on Stack Overflow

how to parse csv by csv-jQuery and generate report?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related