Python從TXT組織資料并寫入csv

我有這種格式的資料轉儲：

[
{
      "vaultId": "429d60edc11df0a576cd9173e8c0d0de8792538862db0122848b87a96ecdf537",
      "loanSchemeId": "MIN150",
      "ownerAddress": "df1q7crh6d3dscj3sajpklehpnwdwhvs0l0jm9fr7s",
      "state": "inLiquidation",
      "liquidationHeight": 1488540,
      "batchCount": 2,
      "liquidationPenalty": 5,
      "batches": [
        {
          "index": 0,
          "collaterals": [
            "282.34948388@DFI"
          ],
          "loan": "6.38045570@BABA"
        },
        {
          "index": 1,
          "collaterals": [
            "300.16175126@DFI"
          ],
          "loan": "0.26745972@GOOGL"
        }
      ]
    },
]
   

我已將其寫入 txt，我正在嘗試使用 Pandas 制作資料框，然后使用此代碼寫入 csv，但是我收到此錯誤ValueError: Length mismatch: Expected axis has 1729 elements, new values have 5 elements。這是我用來形成資料框的代碼，非常感謝。

import pandas as pd
import simplejson as json

df = pd.read_json('auctions.txt')
df[['index', 'collaterals', 'loan']] = df.batches.apply(pd.Series)

編輯：這是我更改代碼的錯誤

    Traceback (most recent call last):
  File "c:\Users\iones\Documents\DeFI Chain Auction Bot\start.py", line 3, in <module>
    df = pd.read_json('auctions.json')
  File "C:\Users\iones\Documents\DeFI Chain Auction Bot\.venv\lib\site-packages\pandas\util\_decorators.py", line 207, in wrapper
    return func(*args, **kwargs)
  File "C:\Users\iones\Documents\DeFI Chain Auction Bot\.venv\lib\site-packages\pandas\util\_decorators.py", line 311, in wrapper
    return func(*args, **kwargs)
  File "C:\Users\iones\Documents\DeFI Chain Auction Bot\.venv\lib\site-packages\pandas\io\json\_json.py", line 614, in read_json
    return json_reader.read()
  File "C:\Users\iones\Documents\DeFI Chain Auction Bot\.venv\lib\site-packages\pandas\io\json\_json.py", line 748, in read
    obj = self._get_object_parser(self.data)
  File "C:\Users\iones\Documents\DeFI Chain Auction Bot\.venv\lib\site-packages\pandas\io\json\_json.py", line 770, in _get_object_parser
    obj = FrameParser(json, **kwargs).parse()
  File "C:\Users\iones\Documents\DeFI Chain Auction Bot\.venv\lib\site-packages\pandas\io\json\_json.py", line 885, in parse
    self._parse_no_numpy()
  File "C:\Users\iones\Documents\DeFI Chain Auction Bot\.venv\lib\site-packages\pandas\io\json\_json.py", line 1140, in _parse_no_numpy
    loads(json, precise_float=self.precise_float), dtype=None
ValueError: Expected object or value

uj5u.com熱心網友回復：

使用加載 JSON read_json，然后將批處理字典轉換為列

import pandas as pd

df = pd.read_json('data.json')
df[['index', 'collaterals', 'loan']] = df.batches.apply(pd.Series)

如果您希望將抵押品放在不同的行中

df = df.explode('collaterals')

輸出

print(df[['vaultId', 'liquidationHeight', 'index', 'collaterals', 'loan']])

                                             vaultId  liquidationHeight  index        collaterals              loan
0  6af21886adcb92c4669a8a901975eb9b9d5544c67e4292...            1489770      0  2326.00000000@DFI  2.24978028@GOOGL
1  6af21886adcb92c4669a8a901975eb9b9d5544c67e4292...            1489770      1  2326.00000000@DFI  2.24978028@GOOGL

編輯：

根據您所說的，看起來資料已損壞，即無效的 JSON 格式。請從源頭上更正。我使用了以下資料樣本。

{
  "vaultId": "6af21886adcb92c4669a8a901975eb9b9d5544c67e429267841491649810958a",
  "ownerAddress": "df1qhh9ek2d98mxjeh58xdsfj7ad2k7q4d4kwshsxr",
  "liquidationHeight": 1489770,
  "batchCount": 2,
  "batches": [
    {
      "index": 0,
      "collaterals": [
        "2326.00000000@DFI"
      ],
      "loan": "2.24978028@GOOGL"
    },
    {
      "index": 1,
      "collaterals": [
        "2326.00000000@DFI"
      ],
      "loan": "2.24978028@GOOGL"
    }
  ]
}

uj5u.com熱心網友回復：

通過使用這個修復

def jsontocsv():
    df = pd.read_json('auctions.json')
    df = df.explode('batches')
    df[['index', 'collaterals', 'loan']] = df.batches.apply(pd.Series)
    print(df[['vaultId', 'liquidationHeight', 'index', 'collaterals','loan']])
    df.to_csv('auctions.csv')

`

標籤：Python 熊猫 数据框

上一篇：將資料幀與具有重復索引且不包括一列的系列相乘

下一篇：如何在Julia中加入列？