我需要將以下 CSV 數(shù)據(jù)解析為嵌套的 JSON 字符串。請告知我如何將“ payment_mode”添加為“cashier”的嵌套值。我嘗試了一些方法，例如創(chuàng)建另一個orderedDict并將其附加到子集列表中，但這并沒有按預(yù)期工作。將不勝感激任何幫助。CSV 數(shù)據(jù)：Contract_no,sales_date,store_sales_amount,cashier_counter,discount_amount,before_tax_amount,tax_amount,cashier_amount,product,dine_in,take_away,mode,amountCS,2020-04-12,18.50,C1,0,18.50,0,18.50,18.50,0,0,CASH,1068.50預(yù)期的 JSON 格式：    {    "contract_no": "CS",    "sales_date": "2020-04-06",    "store_sales_amount": "822.17",    "cashier": [        {            "cashier_counter": "C1",            "discount_amount": "15",            "before_tax_amount": "13.15",            "tax_amount": "219.13",            "cashier_amount": "232.28",          "product":"100.12",          "dine_in":"116.02",          "take_away":"16.14",            "payment_mode": [                {                    "mode": "CASH",                    "amount": "112.46"                }            ]        },    ]}電流輸出：{"contract_no": "CS","sales_date": "2020-04-12","store_sales_amount": "18.50","cashier": [    {        "cashier_counter": "C1",        "discount_amount": "0",        "before_tax_amount": "18.50",        "tax_amount": "0",        "cashier_amount": "18.50",        "product": "18.50",        "dine_in": "0",        "take_away": "0",        "mode": "CASH",        "cash_amount": "18.50"    }]}代碼import pandas as pdfrom itertools import groupby from collections import OrderedDictimport json    #read csv into dataframedf = pd.read_csv('sales2.csv', dtype={        #level1        "Contract_no" : str,        "sales_date" : str,        "store_sales_amount" : str,        #level2 cashier        "cashier_counter" : str,        "discount_amount" : str,        "before_tax_amount" : str,        "tax_amount" : str,        "cashier_amount" : str,        "product" : str,        "dine_in" : str,        "take_away" : str,        #level3 payment_mode        "mode" : str,        "cash_amount" : str             })