我将如何将此 JSON 的“数据”部分转换为简单的 Pandas 表。这是我所拥有的:
import json
import urllib.request
import pandas
url = urllib.request.urlopen('https://www.cryptocompare.com/api/data/coinlist/')
json_obj = json.load(url)
print(json.dumps(json_obj, sort_keys=True, indent=4))
json_data = json_obj['Data']
print(json.dumps(json_data, sort_keys=True, indent=4))
df = pandas.DataFrame(json_data)
with pandas.option_context('display.max_rows', None, 'display.max_columns', 3):
print(df)
尝试了很多方法,但结果看起来不正确。该表应该是:
CoinName,Algorithm,...
ABC, AAA, ...
DEF, DDS, ...
在我看来很好
pandas.DataFrame(json_obj['Data']).T
Algorithm CoinName FullName FullyPremined
007 Scrypt 007 coin 007 coin (007) 0
1337 X13 1337 1337 (1337) 0
1CR Scrypt 1Credit 1Credit (1CR) 0
1ST N/A FirstBlood FirstBlood (1ST) 1
2015 X11 2015 coin 2015 coin (2015) 0
2BACCO Scrypt 2BACCO Coin 2BACCO Coin (2BACCO) 0
2GIVE Scrypt 2GiveCoin 2GiveCoin (2GIVE) 0
32BIT X11 32Bitcoin 32Bitcoin (32BIT) 0
365 X11 365Coin 365Coin (365) 0
404 Scrypt 404Coin 404Coin (404) 0
42 Scrypt 42 Coin 42 Coin (42) 0
611 SHA256 SixEleven SixEleven (611) 0
808 SHA256 808 808 (808) 0
888 N/A Octocoin Octocoin (888) 0
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句