我有這個代碼并且運行良好
import requests
import xml.etree.ElementTree as ET
import json
def get_stock(sku):
params = {'ItemId': sku}
base_url = 'http://10.0.0.25/api/GetSku'
response = requests.get(base_url, params=params)
json_parsed = json.loads(response.content)
if response.status_code == 200:
return [item for item in response.json() if item['Site'] == "12"]
else:
return None
def jprint(obj):
text = json.dumps(obj, sort_keys=True, indent=4)
print(text)
jprint(get_stock(101025HRLONDON))
輸出是json：
[
{
"ItemId": "101025HRLONDON",
"Site": "12",
"Warehouse": "17",
"availablePhysical": 1.0
},
{
"ItemId": "101025HRLONDON",
"Site": "12",
"Warehouse": "33",
"availablePhysical": 1.0
},
{
"ItemId": "101025HRLONDON",
"Site": "12",
"Warehouse": "34",
"availablePhysical": 1.0
},
]
我需要一種方法將上述輸出轉換為美容表或類似的：
---- ------ ----------------------
| WH |aval. | ItemID |
---- ------ ----------------------
| 17 | 1 | 101025HRLONDON |
| 33 | 1 | 101025HRLONDON |
| 34 | 1 | 101025HRLONDON |
---- ------ ----------------------
請分享您處理此類事情的經驗。
謝謝
uj5u.com熱心網友回復：
有PrettyTable和BeautifulTable。您可以 pip install 這些并閱讀檔案。如果你真的想做一些有用的東西，OpenpyXl 是你要走的路。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/339834.html