我抓取了數(shù)據(jù)并嘗試轉(zhuǎn)換為 json 格式。但是，它似乎不成功，我想用鍵和值轉(zhuǎn)換字典，然后轉(zhuǎn)換為數(shù)據(jù)幀。from bs4 import BeautifulSoupimport bs4import requestsimport jsonreq = Request(url, headers={'User-Agent': 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6)})webpage = urlopen(req).read().decode("utf-8")webpage = json.loads(webpage)輸出：{'data': [{'id': 'GILD', 'attributes': {'longDesc': "Gilead Sciences, Inc., a research-based biopharmaceutical company, discovers, develops, and commercializes medicines in the areas of unmet medical needs in the United States, Europe, and internationally. It was founded in 1987 and is headquartered in Foster City, California.", 'sectorname': 'Health Care', 'sectorgics': 35, 'primaryname': 'Biotechnology', 'primarygics': 35201010, 'numberOfEmployees': 11800.0, 'yearfounded': 1987, 'streetaddress': '333 Lakeside Drive', 'streetaddress2': None, 'streetaddress3': None, 'streetaddress4': None, 'city': 'Foster City', 'peRatioFwd': 9.02045209903122, 'lastClosePriceEarningsRatio': None, 'divRate': 2.72, 'divYield': 4.33, 'shortIntPctFloat': 1.433, 'impliedMarketCap': None, 'marketCap': 78796576654.0, 'divTimeFrame': 'forward'}}]}我想要的結(jié)果是：df = {'id':'GILD', 'longDesc', 'Gildead...}
1 回答
當(dāng)年話下
TA貢獻(xiàn)1890條經(jīng)驗(yàn) 獲得超9個(gè)贊
根據(jù)您的數(shù)據(jù)，您可以嘗試此操作，作為代碼的一部分：
d = {
'data': [
{
'id': 'GILD',
'attributes': {
'longDesc': "Gilead Sciences, Inc., a research-based biopharmaceutical company, discovers, develops, and commercializes medicines in the areas of unmet medical needs in the United States, Europe, and internationally. It was founded in 1987 and is headquartered in Foster City, California.",
'sectorname': 'Health Care',
'sectorgics': 35,
'primaryname': 'Biotechnology',
'primarygics': 35201010,
'numberOfEmployees': 11800.0,
'yearfounded': 1987,
'streetaddress': '333 Lakeside Drive',
'streetaddress2': None,
'streetaddress3': None,
'streetaddress4': None,
'city': 'Foster City',
'peRatioFwd': 9.02045209903122,
'lastClosePriceEarningsRatio': None,
'divRate': 2.72,
'divYield': 4.33,
'shortIntPctFloat': 1.433,
'impliedMarketCap': None,
'marketCap': 78796576654.0,
'divTimeFrame': 'forward'}
}
]
}
try:
_id = d['data'][0]['id']
ld = d['data'][0]['attributes']['longDesc']
df = {"id": _id, 'longDesc': ld}
except (KeyError, ValueError) as error:
print(f"Failed to load data: {error}")
print(df)
輸出：
{'id': 'GILD', 'longDesc': 'Gilead Sciences, Inc., a research-based biopharmaceutical company, discovers, develops, and commercializes medicines in the areas of unmet medical needs in the United States, Europe, and internationally. It was founded in 1987 and is headquartered in Foster City, California.'}
注意： df通常被稱為dataframe，大多是用pandas模塊創(chuàng)建的。但是，您擁有的可能是JSON從您發(fā)出的請(qǐng)求返回的對(duì)象。話雖如此，您想要的輸出實(shí)際上是 a dictionary，但我保留了您的命名約定。
編輯：
要將您的轉(zhuǎn)換dict為df只需執(zhí)行以下操作：
import pandas as pd
d = {'id': 'GILD', 'longDesc': 'Gilead Sciences, Inc., a research-based biopharmaceutical company, discovers, develops, and commercializes medicines in the areas of unmet medical needs in the United States, Europe, and internationally. It was founded in 1987 and is headquartered in Foster City, California.'}
df = pd.Dataframe(d.items())
print(df)
這輸出：
0 1
0 id GILD
1 longDesc Gilead Sciences, Inc., a research-based biopha...
添加回答
舉報(bào)
0/150
提交
取消