将 MultiIndex 数据帧转换为 Json

我有带有 Multiindex 的 Datframe，我想将它转移到 Json

这是数据框

当我尝试将其转换为 JSON 并将 to_json() 放在 orient = index 上时，它将所有键转换为元组

这就是为什么我尝试以这种格式放置数据，但它不知道如何正确执行

当我尝试将其转换为Json时，我在索引上放置to_Json（），它将所有键转换为元组

    data = {
        '2022-01-21': {
            'SF1_8-1':
                {"Lock_Auto":0,
                 "Lock_Man":0,
                 "lability_Auto":0,
                 "lability_Man":67499,
                 "ANd":40,
                 "ANR_Remove":0,
                 "AveI":11.01470647,
                 "AveLoss":113.8496936
                },
            'S01_8-2':
                {"Lock_Auto":0,
                 "Lock_Man":0,
                 "Unavailability_Auto":0,
                 "Unavailability_Man":8475,
                 "ANd":40,
                 "ANR_Remove":0,
                 "AveI":11.01470647,
                 "AveLoss":113.8496936
                },

            'S01_8-3':
                {"Lock_Auto":0,
                 "Lock_Man":0,
                 "Unavailability_Auto":0,
                 "Unavailability_Man":8475,
                 "ANd":40,
                 "ANR_Remove":0,
                 "AveI":11.01470647,
                 "AveLoss":113.8496936
                }
        },
        '2022-01-22': {
            '001_P87-1':
                {"Lock_Auto":0,
                 "Lock_Man":0,
                 "Unavailability_Auto":0,
                 "Unavailability_Man":8475,
                 "ANd":40,
                 "ANR_Remove":0,
                 "AveI":11.01470647,
                 "AveLoss":113.8496936
                },

            },
            '001_P-2':
                {"Lock_Auto":0,
                 "Lock_Man":0,
                 "Unavailability_Auto":0,
                 "Unavailability_Man":8475,
                 "ANd":40,
                 "ANR_Remove":0,
                 "AveI":11.01470647,
                 "AveLoss":113.8496936
                },

            '001_P-3':
                {"Lock_Auto":0,
                 "Lock_Man":0,
                 "Unavailability_Auto":0,
                 "Unavailability_Man":8475,
                 "ANd":40,
                 "ANR_Remove":0,
                 "AveI":11.01470647,
                 "AveLoss":113.8496936
                },
        }

• 问题1：有没有办法将多索引数据帧传输到Json
• 问题2：我怎样才能把这样的数据放进去？