我抓取了數(shù)據(jù)并嘗試轉換為 json 格式。但是，它似乎不成功，我想用鍵和值轉換字典，然后轉換為數(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'}}]}我想要的結果是：df = {'id':'GILD', 'longDesc', 'Gildead...}
1 回答
當年話下
TA貢獻1890條經(jīng)驗 獲得超9個贊
根據(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ā)出的請求返回的對象。話雖如此，您想要的輸出實際上是 a dictionary，但我保留了您的命名約定。
編輯：
要將您的轉換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...
添加回答
舉報
0/150
提交
取消