如何使用Python将JSON数据文件映射到SQLIte数据库

Question

我需要将数据从JSON数据文件转换为SQLite数据库。JSON数据文件包含以下内容：

{
    "CHILLER_2": {
        "event": {
            "payloadData": {
                "_timestamp": 1573228140000, 
                "CHILLER___TDCOMPB": 0, 
                "CHILLER___TDCOMPA": 82.06, 
                "CHILLER___PEB": 0, 
                "COMPA___E": 83624.896, 
                "CHILLER___TEVDXA": 65.86, 
                "CHILLER___PEA": -4.21, 
                "CHILLER___TEVDXB": 0, 
                "CHILLER___PCA": -4.36, 
                "CHILLER___PCB": 0, 
                "COMPB___P": 0, 
                "CHILLER___TSAC": 88.14, 
                "data_timestamp": "2019-11-08T10:49:00Z", 
                "CHILLER___TEAE": 65.41, 
                "CHILLER___ST": 0, 
                "CHILLER___TSCOMPB": 0, 
                "COMPB___E": 0, 
                "CHILLER___TEAC": 87.24, 
                "COMPA___P": 0.0, 
                "CHILLER___TSCOMPA": 80.15, 
                "CHILLER___TSAE": 60.91
            }
        }
    }, 
    "CHILLER_1": {
        "event": {
            "payloadData": {
                "_timestamp": 1573228140000, 
                "CHILLER___TDCOMPB": 0, 
                "CHILLER___TDCOMPA": 115.25, 
                "CHILLER___PEB": 0, 
                "COMPA___E": 54329.2, 
                "CHILLER___TEVDXA": 55.17, 
                "CHILLER___PEA": -8.54, 
                "CHILLER___TEVDXB": 0, 
                "CHILLER___PCA": 6.74, 
                "CHILLER___PCB": 0, 
                "COMPB___P": 0, 
                "CHILLER___TSAC": 95.9, 
                "data_timestamp": "2019-11-08T10:49:00Z", 
                "CHILLER___TEAE": 45.72, 
                "CHILLER___ST": 2, 
                "CHILLER___TSCOMPB": 0, 
                "COMPB___E": 0, 
                "CHILLER___TEAC": 87.12, 
                "COMPA___P": 198.5, 
                "CHILLER___TSCOMPA": 43.59, 
                "CHILLER___TSAE": 41.67
            }
        }
    }, 
    "BOMBAS": {
        "event": {
            "payloadData": {
                "BAC___P": 27.46, 
                "_timestamp": 1573228140000, 
                "BAF___E": 23893.98, 
                "data_timestamp": "2019-11-08T10:49:00Z", 
                "BAC___E": 23055.22, 
                "BAF___P": 28.48
            }
        }
    }
}

所以，我需要一种方法，用相应的数据为Columer_1、Columer_2和BOMBAS数据集创建一个表

就我个人而言，我是Python的新手，因此任何帮助都将受到感谢

有没有关于如何实现这一目标的建议