我正在使用Shopify的訂單API,我收到了以下響應,這些響應目前位于dataframe(非常簡單)中。
+----------+-----------+-----------------------------------------------------------------------------+
| order_id | name | item_order |
+----------+-----------+-----------------------------------------------------------------------------+
| 123 | Jon Doe | [{'id':789,'price':40.0,'sku':'HAT'},{'id':790,'price':41.0,'sku':'SHIRT'}] |
+----------+-----------+-----------------------------------------------------------------------------+
| 122 | Jonah Doe | [{'id':553,'price':20.0,'sku':'CAP'}] |
+----------+-----------+-----------------------------------------------------------------------------+
| | | |
+----------+-----------+-----------------------------------------------------------------------------+
我想爆炸item_order,所以我們得到了更接近下面的東西:
+----------+-----------+---------------+------------------+----------------+
| order_id | name | item_order.id | item_order.price | item_order.sku |
+----------+-----------+---------------+------------------+----------------+
| 123 | Jon Doe | 789 | 40.0 | HAT |
+----------+-----------+---------------+------------------+----------------+
| 123 | Jon Doe | 790 | 41.0 | SHIRT |
+----------+-----------+---------------+------------------+----------------+
| 122 | Jonah Doe | 553 | 20 | CAP |
+----------+-----------+---------------+------------------+----------------+
Use
DataFrame.explode
withjson_normalize
: