0

I'm trying to add Header Columns to my "CSV embedded JSON" file

My Data Looks like this:

kgp22786001, {"AA":[6,213,21,122,151], "CC":[74,421,302,413,155,368], "AC":[350,48,106,169,17]}
rs22786001, {"AA":[6,3,21,12,51], "CC":[7,41,32,13,15,68], "AC":[35,4,16,16,17]}
kgp22786001, {"AA":[69,30,27,2,1], "CC":[70,49,92,13,9,8], "AC":[5,49,96,19,14]}

Here I would like to assign headers i.e SNP_id, Genotype

Desired Output:

SNP_id, Genotype
kgp22786001, {"AA":[6,213,21,122,151], "CC":[74,421,302,413,155,368], "AC":[350,48,106,169,17]}
rs22786001, {"AA":[6,3,21,12,51], "CC":[7,41,32,13,15,68], "AC":[35,4,16,16,17]}
kgp22786001, {"AA":[69,30,27,2,1], "CC":[70,49,92,13,9,8], "AC":[5,49,96,19,14]}

Here for First header column (SNP_id) should contain all SNP_id's(kgp22786001,rs22786001, kgp22786001), for second header column i need to assign whole dictionary of each row as one value

Raju Natha
  • 55
  • 5

0 Answers0