数据帧转换为PowerBI的json格式

Question

我正在尝试将数据帧数据转换为PowerBI的JSON格式。但到目前为止运气不好

数据帧：

  ProductID Name                        Category    IsCompete ManufacturedOn
0 1         Adjustable Race             Components  true      07/30/2014
1 2         LL Crankarm                 Components  false     07/30/2014
2 3         HL Mountain Frame - Silver  Bikes       true      07/30/2019

预期的JSON格式：

{
  "rows": [
    {
      "ProductID": 1,
      "Name": "Adjustable Race",
      "Category": "Components",
      "IsCompete": true,
      "ManufacturedOn": "07/30/2014"
    },
    {
      "ProductID": 2,
      "Name": "LL Crankarm",
      "Category": "Components",
      "IsCompete": true,
      "ManufacturedOn": "07/30/2014"
    },
    {
      "ProductID": 3,
      "Name": "HL Mountain Frame - Silver",
      "Category": "Bikes",
      "IsCompete": true,
      "ManufacturedOn": "07/30/2014"
    }
  ]
} 

Answer 1

使用to_dict方法：

json = {'rows':df.to_dict('records')}

print(json)

{'rows': [{'ProductID': 1,
   'Name': 'Adjustable Race',
   'Category': 'Components',
   'IsCompete': True,
   'ManufacturedOn': '07/30/2014'},
  {'ProductID': 2,
   'Name': 'LL Crankarm',
   'Category': 'Components',
   'IsCompete': False,
   'ManufacturedOn': '07/30/2014'},
  {'ProductID': 3,
   'Name': 'HL Mountain Frame - Silver',
   'Category': 'Bikes',
   'IsCompete': True,
   'ManufacturedOn': '07/30/2019'}]}