{"id":1077588,"date":"2025-01-08T12:03:37","date_gmt":"2025-01-08T04:03:37","guid":{"rendered":"https:\/\/docs.pingcode.com\/ask\/ask-ask\/1077588.html"},"modified":"2025-01-08T12:03:40","modified_gmt":"2025-01-08T04:03:40","slug":"%e7%94%a8python%e5%a6%82%e4%bd%95%e8%8e%b7%e5%8f%96%e8%82%a1%e5%b8%82%e8%a1%8c%e6%83%85-2","status":"publish","type":"post","link":"https:\/\/docs.pingcode.com\/ask\/1077588.html","title":{"rendered":"\u7528Python\u5982\u4f55\u83b7\u53d6\u80a1\u5e02\u884c\u60c5"},"content":{"rendered":"<p style=\"text-align:center;\" ><img decoding=\"async\" src=\"https:\/\/cdn-kb.worktile.com\/kb\/wp-content\/uploads\/2024\/04\/24181550\/aab9029a-948c-495f-a166-5e82d0b9ebec.webp\" alt=\"\u7528Python\u5982\u4f55\u83b7\u53d6\u80a1\u5e02\u884c\u60c5\" \/><\/p>\n<p><p> <strong>\u4f7f\u7528Python\u83b7\u53d6\u80a1\u5e02\u884c\u60c5\u7684\u65b9\u5f0f\u6709\u5f88\u591a\uff0c\u5305\u62ec\u4f7f\u7528API\u3001\u7f51\u9875\u6293\u53d6\u548c\u6570\u636e\u6e90\u5e93\u3002\u672c\u6587\u5c06\u8be6\u7ec6\u4ecb\u7ecd\u51e0\u79cd\u5e38\u89c1\u7684\u83b7\u53d6\u80a1\u5e02\u884c\u60c5\u7684\u65b9\u6cd5\uff0c\u5305\u62ec\u4f7f\u7528API\u3001\u901a\u8fc7\u7f51\u9875\u6293\u53d6\u3001\u548c\u4f7f\u7528Python\u5e93\u3002<\/strong>\u5176\u4e2d\uff0c\u4f7f\u7528API\u662f\u6700\u5e38\u89c1\u548c\u6700\u65b9\u4fbf\u7684\u65b9\u5f0f\uff0c\u56e0\u4e3a\u5b83\u4eec\u901a\u5e38\u63d0\u4f9b\u4e86\u73b0\u6210\u7684\u6570\u636e\u63a5\u53e3\uff0c\u53ef\u4ee5\u76f4\u63a5\u8c03\u7528\u3002\u63a5\u4e0b\u6765\u5c06\u8be6\u7ec6\u4ecb\u7ecd\u51e0\u79cd\u65b9\u6cd5\u3002<\/p>\n<\/p>\n<p><p>\u4e00\u3001\u4f7f\u7528API\u83b7\u53d6\u80a1\u5e02\u884c\u60c5<\/p>\n<\/p>\n<p><p>\u5229\u7528API\u83b7\u53d6\u80a1\u5e02\u884c\u60c5\u662f\u6700\u76f4\u63a5\u3001\u6700\u65b9\u4fbf\u7684\u4e00\u79cd\u65b9\u5f0f\u3002\u8bb8\u591a\u91d1\u878d\u6570\u636e\u63d0\u4f9b\u5546\u90fd\u63d0\u4f9b\u4e86\u514d\u8d39\u7684\u6216\u4ed8\u8d39\u7684API\uff0c\u7528\u6237\u53ef\u4ee5\u901a\u8fc7\u8c03\u7528\u8fd9\u4e9bAPI\u6765\u83b7\u53d6\u5b9e\u65f6\u6216\u5386\u53f2\u7684\u80a1\u5e02\u6570\u636e\u3002\u4ee5\u4e0b\u662f\u51e0\u4e2a\u5e38\u7528\u7684API\uff1a<\/p>\n<\/p>\n<p><h3>1. Alpha Vantage API<\/h3>\n<\/p>\n<p><p>Alpha Vantage \u662f\u4e00\u4e2a\u6d41\u884c\u7684\u91d1\u878d\u6570\u636e\u63d0\u4f9b\u5546\uff0c\u63d0\u4f9b\u4e86\u514d\u8d39\u7684API\uff0c\u53ef\u4ee5\u83b7\u53d6\u80a1\u7968\u3001\u52a0\u5bc6\u8d27\u5e01\u548c\u5916\u6c47\u7684\u6570\u636e\u3002<\/p>\n<\/p>\n<p><h4>\u5b89\u88c5\u4e0e\u6ce8\u518c<\/h4>\n<\/p>\n<p><p>\u9996\u5148\uff0c\u9700\u8981\u5728Alpha Vantage\u5b98\u7f51\u6ce8\u518c\u8d26\u53f7\uff0c\u83b7\u53d6API key\u3002\u7136\u540e\u5b89\u88c5requests\u5e93\uff1a<\/p>\n<\/p>\n<p><pre><code class=\"language-sh\">pip install requests<\/p>\n<p><\/code><\/pre>\n<\/p>\n<p><h4>\u83b7\u53d6\u80a1\u5e02\u6570\u636e<\/h4>\n<\/p>\n<p><p>\u901a\u8fc7\u8c03\u7528API\uff0c\u53ef\u4ee5\u83b7\u53d6\u80a1\u7968\u7684\u65f6\u95f4\u5e8f\u5217\u6570\u636e\uff1a<\/p>\n<\/p>\n<p><pre><code class=\"language-python\">import requests<\/p>\n<p>API_KEY = &#39;your_alpha_vantage_api_key&#39;<\/p>\n<p>symbol = &#39;AAPL&#39;<\/p>\n<p>function = &#39;TIME_SERIES_D<a href=\"https:\/\/docs.pingcode.com\/blog\/59162.html\" target=\"_blank\">AI<\/a>LY&#39;<\/p>\n<p>url = f&#39;https:\/\/www.alphavantage.co\/query?function={function}&amp;symbol={symbol}&amp;apikey={API_KEY}&#39;<\/p>\n<p>response = requests.get(url)<\/p>\n<p>data = response.json()<\/p>\n<p>print(data)<\/p>\n<p><\/code><\/pre>\n<\/p>\n<p><h3>2. Yahoo Finance API<\/h3>\n<\/p>\n<p><p>Yahoo Finance\u63d0\u4f9b\u4e86\u4e00\u4e2a\u975e\u5b98\u65b9\u7684API\uff0c\u53ef\u4ee5\u83b7\u53d6\u80a1\u7968\u884c\u60c5\u6570\u636e\u3002\u4f7f\u7528yfinance\u5e93\u53ef\u4ee5\u65b9\u4fbf\u5730\u83b7\u53d6\u6570\u636e\u3002<\/p>\n<\/p>\n<p><h4>\u5b89\u88c5yfinance\u5e93<\/h4>\n<\/p>\n<p><pre><code class=\"language-sh\">pip install yfinance<\/p>\n<p><\/code><\/pre>\n<\/p>\n<p><h4>\u83b7\u53d6\u80a1\u5e02\u6570\u636e<\/h4>\n<\/p>\n<p><pre><code class=\"language-python\">import yfinance as yf<\/p>\n<p>stock = yf.Ticker(&#39;AAPL&#39;)<\/p>\n<p>data = stock.history(period=&#39;1d&#39;)<\/p>\n<p>print(data)<\/p>\n<p><\/code><\/pre>\n<\/p>\n<p><h3>3. IEX Cloud API<\/h3>\n<\/p>\n<p><p>IEX Cloud \u662f\u4e00\u4e2a\u5f3a\u5927\u7684\u91d1\u878d\u6570\u636e\u5e73\u53f0\uff0c\u63d0\u4f9b\u4e86\u4e30\u5bcc\u7684API\uff0c\u53ef\u4ee5\u83b7\u53d6\u80a1\u7968\u3001\u52a0\u5bc6\u8d27\u5e01\u548c\u5176\u4ed6\u91d1\u878d\u5e02\u573a\u7684\u6570\u636e\u3002<\/p>\n<\/p>\n<p><h4>\u5b89\u88c5\u4e0e\u6ce8\u518c<\/h4>\n<\/p>\n<p><p>\u5728IEX Cloud\u5b98\u7f51\u6ce8\u518c\u8d26\u53f7\uff0c\u83b7\u53d6API key\u3002\u7136\u540e\u5b89\u88c5requests\u5e93\uff1a<\/p>\n<\/p>\n<p><pre><code class=\"language-sh\">pip install requests<\/p>\n<p><\/code><\/pre>\n<\/p>\n<p><h4>\u83b7\u53d6\u80a1\u5e02\u6570\u636e<\/h4>\n<\/p>\n<p><pre><code class=\"language-python\">import requests<\/p>\n<p>API_KEY = &#39;your_iex_cloud_api_key&#39;<\/p>\n<p>symbol = &#39;AAPL&#39;<\/p>\n<p>url = f&#39;https:\/\/cloud.iexapis.com\/stable\/stock\/{symbol}\/quote?token={API_KEY}&#39;<\/p>\n<p>response = requests.get(url)<\/p>\n<p>data = response.json()<\/p>\n<p>print(data)<\/p>\n<p><\/code><\/pre>\n<\/p>\n<p><p>\u4e8c\u3001\u901a\u8fc7\u7f51\u9875\u6293\u53d6\u83b7\u53d6\u80a1\u5e02\u884c\u60c5<\/p>\n<\/p>\n<p><p>\u6709\u65f6API\u7684\u4f7f\u7528\u4f1a\u53d7\u5230\u9650\u5236\uff0c\u6216\u8005\u9700\u8981\u83b7\u53d6\u4e00\u4e9bAPI\u6ca1\u6709\u63d0\u4f9b\u7684\u6570\u636e\uff0c\u8fd9\u65f6\u53ef\u4ee5\u901a\u8fc7\u7f51\u9875\u6293\u53d6\u7684\u65b9\u5f0f\u6765\u83b7\u53d6\u80a1\u5e02\u6570\u636e\u3002\u5e38\u7528\u7684\u7f51\u9875\u6293\u53d6\u5e93\u6709BeautifulSoup\u548cScrapy\u3002<\/p>\n<\/p>\n<p><h3>1. \u4f7f\u7528BeautifulSoup\u6293\u53d6\u6570\u636e<\/h3>\n<\/p>\n<p><p>BeautifulSoup\u662f\u4e00\u4e2a\u89e3\u6790HTML\u548cXML\u6587\u4ef6\u7684Python\u5e93\uff0c\u53ef\u4ee5\u65b9\u4fbf\u5730\u4ece\u7f51\u9875\u4e2d\u63d0\u53d6\u6570\u636e\u3002<\/p>\n<\/p>\n<p><h4>\u5b89\u88c5BeautifulSoup\u548crequests\u5e93<\/h4>\n<\/p>\n<p><pre><code class=\"language-sh\">pip install beautifulsoup4 requests<\/p>\n<p><\/code><\/pre>\n<\/p>\n<p><h4>\u6293\u53d6\u80a1\u5e02\u6570\u636e<\/h4>\n<\/p>\n<p><p>\u4ee5\u4e0b\u793a\u4f8b\u4eceYahoo Finance\u9875\u9762\u6293\u53d6\u80a1\u7968\u6570\u636e\uff1a<\/p>\n<\/p>\n<p><pre><code class=\"language-python\">import requests<\/p>\n<p>from bs4 import BeautifulSoup<\/p>\n<p>url = &#39;https:\/\/finance.yahoo.com\/quote\/AAPL?p=AAPL&#39;<\/p>\n<p>response = requests.get(url)<\/p>\n<p>soup = BeautifulSoup(response.text, &#39;html.parser&#39;)<\/p>\n<p>price = soup.find(&#39;fin-streamer&#39;, {&#39;data-symbol&#39;: &#39;AAPL&#39;}).text<\/p>\n<p>print(price)<\/p>\n<p><\/code><\/pre>\n<\/p>\n<p><h3>2. \u4f7f\u7528Scrapy\u6293\u53d6\u6570\u636e<\/h3>\n<\/p>\n<p><p>Scrapy\u662f\u4e00\u4e2a\u529f\u80fd\u5f3a\u5927\u7684\u7f51\u9875\u6293\u53d6\u548c\u6570\u636e\u63d0\u53d6\u6846\u67b6\uff0c\u9002\u7528\u4e8e\u5927\u89c4\u6a21\u6293\u53d6\u3002<\/p>\n<\/p>\n<p><h4>\u5b89\u88c5Scrapy<\/h4>\n<\/p>\n<p><pre><code class=\"language-sh\">pip install scrapy<\/p>\n<p><\/code><\/pre>\n<\/p>\n<p><h4>\u521b\u5efaScrapy\u9879\u76ee<\/h4>\n<\/p>\n<p><pre><code class=\"language-sh\">scrapy startproject stockscraper<\/p>\n<p>cd stockscraper<\/p>\n<p>scrapy genspider yahoo_finance finance.yahoo.com<\/p>\n<p><\/code><\/pre>\n<\/p>\n<p><p>\u5728\u751f\u6210\u7684yahoo_finance.py\u6587\u4ef6\u4e2d\uff0c\u7f16\u5199\u6570\u636e\u6293\u53d6\u903b\u8f91\uff1a<\/p>\n<\/p>\n<p><pre><code class=\"language-python\">import scrapy<\/p>\n<p>class YahooFinanceSpider(scrapy.Spider):<\/p>\n<p>    name = &#39;yahoo_finance&#39;<\/p>\n<p>    allowed_domains = [&#39;finance.yahoo.com&#39;]<\/p>\n<p>    start_urls = [&#39;https:\/\/finance.yahoo.com\/quote\/AAPL?p=AAPL&#39;]<\/p>\n<p>    def parse(self, response):<\/p>\n<p>        price = response.xpath(&#39;\/\/fin-streamer[@data-symbol=&quot;AAPL&quot;]\/text()&#39;).get()<\/p>\n<p>        yield {&#39;price&#39;: price}<\/p>\n<p><\/code><\/pre>\n<\/p>\n<p><p>\u8fd0\u884cScrapy\u722c\u866b\uff1a<\/p>\n<\/p>\n<p><pre><code class=\"language-sh\">scrapy crawl yahoo_finance -o prices.json<\/p>\n<p><\/code><\/pre>\n<\/p>\n<p><p>\u4e09\u3001\u4f7f\u7528Python\u5e93\u83b7\u53d6\u80a1\u5e02\u884c\u60c5<\/p>\n<\/p>\n<p><p>\u9664\u4e86API\u548c\u7f51\u9875\u6293\u53d6\uff0cPython\u5e93\u4e5f\u662f\u83b7\u53d6\u80a1\u5e02\u6570\u636e\u7684\u4e00\u4e2a\u91cd\u8981\u9014\u5f84\u3002\u8fd9\u4e9b\u5e93\u901a\u5e38\u5c01\u88c5\u4e86\u6570\u636e\u6e90\u7684\u8c03\u7528\u63a5\u53e3\uff0c\u63d0\u4f9b\u4e86\u65b9\u4fbf\u7684\u6570\u636e\u83b7\u53d6\u65b9\u5f0f\u3002<\/p>\n<\/p>\n<p><h3>1. \u4f7f\u7528Pandas DataReader\u83b7\u53d6\u6570\u636e<\/h3>\n<\/p>\n<p><p>Pandas DataReader\u662f\u4e00\u4e2a\u7528\u4e8e\u4ece\u5404\u79cd\u6570\u636e\u6e90\uff08\u5305\u62ecYahoo Finance\u3001Google Finance\u3001FRED\u7b49\uff09\u8bfb\u53d6\u6570\u636e\u7684\u5e93\u3002<\/p>\n<\/p>\n<p><h4>\u5b89\u88c5Pandas DataReader<\/h4>\n<\/p>\n<p><pre><code class=\"language-sh\">pip install pandas_datareader<\/p>\n<p><\/code><\/pre>\n<\/p>\n<p><h4>\u83b7\u53d6\u80a1\u5e02\u6570\u636e<\/h4>\n<\/p>\n<p><pre><code class=\"language-python\">import pandas_datareader.data as web<\/p>\n<p>import datetime<\/p>\n<p>start = datetime.datetime(2022, 1, 1)<\/p>\n<p>end = datetime.datetime(2022, 10, 1)<\/p>\n<p>data = web.DataReader(&#39;AAPL&#39;, &#39;yahoo&#39;, start, end)<\/p>\n<p>print(data)<\/p>\n<p><\/code><\/pre>\n<\/p>\n<p><h3>2. \u4f7f\u7528Quandl\u5e93\u83b7\u53d6\u6570\u636e<\/h3>\n<\/p>\n<p><p>Quandl\u662f\u4e00\u4e2a\u63d0\u4f9b\u91d1\u878d\u3001\u7ecf\u6d4e\u548c\u793e\u4f1a\u6570\u636e\u7684\u5e73\u53f0\uff0c\u63d0\u4f9b\u4e86\u4e30\u5bcc\u7684\u6570\u636e\u6e90\u548cAPI\u3002<\/p>\n<\/p>\n<p><h4>\u5b89\u88c5Quandl\u5e93<\/h4>\n<\/p>\n<p><pre><code class=\"language-sh\">pip install quandl<\/p>\n<p><\/code><\/pre>\n<\/p>\n<p><h4>\u83b7\u53d6\u80a1\u5e02\u6570\u636e<\/h4>\n<\/p>\n<p><pre><code class=\"language-python\">import quandl<\/p>\n<p>quandl.ApiConfig.api_key = &#39;your_quandl_api_key&#39;<\/p>\n<p>data = quandl.get(&#39;WIKI\/AAPL&#39;)<\/p>\n<p>print(data)<\/p>\n<p><\/code><\/pre>\n<\/p>\n<p><h3>3. \u4f7f\u7528Tushare\u5e93\u83b7\u53d6\u4e2d\u56fd\u80a1\u5e02\u6570\u636e<\/h3>\n<\/p>\n<p><p>Tushare\u662f\u4e00\u4e2a\u4e3a\u4e2d\u56fd\u5e02\u573a\u8bbe\u8ba1\u7684\u5f00\u6e90\u91d1\u878d\u6570\u636e\u63a5\u53e3\u5e93\uff0c\u63d0\u4f9b\u4e86\u5168\u9762\u7684\u80a1\u7968\u3001\u671f\u8d27\u3001\u57fa\u91d1\u7b49\u6570\u636e\u3002<\/p>\n<\/p>\n<p><h4>\u5b89\u88c5Tushare\u5e93<\/h4>\n<\/p>\n<p><pre><code class=\"language-sh\">pip install tushare<\/p>\n<p><\/code><\/pre>\n<\/p>\n<p><h4>\u83b7\u53d6\u80a1\u5e02\u6570\u636e<\/h4>\n<\/p>\n<p><pre><code class=\"language-python\">import tushare as ts<\/p>\n<p>pro = ts.pro_api(&#39;your_tushare_api_key&#39;)<\/p>\n<p>data = pro.daily(ts_code=&#39;000001.SZ&#39;, start_date=&#39;20220101&#39;, end_date=&#39;20221001&#39;)<\/p>\n<p>print(data)<\/p>\n<p><\/code><\/pre>\n<\/p>\n<p><p>\u56db\u3001\u6570\u636e\u5904\u7406\u4e0e\u53ef\u89c6\u5316<\/p>\n<\/p>\n<p><p>\u83b7\u53d6\u6570\u636e\u540e\uff0c\u8fd8\u9700\u8981\u5bf9\u6570\u636e\u8fdb\u884c\u5904\u7406\u548c\u5206\u6790\uff0c\u5e76\u8fdb\u884c\u53ef\u89c6\u5316\u5c55\u793a\u3002Python\u63d0\u4f9b\u4e86\u4e30\u5bcc\u7684\u6570\u636e\u5904\u7406\u548c\u53ef\u89c6\u5316\u5e93\uff0c\u5982Pandas\u3001Matplotlib\u3001Seaborn\u7b49\u3002<\/p>\n<\/p>\n<p><h3>1. \u6570\u636e\u5904\u7406<\/h3>\n<\/p>\n<p><p>\u4f7f\u7528Pandas\u5e93\u8fdb\u884c\u6570\u636e\u5904\u7406\uff1a<\/p>\n<\/p>\n<p><pre><code class=\"language-python\">import pandas as pd<\/p>\n<p>data = {<\/p>\n<p>    &#39;date&#39;: [&#39;2022-01-01&#39;, &#39;2022-01-02&#39;, &#39;2022-01-03&#39;],<\/p>\n<p>    &#39;price&#39;: [150, 155, 160]<\/p>\n<p>}<\/p>\n<p>df = pd.DataFrame(data)<\/p>\n<p>df[&#39;date&#39;] = pd.to_datetime(df[&#39;date&#39;])<\/p>\n<p>df.set_index(&#39;date&#39;, inplace=True)<\/p>\n<p>print(df)<\/p>\n<p><\/code><\/pre>\n<\/p>\n<p><h3>2. \u6570\u636e\u53ef\u89c6\u5316<\/h3>\n<\/p>\n<p><p>\u4f7f\u7528Matplotlib\u548cSeaborn\u8fdb\u884c\u6570\u636e\u53ef\u89c6\u5316\uff1a<\/p>\n<\/p>\n<p><pre><code class=\"language-python\">import matplotlib.pyplot as plt<\/p>\n<p>import seaborn as sns<\/p>\n<p>sns.set(style=&#39;darkgrid&#39;)<\/p>\n<p>plt.figure(figsize=(10, 6))<\/p>\n<p>plt.plot(df.index, df[&#39;price&#39;], label=&#39;Price&#39;, marker=&#39;o&#39;)<\/p>\n<p>plt.title(&#39;Stock Price Over Time&#39;)<\/p>\n<p>plt.xlabel(&#39;Date&#39;)<\/p>\n<p>plt.ylabel(&#39;Price&#39;)<\/p>\n<p>plt.legend()<\/p>\n<p>plt.show()<\/p>\n<p><\/code><\/pre>\n<\/p>\n<p><p>\u4e94\u3001\u603b\u7ed3<\/p>\n<\/p>\n<p><p>\u83b7\u53d6\u80a1\u5e02\u884c\u60c5\u6570\u636e\u7684\u65b9\u5f0f\u591a\u79cd\u591a\u6837\uff0c\u9009\u62e9\u5408\u9002\u7684\u65b9\u6cd5\u53d6\u51b3\u4e8e\u5177\u4f53\u9700\u6c42\u548c\u6570\u636e\u6e90\u7684\u53ef\u7528\u6027\u3002<strong>\u5229\u7528API\u662f\u6700\u65b9\u4fbf\u548c\u53ef\u9760\u7684\u65b9\u5f0f\uff0c\u63a8\u8350\u4f7f\u7528Alpha Vantage\u3001Yahoo Finance\u548cIEX Cloud\u7b49\u77e5\u540dAPI\uff1b\u7f51\u9875\u6293\u53d6\u9002\u7528\u4e8e\u83b7\u53d6API\u65e0\u6cd5\u63d0\u4f9b\u7684\u6570\u636e\uff0c\u53ef\u4ee5\u4f7f\u7528BeautifulSoup\u548cScrapy\u8fdb\u884c\u6293\u53d6\uff1bPython\u5e93\u5982Pandas DataReader\u3001Quandl\u548cTushare\u4e5f\u63d0\u4f9b\u4e86\u65b9\u4fbf\u7684\u6570\u636e\u83b7\u53d6\u63a5\u53e3\u3002<\/strong>\u5728\u83b7\u53d6\u6570\u636e\u540e\uff0c\u53ef\u4ee5\u4f7f\u7528Pandas\u8fdb\u884c\u6570\u636e\u5904\u7406\uff0c\u5e76\u4f7f\u7528Matplotlib\u548cSeaborn\u8fdb\u884c\u6570\u636e\u53ef\u89c6\u5316\u3002\u5e0c\u671b\u8fd9\u7bc7\u6587\u7ae0\u80fd\u5e2e\u52a9\u4f60\u638c\u63e1\u4f7f\u7528Python\u83b7\u53d6\u80a1\u5e02\u884c\u60c5\u6570\u636e\u7684\u6280\u5de7\u3002<\/p>\n<\/p>\n<h2><strong>\u76f8\u5173\u95ee\u7b54FAQs\uff1a<\/strong><\/h2>\n<p> <strong>\u5982\u4f55\u4f7f\u7528Python\u83b7\u53d6\u5b9e\u65f6\u80a1\u5e02\u884c\u60c5\u6570\u636e\uff1f<\/strong><br \/>\u53ef\u4ee5\u901a\u8fc7\u591a\u79cdAPI\u83b7\u53d6\u5b9e\u65f6\u80a1\u5e02\u884c\u60c5\u6570\u636e\uff0c\u4f8b\u5982Alpha Vantage\u3001Yahoo Finance\u6216IEX Cloud\u7b49\u3002\u9996\u5148\uff0c\u6ce8\u518c\u83b7\u53d6API\u5bc6\u94a5\uff0c\u7136\u540e\u4f7f\u7528Python\u7684requests\u5e93\u53d1\u9001HTTP\u8bf7\u6c42\uff0c\u83b7\u53d6\u6240\u9700\u7684\u80a1\u7968\u6570\u636e\u3002\u89e3\u6790\u8fd4\u56de\u7684JSON\u683c\u5f0f\u6570\u636e\u540e\uff0c\u53ef\u4ee5\u63d0\u53d6\u51fa\u4ef7\u683c\u3001\u6210\u4ea4\u91cf\u7b49\u4fe1\u606f\uff0c\u4fbf\u4e8e\u540e\u7eed\u5206\u6790\u3002<\/p>\n<p><strong>\u83b7\u53d6\u80a1\u5e02\u5386\u53f2\u6570\u636e\u7684\u6700\u4f73\u65b9\u6cd5\u662f\u4ec0\u4e48\uff1f<\/strong><br \/>\u5bf9\u4e8e\u5386\u53f2\u80a1\u5e02\u6570\u636e\uff0c\u53ef\u4ee5\u4f7f\u7528pandas_datareader\u5e93\uff0c\u5b83\u652f\u6301\u4eceYahoo Finance\u3001Google Finance\u7b49\u591a\u4e2a\u6570\u636e\u6e90\u63d0\u53d6\u5386\u53f2\u6570\u636e\u3002\u901a\u8fc7\u6307\u5b9a\u80a1\u7968\u4ee3\u7801\u53ca\u65f6\u95f4\u8303\u56f4\uff0c\u60a8\u53ef\u4ee5\u8f7b\u677e\u83b7\u53d6\u6240\u9700\u7684\u5386\u53f2\u4ef7\u683c\u548c\u4ea4\u6613\u91cf\uff0c\u5e76\u4f7f\u7528pandas\u8fdb\u884c\u6570\u636e\u5904\u7406\u548c\u53ef\u89c6\u5316\u3002<\/p>\n<p><strong>\u5982\u4f55\u5904\u7406\u80a1\u5e02\u6570\u636e\u4e2d\u7684\u7f3a\u5931\u503c\u548c\u5f02\u5e38\u503c\uff1f<\/strong><br \/>\u5728\u83b7\u53d6\u80a1\u5e02\u6570\u636e\u540e\uff0c\u53ef\u80fd\u4f1a\u9047\u5230\u7f3a\u5931\u503c\u548c\u5f02\u5e38\u503c\u3002\u53ef\u4ee5\u4f7f\u7528pandas\u5e93\u4e2d\u7684fillna()\u65b9\u6cd5\u586b\u8865\u7f3a\u5931\u503c\uff0c\u4f8b\u5982\u4f7f\u7528\u524d\u4e00\u4e2a\u6709\u6548\u503c\u586b\u5145\u3002\u5bf9\u4e8e\u5f02\u5e38\u503c\uff0c\u60a8\u53ef\u4ee5\u901a\u8fc7\u8ba1\u7b97\u7edf\u8ba1\u6307\u6807\uff0c\u5982\u5747\u503c\u548c\u6807\u51c6\u5dee\uff0c\u8bc6\u522b\u5e76\u79fb\u9664\u8d85\u51fa\u4e00\u5b9a\u8303\u56f4\u7684\u6570\u636e\uff0c\u786e\u4fdd\u6570\u636e\u7684\u51c6\u786e\u6027\u548c\u53ef\u9760\u6027\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"\u4f7f\u7528Python\u83b7\u53d6\u80a1\u5e02\u884c\u60c5\u7684\u65b9\u5f0f\u6709\u5f88\u591a\uff0c\u5305\u62ec\u4f7f\u7528API\u3001\u7f51\u9875\u6293\u53d6\u548c\u6570\u636e\u6e90\u5e93\u3002\u672c\u6587\u5c06\u8be6\u7ec6\u4ecb\u7ecd\u51e0\u79cd\u5e38\u89c1\u7684\u83b7\u53d6\u80a1\u5e02 [&hellip;]","protected":false},"author":3,"featured_media":1077594,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[37],"tags":[],"acf":[],"_links":{"self":[{"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/posts\/1077588"}],"collection":[{"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/comments?post=1077588"}],"version-history":[{"count":"1","href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/posts\/1077588\/revisions"}],"predecessor-version":[{"id":1077596,"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/posts\/1077588\/revisions\/1077596"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/media\/1077594"}],"wp:attachment":[{"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/media?parent=1077588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/categories?post=1077588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/tags?post=1077588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}