擅长:python、mysql、java
<p>最新的pandas(pandas==1.2.0)能够在安装<code>requests</code>时使用<code>pd.read_excel</code>从url读取</p>
<pre><code>import pandas
url = "https://www.nordpoolgroup.com/48d3ac/globalassets/marketdata-excel-files/exchange-ee-connections_2021_daily.xls"
df = pandas.read_excel(url)
</code></pre>
<p>但您的文件似乎已损坏,它会触发:</p>
<pre><code>ValueError: File is not a recognized excel file
</code></pre>