chamkank
not recognizing the arrays nested in json
Hi, can we able to convert the csv data below with '.' as delimiter that has a json array nested in an array
CSV:
Products.name | Products.specifications.cost | Products.discount | Products.specifications.weight | Products.type Onions | 50 | 0 | 1 | classic Onions | 200 | 0 | 2 | classic Tomato | 25 | 1 | 1 | classic Broccoli | 50 | 0 | 0.5 | classic
JSON needed as output: { "Products": [ { "name": "Onions", "specification": [ { "cost": "50", "weight": "1" }, { "cost": "200", "weight": "2" } ], "discount": "0", "type": "classic" }, { "name": "Tomato", "specification": [ { "cost": "25", "weight": "1" } ], "discount": "1", "type": "classic" }, { "name": "Broccoli", "specification": [ { "cost": "50", "weight": "0.5" } ], "discount": "0", "type": "classic" } ] }
but I m getting this output from the python : [ { "Products": { "discount": "0", "name": "Onions", "specification": { "cost": "50", "weight": "1" }, "type": "classic" } }, { "Products": { "discount": "0", "name": "Onions", "specification": { "cost": "200", "weight": "2" }, "type": "classic" } }, { "Products": { "discount": "1", "name": "Tomato", "specification": { "cost": "25", "weight": "1" }, "type": "classic" } }, { "Products": { "discount": "0", "name": "Broccoli", "specification": { "cost": "50", "weight": "0.5" }, "type": "classic" } } ]
