Node.js convert csv file to json formate

Question

I am beginner to programming. I am reading the csv data from the file then I need to convert csv data into json formate. This is my csv data file:

batch_id  ingredient_code   quantity    expiry_date
1             item1           1000      18-01-2019
1             item2           500       18-02-2019
2             item1           1000      18-01-2019
3             item2           1000      18-08-2019
4             item2           1000      18-01-2019
4             item1           1000      18-05-2019
4             item3           500       18-04-2019
5             item4           1000      18-01-2019

I am expecting output like this

[{
   batch_id : 1,
   items :[{ingredient_code:item1, quantity:1000, expiry_date:18-01-2019},
           {ingredient_code:item2, quantity:500, expiry_date:18-02-2019}]     
   },
   {
     batch_id : 2,
     items :[{ingredient_code:item1, quantity:1000, expiry_date:18-01-2019}]     
    },
    {
      batch_id : 3,
      items :[{ingredient_code:item1, quantity:1000, expiry_date:18-01-2019}]     
    },
    {
      batch_id : 4,
      items :[{ingredient_code:item1, quantity:1000, expiry_date:18-05-2019},
              {ingredient_code:item2, quantity:1000, expiry_date:18-01-2019},
              {ingredient_code:item3, quantity:500, expiry_date:18-04-2019}]     
     },
    {
      batch_id : 5,
      items :[{ingredient_code:item4, quantity:1000, expiry_date:18-01-2019}]     
}]

what I am expecting is batch id should display single time, all the items of that batch id should be added to array. thanks in advance..... sorry for poor english

SO is not a code provider. You should first propose a code that you already tried and tell use what are you expecting from this and why it doesn't match your needs. To start with your problem, you can find tutorials to read a CSV file, then how to store the data from a CSV file — Weedoze
– Weedoze, Commented Jun 21, 2019 at 5:17

Anusha kurra · Accepted Answer · 2018-03-07 11:41:19Z

2

Csv file is in same location as js file,Install node module csvtojson

var csv = require("csvtojson");
csv().fromFile('a.csv').on("json",function(jsonArrayObj){ 
     console.log(jsonArrayObj); 
   })

answered Mar 7, 2018 at 11:41

Anusha kurra

4803 silver badges9 bronze badges

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

Comments

Krrish Raj · Accepted Answer · 2018-03-07 11:10:35Z

0

Create an empty map.
Iterate over data line by line.
Split each line by comma.
Use batch id as key and look for it in map, it exists, push data into array otherwise initialize that key with an array containing data for that row.
Iterate over keys and create an array out of it.

answered Mar 7, 2018 at 11:10

Krrish Raj

1,5451 gold badge13 silver badges29 bronze badges

1 Comment

Bramhani G Over a year ago

thank you for your response, can you please give some example.

Saniya syed qureshi · Accepted Answer · 2019-06-21 05:26:42Z

0

You can acheive it by installing the csvtojson in your node module, by typing the following command:

npm install csvtojson --save

You can get more detailed information here from-csv-file-to-json-array.

edited Jun 21, 2019 at 5:26

answered Jun 21, 2019 at 5:09

Saniya syed qureshi

3,1973 gold badges18 silver badges23 bronze badges

Comments

hongkongbboy · Accepted Answer · 2020-05-12 05:56:52Z

0

2 Steps Process:

1) Run npm i -g csvtojson in terminal.

2) Run csvtojson source.csv > converted.json in terminal where your file located. Note that "source.csv" is the file that you want to convert and "converted.json" is the file that you will generate.

For documentation, see here

answered May 12, 2020 at 5:56

hongkongbboy

3201 gold badge5 silver badges15 bronze badges

Collectives™ on Stack Overflow

Node.js convert csv file to json formate

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related