熊猫：创建多层表或子表格

Question

我在列表中具有字典格式的数据：

data_dict = [{
    "exchange": "binance",
    "base": "kp3r",
    "quote": "busd",
    "resolution": 15,
    "ohlcv": [
        {
            "source_id": 7905,
            "timestamp": "2022-07-05T14:45:00.000Z",
            "open": "131.55",
            "high": "131.84",
            "low": "130.38",
            "close": "130.94",
            "volume": "90.29"
        },
        {
            "source_id": 7905,
            "timestamp": "2022-07-05T14:45:00.000Z",
            "open": "131.55",
            "high": "131.84",
            "low": "130.38",
            "close": "130.94",
            "volume": "90.29"
        },
        {
            "source_id": 19252,
            "timestamp": "2022-07-05T13:00:00.000Z",
            "open": "24.5610000000000000",
            "high": "24.5610000000000000",
            "low": "24.5610000000000000",
            "close": "24.5610000000000000",
            "volume": "0.0000000000000000"
        }]
    },
    {
    "exchange": "kucoin",
    "base": "mln",
    "quote": "usdt",
    "resolution": 15,
    "ohlcv": [
        {
            "source_id": 19252,
            "timestamp": "2022-07-05T13:00:00.000Z",
            "open": "24.56",
            "high": "24.56",
            "low": "24.56",
            "close": "24.56",
            "volume": "0.0"
        }]
    }
]

现在我需要表格像（ greenge ）：

      exchange  base  ... resolution   source_id      timestamp             open    high   low    close  volume
    0  binance  kp3r  ...         15     7905     2022-07-05T14:45:00.000Z  131.55 131.84  130.38 130.94  90.29
                                         7905     2022-07-05T14:45:00.000Z  131.55 131.84  130.38 130.94  90.29
                                         19252    2022-07-05T13:00:00.000Z  24.56   24.56  24.56   24.56   0.0

    1   kucoin   mln  ...         15     19252    2022-07-05T13:00:00.000Z  24.56   24.56  24.56   24.56   0.0

这是我尝试的：

pd.DataFrame.from_dict(data_dict)

它给了我

  exchange  base  ... resolution                                              ohlcv
0  binance  kp3r  ...         15  [{'source_id': 7905, 'timestamp': '2022-07-05T...
1   kucoin   mln  ...         15  [{'source_id': 19252, 'timestamp': '2022-07-05...

Answer 1

尝试：

df = pd.DataFrame(data_dict).explode("ohlcv")
df = pd.concat([df, df.pop("ohlcv").apply(pd.Series)], axis=1)
print(df)

打印：

  exchange  base quote  resolution  source_id                 timestamp    open    high     low   close volume
0  binance  kp3r  busd          15       7905  2022-07-05T14:45:00.000Z  131.55  131.84  130.38  130.94  90.29
0  binance  kp3r  busd          15       7905  2022-07-05T14:45:00.000Z  131.55  131.84  130.38  130.94  90.29
1   kucoin   mln  usdt          15      19252  2022-07-05T13:00:00.000Z   24.56   24.56   24.56   24.56    0.0