How to merge two .csv files in javascript?

Question

I have two .csv files like that example:

date,type,brand,model,price
2014-11-27,  electric, tesla, model s , 100000
2014-11-27,  diesel, bmw, m3, 90000 
2014-12-13,  hybrid, toyota, yaris , 20000

How can I merge these files for make only one object?

Two files has the first row with names of columns, it's possible to delete? Or add it if I get the files without that first row?

see this post:stackoverflow.com/questions/15700658/combining-two-csvs-d3 — Suchit kumar
– Suchit kumar, Commented Nov 20, 2014 at 10:40
@suchit I tried but only works if the data is different. I my case I would like to add at the end of array like adding data. — Lins
– Lins, Commented Nov 20, 2014 at 11:10

Suchit kumar · Accepted Answer · 2014-11-20 11:36:46Z

1

try this:It will solve your problem.

 $(document).ready(function () {
    var newArray = [];
    d3.csv("test.csv", function(error, data) {// with header..
        data.forEach(function(d) {


                newArray.push(d);
        });

        });

        d3.csv("test1.csv", function(error, data2) {// without header..
            data2.forEach(function(d2) {


                    newArray.push(d2);
            });

            });
        console.log(newArray);
    });

for info see here:http://www.d3noob.org/2014/02/how-to-import-data-from-csv-file-with.html

edited Nov 20, 2014 at 11:36

answered Nov 20, 2014 at 11:30

Suchit kumar

11.9k3 gold badges26 silver badges46 bronze badges

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

2 Comments

Suchit kumar Over a year ago

@Lins if you are using header in second file also then skip it in foreach for first time in second d3.csv.

Lins Over a year ago

Thank you @suchit for your help. Finally I got the response in that question: stackoverflow.com/questions/27041758/… for merge two files without header.

Collectives™ on Stack Overflow

How to merge two .csv files in javascript?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related