python - 使用 Pandas 将 csv 转换为 Json

Question

我想使用 pandas 将 CSV 格式转换为 JSON 格式。我是一名测试人员，想将一些事件发送到事件中心，因为我想维护 CSV 文件并使用 CSV 文件更新我的记录/数据。我通过使用 pandas 读取 JSON 作为引用创建了一个 CSV 文件。现在，当我再次使用 pandas< 将 CSV 转换为 JSON 时，数据未以正确的格式显示。你能帮忙吗？

第 1 步:使用 pandas 将 JSON 转换为 CSV:

df = pd.read_json('C://Users//DAMALI//Desktop/test.json')
df.to_csv('C://Users//DAMALI//Desktop/test.csv')

第 2 步:现在，如果我尝试再次将 JSON 转换为 CSV，它不会以与之前相同的格式转换:

df = pd.read_csv('C://Users//DAMALI//Desktop/test.csv')
df.to_json('C://Users//DAMALI//Desktop/test1.json')

提供以下 JSON:

{
    "body": {
        "deviceId": "UDM",
        "registrationDate": "12/11/2019",
        "testRegistration": false,
        "serialNumber": "25",
        "articleNumber": "R91",
        "deviceName": "UDM-test",
        "locationId": "lc0",
        "sapSoldToId": "1138474",
        "crmDomainAccountId": "1234566",
        "crmAccountDetails": {
            "accountName": "ProjectX",
            "accountId": "Instal",
            "region": "AP"
        },
        "productLine": "UD",
        "state": "registered",
        "installerName": "ABC Rooms",
        "installationAddress": {
            "street": "Benelu",
            "zipCode": "850",
            "city": "Kortr",
            "state": "OVL",
            "country": "Belgi"
        },
        "customerDetails": {
            "name": "John D",
            "contactName": "John Doe",
            "phone": "+32 999999999",
            "email": "john.doe@test.com"
        },
        "wallConnect": {
            "wallSize": "Width 5 x Height 4",
            "wallOrientation": "LANDSCAPE",
            "displayType": "BVD-D55M21H321A1C300",
            "softwareVersion": "1.13.1.1.3"
        },
        "projector": {
            "name": "UDX 40K-123456789",
            "subType": "UDX 40K"
        },
        "featureLicense": ["UDX-aa00213a-5719-440e-a3b5", "UDX-aa00a-571"],
        "cloudServiceLicense": ["EN04d5-4d2a-9131-875ad37c5883", "E15-4d2a-9131-875ad37c5154"],
        "metadata": {
            "cusQuesAns": [{
                    "ques": "End ucal industry",
                    "ans": "Hosity",
                    "key": "CUST_ANSWER"
                },
                {
                    "ques": "End user video wall application",
                    "ans": "Simulation & Virtual Reality",
                    "key": "CUSSECOND_ANSWER"
                }
            ]
        },
        "frequency": "realtime",
        "subDevices": [{
            "deviceType": "DISPLAY",
            "serialNumber": "68960",
            "articleNumber": "R792",
            "wallConnect": {
                "displayFMWVersion": "3.0.0",
                "displayVariant": "KVD21H331A1C300"
            }
        }]
    },
    "properties": {
        "drs": {
            "type": "salesforce-lm"
        }
    },
    "systemProperties": {
        "user-id": "data-cvice",
        "message-id": "1b1012cc-9b18c192"
    }
}

Answer 1

尝试将 CSV 转换为 JSON

    import pandas as pd
    df = pd.read_csv (r'Fayzan-Bhatti\test.csv')
    df.to_json (r'Fayzan-Bhatti\new_test.json')