CODEWITHSUNDEEP
javascriptjsoncsv
MFarooqi
MFarooqi

Reputation: 1034

CSV to multilevel/nested JSON

I want to convert a csv to multilevel json. All I want is from:

brand,  active, prod   , prod_id, part, part_id, part_prise
canon,  1     , camera , 132    , body,  543   , 399
canon,  0     , camera , 132    , lens,  543   , 399
canon,  1     , printer, 132    , cart,  543   , 399
canon,  1     , printer, 872    , ink ,  543   , 399
sony ,  1     , camera , 132    , body,  543   , 399
sony ,  1     , lcd    , 112    , body,  543   , 399
sony ,  0     , lcd    , 132    , body,  543   , 399
sony ,  1     , laptop , 162    , body,  543   , 399

And following should be its JSON file.

brand : "canon",
active : 1,
prod : [{
     prod : "camera",
     prod_id : 132,
     part : [{
            part : "body",
            part_id : 543,
            part_prise:399
            },
           {
            part : "lens",
            part_id : 543,
            part_prise:399
            }]
         },{
     prod : "printer",
     prod_id : 132,
     part : [{
            part : "cart",
            part_id : 543,
            part_prise:399
            },
           {
            part : "ink",
            part_id : 543,
            part_prise:399
            }]
         }
      ]
...
...
...and so on..

Upvotes: 1

Views: 698

Answers (1)

user3428899
user3428899

Reputation:

use csv dictreader, it prescent in the python csv package

Upvotes: 1

Related Questions