擅长:python、mysql、java
<p>首先,可以通过以下方式使用Python下载文件:<a href="https://stackoverflow.com/a/17961068/8565438">urllib.request</a></p>
<pre><code>import urllib.request
url='https://www.nordpoolgroup.com/48d3ac/globalassets/marketdata-excel-files/exchange-ee-connections_2021_daily.xls'
filename='yourfile.csv'
urllib.request.urlretrieve (url,filename)
</code></pre>
<p>然后在使用熊猫中阅读:</p>
<pre><code>import pandas as pd
df = pd.read_excel(filename)
</code></pre>
<p>这将给你:</p>
<pre><code>XLRDError: Unsupported format, or corrupt file: Expected BOF record; found b'Exchange'
</code></pre>
<p>在使用真正的Excel进行检查后,我发现:</p>
<p><a href="https://i.stack.imgur.com/3rqYv.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3rqYv.png" alt="enter image description here"/></a></p>
<p>我怀疑你的档案有问题。对于正确的文件,上述方法应该有效</p>