将 API 转换为 Pandas DataFrame
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/41100303/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Convert API to Pandas DataFrame
提问by LearningToJava
I'd like to convert the API call into a pandasdata frame.
我想将 API 调用转换为pandasdata frame.
At the moment, the APIis very unorganised and I'd like to incorporate pandasto make it easier to read/edit/manipulate.
目前，API非常无组织，我想合并pandas以使其更易于阅读/编辑/操作。
I have attempted the following:
我尝试了以下方法：
r = requests.get('http://api.football-data.org/v1/competitions/398/teams')
x = r.json()
df = pd.read_json(x)
print df
But receive:
但收到：
TypeError: Expected String or Unicode
采纳答案by Rishabh Srivastava
pd.read_jsonexpects a string. However, r.json()returns a dict object.
pd.read_json期待一个字符串。但是，r.json()返回一个 dict 对象。
In your case, you should explore the structure of the returned JSON object by looking at x.keys(). This will yield ['count', '_links', 'teams']. You are probably interested in the 'teams' field.
在您的情况下，您应该通过查看x.keys(). 这将产生['count', '_links', 'teams']. 您可能对“团队”领域感兴趣。
As such, you should do the following:
因此，您应该执行以下操作：
r = requests.get('http://api.football-data.org/v1/competitions/398/teams')
x = r.json()
df = pd.DataFrame(x['teams'])
print df
回答by bman
read_jsonfunction expectsa string. You are providing a JSON object (parsed using requestslibrary's jsonmethod). What you need to do is to convert the object back to a string using json.dumpsmethod:
read_json函数需要一个字符串。您正在提供一个 JSON 对象（使用requests库的json方法解析）。您需要做的是使用json.dumps方法将对象转换回字符串：
import json
r = requests.get('http://api.football-data.org/v1/competitions/398/teams')
x = r.json()
df = pd.read_json(json.dumps(x))
Or even better, just get the buffer from request object directly and do not convert it to an object.
或者更好的是，直接从请求对象中获取缓冲区，不要将其转换为对象。
r = requests.get('http://api.football-data.org/v1/competitions/398/teams')
df = pd.read_json(x.text)
回答by usct01
This simple solution worked for me (the api link in question is not accessible by me)
这个简单的解决方案对我有用（我无法访问有问题的 api 链接）
df=pd.read_json('https://api.coinmarketcap.com/v1/ticker/?limit=10')
df.head()
24h_volume_usd available_supply id last_updated \
0 12465900000 16812425 bitcoin 1516379664
1 4827670000 97080757 ethereum 1516379652
2 5091970000 38739142811 ripple 1516379641
3 862348000 16920150 bitcoin-cash 1516379657
4 678044000 25927070538 cardano 1516379659
market_cap_usd max_supply name percent_change_1h \
0 198285740450 2.100000e+07 Bitcoin 0.88
1 103477408544 NaN Ethereum 0.02
2 62593157388 1.000000e+11 Ripple -0.63
3 30726992400 2.100000e+07 Bitcoin Cash 0.41
4 17206681852 4.500000e+10 Cardano 0.56
percent_change_24h percent_change_7d price_btc price_usd rank \
0 -0.37 -15.41 1.000000 11794.000000 1
1 -0.92 -15.24 0.090786 1065.890000 2
2 -1.39 -20.53 0.000138 1.615760 3
3 -2.43 -29.81 0.154675 1816.000000 4
4 -4.15 -18.47 0.000057 0.663657 5
symbol total_supply
0 BTC 16812425
1 ETH 97080757
2 XRP 99993093880
3 BCH 16920150
4 ADA 31112483745
