将复杂的JSON转换为excel或CSV

Question

谢谢你调查我的问题

我正在尝试使用Python将复杂的JSON文件转换为excel或CSV，但未能成功。 您能用Python或任何其他语言帮助解决以下问题吗

下面是一个示例JSON文件：

{
   "gstin":"XYZ",
   "fp":"032021",
   "b2b":[
      {
         "ctin":"ABC",
         "cfs":"N",
         "inv":[
            {
               "itms":[
                  {
                     "num":1201,
                     "itm_det":{
                        "samt":10.13,
                        "csamt":0,
                        "rt":12,
                        "txval":168.8,
                        "camt":10.13
                     }
                  }
               ],
               "samt":10.13,
               "val":189,
               "txval":168.8,
               "camt":10.13,
               "inum":"KC14926",
               "iamt":0,
               "csamt":0,
               "inv_typ":"R",
               "pos":"37",
               "idt":"31-03-2021",
               "rchrg":"N",
               "chksum":"XXXX"
            }
         ]
      },
      {
         "ctin":"PQR",
         "cfs":"N",
         "inv":[
            {
               "itms":[
                  {
                     "num":1201,
                     "itm_det":{
                        "samt":24.2,
                        "csamt":0,
                        "rt":12,
                        "txval":403.3,
                        "camt":24.2
                     }
                  }
               ],
               "samt":24.2,
               "val":452,
               "txval":403.3,
               "camt":24.2,
               "inum":"RSC7276",
               "iamt":0,
               "csamt":0,
               "inv_typ":"R",
               "pos":"37",
               "idt":"01-03-2021",
               "rchrg":"N",
               "chksum":"YYYY"
            },
            {
               "itms":[
                  {
                     "num":1801,
                     "itm_det":{
                        "samt":22.95,
                        "csamt":0,
                        "rt":18,
                        "txval":255,
                        "camt":22.95
                     }
                  }
               ],
               "samt":22.95,
               "val":301,
               "txval":255,
               "camt":22.95,
               "inum":"RSC7704",
               "iamt":0,
               "csamt":0,
               "inv_typ":"R",
               "pos":"37",
               "idt":"16-03-2021",
               "rchrg":"N",
               "chksum":"ZZZZ"
            },
            {
               "itms":[
                  {
                     "num":1801,
                     "itm_det":{
                        "samt":19.13,
                        "csamt":0,
                        "rt":18,
                        "txval":212.5,
                        "camt":19.13
                     }
                  }
               ],
               "samt":19.13,
               "val":251,
               "txval":212.5,
               "camt":19.13,
               "inum":"RSC7793",
               "iamt":0,
               "csamt":0,
               "inv_typ":"R",
               "pos":"37",
               "idt":"19-03-2021",
               "rchrg":"N",
               "chksum":"MMMM"
            }
         ]
      }
   ]
}

所需输出：screenshot of desired output