Skip to main content
 首页 » 编程设计

python之使用 pandas 提取 ASX 数据

2025年02月15日12daizhj

我正在尝试从雅虎财经提取股票市场数据,以下是链接 https://au.finance.yahoo.com/quote/ABP.AX/history?p=ABP.AX

我的代码如下

import pandas as pd 
dfs = pd.read_html('https://au.finance.yahoo.com/quote/ABP.AX/history?p=ABP.AX')        
print(dfs) 

上面的代码导致如下错误

Traceback (most recent call last): 
  File "/home/furqan/Desktop/Data/Fundamental Analysis/get_data/ax_data.py", line 5, in <module> 
    dfs = pd.read_html('https://au.finance.yahoo.com/quote/ABP.AX/history?p=ABP.AX') 
  File "/usr/local/lib/python3.5/dist-packages/pandas/io/html.py", line 874, in read_html 
    parse_dates, tupleize_cols, thousands, attrs, encoding) 
  File "/usr/local/lib/python3.5/dist-packages/pandas/io/html.py", line 747, in _parse 
    thousands=thousands)) 
  File "/usr/local/lib/python3.5/dist-packages/pandas/io/html.py", line 628, in _data_to_frame 
    _expand_elements(body) 
  File "/usr/local/lib/python3.5/dist-packages/pandas/io/html.py", line 611, in _expand_elements 
    body[ind] += empty * (lens_max - length) 
TypeError: ufunc 'add' did not contain a loop with signature matching types dtype('<U47') dtype('<U47') dtype('<U47') 

我该如何解决这个问题?

请您参考如下方法:

感谢完成使用。

import fix_yahoo_finance as yf 
data = yf.download("SPY", start="2017-01-01", end="2017-04-30")