I've got a .csv
files with 5 columns but I only need the json
file to contain 3 of these how would i go about doing it?
csv file:
Ncode Ocode name a b c 1 1.1 1x 1a 1b 1c2 2.2 2x 2a 2b 2c3 3.3 3x 3a 3b 3c
Json output:
{"1.1":[{"a":"1a"},{"b":"1b"},{"c":"1c"}],"2.2":[{"a":"2a"},{"b":"2b"},{"c":"2c"}]}